PLEASE HELP: ORACLE 8i STANDBY DATABASE

From: DBA-Jim <jbizzaro_at_jackpot.com>
Date: 25 Jul 2001 17:31:55 -0700
Message-ID: <d612576.0107251631.ae8dde@posting.google.com>

Hello database comrades,

I'm getting a strange error when I try to place an Oracle standby database in managed recovery mode by issuing "RECOVER MANAGED STANDBY DATABASE" . Please review the following sequence of events I took below. For some reason it tries to restore the next available log instead of waiting for the next one to come via the service hence "MANAGED" mode. Please help!

I have followed the standard steps:

1. Created the Standby Datafies.
2. Created the Standby Control File.
3. Transferred the files to the standby site

Entries in the INIT file:

log_archive_start = false

log_archive_dest_1 = "location=G:\Oracle\archive"

standby_archive_dest = "G:\Oracle\archive"

log_archive_format = ODB1_%S.ARC

log_archive_trace = 100

Sequence of events leading to error:

SQL> startup nomount pfile=e:\oracle\admin\pfile\initSTANDBY.ora; ORACLE instance started.

Total System Global Area 304280844 bytes

Fixed Size                    70924 bytes
Variable Size             287260672 bytes
Database Buffers           16777216 bytes
Redo Buffers                 172032 bytes

SQL> alter database mount standby database;

Database altered.

SQL> Recover standby database;
ORA-00279: change 15742701 generated at 07/25/2001 17:02:25 needed for thread 1
ORA-00289: suggestion : G:\ORACLE\ARCHIVE\DB1_00105.ARC ORA-00280: change 15742701 for thread 1 is in sequence #105

Specify log: {<RET>=suggested | filename | AUTO | CANCEL} auto
ORA-00279: change 15742924 generated at 07/25/2001 17:08:30 needed for thread 1

ORA-00289: suggestion : G:\ORACLE\ARCHIVE\DB1_00106.ARC
ORA-00280: change 15742924 for thread 1 is in sequence #106
ORA-00278: log file 'G:\ORACLE\ARCHIVE\DB1_00105.ARC' no longer needed

for this recovery

ORA-00279: change 15742926 generated at 07/25/2001 17:08:33 needed for thread 1

ORA-00289: suggestion : G:\ORACLE\ARCHIVE\DB1_00107.ARC
ORA-00280: change 15742926 for thread 1 is in sequence #107
ORA-00278: log file 'G:\ORACLE\ARCHIVE\DB1_00106.ARC' no longer needed

for this recovery

ORA-00308: cannot open archived log 'G:\ORACLE\ARCHIVE\DB1_00107.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> Recover managed standby database;

ORA-00308: cannot open archived log 'G:\ORACLE\ARCHIVE\DB1_00107.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.

• ??????????? ***********

Thanks so much,

JB Received on Wed Jul 25 2001 - 19:31:55 CDT