INTERVIEW QUESTIONS ORACLE BACKUP AND RECOVERY DETAILS

Question: What is the steps for recovery of missing data file? and the steps for physical stand by database creation?

Answer: Shut down the database and start mount then recreate the d.b by using recreation using old data file path.

Shut down the database and start mount then recreate the d.b by using recreation using old data file path. Source: CoolInterview.com

steps:
copy all the files in the Hot backup.
2.startup mount
3.alter database recover automatic using backup controlfile until cancel
;
4.alter database open reset logs;
Source: CoolInterview.com

If any data file is missing, make datafile offline with the commond 'alter tablespace tablespace_name offline;

And Restore the relivent datafile from the backup, recover the datafile 'recover datafile path of datafile or datafile no# online;
it will apply all archive logs and redo logs and it will recover and open for normal use. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question