Find us on Google+ Google+

October 20, 2012

Oracle RMAN Interview Questions/FAQs

Oracle RMAN Interview Questions/FAQs


1. Difference between catalog and nocatalog?
Recovery catalog is central and can have information of many databases.

2. Difference between using recovery catalog and control file?
When new incarnation happens, the old backup information in control file will be lost. It will be preserved in recovery catalog.
In recovery catalog, we can store scripts.
Recovery catalog is central and can have information of many databases.

3. Can we use same target database as catalog?
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.

4. How do u know how much RMAN task has been completed?
By querying v$rman_status or v$session_longops

5. From where list & report commands will get input?

6. Command to delete archive logs older than 7days?
RMAN> delete archivelog all completed before sysdate-7;

7. How many days backup, by default RMAN stores?

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

9. What are the differences between crosscheck and validate commands?

10. Which is one is good, differential (incremental) backup or cumulative (incremental) backup?
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

11. What is Level 0, Level 1 backup?
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

12. Can we perform level 1 backup without level 0 backup?
If no level 0 backup is available, then the behavior depends upon the compatibility mode setting. If compatibility < 10.0.0, RMAN generates a level 0 backup of the file contents at the time of the backup. If compatibility is >= 10.0.0, RMAN copies all blocks changed since the file was created, and stores the results as a level 1 backup. In other words, the SCN at the time the incremental backup is taken is the file creation SCN.

13. Will RMAN put the database/tablespace/datafile in backup mode?
Nope.

14. What is snapshot control file?

15. What is the difference between backup set and backup piece?
Backup set is logical and backup piece is physical.

16. RMAN command to backup for creating standby database?
RMAN> duplicate target database to standby database ....

17. How to do cloning by using RMAN?
RMAN> duplicate target database …

18. Suppose you lost one datafile and DB is running in ARCHIVELOG mode. You have full database backup of 1 week/day old and don’t have backup of this (newly created) datafile. How do you restore/recover file?
create the datafile and recover that datafile.
SQL> alter database create datafile ‘…path..’ size n;
RMAN> recover datafile file_id;

19. What is obsolete backup & expired backup?
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. The backup piece is no longer needed since RMAN has been configured to no longer need this piece after so many days have elapsed, or so many backups have been performed.

20. What is the difference between hot backup & RMAN backup?
For hot backup, we have to put database in begin backup mode, then take backup.
RMAN won’t put database in backup mode.

21. How to put manual/user-managed backup in RMAN (recovery catalog)?
By using catalog command.
RMAN> CATALOG START WITH '/tmp/backup.ctl';

22. What are new features in Oracle 11g RMAN?

23. What is the difference between auxiliary channel and maintenance channel?

9 comments:

  1. Please correct the 15 question answer it should be backup set is logical and backup piece is physical

    ReplyDelete
  2. Hi Satya,

    You're posts are really very help full to me i need a help from you. Could you please post some more real time interview questions for RMAN,ASM and RAC.


    Regards,
    Seshu

    ReplyDelete
  3. Hi Seshu,

    Thank you very much...
    All these interview questions are real time. I faced all these questions (each question at least 3 times).

    Oracle RMAN Interview Questions/FAQs http://satya-dba.blogspot.in/2012/10/oracle-rman-interview-questions-faqs.html

    Oracle ASM Interview Questions/FAQs http://satya-dba.blogspot.in/2012/10/oracle-asm-interview-questions-faqs.html

    Oracle RAC Interview Questions http://satya-racdba.blogspot.in/2012/10/oracle-rac-interview-questions-faqs.html

    All the best.

    -Cheers, Satya

    ReplyDelete
    Replies
    1. Hi Satya,

      Really thanks a lot for your help.

      Regards,
      Seshu

      Delete
  4. Sir Really i have no words to describe regarding your Website .
    Its Really Helpful and really short and sweet.

    Once again thanks for creating this blog.

    ReplyDelete
  5. Good blog. Thanks for providing info about RMAN, RAC

    ReplyDelete
  6. Hi Satya,

    First time I read your blog all docs are very useful .. kindly share some tuning releated

    ReplyDelete
  7. Hi Satya,

    Plse correct question 10 as Differential backup (for level 1 parents only) and Cumulative backup (for level 0 or level 1 parents)

    Regards,
    Seshu

    ReplyDelete