Posted by Mir Sayeed Hassan on 15th September 2018
Switchover in Realtime Production database in Oracle 11gR2 ================= PRIMARY DATABASE ================= Pre-requisite SQL> select INSTANCE_NAME,VERSION,STATUS from V$instance; INSTANCE_NAME VERSION STATUS —————-… Read more..
Posted in DataGuard (DR) | Comments Off on Switchover in Realtime Production database in Oracle 11gR2
Posted by Mir Sayeed Hassan on 15th September 2018
Rename a schema in Oracle Database 11gR2 Find the schema name to rename with user# SQL> select user#,NAME from SYS.user$ WHERE NAME=’TEST’; USER# NAME ———- —————————— 208 MIR Now modify the schema name “MIR” to “SAYEED” as shown below SYNTAX: SQL> UPDATE USER$ SET… Read more..
Posted in Oracle SQL | Comments Off on Rename a schema in Oracle Database 11gR2
Posted by Mir Sayeed Hassan on 15th September 2018
ORA-16139: media recovery required in Oracle Database 11gR2 The Ora-16139 error occur while performing the physical standby database during switchover from physical standby database to primary database in Oracle database 11gR2(11.2.0.4) Check the status of standby db SQL> select switchover_status from v$database; SWITCHOVER_STATUS … Read more..
Posted in ORA-Error | Comments Off on ORA-16139: media recovery required in Oracle Database 11gR2
Posted by Mir Sayeed Hassan on 4th September 2018
How to exclude Single or Multiple tables from schema by using from EXPDP Include Single table from schema [oracle@testdb dump_bkp]$ expdp system directory=dump_bkp dumpfile=mir04sep18.dmp logfile=mir04sep18.log schemas=mir include=TABLE:”IN(‘T1’)” Export: Release 11.2.0.4.0 – Production on Tue Sep 4 11:16:31 2018 Copyright… Read more..
Posted in Datapump (Expdp/Impdp) | Comments Off on How to exclude Single or Multiple tables from schema by using from EXPDP