News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Duplicate from active database – ASM Primary to ASM Standby

  • Posted by Gavin Soorma
  • On December 8, 2009
  • 0 Comments

In my earlier post 11g Standby Database Creation Without Any RMAN Backups I had illustrated how to create a standby database using the 11g Active Duplication feature which enabled us to create a standby database without any backup taken of the primary database. In this case it was a ASM Primary and a non ASM Standby database.

This example now illustrates how the same procedure can be extended to create an ASM Standby database from an ASM Primary database using the same active duplication method.

After following all the steps explained in the previous example, run the following command after launching RMAN and connecting to the auxiliary instance.

DUPLICATE TARGET DATABASE
FOR STANDBY
FROM ACTIVE DATABASE
NOFILENAMECHECK
DORECOVER
SPFILE
PARAMETER_VALUE_CONVERT
‘/u01/oracle/admin/test_fc’,’/u01/oracle/admin/test_js’
SET DB_UNIQUE_NAME=”test_js”
SET LOG_ARCHIVE_DEST_2=”service=test_fc LGWR SYNC REGISTER VALID_FOR=(online_logfile,primary_role)”
SET FAL_SERVER=”test_fc”
SET FAL_CLIENT=”test_js”
SET CONTROL_FILES=’+DATA/TEST_JS/controlfile/control01.dbf’
;

What I found is that if you do not include the full path name for the CONTROL_FILES parameter and only include the ‘+DATA’ part as shown below we will get a number of different errors – one of them is shown below. In another case I got an error related to RMAN-06152 which is an AUTOBACKUP related error.

DUPLICATE TARGET DATABASE
FOR STANDBY
FROM ACTIVE DATABASE
NOFILENAMECHECK
DORECOVER
SPFILE
PARAMETER_VALUE_CONVERT
‘/u01/oracle/admin/test_fc’,’/u01/oracle/admin/test_js’
SET DB_UNIQUE_NAME=”test_js”
SET LOG_ARCHIVE_DEST_2=”service=test_fc LGWR SYNC REGISTER VALID_FOR=(online_logfile,primary_role)”
SET FAL_SERVER=”test_fc”
SET FAL_CLIENT=”test_js”
SET CONTROL_FILES=’+DATA’
;

Starting backup at 08-12-2009 10:47:38
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying standby control file
output file name=/u01/oracle/product/11.1/db_1/dbs/snapcf_test.f tag=TAG20091208T104738 RECID=14 STAMP=705062859
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 08-12-2009 10:47:42

sql statement: alter database mount standby database
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/08/2009 10:47:45
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of sql command on clone_default channel at 12/08/2009 10:47:45
RMAN-11003: failure during parse/execution of SQL statement: alter database mount standby database
ORA-00205: error in identifying control file, check alert log for more info

 

0 Comments

Leave Reply

Your email address will not be published. Required fields are marked *