on 01-03-2011 7:37 AM
I m performing the data refresh activity. I had taken the backup(database backup through filesystem) and restored the same in the new target system.My target system is an freshly installed SAP system where I m replicating the data of PRD.
I had done the restoration successfully and also had created successfully the control file. But when i try command as
"alter database open resetlogs;" it gives error as alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 2 was not restored from a sufficiently old backup
ORA-01110: data file 2: '/oracle/BRT/sapdata5/undo_1/undo.data1'
Below mentioned are the tried commands.
-
SQL> alter database recover until cancel using backup controlfile;
alter database recover until cancel using backup controlfile
*
ERROR at line 1:
ORA-00279: change 5014386605 generated at 01/01/2011 10:16:37 needed for thread
1
ORA-00289: suggestion : /oracle/BRT/oraarch/BRTarch1_172808_676564222.dbf
ORA-00280: change 5014386605 for thread 1 is in sequence #172808
SQL> alter database recover until cancel using backup controlfile;
alter database recover until cancel using backup controlfile
*
ERROR at line 1:
ORA-00275: media recovery has already been started
SQL> alter database recover cancel;
alter database recover cancel
*
ERROR at line 1:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 2 was not restored from a sufficiently old backup
ORA-01110: data file 2: '/oracle/BRT/sapdata5/undo_1/undo.data1'
SQL> alter database recover until cancel using backup controlfile;
alter database recover until cancel using backup controlfile
*
ERROR at line 1:
ORA-00279: change 5014386605 generated at 01/01/2011 10:16:37 needed for thread
1
ORA-00289: suggestion : /oracle/BRT/oraarch/BRTarch1_172808_676564222.dbf
ORA-00280: change 5014386605 for thread 1 is in sequence #172808
-
We modified the command later as " recover database using backup controlfile until cancel;"for which it asked for AUTO Cancel etc. where we gave an option of CANCEL.
After completing the process we gave command as "alter database open resetlogs;"
For which we got an err in trace file as mentioned below:
-
Errors in file /oracle/BRT/saptrace/usertrace/brt_ora_2109488.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Mon Jan 3 11:35:47 2011
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 2109488
ORA-1092 signalled during: alter database open resetlogs...
-
The dbf file it is asking is present in target system , but still facing the same issue.
Kindly suggest .
Regards,
thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.