Error during re-creation of standby database
779621Jul 3 2010 — edited Sep 30 2010Hi Gurus,
DB Version -9.2.0.8
I have activated my standby database for application testing purpose,but before that i have taken the coldbackup of data,control,configuration files as i knew i'll have to re-create the standby database once again on the same server.
I kept the same directory structure
I replaced datafiles with old backup datafiles
I created new instance
restored pfile and PWD file
create spfile when connected to idle instance
Mounted my standby database
I put my standby db in recovery mode,but archives were not transfering from PROD to DR.
However;i have checked linstner,tnsname.ora ,fal_server,fal_client, RFS process was showing attached and receiving status everything is correct but the archives were not getting transfered on DR from PROD .
For a while i decided to maually feed the archives to my DR this is what i did after copying all necessary archives from PROD to DR .
Following steps i did after shutdown immediate the DR
SQL> startup nomount
ORACLE instance started.
Total System Global Area 1234249560 bytes
Fixed Size 456536 bytes
Variable Size 461373440 bytes
Database Buffers 771751936 bytes
Redo Buffers 667648 bytes
SQL> alter database mount standby database;
Database altered.
SQL> recover standby database;
ORA-00279: change 30315625 generated at 06/21/2010 04:05:07 needed for thread 1
ORA-00289: suggestion : D:\SUN\ARCHIVESARC04308.001
ORA-00280: change 30315625 for thread 1 is in sequence #4308
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log 'D:\SUN\ARCHIVESARC04308.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-00308: cannot open archived log 'D:\SUN\ARCHIVESARC04308.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'D:\SUN\DATA\SYSTEM01.DBF'
I have also did log switches and transfered those generated archives to DR location and tried again but getting the same error.
Can any one please let me know what went wrong ??
Thanks in advance
Girish
Edited by: user13299764 on Jul 3, 2010 12:36 AM
Edited by: user13299764 on Jul 3, 2010 12:38 AM
Edited by: user13299764 on Jul 3, 2010 12:44 AM