RE: Oracle 8i crashed: system ts needs more recovery - how do I recover from this?
- From: "Powell, Mark" <mark.powell2@xxxxxx>
- To: "Oracle-L@xxxxxxxxxxxxx" <Oracle-L@xxxxxxxxxxxxx>
- Date: Thu, 31 Oct 2013 14:28:32 +0000
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of De DBA
Sent: Thursday, October 31, 2013 4:23 AM
To: Oracle-L@xxxxxxxxxxxxx
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> @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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
