Prev: Best way to delete million records
Next: ORA-00959: tablespace '_$deleted$8$0' does not exist
From: Woody Ling on 30 Jun 2008 04:08
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
From: sybrandb on 30 Jun 2008 06:32
On Mon, 30 Jun 2008 01:08:01 -0700 (PDT), Woody Ling
<woodyling(a)gmail.com> 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
From: Helma on 30 Jun 2008 07:02

> 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.


" The tables in USERS tablespace is NOT important, is there any way
for
me to open the database? "

Sybrand,

Can't he use the 29th backup, and drop the USER tablespace ? In that
case, the db should open , i guess. Is that true?

H.
From: sybrandb on 30 Jun 2008 07:28
On Mon, 30 Jun 2008 04:02:31 -0700 (PDT), Helma
<helma.vinke(a)hotmail.com> wrote:

>
>> 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.
>
>
>" The tables in USERS tablespace is NOT important, is there any way
>for
>me to open the database? "
>
>Sybrand,
>
>Can't he use the 29th backup, and drop the USER tablespace ? In that
>case, the db should open , i guess. Is that true?
>
>H.

Helma, he could try if he
- restored the db from 29 (including controlfiles)
- MOUNTED the database
- OFFLINED the datafile for the users tablespace
- open the database and drop the users tablespace.

Note: ALL files are from 1 backup!

--
Sybrand Bakker
Senior Oracle DBA
From: DA Morgan on 30 Jun 2008 16:07
Helma wrote:
>> 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.
>
>
> " The tables in USERS tablespace is NOT important, is there any way
> for
> me to open the database? "
>
> Sybrand,
>
> Can't he use the 29th backup, and drop the USER tablespace ? In that
> case, the db should open , i guess. Is that true?
>
> H.

http://www.psoug.org/reference/tablespaces.html
Look up "Drop tablespace afgter datafile was accidentally dropped"
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan(a)x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
 | 
Pages: 1
Prev: Best way to delete million records
Next: ORA-00959: tablespace '_$deleted$8$0' does not exist