Describe the process of configuring a database to perform online backups and to

Question

Describe the process of configuring a database to perform online backups and to recover from a media failure, assuming that a hard drive crash occurred at some time in the future.  In the description be sure to include,

Init.ora Parameters for the following

Configuring for archiving  (Explain why particular mode selected Configuring control files (i.e., multiplexing)

RMAN Backup strategy (i.e., describe some weekly strategy [using some combination of incremental or cumulative techniques] that can be used to recover the database ASAP, explain choice)

SQL script to restore and  recover  the database using RMAN commands(Explain the steps in the procedure)

Explanation / Answer

The process of configuring a database for backup and recovery can be done by the following

A) we can run the database in ARCHIVE LOG mode, it will help in performing online backup and data recovery options which includes complete and point-in-time media recovery.

B) we can use a flash recovery technique that will automate storage management for most files related to backup.

RMAN backup strategy : RMAN connects to the said database that us the database which is needed to be backed up or recover with SYSDBA privilege. If we don't have the privilege then the connection fails. The recovery catalog database runs in NOCATALOG mode.

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.