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 :)

  4. #4 by Orville on April 18, 2014 - 23:11

    My brother recommended I might like this web site. He was totally right.
    This post truly made my day. You cann’t imagine simply how much
    time I had spent for this info! Thanks!

  5. #5 by Audra on April 20, 2014 - 13:21

    The fact is that as we get older our body appears to lose some of its elasticity.

    We can wear clothes that distract from the real challenge to get a few
    pounds, slimming, now with spandex underwear, we can easily hide and conceal the bulging waistlines, or less than thin thighs.
    Learn about where to find templates, how to use shortcuts for tasks like adding an accent mark, how to insert and modify graphics, and more.
    Aerobic exercise will regenerate them and assist you experience greater in times when you aren’t exercising.
    This is very different from double chin caused by obesity.

  6. #6 by inversion table reviews on April 23, 2014 - 09:41

    Hello, i think that i saw you visited my blog so i came to “return
    the favor”.I’m trying to find things to enhance my website!I suppose its ok to use a few of your ideas!!

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,429 other followers

%d bloggers like this: