7-RMAN Backup and Recovery

7-RMAN Backup and Recovery - RMAN Backup and Recovery...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
1 RMAN Backup and Recovery Presenter Tathagata Bhattacharjee
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Tathagata Bhattacharjee 2 What is RMAN? ± Oracle utility. Installed along with Oracle. ± Can back up database files (datafiles, controlfile, archivelogs) to disk or tape ± Can restore database files from disk or tape. ± Can parallalize the backup operation ± Create duplicate databases ± Create Standby database ± Can run scripts from a command line. So jobs can be scheduled from crontab, OEM or windows scheduler ± Can generate reports on backups taken using RMAN ± Can perform shutdown, startup and some administrative tasks
Background image of page 2
Tathagata Bhattacharjee 3 How it Works ± Creates database server sessions on the target database to access internal backup and recovery packages. ± The database has internal packages, DBMS_RCVMAN, DBMS_BACKUP_RESTORE that actually take the pl/sql blocks passed from RMAN and turn them into system calls. ± It stores metadata about its operations in the control file of the target database and, optionally, in a recovery catalog schema in an Oracle database.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Tathagata Bhattacharjee 4 Why RMAN? ± Manages the complexity of backup and recovery operations. RMAN can backup your database online without having to put the tablespaces in hot backup mode. This reduces the additional redo generated during a hot backup. ± Minimizes the possibility of human errors. RMAN will automatically track new datafiles and tablespaces for you. ± Maintains history of backups and incarnations ± RMAN can work fairly seamlessly with third-party media management products.
Background image of page 4
Tathagata Bhattacharjee 5 Why RMAN? ± Make backups proportional to the size of transactional changes, not to the size of the database. RMAN will only back up used data blocks (up to HWM). Null blocks (Blocks that have never been used) are never backed up. ± Backups taken outside of RMAN can also be cataloged in the control using RMAN ± Can create Hot Backups (Image Copies) just like you do it from SQLPLUS prompt. These Image copies can be used for recovering database outside of RMAN
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Tathagata Bhattacharjee 6 Why RMAN? ± Since RMAN is integrated into the RDBMS, it has block-level access enabling it to check for data block corruptions. ± In 9i, RMAN provides block media recovery. For “ORA-1578:block corruption detected” error, instead of recovering the entire file and performing recovery, RMAN can simply recover the bad block and perform recovery. This means, rest of the data in the datafile is available during recovery. ± RMAN supports incremental backup strategies. ± RMAN can test/validate the backups without actually restoring them. ± Free
Background image of page 6
Tathagata Bhattacharjee 7 Restrictions ± Backups taken using “backup” command are in RMAN format. They can only be read by RMAN.
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.

Page1 / 79

7-RMAN Backup and Recovery - RMAN Backup and Recovery...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online