When you created the control file did you use the SQL script that was
created from the command

ALTER DATABASE BACKUP CONTROL FILE TO TRACE

If so, did you change the command

CREATE CONTROLFILE SET DATABASE "SID_NAME" NORESETLOGS NOARCHIVELOG

AND

Comment out

RECOVER DATABASE

Dallas Scott
Vertex Inc.
x5824



"Lau John " <oracledba-ezmlmshield-x76103671.[Email address protected]
06/29/2007 09:45 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
RE: Unable to recover the database






You sure that's an error?

It's the recovery process telling you it needs arch log arch15.arc ...
Sometimes the archlog it thinks it needs is actually one of the online
redo logs so if that's the case, specify the name and location of that in
place of arch15.arc



-----Original Message-----
From: oracledba-ezmlmshield-x17571643.[Email address protected]
[mailto:oracledba-ezmlmshield-x17571643.[Email address protected]
Sent: 29 June 2007 03:47
To: LazyDBA Discussion
Subject: RE: Unable to recover the database

Hi Oliver,

Verify the lot_Archive_dest# patameter.

Check follow sql statement output on both instance

select name,value from v$parameter
where name like 'log_archive_dest%'

Regards
Wilson



-----Original Message-----
From: Oliver M. Thomson
[mailto:oracledba-ezmlmshield-x25040798.[Email address protected]
Sent: Monday, June 18, 2007 11:15 PM
To: LazyDBA Discussion
Subject: Unable to recover the database


Hi All,

1. we are using oracle apps 11.0.3, our production server is
on
archivelog mode.
2. I wanted to make a test system using the datafiles etc of
the
production.
3. I have installed apps and copied the datafiles,cntrl
files etc
on to the target machine
4. I have created a controlfile and when I am trying to
recover
the database it gives the following error ,it's not prompting to apply
the archivelogs,It immediately comes back to svrmgr prompt.



ORA-00279: change 14506404 generated at 06/18/07 12:33:59 needed for
thread 1
ORA-00289: suggestion : D:\OA\ORANT\RDBMS80\ARCHIVE\ARCH15.ARC
ORA-00280: change 14506404 for thread 1 is in sequence #15



Regards

Oliver







---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



==============================================================================
Please access the attached hyperlink for an important electronic
communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




Oracle LazyDBA home page