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!“ 🙂
Pickleball spielen 
#1 von alexandruneda am September 6, 2013 - 09:44
Interesting!
#2 von oraclebhola am 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 von Uwe Hesse am September 6, 2013 - 20:58
Yes it is the same with 12c,
I have tested that too 🙂