Hi ALL.
We have an old 9i database backup which we want to check for audit.
It is not really so important, but we need to check some data.
But when we try to start it up, the database needs recovery
How do we force open it even if it is corrupted or not in sync? Just for the sake of opening?
ORACLE instance started.
Total System Global Area 581506668 bytes
Fixed Size 452204 bytes
Variable Size 402653184 bytes
Database Buffers 167772160 bytes
Redo Buffers 10629120 bytes
Control file created.
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/home/oraprod/PROD/proddata/system01.dbf'
Please help....
I remember there is a hidden parameter something like... _allow_corrupted_database?
Kind regards,
jc