Recovery without backup [message #516638] |
Tue, 19 July 2011 14:06 |
|
aalbuquerque
Messages: 1 Registered: July 2011 Location: Brasil
|
Junior Member |
|
|
How I solve this crash. I just have a copy from datafiles,controlfiles and redo from an one day before the crash. I try replace like a cold backup but the database return the same error below asking from a redo file with the date after the copy.
regards,
Alexandre Albuquerque.
SQL> startup
ORACLE instance started.
Total System Global Area 5217714176 bytes
Fixed Size 2072984 bytes
Variable Size 2617249384 bytes
Database Buffers 2583691264 bytes
Redo Buffers 14700544 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-01113: file 1 needs media recovery
ORA-01110: data file 1: 'G:\ORACLE\SMD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'
SQL> recover database;
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 until cancel;
ORA-00279: change 46992439 generated at 07/04/2011 17:00:46 needed for thread 1
ORA-00289: suggestion : F:\ORACLE\SMD\ORAARCH\SMDARCHARC03073_0746548057.001
ORA-00280: change 46992439 for thread 1 is in sequence #3073
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'G:\ORACLE\SMD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'
ORA-01112: media recovery not started
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: 'G:\ORACLE\SMD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'
|
|
|
|