Restore Online backup

[Former Member]

Dear Team,

I have lost one of my test server data . But Now i have old Full Online backup and I have no latest archive log.

When I have restore from full online backup.

When after restore full online backup then I start Oracle.it give below messege

SQL> startup

ORACLE instance started.

Total System Global Area 356515840 bytes

Fixed Size 1289448 bytes

Variable Size 188744472 bytes

Database Buffers 163577856 bytes

Redo Buffers 2904064 bytes

Database mounted.

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

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01195: online backup of file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'F:\ORACLE\IDE\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

SQL> recover database until cancel;

ORA-00283: recovery session canceled due to errors

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

How I start my Oracle.

Kavi

[former_member524429 · Accepted solution]

Post your error messages (if any) , upon execution of the above commands.

Regards

Bhavik G. Shroff

[Former Member · Accepted solution]

Dear Sir,

I am using below but not started

SQL> startup

ORACLE instance started.

Total System Global Area 356515840 bytes

Fixed Size 1289448 bytes

Variable Size 188744472 bytes

Database Buffers 163577856 bytes

Redo Buffers 2904064 bytes

Database mounted.

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

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 16237932 generated at 01/22/2010 21:08:24 needed for thread 1

ORA-00289: suggestion : E:\ORACLE\IDE\ORAARCH\IDEARCHARC01209_0695222064.001

ORA-00280: change 16237932 for thread 1 is in sequence #1209

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

cancel

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: 'F:\ORACLE\IDE\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

ORA-01112: media recovery not started

SQL> recover database using backup controlfile;

ORA-00279: change 16237932 generated at 01/22/2010 21:08:24 needed for thread 1

ORA-00289: suggestion : E:\ORACLE\IDE\ORAARCH\IDEARCHARC01209_0695222064.001

ORA-00280: change 16237932 for thread 1 is in sequence #1209

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

cancel

Media recovery cancelled.

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01113: file 1 needs media recovery

ORA-01110: data file 1: 'F:\ORACLE\IDE\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

SQL>

Whats the problem

kavi

[former_member524429 · Accepted solution]

Hi,

Execute the following statements in sequence.

1.

SQL>recover database using backup controlfile

Provide available Archive Log Files (which are taken since that applied Online Backup). Type CANCEL to cancel it.

2.

SQL>recover database using backup controlfile until cancel

Type CANCEL to cancel it.

3.

SQL>alter database open resetlogs;

Regards,

Bhavik G. Shroff

[Former Member · Accepted solution]

Hi

Try

SQL> recover database using backup controlfile until cancel;

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

enter the full path to the online redo logs....E.G

<Drive>:\oracle\IDE\OriglogA\(<dbf> file and also do OriglogB if the sequence nuber is still asked for.

If successful the alter databse open resetlogs;

If this does not work it's a trash and restore I'm afraid..

Mark

[former_member524429]

Hi,

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

...

...

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

Your Database is in Inconsistent State. Please perform the following Steps to correct the problem.

I hope the control files are there on your Test Server.

Try the following Commands.

SQL>recover database using backup controlfile until cancel

Provide available Archive Log Files (which are taken since that applied Online Backup). Type CANCEL to cancel it.

SQL>recover database using backup controlfile

Type CANCEL to cancel it.

SQL>alter database open resetlogs;

Regards,

Bhavik G Shroff

Edited by: Bhavik G. Shroff on Feb 11, 2010 12:21 AM