Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: RECOVER AUTOMATIC STANDBY DATABASE; Script question
76434.1353_at_compuserve.com (Ton) wrote in
news:4477604.0402240415.21bd262e_at_posting.google.com:
> Chuck:
>
> I tried your solution in the script but the situation is still the
> same. The scripts is hanging and waiting for the manual answering of
> CANCEL or AUTO
> (See underneath)
>
> I want to run the script unattended so that it will not hang. As
> described in first msg under name ITAPORT06
>
> Thanks
>
> Statement processed.
> ORA-00279: change 14285347 generated at 02/24/2004 10:44:32 needed for
> thread 1
> ORA-00289: suggestion :
> D:\SUN_BACKUP_DATA\ORACLE_SUNL_ARC\SUNL_ARC_12199.ARC
> ORA-00280: change 14285347 for thread 1 is in sequence #12199
> Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
I've found in some cases with windows you need to redirect the sql script into sqlplus to get things to work. Instad of issuing a command like "sqlplus @recover.sql", do this "sqlplus < recover.sql". Make sure the recover.sql file contains all the commands from my previous post including the connect.
-- Chuck Remove "_nospam" to reply by emailReceived on Tue Feb 24 2004 - 13:02:25 CST