DataBase Open Problem

[Former Member]

Hi Gurus ,

I restored the online backup of our R3 server to different hardware with different file structure using brtools . But after restore the DB am not able to open the database . here with below i mentioned the error while starting the database .

SQL> startup

ORACLE instance started.

Total System Global Area 1627389952 bytes

Fixed Size 2004648 bytes

Variable Size 822085976 bytes

Database Buffers 788529152 bytes

Redo Buffers 14770176 bytes

Database mounted.

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

So kindly

[Former Member · Accepted solution]

Hi,

You can also use below command for recovery.

SQL>recover database;

Regards

Krishna

[Former Member]

Hi,

Goto sql prompt

sqlplus u201C/ as sysdbau201D

Execute the below commands for recovery and open reset logs.

SQL> recover automatic database until cancel using backup controlfile;

SQL> alter database open resetlogs;

and try to open the Database.

Regards

Krishna

[former_member603052]

Hi,

Since the backup is online and you restored it.

Now you need to recover the DB using archive logs.

After you apply archive logs you can open the database using the command alter database open resetlogs

Regards,

Kalyan

[JPReyes]

Try to open the database by using command alter database open resetlogs;

Regards

Juan