GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  Backup and Recovery
Go To First  |  Previous Question  |  Next Question 
 Backup and Recovery  |  Question 26 of 42    Print  
If an oracle database has crashed. How would you recover the transactions that are not in the backups?

  
Total Answers and Comments: 3 Last Update: March 16, 2009     Asked by: Ed 
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: Mohammed Abdul Afroze
 

If an Oracle Database has been crashed we can recover the database with SCN. For every commit transaction the SCN will generate.

Sql>Alter database recover automatic using backup controlfile until SCN;



Above answer was rated as good by the following members:
billablaze, amanx
July 14, 2007 00:28:40   #1  
kodaliprakash Member Since: July 2007   Contribution: 10    

RE: If an oracle database has crashed. How would you r...
By time based recovery.

we can issue recover database till time

 
Is this answer useful? Yes | NoAnswer is useful 0   Answer is not useful 1Overall Rating: -1    
September 28, 2007 05:16:58   #2  
Mohammed Abdul Afroze        

RE: If an oracle database has crashed. How would you r...

If an Oracle Database has been crashed we can recover the database with SCN. For every commit transaction the SCN will generate.

Sql>Alter database recover automatic using backup controlfile until SCN;


 
Is this answer useful? Yes | NoAnswer is useful 2   Answer is not useful 1Overall Rating: +1    
March 15, 2009 10:55:38   #3  
narasimulu Member Since: February 2009   Contribution: 2    

RE: If an oracle database has crashed. How would you recover the transactions that are not in the backups?
Following steps are involved in Database Startup
1. Start the listener
2. Mount the database

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape