Oracle Rman Backup and restore considerations

1 backup File Management

If you want to delete the previous backup, do not manually go to the directory to delete, you should use the Delete command in the Rman command mode, otherwise, although the physical backup file is deleted on disk, but use the Backup view command will always see the deleted backup file

List backup; See what backup files are available on the current system

List Backupset summary; View summary information for a backup file

Crosscheck backup; Update the Rman backup information, if there is a corruption is unavailable, or manually delete the physical backup file can be viewed through this command the EX

Delete expired backup; Delete an expired backup

Delete backup; Delete all backup files;

Delete Backupset 1; Delete a specific backup set

　　

2 Archive Log Management

In addition to backing up the archive log when backing up the entire library, we can also manage the archive log separately.

Backup archive log separately: Rman>backup archivelog all;

After you have finished backing up the archive log, you should switch the log immediately: sql>alter system switch logfile; or rman> SQL ' alter system switch logfile ';

View archive Log:rman> list archivelog all;

View Backup archive Log:rman> list backup of Archivelog all;

Recover archive Log:rman> restore Archivelog sequence between 1 and 9; Determine the range of sequence to be recovered based on the results viewed

To clear redundant archive logs:

First manually remove the archived logs from the directory and then use the Crosscheck archivelog All command to update the system archive log information

RM-RF *arc; or Find/usr/oracle/app/flash_recovery_area/orcl/archivelog/2017_06_15-ctime +0-delete;

Rman> crosscheck Archivelog All;

rman> Delete Archivelog until sequence 9; --Press sequence to delete the log

rman> Delete Archivelog all completed before ' sysdate-7 ';

Oracle Rman Backup and restore considerations