1 / 25

DBA 101 Bootcamp

DBA 101 Bootcamp . New DBA Series Backup 101. Definitions. Archivelogmode Noarchivelogmode Shutdown normal Shutdown immediate Shutdown transactional Shutdown abort. Definitions cont’d . Consistent Inconsistent Control Files Data Files Redo Logs Archive Logs. Definitions cont’d.

rolf
Download Presentation

DBA 101 Bootcamp

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DBA 101 Bootcamp New DBA Series Backup 101 Paper #352

  2. Definitions • Archivelogmode • Noarchivelogmode • Shutdown normal • Shutdown immediate • Shutdown transactional • Shutdown abort Paper #352

  3. Definitions cont’d • Consistent • Inconsistent • Control Files • Data Files • Redo Logs • Archive Logs Paper #352

  4. Definitions cont’d • Physical Backup • Logical Backup • RMAN client • Target database • Recovery catalog database • Recovery catalog schema Paper #352

  5. Definitions cont’d • User Managed Backups • Hot Backup • Cold Backup • Flash/Fast recovery area Paper #352

  6. User Managed Backups (Physical) • YOU manage the: • Who • What • Where • When • Why • How Paper #352

  7. User Managed Backups cont’d • Cold (consistent noarchivelogmode) backup • (g)v$datafile • (g)v$controlfile • Shutdown (any mode EXCEPT ABORT) • Copy datafiles and 1 copy of controlfile to “other” location. Paper #352

  8. User Managed Backups cont’d • Cold (consistent archivelogmode) backup • Same as consistent noarchivelogmode AND • (g)v$archived_log • That’s it for COLD backups, any questions before we move on? Paper #352

  9. User Managed Backups cont’d • Hot (inconsistent) backup • Implies archivelogmode • Same as cold consistent archivelogmode • Put tablespaces in backup mode • Copy datafile • Take tablespaces out of backup mode • Switch logfile • Backup controlfile to trace Paper #352

  10. User Managed Backups cont’d • Questions to ponder: • We never backed up redo logs, why? • Why was methodology different for control file backup? • Why did we only backup 1 copy of the control file? Paper #352

  11. User Managed Backups Logical • Export (old exp command, shouldn’t be used anymore) • Data Pump • Whole presentation in itself. • Look at today at 11:45 for a datapump presentation. Paper #352

  12. Recovery Manager (RMAN) Backups • What is RMAN? • How do you access it? • Command line • OEM • What is a repository and do I need one? Paper #352

  13. Recovery Manager (RMAN) Backups cont’d • Connecting • connect catalog userid/password@______ • connect target / or userid/password@_______ Paper #352

  14. Recovery Manager (RMAN) Backups cont’d • Types of backups • Full • Incremental • Archivelog • Control File • Tablespace • Data File Paper #352

  15. Recovery Manager (RMAN) Backups cont’d • Full • Backup database [plus archivelog]; • Incremental • Backup incremental level 0 database; • Backup incremental level 1 database; Paper #352

  16. Recovery Manager (RMAN) Backups cont’d • Archivelog • Backup archivelog all [delete input]; • Controlfile • Backup current controlfile; Paper #352

  17. Recovery Manager (RMAN) Backups cont’d • Tablespace • Backup tablespace tsname; • Datafile • Backup datafile number; • Backup datafile “full path”; Paper #352

  18. Recovery Manager (RMAN) Backups cont’d • Reporting • List backup • Delete backup Paper #352

  19. Recovery Manager (RMAN) Backups cont’d • Questions to ponder: • Why do a controlfile backup AFTER the database backup? • Why can’t I do a backup of my noarchivelog mode database while its running? • Repository or no repository? Paper #352

  20. Pros/Cons • User Managed: • Pros: • You control all of it, control freaks, is this you? • It’s easy to just copy a file from a backup place to its original place • Cons: • You control all of it. • You have to maintain repository of when things were backed up last, etc. Paper #352

  21. Pros/Cons cont’d • RMAN managed: • Pros: • Oracle manages it all, you barely have to think about it • What has been backed up is kept for you automatically. Paper #352

  22. Pros/Cons cont’d • RMAN managed: • Cons: • You control freaks might not like Oracle “taking over it all” • Not just being able to cp a file from a backup location to the original location, you have to get RMAN involved. Paper #352

  23. Take home thought • Backups are important but are useless if they can't be recovered, so test your recovery plan. Paper #352

  24. Demo • Do you have a playground? • If not, why not? You need one • We’ll look at • User managed backup, both hot and cold • Recovery Manager(RMAN) backups full, incremental, tablespace, datafile, archivelog and control file. Paper #352

  25. Contact Info • Joe Testa • Cell: 614-774-3595 • Email: • ceo@teci-it.com • jtesta@gotvideographer.com • testaj3@nationwide.com • Facebook: joseph.s.testa • Twitter: n8xct Paper #352

More Related