This content has been marked as final. Show 8 replies
So I understand you have a full backup of 09'th Nov. May I Know exactly what are you trying to do.
* are trying to restore the full backup only
* or trying to recover till some specific time?
If you are restoring the full backup only, then restore database alone would do. If not, then we need to look your exact requirements.
I am trying to restore full backup only.
Ok, So use the below -
rman target /
rman> list backup (Make sure the database backup is valid and available)
alter database open;
Restore database is happeneing, but nothing showing in v$session_longops view. yesterday I did restore.Today I tried to receover database. Given the above problem,
So today I have started again the restore activity.
Ok. If you are restoring the database and was successful, then what is the issue here. What is the necessity to recover the database?
Also, it looks bit strange why the restore is not appearing in the v$session_longops. It should display in the view.
Is the database open now after the restoration?
restore database was done.
When recover database happening , issue is below.
starting media recovery
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01190: control file or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: '/oracle/PBW/sapdata1/system_1/system.data1'
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-03002: failure of recover command at 11/15/2012 09:17:21
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 186143 lowscn 5870286990828 found to restore
RMAN-06025: no backup of log thread 1 seq 186142 lowscn 5870286983456 found to restore
The issue is, first i have take the backup of database and then control file.
I am doing time in recovery from the backup.
I have to restore on the particular time.
Now I am set until time to eg"10:00".
I need restore the control file to 'location'
after this restore database
Can you please let me know the above steps are OK.?
You need to restore & recover database until archive log sequence 18614 & 186142
$ sqlplus "/ as sysdba"
SQL> shutdown abort;
SQL> startup mount;
$ rman target
RMAN> restore database until sequence 186143;
RMAN> restore database until sequence 186142;
RMAN> recover database until sequence 186143;
RMAN> recover database until sequence 186142;
SQL> alter database open resetlogs;
Hope this will help you