Lab 12 – Oracle – User Managed Backup and Recovery Questions

1. what is the internals of hot backup? (What happens when you give alter database/tablespace begin backup)

2. How will you recreate controlfile?

3. how to change the dbname without using NID utility?

4. What is the diffrence between hot backup and cold backup?

5. What is the difference between logical and physical backup?

6. What is split block/fractured block?

8. What is the prerequisite to take hot backup?

9. What is your database size? How long it will take to take backup of you database?

10. How many archivelogs will generate in a 1 hr? Where will you check?

11. How frequenty you will take full backup and incremental backup?

12. What is your backup strategy?