rman

From: toto <parag9i_at_gmail.com>
Date: 9 Mar 2006 21:12:17 -0800
Message-ID: <1141967537.815956.14580@z34g2000cwc.googlegroups.com>

Hi

We are changing our backup tools from exp to rman. For this I am trying to do
restoration in test server of oracle db running on 9.2 noarchive log.

Step 1. Taken complete backup with rman with nocatalog

nput datafile fno=00008 name=D:\ORACLE\ORADATA\TOTO\TOOLS01.DBF channel ORA_DISK_1: starting piece 1 at 09-MAR-06 channel ORA_DISK_1: finished piece 1 at 09-MAR-06 piece handle=D:\DBBACKUPS\T1.BKP comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15 Finished backup at 09-MAR-06

Step 2. Deleted database files and control files from database directory.

Step 3. Restore controlfiles

RMAN> restore controlfile from 'd:\dbbackups\t1.bkp';

Starting restore at 09-MAR-06

using channel ORA_DISK_1
channel ORA_DISK_1: restoring controlfile channel ORA_DISK_1: restore complete
replicating controlfile
input filename=D:\ORACLE\ORADATA\TOTO\CONTROL01.CTL output filename=D:\ORACLE\ORADATA\TOTO\CONTROL02.CTL output filename=D:\ORACLE\ORADATA\TOTO\CONTROL03.CTL Finished restore at 09-MAR-06

Step 3. after database mount, try to restore datafiles, which is failed

restoring datafile 00024 to D:\ORACLE\ORADATA\TOTO\DIN36\TESTUNV1.ORA

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 03/09/2006 17:24:25

ORA-19505: failed to identify file "D:\DBBACKUPS\TOTOBKP.RMAN"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Why it is looking old backup totobkp.rman which is not existing on disk ? My
backup name is t1.bkp.

Will you pl tell me where I have gone wrong ? Secondly what are the correct
steps to be followed for taking cold backup and restoration.

thanks & regards
pjp Received on Thu Mar 09 2006 - 23:12:17 CST