Introduction to RMAN Interview Interview Questions and Answers It is an Oracle Database client which is used for the backup and recovery tasks on our. + Rman (recovery Manager) Interview Questions and Answers, Question1: What is SCN? Question2: Oracle DBA Tutorial Oracle 11g Interview Questions. RMAN Interview Questions from Geekinterview - Download as Word Doc .doc), PDF File .pdf), Text File .txt) or read online. Oracle 11g RAC Interview Question and Answers. Uploaded by . Basic Tutorial XML PUBLISHER Insieme.

Rman Interview Questions And Answers In Oracle 11g Ebook

Language:English, Indonesian, Arabic
Published (Last):29.02.2016
ePub File Size:20.72 MB
PDF File Size:17.68 MB
Distribution:Free* [*Registration needed]
Uploaded by: STEPHANIA

After long time, again we are back with some important RMAN utility Questions and Answers. Now a day it is very important to know about the. Oracle RMAN basic/advanced Interview Questions for DBAs What is Level 0, Level 1 backup? Answer: A level 0 incremental backup. RMAN Interview Questions - 52 RMAN Interview Questions interview questions and answers by expert members with experience in RMAN Interview Questions subject. I am using HP Data Protector to store Oracle Backup. . 01 PM . subscription, you will be able to download Job Inteview Questions Ebook.

I Believe in designing a good backup strategy it will not only be simply backup but also a contingency plan. In this case you should consider the following: 1. How long is the allowable down time during recovery? How long is the backup period? If limited disk space for backup never use user managed backup.

If the database is large you could consider doing full rman backups on a weekend and do a incremental backup on a weekday. Schedule your backup on the time where there is least database activity this is to avoid resource huggling. Backup script should always be automized via scheduled jobs.

This way operators would never miss a backup period. Retention period should also be considered.

Top Oracle DBA, RAC, and Performance Tuning Interview Questions

Try keeping atleast 2 full backups. Cold backup: shutdown the database and copy the datafiles with the help of O. Hot backup: backup process starts even though database in running. During restore database will restore the data from backup till that timestamp and remaining backup will be recovered from archive log.

Top FREE Training Tutorials

What is hot backup and what is cold backup? What are the various tape backup solutions available in the market?

How do you generate the begin backup script? How do you enable the encryption for RMAN backups? Outline the steps for recovering the full database from cold backup? Explain the steps to perform the point in time recovery with a backup which is taken before the resetlogs of the db? Outline the steps involved in TIME based recovery from the full database from hot backup?

If Yes, How? Can a schema be restored in oracle 9i RMAN when the schema having numerous table spaces? Outline the steps for changing the DBID in a cloned environment? Can we use same target database as catalog?

RMAN Interview Questions from Geekinterview

Answer : No. The recovery catalog should not reside in the target database database to be backed up , because the database can't be recovered in the mounted state.

How do u know how much RMAN task has been completed? Command to delete archive logs older than 7days? By default how many days backup RMAN stores?

Answer : 8. What is the use of crosscheck command in RMAN? Answer : Crosscheck will be useful to check whether the catalog information is intact with OS level information.

What are the differences between crosscheck and validate commands? Answer : Validate command is to examine a backup set and report whether it can be restored. RMAN scans all of the backup pieces in the specified backup sets and looks at the checksum to verify that the contents are intact so that backup can be successfully restored if necessary.

RMAN Interview Questions

Crosscheck command is to verify the status of backups and copies recorded in the RMAN repository against media such as disk or tape. The crosscheck command only processes files created on the same device type as the channel running crosscheck.

Which is one is good, differential incremental backup or cumulative incremental backup? Answer : A differential backup, which backs up all blocks changed after the most recent incremental backup at level 1 or 0 A cumulative backup, which backs up all blocks changed after the most recent incremental backup at level 0 What is Level 0, Level 1 backup?

Answer : A level 0 incremental backup , which is the base for subsequent incremental backups, copies all blocks containing data, backing the datafile up into a backup set just as a full backup would. A level 1 incremental backup can be either of the following types: A differential backup, which backs up all blocks changed after the most recent incremental backup at level 1 or 0 A cumulative backup, which backs up all blocks changed after the most recent incremental backup at level 0 Can we perform level 1 backup without level 0 backup?

Introduction to RMAN Interview Interview Questions and Answers

Answer : If no level 0 backup is available, then the behavior depends upon the compatibility mode setting. Answer : What is snapshot control file?While cold backup can be taken only when the database is in shut down mode and hence it is known as Offline Backup as well.

Hence, mirroring of these files will be done to protect them.

Q 20 How would you differentiate between cluster and grid? Hence, it is also known as Online Backup.

Ans: Recovery Catalog is a database schema that holds the metadata used by RMAN for restoration and recovery processes. How Many catalog database I can have? RMAN command to backup for creating standby database? Ans: Clustering is an integral part of grid infrastructure and focuses on a specific objective.

When do you use this?

It has also recovery catalog to store the metadata.