-
Hi all
I followed the below steps to create hot backup database, but when I restore I got the problem.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open.
And then I try to open with resetlogs and noresetlogs, I got another error
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1 : '/db02/oracle/oradata/system01.dbf'
Please help me to solve this problem. I tried so many different ways but it still doesn't work.
Thanks
alter tablespace system begin backup;
!cp to backup directory
alter tablespace system end backup;
REM ****** backup user tablespace
alter tablespace user begin backup;
!cp to backup directory
alter tablespace user end backup;
REM ****** backup rollback tablespace
alter tablespace rollback begin backup;
!cp to backup directory
alter tablespace rollback end backup;
REM ****** backup temp tablespace
alter tablespace temp begin backup;
!cp to backup directory
alter tablespace temp end backup;
REM ****** Perform controlfile backup
Alter database backup controlfile to filename reuse;
Alter database backup controlfile to filename reuse;
alter database backup controlfile to trace;
copy file to backup directory
REM ****** Backup online redo-logs
Alter system archive log all;
copy redo log files into backup directory
-
Hi,
During recovery did you specify UNTIL CANCEL? Otherwise ORACLE will assume compelte recovery and keep asking you for logs.
Use "recover database until cancel using backup controlfile" and reply CANCEL when you have reached the required log. Then open database with RESETLOGS.
BAliga
-
mbaliga
I followed your way, but it has the same error.
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'system01.dbf'
Is there anything need to be done first?
THanks
-
I have come across the same problem but i dont remember the solution that i did. But i too would like to hear the solution for that.
karthi,
MDC Systems inc
Farmington Hills,MI
-
Hi,
You get these messages if you originally start with "recover database" command and later switch to "recover database until cancel".
Check the V$datafile view and make sure all the datafiles are at the same change number. If you find that all have the same change no, then recreate the controlfile and open the database with resetlogs.
Baliga
-
Hi Ns
I too faced the same problem yesterday.And i executed the same steps as u did.Just the same steps.But like u i too didn't succeeded
Then in my backup control file i placed the NORESETLOGS Option in create controlfile command and i ran this controlfile.Because, if u put noresetlogs it will make ur control file current.and you can open your database simply like that.If you solved this problem by now it's cool.If not,and still you end up with any problems reg. this let me know.
Thanks
Ravi
ravi
-
nsuser,
How have you perform your restore/recovery? Are you sure you restored all the files from the same backup? Have you also restored your controlfile from your backup (not very good idea if you have usable current controlfile, but must be done under certain circumstances...)? It seems to me that (at least) your system01.dbf datafile is from a backup taken later than your backup controlfile or smth simmilar... Please provide all of your steps when performing restore and recover.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
I am very weary of Oracle Restores !
The best thing that I can recommend is that you spend a few days doing all kinds of restores on a test machine. I learned an awful lot and destroyed the database 6-8 times before I started to see the logic of the whole thing. The resetlogs can be a bit dangerous because it starts a new era of the db.
I would never "learn" how to restore on a live production db. Once you F***ed up it may be hard to come back without a cold backup from before you started playing with the restores.
-
rogerF: I am going to do the same. Nevertheless, could you share what logic you've started to see? What kind of tests you did?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|