ORA-00279, ORA-00278 and Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

From: HARI OM <hari_om_at_hotmail.com>
Date: 2 Feb 2005 09:27:59 -0800
Message-ID: <1107365279.831835.30580@g14g2000cwa.googlegroups.com>

I am using Oracle 9.2.0.4 on IBM AIX 5.1L.

I had one instance named "solar" on my database running. I wanted to change ALL the file locations like redo01.log, system01.dbf etc etc.. to a different new location. So, here is what I did:

1. SQL> ALTER database backup controlfile to trace
   • this saves the controlfile in udump directory which I edit it and change the locations -- of all the data files on it. SO this is what I have now and I save it is solar.sql
2. EDIT the file:

Example: I changed the REDO Log Location from /rdisk/solar/gp1/redo01.log to /redo/solar/gp1/redo01.log as shown below.

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "SOLAR" RESETLOGS NOARCHIVELOG MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 113
LOGFILE

GROUP 1 '/redo/solar/gp1/redo01.log'  SIZE 100M,
GROUP 2 '/redo/solar/gp1/redo02.log'  SIZE 100M,
GROUP 3 '/redo/solar/gp3/redo03.log'  SIZE 100M

DATAFILE
'/dict/solar/system01.dbf',
'/data/solar/undotbs01.dbf',
'/dict/solar/drsys01.dbf',
'/data/solar/example01.dbf',
'/data/solar/indx01.dbf',
'/dict/solar/odm01.dbf',
'/dict/solar/tools01.dbf',
'/data/solar/users01.dbf',
'/dict/solar/xdb01.dbf',
'/data/solar/oem_repository.dbf'

CHARACTER SET WE8ISO8859P1
;
RECOVER AUTOMATIC DATABASE using backup controlfile ALTER DATABASE OPEN resetlogs;
ALTER TABLESPACE TEMP ADD TEMPFILE '/data/solar/temp01.dbf' SIZE 99614720 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 16383M;

3) SHUTDOWN this DATABASE
4) Copy the files to above location.
5) Run the above script SOLAR.SQL

and it shows: CONTROL FILE CREATED..... BUT Gives following error with it...

ORA-00279: change 2212096 generated at 2/2/2005 09:46:04 n­eeded for thread 1

ORA-00289: suggestion : /u01/admin/ar/arch/arch_1­_5006.dbf
ORA-00280: change 2212096 for thread 1 is in sequence #5006
ORA-00278: log file '/u01/admin/ar/arch/arch_1_50­05.dbf' no longer

needed for this recovery

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

CAN anyone help me or give some hints/pointers to this ERROR. Any related information would be appreciated...

THANKS! HARI OM Received on Wed Feb 02 2005 - 11:27:59 CST