Folks,
Hello. On December 2, 2013, I backed up my database instance HRCS90 using RMAN with Oracle Linux 5.The backing up database run successfully. The 2 files " full_0doqhbqc_13_1 " and " full_0eoqhce9_14_1 " are saved into the directory /backup_database_instance_HRCS90.
Because my database HRCS90 has been corrupted, I need to restore database HRCS90 up to the time 02-Dec_13 when it's backed up.
First time, don't use SET UNTIL. I run the commands as below:
RMAN > CONNECT TARGET;
RMAN > RESTORE DATABASE;
The system comes up the error message as below:
RMAN-06956:create datafile failed; retry after removing /u01/oradata/HRCS90/psimage2.dbf from OS.
Thus, I remove the file /u01/oradata/HRCS90/psimage2.dbf and don't make a copy of it.
I run RESTORE DATABASE again and the file psimage2.dbf is recreated.
The output of RESTORE DATABASE command is:
Restore complete, elapsed time: 00:15:54
Finished restore at 01-FEB-14.
Then I run the command below:
RMAN>RECOVER DATABASE;
Its output: warning: media recovery until SCN 1947113 complete. Finished recover at 03-FEB-14.
Second time, because I need the database before 02-12-2013 when it was backed up, I run the commands below:
RMAN > RUN { SET UNTIL TIME "to_date ( '02-12-2013 : 00 : 04 : 56', 'DD-MM-YYYY : HH24:MI:SS')" ; RESTORE DATABASE;}
The above commands run successfully and restore completed.
Then I run the commands below:
SQL > ALTER DATABASE OPEN RESETLOGS;
Its output: failure of alter db command. File 121 was created in the future of incomplete recovery. Data file 121: /u01/oradata/HRCS90/psimage2.dbf.
RMAN > RECOVER DATABASE NOREDO;
Its output: failure of recover command. Data file 121 must be restored.
Data file 121 is the file /u01/oradata/HRCS90/psimage2.dbf. I have made sure the directory /u01/oradata/HRCS90/ has rwx permissions for all users and groups.
RESTORE DATABASE SET UNTIL does not recreate the file psimage2.dbf while RESTORE DATABASE recreate the file psimage2.dbf.
I have removed the file psimage2.dbf and cannot take it back. I cannot find the article ORA-1248 by DBPITR that used a current controlfile (Doc ID 1558515.1).
My question is:
Can any folk tell me how to RESTORE/RECOVER database HRCS90 with SET UNTIL in other way such as using Control file ?
or how to fix the file psimage2.dbf that was removed by me ?
Thanks in advance.