Skip to Content
0
Former Member
Jan 04, 2011 at 03:18 AM

Unable to open database

344 Views

Dear Guru!,

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...

-


Regards,

Amit