Shulou(Shulou.com)05/31 Report--

This article mainly explains the "RMAN common command summary", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "RMAN common command summary" bar!

1. Default configuration show command

View current configuration parameters

RMAN > show all

RMAN configuration parameters for database with db_unique_name ORCL are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO'% favored; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE' DEFAULT' OPTIMIZE FOR LOAD TRUE; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO'/ u01 apprenticespact oracleandproduct11.2.0Uniplicationdbroom1anddbsActionSnapcfpictures orcl.fags; # default

two。 List backup information-LIST command

(1) list all backup information in the database

RMAN > list backup

(2) list the backup information of all control files

RMAN > list backup of controlfile

(3) list the backup information of the specified data file

RMAN > list backup of datafile'/ u01GUUUPUGUBUBUBUSERVER. Dbf'

Or

RMAN > list backup of datafile 3

Note: the DATAFILE serial number can be queried through the dynamic performance view V$DATAFILE or the data dictionary DBA_DATA_FILES.

(4) list all the information on a device

RMAN > list device type disk backup

(5) list all invalid backups

RMAN > list expired backup

3. Delete command-DELETE command

(1) Delete expired backups

RMAN > delete obsolete

(2) Delete invalid backups

To delete an invalid backup, you need to first execute the CROSSCHECK command to check the backup set. If the backup is found to be invalid (for example, the data file that the backup should deal with is corrupted or missing), RMAN will mark the backup set as EXPIRED.

RMAN > delete expired backup

(3) Delete invalid copy

RMAN > delete expired copy

(4) Delete the specified backup set

RMAN > delete backupset 3

(5) Delete all backup sets

RMAN > delete backup

(6) Delete all image copies

RMAN > delete copy

(7) Delete input objects after backup

RMAN > delete archivelog all delete input

4. Report display-REPORT command

(1) View all files that need to be backed up

RMAN > report need backup

(2) check whether the specified tablespace needs to be backed up

RMAN > report need backup tablespace users

(3) View expired backups

RMAN > report obsolete

5. Execute check-CROSSCHECK command

The CROSSCHECK command is used to check the status of a backup or archive physical file. If the physical file does exist and there is a matching record in the control file (or recovery directory), the status of the object is marked as AVAILABLE (valid), and if the file no longer exists, the status of the object is marked as EXPIRED (invalid)

(1) check all archived documents

RMAN > crosscheck archivelog all

(2) check all backup sets

RMAN > crosscheck backup

Thank you for your reading, the above is the content of "RMAN common command summary", after the study of this article, I believe you have a deeper understanding of the problem of RMAN common command summary, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.