Re: Database refresh

From: Night Shade Books <jasonw_at_nightshadebooks.com>
Date: Sat, 29 Sep 2001 02:00:12 -0700
Message-ID: <3800585A27A89837.64188A3DF9CC2361.5DE4EB243A7651ED@lp.airnews.net>

"koert54" <koert54_at_nospam.com> wrote in message news:2Tft7.77553$6x5.16843409_at_afrodite.telenet-ops.be...

> Change the 'recover database' command at the end of the trace to 'recover
> database using backup controlfile' and then
> 'alter database open resetlogs' (might have to use until cancel because

you

> open with resetlogs ..)
> I usually throw those commands out and do the recovery myself ...
>
> > ORA-00283: recovery session canceled due to errors
> > ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
> --> you created a new controlfile - it can not be used anymore as a
> reference for the other datafiles - that's why you
> need to specify that it's a backup controlfile in the recovery command ...
> it does not mean you have to do
> the 'alter database backup controlfile to trace' again !
>
>
> cheers
> Koert

First, thanks for your help. I'm going insane here.

Ok, so I whacked all the control files again, and generated a new tracefile. I edited it so it looks like so: (EBDB1 is the new name)

STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "EBDB1" RESETLOGS NOARCHIVELOG     MAXLOGFILES 32
    MAXLOGMEMBERS 2
    MAXDATAFILES 500
    MAXINSTANCES 8
    MAXLOGHISTORY 904
LOGFILE

  GROUP 1 '/u03/oradata/EBQA817/redo01.log'  SIZE 10M,
  GROUP 2 '/u03/oradata/EBQA817/redo02.log'  SIZE 10M,
  GROUP 3 '/u03/oradata/EBQA817/redo03.log'  SIZE 10M

DATAFILE
'/u02/oradata/EBDB1/system01.dbf',
'/u02/oradata/EBDB1/tools01.dbf',
'/u03/oradata/EBDB1/rbs01.dbf',
'/u03/oradata/EBDB1/data03_03.dbf',
'/u02/oradata/EBDB1/users01.dbf',
'/u02/oradata/EBDB1/indx01.dbf',
'/u04/oradata/EBDB1/indx01a_01.dbf',
'/u03/oradata/EBDB1/data01_01.dbf',
'/u03/oradata/EBDB1/data01_02.dbf',
'/u04/oradata/EBDB1/indx01a_02.dbf',
'/u03/oradata/EBDB1/data02_01.dbf',
'/u04/oradata/EBDB1/indx01b_01.dbf',
'/u03/oradata/EBDB1/data02_02.dbf',
'/u04/oradata/EBDB1/indx02a_01.dbf',
'/u03/oradata/EBDB1/data02_03.dbf',
'/u04/oradata/EBDB1/indx02a_02.dbf',
'/u03/oradata/EBDB1/data02_04.dbf',
'/u04/oradata/EBDB1/indx03a_01.dbf',
'/u03/oradata/EBDB1/data03_01.dbf',
'/u04/oradata/EBDB1/indx03a_02.dbf',
'/u03/oradata/EBDB1/data03_02.dbf',
'/u04/oradata/EBDB1/indx08a_01.dbf',
'/u03/oradata/EBDB1/data08_01.dbf',
'/u04/oradata/EBDB1/indx04a_01.dbf',
'/u03/oradata/EBDB1/data04_01.dbf',
'/u04/oradata/EBDB1/indx04a_02.dbf',
'/u03/oradata/EBDB1/data04_02.dbf',
'/u04/oradata/EBDB1/indx05a_01.dbf',
'/u03/oradata/EBDB1/data05_01.dbf',
'/u04/oradata/EBDB1/indx06a_01.dbf',
'/u03/oradata/EBDB1/data06_01.dbf',
'/u04/oradata/EBDB1/indx07a_01.dbf',
'/u03/oradata/EBDB1/data07_01.dbf',
'/u02/oradata/EBDB1/tsdef_01.dbf',
'/u02/oradata/EBDB1/imprbsts01.dbf',
'/u02/oradata/EBDB1/imprbsts02.dbf',
'/u04/oradata/EBDB1/indx03a_03.dbf'

CHARACTER SET WE8ISO8859P9; RECOVER DATABASE USING BACKUP CONTROLFILE; ALTER DATABASE OPEN RESETLOGS; But now I end up with this:

SVRMGR> recover database using backup controlfile until cancel; ORA-00279: change 102582082 generated at 09/28/2001 19:30:59 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/product/8.1.7/dbs/arch1_1.dbf ORA-00280: change 102582082 for thread 1 is in sequence #1 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: '/u02/oradata/EBDB1/system01.dbf'

The problem is that this is on a new machine, and I don't have those archive logs.

And after that, I can't get it to do an 'alter database open resetlogs', because it tells me that further recovery is needed.

Thanks,

Jason Received on Sat Sep 29 2001 - 04:00:12 CDT