Topic : Backup and Recovery

What is Different Type of RMAN Backup?


Answer :

Full backup: During a Full backup (Level 0) all of the block ever used in datafile are backed up. The only difference between a level 0 incremental backup and a full backup is that a full backup is never included in an incremental strategy.
Comulative Backup: During a cumulative (Level 0) the entire block used since last full backup are backed up.
RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; # blocks changed since level 0 Differential Backup: During incremental backup only those blocks that have changed since last cumulative (Level 1) or full backup (Level 0) are backed up. Incremental backup are differential by default.
RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE

Show Answer Discuss

Can we restore a dropped table after a new table with the same name has been created?


  • Yes
  • No

Answer :

Yes

Show Answer Discuss

Which following command will clear database recyclebin?


  • Delete recyclebin;
  • Clear recyclebin;
  • Purge recyclebin;
  • Truncate recyclebin

Answer :

Purge recyclebin;

Show Answer Discuss

Flashback query time depends on ____?


  • Undo_retention
  • Flashback_timeout
  • Recyclebin retention
  • Flush

Answer :

Undo_retention

Show Answer Discuss

Does Drop Database command removes spfile?


  • Yes
  • No

Answer :

Yes

Show Answer Discuss