Home » RDBMS Server » Backup & Recovery » RMAN complete restore -- noarchive log fails.. (Oracle 9i/ Solaris 9)
RMAN complete restore -- noarchive log fails.. [message #326286] Tue, 10 June 2008 23:59
desertrose22
Messages: 1
Registered: June 2008
Location: mumbai
Junior Member

a) I am trying a complete restore on my database(no archive) from a RMAN backup

b) Accidentially ran the wrong script mentioned below, resulting in the datafile being restored in the ORACLE_HOME\dbs directory with the file_name D:ORACLEORADATATIMEX1CWMLITE01.DBF, an so on..

SET DBID xxxxx;
CONNECT TARGET /;
STARTUP NOMOUNT;
RUN
{
ALLOCATE CHANNEL FOO2 TYPE DISK;
ALLOCATE CHANNEL FOO3 TYPE DISK;

RESTORE CONTROLFILE FROM '/u06/oradata/index1/RMAN_BKP/TESTADC/ora_cfc-2955635561-20080602-00';
ALTER DATABASE MOUNT;

SET NEWNAME FOR DATAFILE 3 TO 'D:\ORACLE\ORADATA\TIMEX1\CWMLITE01.DBF';
SET NEWNAME FOR DATAFILE 5 TO 'D:\ORACLE\ORADATA\TIMEX1\EXAMPLE01.DBF';
........
........

RESTORE DATABASE;
SWITCH DATAFILE ALL;
RECOVER DATABASE;
ALTER DATABASE OPEN RESETLOGS;
}

c) I deleted the files created by the wrong script(step b).

d) Now a complete restore on the database fails with the following :
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=11 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=9 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: ====== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===================================================
RMAN-03002: failure of restore command at 06/11/2008 09:47:18
ORA-19625: error identifying file /boapp/oracle/product/9.2.0/dbs/D:ORACLEORADATATIMEX1CWMLITE01.DBF
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

e) Questions :
i) How do i do a complete restore of my database now.??
ii)Can anyone explain the scenario..(as to my knowledge, i should be able to make a complete restore from a consistent RMAN backup...!)..
Previous Topic: Block recovery using logical backup
Next Topic: recovery catalog problem
Goto Forum:
  


Current Time: Tue Dec 06 02:26:20 CST 2016

Total time taken to generate the page: 0.16038 seconds