kodaliprakash

 Profile Answers by kodaliprakash 

• Jul 14th, 2007

 

By time based recovery.

we can issue recover database till time

Mohammed Abdul Afroze

• Sep 28th, 2007

 

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;

narasimulu

 Profile Answers by narasimulu 

• Mar 15th, 2009

 

Following steps are involved in Database Startup
1. Start the listener
2. Mount the database

Shikha31

 Profile Answers by Shikha31 

• Mar 31st, 2011

 

If the database is in ARCHIVELOG mode we can recover the transactions using archive logs otherwise we can not recover the transactions that are not in the backups.

V.SOMASUNDARAM

• Sep 16th, 2011

 

Restore: just back up from back up media

recover: during the transaction in case of incomplete transaction due to power failure or some other reasons, that time either to complete the transaction or cancel the transaction is called recover

surya

• Jun 7th, 2016

 

Is it the only command for complete recovery? Do we have to mention SCN or not?

Vikas

• Jan 9th, 2018

 

Assuming it was in archive log mode, With recent controlfile backup and archives, uncommitted transactions could be recovered.