Folks,
Hello. On December 2, 2013, I backed up my database instance HRCS90 using RMAN with Oracle Linux 5 as below:
SQL>startup mount; (Database HRCS is mounted but not open.)
SQL>exit;
[user@linux bin]$ ./rman
RMAN>connect target;
RMAN>configure channel device type disk format '/backup_database_instance_HRCS90/full_%0_%s_%p'; (backup_database_instance_HRCS90 is the directory to store backup files)
RMAN>configure retention policy to recovery window of 360 days;
RMAN>configure control file auto backup on;
RMAN>show all;
RMAN>backup database;
Then backing up database runs 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. My questions are:
First, do I need to delete my current database instance HRCS90 that's corrupted ?
Second, may I just do the follwing 2 commands one by one to restore database:
RMAN>restore database;
RMAN>recover database;
Third, does the above 2 commands restore database HRCS90 from the 2 files automatically in directory /backup_database_instance_HRCS90 on December 2, 2013 ?
Finally, if the above 2 commands are not correct, how to restore database correctly on December 2, 2013 ?
Thanks in advance.