Thursday, July 25, 2013

ORACLE - RMAN Create Manual standby database

How to create MANUAL Standby database ?

Add following parameter in init.ora:
*.standby_file_management='AUTO'
*.log_archive_dest_1='LOCATION=/ArchLog/oracle/JAYDB/arch'
*.log_archive_format='arch_%t_%s_%r.arc'
*.db_file_name_convert='+DG_JAYDB','+DG_JAYDB'
*.log_file_name_convert='+DG_JAYDB','+DG_JAYDB'

RMAN> startup nomount;
RMAN> set dbid=1392320630;
RMAN> restore standby controlfile from'/bkup/JAYDB/rman/rman_JAYDB_stbyctl_20130717_1voev8c9.bk';
RMAN> sql 'alter database mount standby database';
RMAN> sql 'create spfile from pfile';
RMAN>run
{
allocate channel c1 type disk format '/bkup/REMEDY/rman/rman_%d_inc0_%T_%u.bk';
restore database;
}

Errors and solutions:
Errors in file /u01/app/oracle/diag/rdbms/JAYDB/JAYDB/trace/JAYDB_lgwr_19545.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '+DG_JAYDB01/JAYDB/onlinelog/group_1.290.820901579'
ORA-17503: ksfdopn:2 Failed to open file +DG_JAYDB01/JAYDB/onlinelog/group_1.290.820901579
ORA-15012: ASM file '+DG_JAYDB01/JAYDB/onlinelog/group_1.290.820901579' does not exist
ORA-00312: online log 1 thread 1: '+DG_JAYDB01/JAYDB/onlinelog/group_1.291.820901579'
ORA-17503: ksfdopn:2 Failed to open file +DG_JAYDB01/JAYDB/onlinelog/group_1.291.820901579
ORA-15012: ASM file '+DG_JAYDB01/JAYDB/onlinelog/group_1.291.820901579' does not exist
Errors in file /u01/app/oracle/diag/rdbms/JAYDB/JAYDB/trace/JAYDB_lgwr_19545.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '+DG_JAYDB01/JAYDB/onlinelog/group_1.290.820901579'
ORA-17503: ksfdopn:2 Failed to open file +DG_JAYDB01/JAYDB/onlinelog/group_1.290.820901579
ORA-15012: ASM file '+DG_JAYDB01/JAYDB/onlinelog/group_1.290.820901579' does not exist
ORA-00312: online log 1 thread 1: '+DG_JAYDB01/JAYDB/onlinelog/group_1.291.820901579'
ORA-17503: ksfdopn:2 Failed to open file +DG_JAYDB01/JAYDB/onlinelog/group_1.291.820901579
ORA-15012: ASM file '+DG_JAYDB01/JAYDB/onlinelog/group_1.291.820901579' does not exist
Errors in file /u01/app/oracle/diag/rdbms/JAYDB/JAYDB/trace/JAYDB_lgwr_19545.trc:

Solution: Ref Doc ID: 352879.1
Use :log_file_name_convert

No comments:

Post a Comment