Re: User-managed incomplete recovery in noarchivelog mode

On Mon, 30 Jun 2008 01:08:01 -0700 (PDT), Woody Ling
<woodyling@xxxxxxxxx> wrote:

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

1. Copy all db files of 29 June to replace existing.
2. Copy the datafile, user01.dbf, of 28 June to replace the corrupted
file.
3. startup mount
4. recover database until cancel (I enter CANCEL since there is no
available redo log file.)
5. 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

Please explain to yourself why your current scenario didn't work: Why
do you think you can 'mix' datafiles and controlfiles from two
*different* backups?
As you are running in NOARCHIVELOG apparently, the database is not
important to you.

Your only choice is to restore the backup of June 28, pray and forget
about anything that happened after June 28.
If that doesn't work, your database is toast, thanks to the decision
of someone to run in NOARCHIVELOG.

--
Sybrand Bakker
Senior Oracle DBA
.

Relevant Pages

  • Re: Restoring SQL Server Backups
    ... ORIGINAL BACKUP & RESTORE (MSDE Database) ... occurrenceof cachestore flush for the 'Object Plans' cachestore (part ...
    (microsoft.public.sqlserver.server)
  • Re: Restoring SQL Server Backups
    ... ORIGINAL BACKUP & RESTORE (MSDE Database) ... occurrenceof cachestore flush for the 'Object Plans' cachestore (part ...
    (microsoft.public.sqlserver.server)
  • Re: POINT IN TIME RESTORE
    ... This is what you should have done in order to do the restore as you wish: ... > 3- erase data ... > 5- restore database with norecovery ... The BACKUP DATABAE can of course be at an earlier point in time, ...
    (microsoft.public.sqlserver.server)
  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • Re: RMAN restore of full backup fails completely
    ... You are not using a catalog database. ... You might have autobackup controlfile on, ... Your autobackup has been made *prior* to the backup! ... plus archivelog', when i try a restore on the other server however, the ...
    (comp.databases.oracle.server)