RE: restore/recovery
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 10 Mar 2004 13:57:25 -0600
Paula - If RMAN recovery encounters problems, I exit RMAN and just log into
Oracle (svrmgrl in 8i, sqlplus in 9i) and perform the recovery there. I
believe that for recovery RMAN is just issuing the same commands to the
RDBMS.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@xxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Paula_Stankus@xxxxxxxxxxxxxxx
Sent: Wednesday, March 10, 2004 1:16 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: restore/recovery
-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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
