Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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).Received on Tue May 27 2003 - 09:44:55 CDT