I will be getting a new database server to use as a physical standby. My production database currently has an existing physical standby database associated with it. I will turn my current standby database into a test standby instance before configuring a new standby for the production instance.
These are the steps to disassociating a physical standby database from the Primary Database:
Login to the production instance.
sqlplus
SQL> create pfile from spfile;
SQL> quit
-- save original Standby configuration init file
$ORACLE_HOME/dbs/cp initSID.ora initSID.date
sqlplus
SQL> alter system set log_archive_dest_state_2=DEFER scope=both;
SQL> alter system set log_archive_dest_2='LOCATION=NULL' scope=both;
SQL> alter system set log_archive_config='NODG_CONFIG' scope=both;
SQL> alter system set fal_client=NULL scope=both;
SQL> alter system set fal_server=NULL scope=both;
SQL> alter system set log_archive_dest_1='LOCATION=/u02/oradata/arch' scope=both;
SQL> alter system switch logfile;
SQL> create pfile from spfile;
SQL> select switchover_status from v$database;
SWITCHOVER_STATUS
--------------------
SESSIONS ACTIVE
SQL> shutdown immediate
SQL> select database_role from v$database;
DATABASE_ROLE
----------------
PRIMARY
SQL> select switchover_status from v$database;
SWITCHOVER_STATUS
--------------------
NOT ALLOWED
No comments:
Post a Comment