User-managed incomplete recovery in noarchivelog mode
From: Woody Ling <woodyling_at_gmail.com>
Date: Mon, 30 Jun 2008 01:08:01 -0700 (PDT)
Message-ID: <4b570be7-3c1e-4e36-a6ef-e9493cc56a48@u12g2000prd.googlegroups.com>
Date: Mon, 30 Jun 2008 01:08:01 -0700 (PDT)
Message-ID: <4b570be7-3c1e-4e36-a6ef-e9493cc56a48@u12g2000prd.googlegroups.com>
Hi all,
I have two full sets of close database files backup. One on 28 June and another on 29 June.
Today, 30 June, I need to restore the whole database by using the backup files on 29 June.
But I found that one of the data files, user01.dbf, was corrupted.
Since the database is running in noarchivelog mode and the online redo log was overwritten, so I try
- Copy all db files of 29 June to replace existing.
- Copy the datafile, user01.dbf, of 28 June to replace the corrupted file.
- startup mount
- recover database until cancel (I enter CANCEL since there is no available redo log file.)
- alter database open resetlogs
However I have error when open the database: ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/u01/oradata/system01.dbf"
The tables in USERS tablespace is NOT important, is there any way for me to open the database?
Thanks.
Woody Ling
Hong Kong
Received on Mon Jun 30 2008 - 03:08:01 CDT