RE: Oracle 8i crashed: system ts needs more recovery - how do I recover from this?
Date: Thu, 31 Oct 2013 14:28:32 +0000
Message-ID: <1E24812FBE5611419EFAFC488D7CCDD11878C4D7_at_G6W2491.americas.hpqcorp.net>
If you have been running this old system for years then it would seem logical that a backup process was set up at one time. If rman was not being used to back up the database then maybe manual hot backups were being made and you just need to look in a different location to find those backup files. Do you have a tape management system? Perhaps the backups were being dumped to tape and the old backup you found was just never removed. The might be worth checking.
If you are unable to "restore" the database on the new server one other option might be to see if nightly full exports were being taken of the database. If exports were being taken then creating a new empty database and populating it with the export might be an option.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of De DBA
Sent: Thursday, October 31, 2013 4:23 AM
To: Oracle-L_at_freelists.org
Subject: Oracle 8i crashed: system ts needs more recovery - how do I recover from this?
G'day,
I've got this old 8i database, that was quietly chugging away on an old NT4 server, until the server finally and irretrievably crashed a few days ago. The sysadmin has succeeded in copying the entire database (and oracle installation) off the old disk. Now we have a "new" Windows 2000 installation with Oracle installed.
Version info:
- Windows 2000 TS, SP4
- Oracle 8.1.7 SE
We have a backup of 24 July, which is not an attractive option for this billing system...
The rescued files have a number of problems:
- the rollback tablespace file header is corrupt
- one redo logfile header is corrupt
- one datafile is missing
- the datafiles are newer than the controlfile
I've copied the missing datafile from the ancient backup, hoping (with some reason) that it contained no data. The logfile was not current, so I could drop and recreate it easily. The rollback tablespace should also not give too much grief, if we accept that some transactions may be lost (we do that, it's way better than loosing 3 months of financial data).
The controlfile is also not too difficult - I've simply created a new one. The newest problem is this:
SQL> _at_recreate_controlfile.dba
Control file created.
ORA-00279: change 84044450 generated at 07/23/2013 01:29:56 needed for thread 1 ORA-00289: suggestion : E:\ORACLE\ORA81\RDBMS\ARC07029.001 ORA-00280: change 84044450 for thread 1 is in sequence #7029
ALTER DATABASE OPEN
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'E:\ORADATA\SUN\SYS1SUN.DBF'
I don't understand where it gets the suggested archivelog from - the database was not in archivelog mode! I can't recover, so we proceed to opening with resetlogs - nothing for it..
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
SQL> recover database until cancel;
ORA-00279: change 84044450 generated at 07/23/2013 01:29:56 needed for thread 1 ORA-00289: suggestion : E:\ORACLE\ORA81\RDBMS\ARC07029.001 ORA-00280: change 84044450 for thread 1 is in sequence #7029
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: 'E:\ORADATA\SUN\SYS1SUN.DBF'
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: 'E:\ORADATA\SUN\SYS1SUN.DBF'
Yep, it did, and that's where I got stuck. Can I even recover from this? No backups, no archived redologs, the online redo logs were too new, and are now stale anyway (due to controlfile recreate). On the positive side, it did not complain about the old datafile that I used to replace the missing one (yet... perhaps it doesn't look that far? )
All thoughts are welcome
Thanks,
Tony
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 31 2013 - 15:28:32 CET