Basic RMAN backup usage

RMANYou don't need to talk about it. Just run the command .....
1. Create RMAN catalog
RMAN can use the control file to store the backup metadata of RMAN, or you can configure catalog to storeBackupInformation. In general, it is bestDatabaseConfigure catalog to manage RMAN backup information, so that when all control files are invalid, you can also use catalog to recreate control files and databases.
1). SQL> Create tablespace rmantbs datafile '/data/oradata/orcl/rmantbs01.dbf' size 50 m
Autoextend on next 5 m maxsize 200 m
Extent management local
Segment space management auto;

2). SQL> create user RMAN identifiedOracle
Default tablespace rmantbs
Temporary tablespace temp
Quota unlimited on rmantbs;

3). SQL> grant create session, recovery_catalog_owner to RMAN;

4). $ RMAN catalog RMAN/Oracle
RMAN> Create catalog tablespace rmantbs;
RMAN> connect target/
RMAN> Register database;

Ii. Configure RMAN
RMAN> show all;
RMAN configuration parameters for database with db_unique_name orcl are:
Configure retention policy to redundancy 1; # default
ConfigureBackupOptimization off; # default
Configure Default device type to disk; # default
Configure controlfile autobackup off; # default
Configure controlfile autobackup format for device type disk to '% F'; # default
Configure device type disk backup type to backupset parallelism 1;
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 'bzip2'; # default
Configure archivelog deletion policy to none; # default
Configure snapshot controlfile name to '/u01/APP/Oracle/product/11.1.0/db_1/dbs/snapcf_orcl.f'; # default

1. Configure retention policy
RMAN has two retention policies: dedundancy (default value: 1) and recovery window.
1.1) Configure to retain two redundant backups
RMAN> Configure retention policy to redundancy 2;
New RMAN configuration parameters:
Configure retention policy to redundancy 2;
New RMAN configuration parameters are successfully stored
Starting full Resync of recovery catalog
Full Resync complete

1.2) set the retention policy to 7 days
RMAN> Configure retention policy to recovery window of 7 days;
Old rman configuration parameters:
Configure retention policy to redundancy 2;
New RMAN configuration parameters:
Configure retention policy to recovery window of 7 days;
New RMAN configuration parameters are successfully stored
Starting full Resync of recovery catalog
Full Resync complete

2. configuration-optimized backup
RMAN> Configure backup Optimization on;
New RMAN configuration parameters:
Configure backup Optimization on;
New RMAN configuration parameters are successfully stored
Starting full Resync of recovery catalog
Full Resync complete

3. Configure the default device type
The default device type is disk, and the default device type is tape.
RMAN> Configure Default device type to SBT;
New RMAN configuration parameters:
Configure Default device type to 'sbt _ tape ';
New RMAN configuration parameters are successfully stored
Starting full Resync of recovery catalog
Full Resync complete

4. Configure Automatic Control File and spfile backup
RMAN> Configure controlfile autobackup on;
New RMAN configuration parameters:
Configure controlfile autobackup on;
New RMAN configuration parameters are successfully stored
Starting full Resync of recovery catalog
Full Resync complete

5. Configure the automatic control file and spfile backup formats
The default value is db_recovery_file_dest/$ oracle_sid/autobackup/$ date. The format is '% F'
Note: The format must contain '% F'
RMAN> Configure controlfile autobackup format for device type disk to '/u01/APP/Oracle/admin/orcl/controlfile/CTL _ % F ';
New RMAN configuration parameters:
Configure controlfile autobackup format for device type disk to '/u01/APP/Oracle/admin/orcl/controlfile/CTL _ % F ';
New RMAN configuration parameters are successfully stored
Starting full Resync of recovery catalog
Full Resync complete

6. Configure whether to generate backup sets or copy copies by default.
6.1 configure the Backup Type as copy
RMAN> Configure device type disk backup type to copy;
Old rman configuration parameters:
Configure device type disk backup type to backupset parallelism 1;
New RMAN configuration parameters:
Configure device type disk backup type to copy parallelism 1;
New RMAN configuration parameters are successfully stored
Starting full Resync of recovery catalog
Full Resync complete

6.2 configure parallelism Parallelism
RMAN> Configure device type disk backup type to backupset parallelism 2;
Old rman configuration parameters:
Configure device type disk backup type to copy parallelism 1;
New RMAN configuration parameters:
Configure device type disk backup type to backupset parallelism 2;
New RMAN configuration parameters are successfully stored
Starting full Resync of recovery catalog
Full Resync complete

RMAN> Configure device type sbt_tape Backup Type to backupset parallelism 2;
New RMAN configuration parameters:
Configure device type 'sbt _ tape 'Backup Type to backupset parallelism 2;
New RMAN configuration parameters are successfully stored
Starting full Resync of recovery catalog
Full Resync complete
NOTE: If parallelism of the tape device is configured, the number of tapes must be equal to the number of parallelism; otherwise, an error is returned.

6.3 configure the default compressed backup (Note that if you use a compressed backup, you must configure wallet and open)
RMAN> Configure device type disk backup type to compressed backupset;
Old rman configuration parameters:
Configure device type disk backup type to backupset parallelism 2;
New RMAN configuration parameters:
Configure device type disk backup type to compressed backupset parallelism 2;
New RMAN configuration parameters are successfully stored
Starting full Resync of recovery catalog
Full Resync complete

