Asm And Rman Interview Questions

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.

  • Automatic specification for various files to include in a backup: A setting of the name and location for backup files happens automatically in RMAN.
  • Compression Unused block: It is one of the RMAN features, which gives provision to skip blocks of the data that have never been used.
  • Backup repository Maintained: Backups are recorded in the control file, which is the main repository of RMAN metadata. Controlfile In RMAN, where all the data are back up. This file is also called the main repository of the Metadata of the RMAN. It also has a recovery catalog to store the metadata.
  • Binary compression OF the Backup: It is a process in which a reduction of the size of data backups happened, and this is associated with Oracle Database.
  • Incremental backups: it backup’s only data blocks changed since a previous backup. Therefore, it speeds up compact backups and faster recovery.
  • Media recovery: The recovery of the data file has only a small number of corrupt data blocks without taking it offline or restoring it from backup.
  • Backups in the Encrypted format: RMAN provides backup with the data in encryption format, it is integrated into Oracle Database, it is used to store backup sets in an encrypted format.
  • Corrupt block detection Features: Rman can check the corrupted block before taking its backup.
  • 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 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.

    #DBAchallenge -1 || Interview question on ASM, RAC, RMAN

    Related Posts

    Leave a Reply

    Your email address will not be published. Required fields are marked *