Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsread.com!news-xfer.newsread.com!postnews.google.com!g14g2000cwa.googlegroups.com!not-for-mail
From: "HARI OM" <hari_om@hotmail.com>
Newsgroups: comp.databases.oracle.server
Subject: ORA-00279, ORA-00278 and Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
Date: 2 Feb 2005 09:27:59 -0800
Organization: http://groups.google.com
Lines: 70
Message-ID: <1107365279.831835.30580@g14g2000cwa.googlegroups.com>
NNTP-Posting-Host: 168.180.96.8
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1107365284 27545 127.0.0.1 (2 Feb 2005 17:28:04 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 2 Feb 2005 17:28:04 +0000 (UTC)
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: g14g2000cwa.googlegroups.com; posting-host=168.180.96.8;
   posting-account=HxfYdw0AAACkF8aowy9PFiIhF5atjeYK
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:234816

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=ADeeded for
thread 1
ORA-00289: suggestion : /u01/admin/ar/arch/arch_1=AD_5006.dbf
ORA-00280: change 2212096 for thread 1 is in sequence #5006
ORA-00278: log file '/u01/admin/ar/arch/arch_1_50=AD05.dbf' no longer
needed for this recovery

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


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

THANKS!

HARI OM