Share your knowledge! Login | Register
 
 
  Search     Advanced search
 

Home | Ask Question | Add tip | Questions | My tips | Recent tips & tricks | Suggest a category | FAQ | Forums

 
 
 
 Category : Home > Databases > Oracle > Security     

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below


Sponsored Links

Click here to Free Ebooks Download


Cause: Media recovery with one of the incomplete recovery options ended without error. However, if the ALTER DATABASE OPEN RESETLOGS command were attempted now, it would fail with the specified error. The most likely cause of this error is forgetting to restore one or more datafiles from a sufficiently old backup before executing the incomplete recovery.

Action: Rerun the incomplete media recovery using different datafile backups, a different control file, or different stop criteria.

  Sponsors
  Options
 
   del.icio.us  |  newsvine  |  digg  |  furl  |  google  |  yahoo  |  Ma.gnolia  |  vigillar  |  reddit  |  technorati  |  icerocket  |  pubsub

     (Average: 4.42 / Votes: 93)   Rate this tip:    

Start discussion or add comment to this tip

  Comments
Reply 1
Solution- alter system switch logfile
Wait to generate next archive or run below command. <br>

sql>alter system switch logfile;

Reply 2
Question
should i applly this query  with before this " recover database until time '2008-04-02:22:59:04'" or after

  Details
Tip reference : #103
views : 115254
Added on : 05/05/09
Submited by : Admin
 
Send a message Send a message Printer friendly output Printer friendly output
Display this member's tips Display this member's tips (180)
 
 
<< Previous Next >>
 Most viewed tips 
  Databases > Oracle > Security : How to unlock Oracle user account  
  Databases > Oracle > Performance Tuning : How to enable trace in Oracle  
  Operating Systems > Unix : How to kill Unix user session  
  Databases > Oracle : Kill user session  
   
  All categories
Databases | Programming | Hardware | Operating Systems | Networking | Internet | ERP / CRM | Games & Multimedia | Graphics & Design | Miscellaneous | Office Software | FAQ
 
 

Home |  FAQ |  Terms of Use |  Privacy Policy

© 2009 11gHelp.com