Automatic Creation of Standby Logs with RMAN DUPLICATE?

Just a brief information for you out there who are about to create a Data Guard Configuration. You will want to have Standby Redo Logs (SRLs) on the Standby Database. Our (otherwise very good) Online Documentation says “RMAN automatically creates the standby redo log files on the standby database.” That is true, but only if you created them before on the Primary! That was already the case with 11g and it still is with 12c, which I have just tested. Here’s the outcome after the RMAN DUPLICATE without SRLs on the Primary, checking the alert log of the Standby:

Use the following SQL commands on the standby database to create
standby redo logfiles that match the primary database:
ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 104857600;

Confirmation with SQL*Plus:

[oracle@uhesse]$ sqlplus sys/oracle@physt as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Fri Sep 6 09:06:08 2013

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select * from v$standby_log;

no rows selected

Conclusion: Don’t believe it (even if it is the Documentation), test it!” :-)

About these ads

  1. #1 by alexandruneda on September 6, 2013 - 09:44

    Interesting!

  2. #2 by oraclebhola on September 6, 2013 - 20:56

    Oracle 11g is that if SRLs have already been configured on the primary database, then the DUPLICATE DATABASE command will automatically create them on the standby database during execution of its memory script. Not sure for 12c :)

  3. #3 by Uwe Hesse on September 6, 2013 - 20:58

    Yes it is the same with 12c,
    I have tested that too :)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 2,603 other followers

%d bloggers like this: