DBAII_R1_1_Les16_E

Views:
 
Category: Education
     
 

Presentation Description

No description available.

Comments

Presentation Transcript

RMAN Maintenance : 

RMAN Maintenance

Objectives : 

Objectives After completing this lesson, you should be able to do the following: Perform cross-checking of backups and copies Update the repository when backups have been deleted Change the availability status of backups and copies Make a backup or copy exempt from the retention policy Catalog backups made with operating system commands

Cross Checking Backups and Copies : 

Cross Checking Backups and Copies Use the CROSSCHECK command to: Ensure repository information is synchronized with actual files Check the status of a backup or copy Update the repository when files have been deleted with operating system commands

The CROSSCHECK Command : 

The CROSSCHECK Command Cross-check all backups in the database: Cross-check all copies in the database: CROSSCHECK BACKUPSET OF DATABASE; CROSSCHECK COPY;

Deleting Backups and Copies : 

Deleting Backups and Copies Use the DELETE command to: Delete physical backups and image copies Update repository status to DELETED Remove records from the recovery catalog

The DELETE Command : 

The DELETE Command Delete a specific backup set: Delete an expired backup without the confirmation: Delete all backups, copies, and archived redo log files based on the configured retention policy: DELETE BACKUPSET 102; DELETE NOPROMPT EXPIRED BACKUP OF TABLESPACE users; DELETE OBSOLETE;

Deleting Backups and Copies : 

Deleting Backups and Copies Use the BACKUP … DELETE INPUT command to: Delete input files upon successful creation of the backup set Delete archived redo log files, datafile copies, and backup sets

Changing the Availability of RMAN Backups and Copies : 

Changing the Availability of RMAN Backups and Copies Change the status of a backup or copy to Unavailable with the CHANGE … UNAVAILABLE command. Return the status to Available with the CHANGE … AVAILABLE command.

Changing the Availability Status : 

Changing the Availability Status Change the status of a specific datafile: Change the status of a control file backup: Change the status of archived redo log files: CHANGE DATAFILECOPY '/DB01/BACKUP/users01.dbf' UNAVAILABLE; CHANGE BACKUP OF CONTROLFILE UNAVAILABLE; CHANGE BACKUP OF CONTROLFILE AVAILABLE; CHANGE COPY OF ARCHIVELOG SEQUENCE BETWEEN 230 AND 240 UNAVAILABLE;

Exempting a Backup or Copy from the Retention Policy : 

Exempting a Backup or Copy from the Retention Policy Use the CHANGE … KEEP command to exempt a backup or copy from the retention policy. Use the CHANGE … NOKEEP command to cancel the exemption.

The CHANGE … KEEP Command : 

The CHANGE … KEEP Command Create a long-term backup: Make a datafile exempt from the retention policy for 60 days: CHANGE BACKUPSET 123 KEEP FOREVER NOLOGS; CHANGE DATAFILECOPY '/DB01/BACKUP/users01.dbf' KEEP UNTIL 'SYSDATE+60';

Cataloging Archived Redo Log Files and User-Managed Backups : 

Cataloging Archived Redo Log Files and User-Managed Backups You can use the CATALOG command to add information to the repository about: An operating system datafile copy An archived redo log copy A control file copy

The CATALOG Command : 

The CATALOG Command Catalog a backup taken with an operating system command: Catalog archived redo log files: CATALOG DATAFILECOPY '/DB01/BACKUP/users01.dbf'; CATALOG ARCHIVELOG '/ORADATA/ARCHIVE1/arch_12.arc', '/ORADATA/ARCHIVE1/arch_13.arc';

Uncataloging RMAN Records : 

Uncataloging RMAN Records Use the CHANGE … UNCATALOG command to: Update the record in the repository to DELETED status Delete a specific backup or copy record from the recovery catalog

The CHANGE … UNCATALOG Command : 

The CHANGE … UNCATALOG Command Remove records for deleted archived redo log files: Remove records for a deleted datafile: CHANGE ARCHIVELOG … UNCATALOG; CHANGE DATAFILECOPY '/DB01/BACKUP/users01.dbf' UNCATALOG;

Summary : 

Summary In this lesson, you should have learned how to: Perform cross-checking of backups and copies Update the repository when backups have been deleted Change the availability status of backups and copies Make a backup or copy exempt from the retention policy Catalog backups made with operating system commands

Practice 16 Overview : 

Practice 16 Overview This practice covers the following topics: Performing cross checking Cataloging files in the repository

authorStream Live Help