Hi all,

Unfortunately, am one of those who are still on Oracle8. Can someone tell me if
there is a bug on Oracle8 that is messing up my RECOVER FROM '/log directory'
STANDBY DATABASE command.

I know the files are there because if I cut-and-paste the file that Oracle is
looking for, it applies the log with no problem ...

BTW, already have 3-cups of coffee so I know am looking at the right file.
Besides I cut-and-paste the one file that he is looking for .... Anyway,
perhaps someone can tell me what am missing here ...

See below:


=============================================================

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production

SQL> RECOVER FROM '/nzp/dg/cidpr/log/PROD01/archive_standby' STANDBY DATABASE;
ORA-00279: change 12386437 generated at 06/21/2006 10:02:44 needed for thread 1
ORA-00289: suggestion :
/nzp/dg/cidpr/log/PROD01/archive_standby/arch_1_68402.arc
ORA-00280: change 12386437 for thread 1 is in sequence #68402


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log
'/nzp/dg/cidpr/log/PROD01/archive/arch_1_68402.arc'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3


SQL> RECOVER FROM '/nzp/dg/cidpr/log/PROD01/archive_standby' STANDBY DATABASE
ORA-00279: change 12386437 generated at 06/21/2006 10:02:44 needed for thread 1
ORA-00289: suggestion :
/nzp/dg/cidpr/log/PROD01/archive_standby/arch_1_68402.arc
ORA-00280: change 12386437 for thread 1 is in sequence #68402


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/nzp/dg/cidpr/log/PROD01/archive_standby/arch_1_68402.arc
ORA-00279: change 12386511 generated at 06/21/2006 10:02:45 needed for thread 1
ORA-00289: suggestion : /nzp/dg/cidpr/log/PROD01/archive/arch_1_68403.arc
ORA-00280: change 12386511 for thread 1 is in sequence #68403
ORA-00278: log file
'/nzp/dg/cidpr/log/PROD01/archive_standby/arch_1_68402.arc' no longer needed
for this recovery


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
Media recovery cancelled.

=============================================================



Oracle LazyDBA home page