Skip to Content
Former Member
May 29, 2010 at 11:05 AM

Online Backup Restoration


Hi Guru's,

We are trying to plan for disaster recovery.

we are taking online backup of our SAP system through DB13.

For backup we are using Tivoli server.

We had run ./sapinst - System Copy-Oracle-Target System Instalation-High-Availability System-Based on AS-ABAP-Database Instance

We had reached to step Restore Backup

we restore backup through Tivoli (backfm -p)

but database is not getting started:

SQL> alter database open;

alter database open


ERROR at line 1:

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-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/oracle/ECB/sapdata1/system_1/system.data1'

SQL> recover datafile '/oracle/ECB/sapdata1/system_1/system.data1';

ORA-00283: recovery session canceled due to errors

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

SQL> recover database using backup controlfile;

ORA-00279: change 476704640 generated at 05/29/2010 15:46:57 needed for thread


ORA-00289: suggestion : /oracle/ECB/oraarch/ECBarch1_1_720287205.dbf

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

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

Any body have any idea.