Home » Server Options » Data Guard » How to add both online and redo log files to standby databas (rbdms: 10.2, os: windows )
How to add both online and redo log files to standby databas [message #522765] Tue, 13 September 2011 09:57 Go to next message
kytemanaic
Messages: 55
Registered: February 2009
Member
Hi

I've only successfully duplicate a standby database. well not really:(

from the alert log
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\ORA102\CTA\REDO01.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Tue Sep 13 21:33:09 2011
Errors in file d:\ora102\cta\bdump\cta_mrp0_2212.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\ORA102\CTA\REDO01.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Clearing online redo logfile 1 D:\ORA102\CTA\REDO01.LOG
Clearing online log 1 of thread 1 sequence number 133
Tue Sep 13 21:33:09 2011
Errors in file d:\ora102\cta\bdump\cta_mrp0_2212.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\ORA102\CTA\REDO01.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Clearing online redo logfile 1 complete
Tue Sep 13 21:33:09 2011
Errors in file d:\ora102\cta\bdump\cta_mrp0_2212.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'D:\ORA102\CTA\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Tue Sep 13 21:33:09 2011
Errors in file d:\ora102\cta\bdump\cta_mrp0_2212.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'D:\ORA102\CTA\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Clearing online redo logfile 2 D:\ORA102\CTA\REDO02.LOG
Clearing online log 2 of thread 1 sequence number 131
Tue Sep 13 21:33:09 2011
Errors in file d:\ora102\cta\bdump\cta_mrp0_2212.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'D:\ORA102\CTA\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.




when I tried to add the online and standby redo log, it error out

SYS@CTA>select logdetail.member, loggroup.group#, loggroup.sequence#, loggroup.archived, loggroup.status lg_status, logdetail.status ld_detail, logdetail.type
  2  from v$log loggroup join v$logfile logdetail
  3  on loggroup.group# = logdetail.group#;

MEMBER                                                                          
--------------------------------------------------------------------------------
    GROUP#  SEQUENCE# ARC LG_STATUS        LD_DETA TYPE                         
---------- ---------- --- ---------------- ------- -------                      
D:\ORA102\CTA\REDO01.LOG                                                        
         1        136 YES CLEARING_CURRENT         ONLINE                       
                                                                                
D:\ORA102\CTA\REDO03.LOG                                                        
         3        135 YES CLEARING                 ONLINE                       
                                                                                
D:\ORA102\CTA\REDO02.LOG                                                        
         2        134 YES CLEARING                 ONLINE                       
                                                                                

SYS@CTA>
SYS@CTA>alter database recover managed standby database cancel;
alter database recover managed standby database cancel
*
ERROR at line 1:
ORA-16136: Managed Standby Recovery not active 


SYS@CTA>
SYS@CTA>--add online redo log start
SYS@CTA>ALTER DATABASE ADD LOGFILE MEMBER 'D:\Ora102\cta\REDO01.LOG' to GROUP 1;
ALTER DATABASE ADD LOGFILE MEMBER 'D:\Ora102\cta\REDO01.LOG' to GROUP 1
*
ERROR at line 1:
ORA-01577: cannot add log file 'D:\Ora102\cta\REDO01.LOG' - file already part 
of database 


SYS@CTA>ALTER DATABASE ADD LOGFILE MEMBER 'D:\Ora102\cta\REDO02.LOG' to GROUP 2;
ALTER DATABASE ADD LOGFILE MEMBER 'D:\Ora102\cta\REDO02.LOG' to GROUP 2
*
ERROR at line 1:
ORA-01577: cannot add log file 'D:\Ora102\cta\REDO02.LOG' - file already part 
of database 


SYS@CTA>ALTER DATABASE ADD LOGFILE MEMBER 'D:\Ora102\cta\REDO03.LOG' to GROUP 3;
ALTER DATABASE ADD LOGFILE MEMBER 'D:\Ora102\cta\REDO03.LOG' to GROUP 3
*
ERROR at line 1:
ORA-01577: cannot add log file 'D:\Ora102\cta\REDO03.LOG' - file already part 
of database 




based on my understanding from http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmdupdb.htm#sthref908

Quote:

As part of the duplicating operation, RMAN automates the following steps:

Creates a control file for the duplicate database

Restores the target datafiles to the duplicate database and performs incomplete recovery by using all available incremental backups and archived redo logs

Shuts down and starts the auxiliary instance (refer to "Task 4: Start the Auxiliary Instance" for issues relating to client-side versus server-side initialization parameter files)

Opens the duplicate database with the RESETLOGS option after incomplete recovery to create the online redo logs (except when running DUPLICATE ... FOR STANDBY, in which case RMAN does not open the database)




when duplicating for standby database it does not create online redo logs. please correct me if I'm wrong on duplicating a standby database does not creates online redo logs.

how should I add the online and standby redo logs. If I transfer the redo logs from primary to standby, it always encountered the the following error

Dump file d:\ora102\cta\bdump\cta_arc0_3624.trc
Tue Sep 13 19:21:53 2011
ORACLE V10.2.0.4.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the OLAP, Data Mining and Real Application Testing options
Windows XP Version V5.1 Service Pack 2
CPU                 : 1 - type 586
Process Affinity    : 0x00000000
Memory (Avail/Total): Ph:556M/1023M, Ph+PgF:819M/1308M, VA:1723M/2047M
Instance name: cta

Redo thread mounted by this instance: 1

Oracle process number: 14

Windows thread id: 3624, image: ORACLE.EXE (ARC0)


*** SERVICE NAME:() 2011-09-13 19:21:53.062
*** SESSION ID:(36.1) 2011-09-13 19:21:53.062
*** 2011-09-13 19:21:53.062 21373 kcrr.c
ORA-16014: log 6 sequence# 127 not archived, no available destinations
ORA-00312: online log 6 thread 1: 'D:\ORA102\CTA\REDO06.LOG'
*** 2011-09-13 19:26:51.812
*** 2011-09-13 19:26:51.812 62692 kcrr.c
ARC0: Archival disabled due to shutdown: 1089
tkcrrxmp: Stopping ARC1 to reduce ARCH processes from 2 to 0
tkcrrxmp: Stopping ARC0 to reduce ARCH processes from 1 to 0




any solution to the above problem?

thanks a lot!
Re: How to add both online and redo log files to standby databas [message #523297 is a reply to message #522765] Fri, 16 September 2011 10:37 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

You have to create standby redo only not online log file. Did you try this

ALTER DATABASE ADD [STANDBY] LOGFILE [THREAD integer] [GROUP integer] [REUSE] SIZE filespec;

- Babu

[Updated on: Fri, 16 September 2011 10:37]

Report message to a moderator

Previous Topic: primary don't want be open after standby configuration
Next Topic: How to resolve ORA-16401: archivelog rejected by RFS
Goto Forum:
  


Current Time: Thu Mar 28 05:02:51 CDT 2024