RE: Unable to recover the database

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
==============================================================================


Oracle LazyDBA home page