You are a smart lady. I am allocating tapes in all of my scripts,
instead of scripting it and reusing like you do. I apologize in
advance, but I am about to steal your idea.
On 03/10/2004 02:16:13 PM, Paula_Stankus_at_doh.state.fl.us wrote:
> -Solaris 2.8
> -Oracle 8.0.6
>
> Restoring - restore says it is complete but recovery keeps failing or hanging:
>
> connect target $TARGET@$DBNAME
>
> run {
>
> execute script alloc_all_tapes;
>
> restore controlfile to '/data/oradata/CSTAT/ctrl/control01.ctl';
>
> allocate channel d1 type disk;
>
> replicate controlfile from '/data/oradata/CSTAT/ctrl/control01.ctl';
>
> sql 'alter database mount';
>
> restore database until time
>
> "to_date('JAN 27 2004 12:00:00','MON DD YYYY HH24:MI:SS')";
>
> sql 'alter database open resetlogs';
>
> execute script rel_all_tapes;
>
> }
>
> EOD
>
>
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Wed Mar 10 2004 - 13:43:04 CST
