RE: restore/recovery
- From: <Paula_Stankus@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 10 Mar 2004 15:09:29 -0500
I don't think that is quite true. If your system admin. blows the box away and
you are doing a restore - so no online redo - then without using recover
database you don't get the archivelog files restored for recovery unless you
restore the archivelog files separate - right? My thought was that recover
database in this cause would restore necessary archive files.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of DENNIS WILLIAMS
Sent: Wednesday, March 10, 2004 2:57 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: restore/recovery
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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
