Skip to Content
0
Former Member
Apr 21, 2010 at 02:42 AM

recover database using backup controlfile until cancel;

2193 Views

Hello,

after a restore of a database with hp dataprotectore the DB was in inconsistential condition and I´ve started recovering every .data file which has to be revovered: (redolog logs from the allonline backup session where restored already)

SQL> startup

ORACLE instance started.

Total System Global Area 2365587456 bytes

Fixed Size 2067528 bytes

Variable Size 1090519992 bytes

Database Buffers 1258291200 bytes

Redo Buffers 14708736 bytes

Database mounted.

ORA-01113: file 1 needs media recovery

ORA-01110: data file 1: 'F:ORACLEC12SAPDATA1SYSTEM_1SYSTEM.DATA1'

SQL> recover datafile 'F:ORACLEC12SAPDATA1SYSTEM_1SYSTEM.DATA1'

ORA-00279: change 79104569 generated at 04/14/2010 00:30:13 needed for thread 1

ORA-00289: suggestion : E:ORACLEC12ORAARCHC12ARCH1_1617_704132954.DBF

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

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

ORA-00279: change 79107667 generated at 04/14/2010 01:19:08 needed for thread 1

ORA-00289: suggestion : E:ORACLEC12ORAARCHC12ARCH1_1618_704132954.DBF

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

ORA-00278: log file 'E:ORACLEC12ORAARCHC12ARCH1_1617_704132954.DBF' no

longer needed for this recovery

Log applied.

Media recovery complete.

Edited by: Martin Haidvogel on Apr 21, 2010 4:45 AM