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 – running an RMAN duplicate

Perform the following steps to create a standby database with the RMAN duplicate method:

  1. Check the primary database status; it must be either open or mount.
    SQL> select db_unique_name,database_role,open_mode from v$database;
    DB_UNIQUE_ DATABASE_ROLE    OPEN_MODE
    ---------- ---------------- --------------------
    turkey_un  PRIMARY          READ WRITE
    
  2. Run the RMAN command from the standby system. Connect the primary and standby instances using Oracle Net Service names.
    [oracle@oracle-stbydbs]$ rman target sys/free2go@turkey auxiliary sys/free2go@india
    Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jul 26 18:41:06 2012
    Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    connected to ...

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