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.
|Language:||English, Spanish, Indonesian|
|ePub File Size:||23.55 MB|
|PDF File Size:||13.15 MB|
|Distribution:||Free* [*Register to download]|
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.
It is an Oracle Database client which is used for the backup and recovery tasks on our databases and it can also automate the administration of our backup strategies. It is true that every interview is different as per the different job profiles. What are the main features of RMAN? Answer: Rman provides us access to various kinds of backup, recovery techniques, and many other features also. Few of them listed below. Compression Unused block: It is one the features of the RMAN, which give provision to skip blocks of the data that have never been used.
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.
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.
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?
How do you identify the expired, active, obsolete backups? Which RMAN command you use? 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. 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?
Answer : If no level 0 backup is available, then the behavior depends upon the compatibility mode setting.
Answer : What is snapshot control file? Answer : The snapshot control file is a copy of a database control file created in an operating system-specific location by RMAN.
RMAN creates the snapshot control file so that it has a consistent version of a control file to use when either resynchronizing the recovery catalog or backing up the control file. What is the difference between backup set and backup piece? RMAN command to backup for creating standby database? How to do cloning by using RMAN? Answer : create the datafile and recover that datafile.
Answer : A status of "expired" means that the backup piece or backup set is not found in the backup destination. A status of "obsolete" means the backup piece is still available, but it is no longer needed.