Shulou(Shulou.com)06/01 Report--

1.configure

CONFIGURE RETENTION POLICY TO REDUNDANCY 3

Keep three backups

CONFIGURE BACKUP OPTIMIZATION OFF; # default

Backup optimization settings, which theoretically work only on read-only or offline table spaces (a table space is read-only, so that read-only table space will not be backed up on the second backup)

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

Backup device disk is disk, sbt is tape

CONFIGURE CONTROLFILE AUTOBACKUP ON

Controls whether the file backup is automatically backed up, which means whether the control file is backed up automatically while backing up the database

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO'/ oracle/RmanBackup/control%F'

Controls the directory and format of file backups

CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET

Backup parallelism and backup compression

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

There are several copies of the backed up data files (if you change 1 to 2, then two backups will be generated, including data files, control files, parameter files)

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

There are several copies of the backed-up archive log

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT'/ oracle/RmanBackup/%U'

Assign channel, backup directory of channel

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

The size of the backup set, this is better than UNLIMITED, because we can never estimate the size of the backup set.

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

Set backup encryption on, the new function after 10R2 is turned off by default, if you set this, you can set encryption on identifyed by youpassword only; encrypted backup, you need to provide a password when restoring.

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

Specify the encryption algorithm, and another is' AES256'

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

Compressed backup

CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK

Archive deletion policy, which requires only one archive backup to disk, after which the archive is allowed to be deleted

CONFIGURE SNAPSHOT CONTROLFILE NAME TO'/ oracle/app/db_1/dbs/snapcf_trac1.f'; # default

Mirror image of backup file

2.report

Report schema

Physical structure of the report database

Report need backup days=3

Report data files that have not been backed up in the last 3 days

Report need backup days 3 tablespace users

Data files on USERS tablespaces that have not been backed up for 3 days

Report need backup incremental 3

Report data files that require no more than 3 incremental backups to recover data files

Report need backup redundancy 2 database

Report all data files with backup files less than 2 points

Report need backup recovery window of 6 days

The recovery of report files requires more than 6 days of archived log data files

Report unrecoverable

Report all unrecoverable data files in the database

Report obsolete redundancy 2

Report stale backups with more than 2 backups

Report obsolete

Report redundant backups

3.list

List backup summary

List available backups (

B stands for backup

F stands for FULL

A stands for archive log

0 1 means incremental backup

S indicates backup status (An availanle,X exoired)

)

List backup

List detailed backups

List expired backup

List expired backups

List backup of database

List the backup sets of all data files

List backup of tablespace users

Lists all data file backup sets for USERS tablespaces

List backup of controlfile

List backup sets of control files

List backup of archivelog all

List archive log backup set details

List archivelog all

List archive log backup set brief information

List backup of spfile

List spfile backup sets

List copy of datafile 1

List data file image copy

List copy of controlfile

List control file image copy

List copy of archivelog all

List copy of archive log image

List incarnation of database

List counterpart / list database copy

List backup by file

List backups by backup type (by data file backup, archive log backup, control file backup, parameter file backup)

4.crosscheck

Crosscheck backup

Check all backup sets

Crosscheck backup of database

Check the backup set of all data files

Crosscheck backup of tablespace users

Check the backup set of the USERS tablespace

Crosscheck backup of controlfile

Check the backup set of control files

Crosscheck backup of spfile

Check the backup set of the parameter file

Crosscheck backup of archivelog sequence 3

Check the backup set of archived logs

Crosscheck archivelog all

Check all archive log backup sets

Crosscheck archivelog like'% *'

Crosscheck archivelog from sequence 172

Crosscheck archivelog until sequence 177

Crosscheck backup tag='db0'

Crosscheck backup completed after 'sysdate-2'

Crosscheck backup completed between 'sysdate-5' and' sysdate-2'

Crosscheck backup device type disk

Crosscheck copy

Check all copies of the image

Crosscheck copy of database

Check the image copies of all data files

Crosscheck copy of tablespace users

Check the image copy of the USERS tablespace

Crosscheck copy of datafile 2

Check the image copy of a specific data file

Crosscheck copy of archivelog sequence 175

Check the image copy of the archive log

Crosscheck copy of controlfile

Check the image copy of the control file

5.delete

Delete obsolete

Delete stale backup

Delete expired backup

Delete expired backup

Delete expired copy

Delete expired copies

Delete backupset 121

Delete backup set 121

Delete backuppiece'/ oracle/RmanBackup/db0_TESTDB_20151210_120'

Delete a specific backup film

Delete backup

Delete all backup sets

Delete backupcopy'/ oracle/RmanBackup/copy_123_1_1.bak'

Delete a specific image copy

Delete copy

Delete all copies of the image

Delete archivelog all

Delete all archive logs

Delete noprompt obsolete

Delete policy-based backup information

Crosscheck backup;delete noprompt expired backup;---- deletes backup information that is physically manually deleted

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.