7. Configure the channel
RMAN> Configure Channel Device Type disk format'/bakup/RMAN/orcl/% d _ % S _ % P _ % T ';
New RMAN configuration parameters:
Configure Channel Device Type disk format'/bakup/RMAN/orcl/% d _ % S _ % P _ % T ';
New RMAN configuration parameters are successfully stored
Starting full Resync of recovery catalog
Full Resync complete

8. Configure encryption and encryption algorithms
You can use transparant for RMAN encryption.DataEncryption (TDE) encryption and password encryption methods. The TDE algorithms include aes128 (default), aes192, aes256, and so on. Wallet is required for backup and recovery.
RMAN> Configure encryption for database on;
New RMAN configuration parameters:
Configure encryption for database on;
New RMAN configuration parameters are successfully stored
Starting full Resync of recovery catalog
Full Resync complete

RMAN> Configure encryption algorithm 'aes256 ';
New RMAN configuration parameters:
Configure encryption algorithm 'aes256 ';
New RMAN configuration parameters are successfully stored
Starting full Resync of recovery catalog
Full Resync complete
 
Reference instance: http://users.telenet.be/oraguy.be/encryption1.htm

View configuration results:
RMAN> show all;
RMAN configuration parameters for database with db_unique_name orcl are:
Configure retention policy to recovery window of 7 days;
Configure backup Optimization on;
Configure Default device type to 'sbt _ tape ';
Configure controlfile autobackup on;
Configure controlfile autobackup format for device type disk to '/u01/APP/Oracle/admin/orcl/controlfile/CTL _ % F ';
Configure controlfile autobackup format for device type sbt_tape to '% F'; # default
Configure device type disk backup type to compressed backupset parallelism 2;
Configure device type 'sbt _ tape 'Backup Type to backupset parallelism 2;
Configure datafile backup copies for device type disk to 1; # default
Configure datafile backup copies for device type sbt_tape to 1; # default
Configure archivelog backup copies for device type disk to 1; # default
Configure archivelog backup copies for device type sbt_tape to 1; # default
Configure Channel Device Type disk format'/bakup/RMAN/orcl/% d _ % S _ % P _ % T ';
Configure maxsetsize to unlimited; # default
Configure encryption for database on;
Configure encryption algorithm 'aes256 ';
Configure compression algorithm 'bzip2'; # default
Configure archivelog deletion policy to none; # default
Configure snapshot controlfile name to '/u01/APP/Oracle/product/11.1.0/db_1/dbs/snapcf_orcl.f'; # default

3. Create a backup script for storage
1. Incremental backup with basic 0 values
Create script. B _whole_inc0 {
Backup
Incremental level 0 Database
Format '/bakup/RMAN/backup/orcl/db0 _ % d _ % S _ % P _ % t'
Tag = 'whole _ inc0 ';
}

2. Incremental backup of basic 1
Create script. B _whole_inc1 {
Backup
Incremental Level 1 Cumulative Database
Format '/bakup/RMAN/backup/orcl/db1 _ % d _ % S _ % P _ % t'
Tag = 'whole _ enc1 ';
}

3. Basic 2 Incremental Backup
Create script. B _whole_inc2 {
Backup
Incremental Level 2 Cumulative Database
Format '/bakup/RMAN/backup/orcl/DB2 _ % d _ % S _ % P _ % t'
Tag = 'whole _ inc2 ';
}

4. archive the current redo log Group
Create script. archive_log_current {
SQL"Alter system archive log current ";
}

5. Back up archived logs two days ago
Create script. B _archive_2days {
Execute script. archive_log_current;
Backup archivelog from time 'sysdate-2'
Format '/bakup/RMAN/backup/orcl/Ar _ % d _ % S _ % P _ % T ';
}

6. Back up and delete the archived logs the day before yesterday.
Create script. archive_delete3 {
Execute script. archive_log_current;
Backup archivelog from time 'sysdate-3' until time 'sysdate-2'
Format '/bakup/RMAN/backup/orcl/Ar _ % d _ % S _ % P _ % t'
Delete input;
}

7. The Backup Type is copy.
Run {
Allocate channel D1 type disk;
Copy
Datafile 1 to '/bakup/RMAN/backup/orcl/system01.dbf. Bak ',
Datafile 2 to '/bakup/RMAN/backup/orcl/undotbs01.dbf. Bak ',
Datafile 3 to '/bakup/RMAN/backup/orcl/sysaux01.dbf. Bak ',
Datafile 4 to '/bakup/RMAN/backup/orcl/users01.dbf. Bak ',
Datafile 5 to '/bakup/RMAN/backup/orcl/example01.dbf. Bak ',
Datafile 6 to '/bakup/RMAN/backup/orcl/rmantbs01.dbf. Bak ',
Current controlfile to '/bakup/RMAN/backup/orcl/control_bakup.ctl ';
}

Or

Run {
Backup as copy database;
}

8. database backup and all archive logs with the backup increment basically 0
Run {
Allocate channel C1 type disk;
Backup incremental level 0 Database
Format '/bakup/RMAN/backup/orcl/DB _ % d _ % S _ % P _ % t'
Tag = 'whole _ inc0'
Archivelog all
Format '/bakup/RMAN/backup/orcl/Ar _ % d _ % S _ % P _ % t'
Tag 'backup _ archivelog_all ';
}