INTERVIEW QUESTIONS
ORACLE
ORACLE BACKUP AND RECOVERY
DETAILS
Question: What is db_recovery_file_dest ? When do you need to set this value ? Give me the steps to perform the point in time recovery with a backup which is taken before the reset logs of the db ? Tell me about the steps required to enable the RMAN backup for a target database ?
Answer: db_recovery_file_dest specifies a default location of flash recovery area which contains multiplexed current control files, online redo logs as well as archived logs, Rman backups,flash back logs. db_recovery_file_dest_size should be specified as well.
|
Question:
What is db_recovery_file_dest ? When do you need to set this value ? Give me the steps to perform the point in time recovery with a backup which is taken before the reset logs of the db ? Tell me about the steps required to enable the RMAN backup for a target database ?
Answer:
db_recovery_file_dest specifies a default location of flash recovery area which contains multiplexed current control files, online redo logs as well as archived logs, Rman backups,flash back logs. db_recovery_file_dest_size should be specified as well. Source: CoolInterview.com
Answered by: jiawei wang | Date: 1/30/2009
| Contact jiawei wang
The parameter db_recovery_file_dest is used to enable the flash recovery area. OR This initialization parameter is a valid destination to create the Flash Recovery Area. The destination can be defined as a directory, file system or ASM disk group. Source: CoolInterview.com
Answered by: sayed nazem | Date: 3/25/2009
| Contact sayed nazem
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.
|