Time for action – converting to a physical standby database

To convert from the snapshot mode to a physical standby, the procedure is the same as discussed earlier. Perform the following steps:

1. 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

2. Shut down the database and put it in the MOUNT status 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...