Topic : RMAN

What is the difference between backup set and backup piece?


Answer :

Backup set is logical and backup piece is physical.
RMAN command to backup for creating standby database
RMAN> duplicate target database
You loss 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 data file and recover datafile.
SQL> alter database create datafile ?/u01/app/oracle/oradata/xyz.dbf? size 2G;
RMAN> recover datafile file_id;

Show Answer Discuss

What is obsolete backup & expired backup?


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. 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.

Show Answer Discuss

Can we take backup of spfile in RMAN?


  • Yes
  • No

Answer :

Yes

Show Answer Discuss

You perform an incomplete database recovery using RMAN. Which state of target database is needed?


  • Mount
  • Nomount
  • Open; initially open
  • Open; initially closed

Answer :

Mount

Show Answer Discuss

Which type of file does Not RMAN include in its backups?


  • Data files
  • Control files
  • Password files
  • Online redo-logs
  • Archived redo-logs

Answer :

Archived redo-logs

Show Answer Discuss