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



Oracle LazyDBA home page