[Terry Note] backup of RMAN comprehensive learning

Rman is the most cost-effective oracle backup tool. Here we will make an overall learning of rman.

Most of the scripts in this article are the syntax of rman commands. It is better to do experiments to be impressed. Because most databases are backed up by running scripts on time, and recovery is not common, and will be unfamiliar after a long time, review more.

[Terry Note] backup http://www.cnblogs.com/kkterry/p/3308405.html for RMAN Integrated Learning

[Terry Notes] recovery http://www.cnblogs.com/kkterry/p/3308407.html for RMAN Integrated Learning

[Terry Note] configuration http://www.cnblogs.com/kkterry/p/3308409.html for RMAN Integrated Learning

 

I. How to connect rman:

Local Connection: rman target/remote connection: rman targer sys/abcd @ testdb TIPS:In rman, you can also disable/enable the database: shutdown immediate/startuprman supports the host command to temporarily exit to the system layer, exit at the system layer, and then enter rman to execute the SQL statement in rman: SQL 'alter system Archive log all'; II. Backup Mode1. Backup Methods: Image and backup set. Image backup is about to be copied and pasted at the system layer, which will not be discussed here. 2. Command Execution method:

）RMAN ）RMAN）rman target  ）rman target  cmdfile）RMAN.sql

Iii. Backup command:1. Back up the database:

） ; ）  format ;  ）list   ;  ） backupset x;  

2. Backup control file:

） ）  include ）configure controlfile autobackup ）list   controlfile;

3. Back up the archive file:

） archivelog ） ） archivelog    input;  

4. Backup parameter file:

） spfile;

5. Back up the backup set: You can back up the backup set to another disk or tape.

） backupset   ） backupset n,n,n   input;

Iv. Incremental Backup (not displayed. The default mode is differential and cumulative)

） incremental   ） incremental    format  status    enable block change tracking using  

V. rman backup redundancy Policy (either based on time or based on the number of redundancy)

configure retention policy  recovery window  n days;   redundancy n;   none;