To convert from the snapshot mode to a physical standby, the procedure is the same as discussed earlier. Perform the following steps:
For validation, perform some DML transactions to verify the number of rows of any table before and after the conversion, as shown in the following query:
SQL> select open_mode from v$database; OPEN_MODE -------------------- READ WRITE SQL> conn packt/packt; Connected. SQL> select count(*) from packt.oracle; COUNT(*) ---------- 41943040 SQL> insert into oracle select * from oracle where sal > 4500; 2097152 rows created. SQL> commit; Commit complete. SQL> select count(*) from packt.oracle; COUNT(*) ---------- 44040192
Shut down the database and put it in the
MOUNTstatus to initiate the conversion as follows:SQL> alter database convert to physical standby; Database altered. SQL>
The following output will be visible:
Wed Nov 07 22:28:12 2012 alter database convert to physical...