| 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...!)..
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
