O'Reilly logo

Oracle Data Guard 11gR2 Administration Beginner's Guide by Nassyam Basha, Emre Baransel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required