Part 1 – RMAN Interview Questions (Basic)
This first part covers basic Interview Questions and Answers.
Answer: Rman provides us access to various kinds of backup, recovery techniques, and many other features also. Few of them listed below.
Answer: In RMAN, expired status means backup data, details backup is not present at the destination, while obsolete means backup information present or found it is not needed currently. This is because RMAN has been configured so that it will not need backup information after the particular number of days elapsed.
Answer: A level 0 is called an incremental backup, which is the base for the upcoming subsequent incremental backups; copies all blocks containing data after that is backup whole data as backup.
A level 1 can be one of the type explained below: It may be the Differential backup, which helps to backs up all blocks changed after the most recent incremental backup at level 1 or It may be the cumulative backup, In which backs up all blocks changed after the most recent incremental backup at level 0
Answer: This is the basic RMAN Interview Question asked in an interview. Please find below the different tables that RMAN supports are. We can take RMAN backup only when the target database is Open or in the Mount stage. The reason behind this is RMAN keeps the backup metadata in the control file. Only in an open or mount mode control file is accessible. So it is not possible to take backup in down status.
Answer: RMAN can backup Data files, Archive logs, standby database Spfile, control file, etc. Files that cannot be taken as a backup are the following p file, network configuration files, Redo logs, password files, external tables, and the Oracle home files’ contents.
What is RMAN?Answer RMAN stands for recovery manager.it is a utility that can manage your entire Oracle backup and recovery activities.
How did the list and report commands of RMAN get the data?Answer RMAN commands reports the data by querying v$ in case of nocatalog and recovery catalog (RC) view in case of Catalog mode. Example V$DATAFILE_COPY in case of Control file RC_DATAFILE_COPY in case of Recovery Catalog
The following are some of the recommended courses you can buy if you want to get a step further
How do u know how much RMAN task has been completed?Answer By querying v$rman_status or v$session_longops
What is the difference between LIST and REPORT commandAnswer Report command performs more complex analysis than LIST. Use the REPORT command to answer questions such as the following:
Q. What happens if catalog database lost?
Since the catalog database is an option one there is no direct effect of loss of catalog database. Create a new catalog database and register the target database with the newly created catalog one. All the backup information from the target database current controlfile will be updated to the catalog schema. If any backup information which is aged out from the target database then you need to manually catalog those backup pieces.