Hi
-> Oracle 8.1.7 , Operacional S. Win 2000.
-> schedule at windows schedule.
I created this code to recovery my archived logs in my standby database
myscript.sql
/* ***** */
connect internal
RECOVER AUTOMATIC STANDBY DATABASE;
EXIT
***********************************/
Then a batch calls it ... at prompt "c:\svrmgrl @myscript.sql"
My problem is the dos windows that executes this code get stucked at this point when reaches the last archived log.
The script is trying to recover a archived log that still not there yet (still be copied)
But I need the dos window to close , because next time the schedule executes... gives an error in the system.dbf " itīs in use"
Connected.
ORA-00279: change 35547547 generated at 09/30/2005 11:48:38 needed for thread 1
ORA-00289: suggestion : F:\ORACLE\ORADATA\ORCL\ARCHIVE\ORCLT001S17789.ARC
ORA-00280: change 35547547 for thread 1 is in sequence #17789
ORA-00278: log file 'F:\ORACLE\ORADATA\ORCL\ARCHIVE\ORCLT001S17789.ARC' no longe
r needed for this recovery
ORA-00308: cannot open archived log 'F:\ORACLE\ORADATA\ORCL\ARCHIVE\ORCLT001S177
89.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.
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
Anybody have any idea ???
This is the error I get when the script executes agains, with the first one stucked !
"
ORA-00283: recovery session canceled due to errors
ORA-01124: cannot recover data file 1 - file is in use or recovery
ORA-01110: data file 1: 'F:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF'
"
Thanks a Lot
Daniel
Oracle LazyDBA home page