But that archived isnīt archived yet. This scripts executes in my standby database.
The last archive archived and copied is the F:\ORACLE\ORADATA\ORCL\ARCHIVE\ORCLT001S17788.ARC
-----Original Message-----
From: Shergill Gurmohan
[mailto:oracledba-ezmlmshield-x48529686.[Email address protected]
Sent: sexta-feira, 30 de setembro de 2005 16:15
To: LazyDBA Discussion
Subject: RE: Question about Recover script
Make sure the archive F:\ORACLE\ORADATA\ORCL\ARCHIVE\ORCLT001S17789.ARC is in its location and available.
Gurmohan
www.freemath.info - The ultimate tool in learning and teaching math skills.
-----Original Message-----
From: dePaula Daniel SBRASOP-ITISOLH51C
[mailto:oracledba-ezmlmshield-x33291640.[Email address protected]
Sent: Friday, September 30, 2005 3:02 PM
To: LazyDBA Discussion
Subject: Question about Recover script
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
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page