RE: RMAN recovery Oracle 8.1.7 notes on recovery

Ron - Thanks for posting "the rest of the story".

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Tuesday, May 27, 2003 8:25 AM
To: Multiple recipients of list ORACLE-L

Dennis,
 today is Tue 5/27 and the work was performed Thur 5/22. From my notes:
 9 a.m. I asked the sysadmin to recover the weekly datafiles from the Wed nite backup. As well I attempted the RMAN recovery and I had the failure of nothing happening. I was reading the instructions and scripts from "Oracle backup and recovery 101". The type is small and I missed a single quite in the command string. I have a printed copy of the PDFs and that, along with the list's answers, is where I found my error. 2:20 p.m. The tape recovery not completed yet so I tried the RMAN recovery again. This time taking care in reading the scripts. "Oracle backup and recovery" Page 376 Incomplete Restore and recover database.
As RMAN: I connected to the target database. Connected to the catalog database.
run {
SET UNTIL TIME "TO_DATE('05/21/2003 16:15:00','MM/DD/YYYY HH24:MI:SS')";
ALLOCATE CHANNEL D1 TYPE DISK;
RESTORE DATABASE;
RECOVER DATABASE;
ALTER DATABASE OPEN RESETLOGS;
}

The restore and recovery was completed at 3:20 p.m. The sysadmin called at 3:10 p.m. stating that he had recovered the datafiles and wanted to know if he should move them to their proper location. Not needed at this time.
The RMAN restored the database and used the archivelogs to bring the database up to the time 16:15:00 and then open the database. It worked like a charm and no data was lost.
 There was no activity on the database after I deleted the data from the weekly tables in error and I did that wonderful act at 16:20. After the database was opened I performed another LEVEL0 backup to bring my backups into sync with the database SCNs.  I know that RMAN can recover a single datafile but I got confused with all of the different command in the books I have. They tend to describe the functions under 9i rather than 8i and the commands structure is different. I am glad that I had the printed PDFs as they were for the 8i version of RMAN and easier to read and understand. RMAN is slick and fast.
Ron

>>> DWILLIAMS_at_LIFETOUCH.COM 05/22/03 05:48PM >>>
Ron - Can you provide any more details while it is fresh in your mind for
those of us who haven't had the courage to try this one?

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).