-
recover standby database
I have backed up archive logs to the standby database and followed the steps below to recover it, but am running into the error shown. What am doing wrong?
SQL> connect /as sysdba
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 286858140 bytes
Fixed Size 453532 bytes
Variable Size 184549376 bytes
Database Buffers 100663296 bytes
Redo Buffers 1191936 bytes
SQL> alter database mount standby database;
Database altered.
SQL> recover standby database until cancel;
ORA-00279: change 739533 generated at 01/23/2006 12:36:36 needed for thread 1
ORA-00289: suggestion : C:\U01\APP\ORACLE\ADMIN\OKCDBST2\ARCHARCH_1_64.ARC
ORA-00280: change 739533 for thread 1 is in sequence #64
Specify log: {=suggested | filename | AUTO | CANCEL}
ORA-00279: change 739895 generated at 01/23/2006 12:54:36 needed for thread 1
ORA-00289: suggestion : C:\U01\APP\ORACLE\ADMIN\OKCDBST2\ARCHARCH_1_65.ARC
ORA-00280: change 739895 for thread 1 is in sequence #65
ORA-00278: log file 'C:\U01\APP\ORACLE\ADMIN\OKCDBST2\ARCHARCH_1_64.ARC' no
longer needed for this recovery
Specify log: {=suggested | filename | AUTO | CANCEL}
ORA-00279: change 741914 generated at 01/23/2006 14:36:17 needed for thread 1
ORA-00289: suggestion : C:\U01\APP\ORACLE\ADMIN\OKCDBST2\ARCHARCH_1_66.ARC
ORA-00280: change 741914 for thread 1 is in sequence #66
ORA-00278: log file 'C:\U01\APP\ORACLE\ADMIN\OKCDBST2\ARCHARCH_1_65.ARC' no
longer needed for this recovery
Specify log: {=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log
'C:\U01\APP\ORACLE\ADMIN\OKCDBST2\ARCHARCH_1_66.ARC'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01666: controlfile is for a standby database
-
what are you trying to do, perform a switchover or sync with your prod db?
Jeff Hunter
-
-
am trying to sync with production database
-
-
so why did you create a standby, is it a one time thing, or consistently up to date?
-
I just built one for practice. I imagine if i built one it will be consistently be up to date. Can tell me how to do both? Thanks
-
it is a physical or a logical standby?
-
-
alter database recover managed standby database disconnect from session;
this needs to be done AFTER you have done alter database mount standby database;
That will keep it in sync forever, make sure you have set log_archive_dest on the primary, fal client and server as well
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|