Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: restore/recovery
Paula - I think you are correct. In my environment I just use RMAN to back
up to disk. I haven't found an advantage to having RMAN back up the archive
logs. Anyway it sounds like Ruth has provided some good advice that is
closer to your actual issue.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of
Paula_Stankus_at_doh.state.fl.us
Sent: Wednesday, March 10, 2004 2:09 PM
To: oracle-l_at_freelists.org
Subject: RE: restore/recovery
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of DENNIS WILLIAMS
Sent: Wednesday, March 10, 2004 2:57 PM
To: 'oracle-l_at_freelists.org'
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_at_lifetouch.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On
Behalf Of Paula_Stankus_at_doh.state.fl.us
Sent: Wednesday, March 10, 2004 1:16 PM
To: oracle-l_at_freelists.org
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
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
![]() |
![]() |