Unable to open database

[Former Member]

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

[Former Member]

Suggest you to close this thread and open a new thread for new issue.

Regards,

Nick Loy

[Former Member]

Hi

I have faced the same error, Below commands may help you

*SQL> recover database using backup controlfile ;*

It will tell that which log is required to restore.

ORA-00279: change 4353699529 generated at 12/18/2010 14:29:39 needed for thread

1

ORA-00289: suggestion : /oracle/PDR/oraarch/PDRarch1_128397_624465037.dbf

ORA-00280: change 4353699529 for thread 1 is in sequence #128397

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

auto

ORA-00308: cannot open archived log

'/oracle/PDR/oraarch/PDRarch1_128397_624465037.dbf'

ORA-27037: unable to obtain file status

HPUX-ia64 Error: 2: No such file or directory

Additional information: 3

Now restore the redolog fromproduction server and then repeate the command

SQL> recover database using backup controlfile ;

After completing the command then check how many logs are required for recovery. Run the command below

Run below command to know which redo log file is required to be recover

SQL> select file# from V$RECOVER_FILE;

no rows selected

SQL> select * from V$RECOVER_FILE;

no rows selected

SQL> select * from V$RECOVERY_LOG

If display no log then run below command

SQL> shutdown immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area 1.1492E+10 bytes

Fixed Size 2063312 bytes

Variable Size 3103786032 bytes

Database Buffers 8371830784 bytes

Redo Buffers 14712832 bytes

Database mounted.

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> recover database

ORA-00283: recovery session canceled due to errors

ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

SQL> alter database open resetlogs;

Database altered.

SQL> shutdown

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 1.1492E+10 bytes

Fixed Size 2063312 bytes

Variable Size 3103786032 bytes

Database Buffers 8371830784 bytes

Redo Buffers 14712832 bytes

Database mounted.

Database opened.

SQL>

Now Oracle has started

[Former Member]

Hi ,

I had performed the following steps:

1> Upgraded version to 0.4

2> Performed startup upgrade

But still we were facing the issue.

So we started providing the redo logs from origlog and mirrlog when we got the error executing recover backup...

after this we were able to open the database successfully.

But now we are facing the problem is sap is not getting started.Errors are as mentioned below:

-

---

bslr3tst:brtadm 17> startsap

Checking BRT Database

-

---

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-

---

11:26:06 06.01.2011 LOG: Effective User Id is root

***********************************************************************

• This is Saposcol Version COLL 20.95 700 - AIX v11.00 5L-64 bit 070920

• Usage: saposcol -l: Start OS Collector

• saposcol -k: Stop OS Collector

• saposcol -d: OS Collector Dialog Mode

• saposcol -s: OS Collector Status

• The OS Collector (PID 749742) is already running .....

************************************************************************

saposcol already running

Running /usr/sap/BRT/SYS/exe/run/startdb

Trying to start BRT database ...

Log file: /home/brtadm/startdb.log

/usr/sap/BRT/SYS/exe/run/startdb: Terminating with error code 12

DB startup failed

-

---

Entries in listner and sqlnet.ora is correct.

Regards,

Amit

[Former Member]

1> Upgraded version to 0.4

2> Performed startup upgrade

Are you performing oracle patch upgrade to 0.4? if this is the case then have you performed the post patch activity?

Your database will not come up until you complete the opatch post installation.

Once you finish with opatch, start your database manually using sqlplus command.

Try to connect via <sid>adm using 'R3trans -d' and check trans.log, you must get RC=0000 else check the trans.log.

[Former Member]

Who are you?

amit prayag or skreddy555 ?

Why posting the same question again?

What is wrong with the answers you already got?

[Former Member]

HI joe,

srk and I had posted seperately but unknowingly.I his message the reply i had received says about the startup upgrade and also about the oracle version.I m not aware of the impact of the startup upgrade, which I would like to know what exactly it does.Also the oracle version difference mentioned I belive should not create any problem as its should be downward compatible and also the error logs doesnt give any compatiblity issue.

Regards,

Amit

[Former Member]

srk and I had posted seperately but unknowingly.

And how come you chose the same wording and even the same formatting, like here:

After completing the process we gave command as "alter database open resetlogs; "

Would you like to comment on that?

Also the oracle version difference mentioned I belive should not create any problem as its should be downward compatible and also the error logs doesnt give any compatiblity issue.

Sorry to disagree.

The error log does give a compatibility issue:

ORA-39700: database must be opened with UPGRADE option

regards