News

  1. Home
  2. All posts
All posts, DR, Oracle by Team Ajara

Converting a Snapshot Standby DB to Physical Standby

Converting a Snapshot Standby database into a Physical Standby Database.

Step 1

verify open mode of database (it should be in read write)

SQL>select open_mode from v$database;

SQL> conn sys/oracle@standby as sysdba

Step 2

If open_mode is read write then shutdown

SQL>shut immediate
SQL> startup mount

Step 3

Convert database to physical standby

SQL>alter database convert to physical standby;

SQL>select name,database_role,open_mode ,db_unique_name from v$database;

Step 4

open standby read only

SQL> alter database open;

Step  5
check open mode of pluggable database.

SQL> select name,open_mode from v$pdbs;

Step 6

open pluggable database

SQL> alter pluggable database pdb1 open;

Check test user and test table which we have created on snapshot database
SQL>conn snptst/snptst@pdb1

o/p ==> should give error

SQL>conn sys/oracle@pdb1 as sysdba

SQL> select * from dba_users where username=’SNPTST’;

no rows selected.
SQL>select * from dba_tables where table_name=TST_SNP’;

no rows selected.

 

See also: