RMAN 备份自动备份spfile、控制文件

1.默认情况下rman参数设置查询

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 OFF; --默认情况下是关闭的

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # 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 '/opt/oracle/product/11.2.0.1.0/db_1/dbs/snapcf_orcl.f'; # default

RMAN>

黑方完全备份脚本：

RMAN>

run{

allocate channel ch1 type disk ;

send 'CONFIG_FILE=/tmp/sbt/ora_sbt_prameter_orcl-%s-%T-%t-%U.conf';

backup incremental level 0 database format '/opt/rman/unasbt-database-%s-%T-%t-%U-.bak';

sql 'alter system archive log current';

backup archivelog all format '/opt/rman/unasbt-archlog-%s-%T-%t-%U-.bak' delete all input;

backup current controlfile format '/opt/rman/unasbt-ctrlfile-%s-%T-%t-%U-.bak';

release channel ch1;

}

执行过程：

RMAN> run{

allocate channel ch1 type disk ;

send 'CONFIG_FILE=/tmp/sbt/ora_sbt_prameter_orcl-%s-%T-%t-%U.conf';

backup incremental level 0 database format '/opt/rman/unasbt-database-%s-%T-%t-%U-.bak';

sql 'alter system archive log current';

backup archivelog all format '/opt/rman/unasbt-archlog-%s-%T-%t-%U-.bak' delete all input;

backup current controlfile format '/opt/rman/unasbt-ctrlfile-%s-%T-%t-%U-.bak';

release channel ch1;

}

2> 3> 4> 5> 6> 7> 8> 9>

allocated channel: ch1

channel ch1: SID=16 device type=DISK

sent command to channel: ch1

Starting backup at 26-DEC-17

channel ch1: starting incremental level 0 datafile backup set

channel ch1: specifying datafile(s) in backup set

input datafile file number=00006 name=/opt/oracle/oradata/orcl/data_D-ORCL_TS-ORCLTBS_FNO-6

input datafile file number=00007 name=/opt/oracle/oradata/orcl/data_D-ORCL_TS-ORCLTBS_FNO-7

input datafile file number=00008 name=/opt/oracle/oradata/orcl/data_D-ORCL_TS-ORCLTBS_FNO-8

input datafile file number=00009 name=/opt/oracle/oradata/orcl/data_D-ORCL_TS-ORCLTBS_FNO-9

input datafile file number=00010 name=/opt/oracle/oradata/orcl/data_D-ORCL_TS-ORCLTBS_FNO-10

input datafile file number=00002 name=/opt/oracle/oradata/orcl/data_D-ORCL_TS-SYSAUX_FNO-2

input datafile file number=00001 name=/opt/oracle/oradata/orcl/data_D-ORCL_TS-SYSTEM_FNO-1

input datafile file number=00005 name=/opt/oracle/oradata/orcl/data_D-ORCL_TS-UNDOTBS2_FNO-5

input datafile file number=00003 name=/opt/oracle/oradata/orcl/data_D-ORCL_TS-UNDOTBS1_FNO-3

input datafile file number=00004 name=/opt/oracle/oradata/orcl/data_D-ORCL_TS-USERS_FNO-4

channel ch1: starting piece 1 at 26-DEC-17

channel ch1: finished piece 1 at 26-DEC-17

piece handle=/opt/rman/unasbt-database-47-20171226-963753620-1fsn3dkk_1_1-.bak tag=TAG20171226T132020 comment=NONE

channel ch1: backup set complete, elapsed time: 00:00:55

channel ch1: starting incremental level 0 datafile backup set

channel ch1: specifying datafile(s) in backup set

including current control file in backup set

including current SPFILE in backup set

channel ch1: starting piece 1 at 26-DEC-17

channel ch1: finished piece 1 at 26-DEC-17

piece handle=/opt/rman/unasbt-database-48-20171226-963753675-1gsn3dmb_1_1-.bak tag=TAG20171226T132020 comment=NONE

channel ch1: backup set complete, elapsed time: 00:00:01

Finished backup at 26-DEC-17

sql statement: alter system archive log current

Starting backup at 26-DEC-17

current log archived

channel ch1: starting archived log backup set

channel ch1: specifying archived log(s) in backup set

input archived log thread=1 sequence=15 RECID=96 STAMP=963753678

input archived log thread=1 sequence=16 RECID=97 STAMP=963753681

channel ch1: starting piece 1 at 26-DEC-17

channel ch1: finished piece 1 at 26-DEC-17

piece handle=/opt/rman/unasbt-archlog-49-20171226-963753681-1hsn3dmh_1_1-.bak tag=TAG20171226T132121 comment=NONE

channel ch1: backup set complete, elapsed time: 00:00:01

channel ch1: deleting archived log(s)

archived log file name=/opt/oracle/product/11.2.0.1.0/db_1/dbs/arch1_15_963398239.dbf RECID=96 STAMP=963753678

archived log file name=/opt/oracle/product/11.2.0.1.0/db_1/dbs/arch1_16_963398239.dbf RECID=97 STAMP=963753681

Finished backup at 26-DEC-17

Starting backup at 26-DEC-17

channel ch1: starting full datafile backup set

channel ch1: specifying datafile(s) in backup set

including current control file in backup set

channel ch1: starting piece 1 at 26-DEC-17

channel ch1: finished piece 1 at 26-DEC-17

piece handle=/opt/rman/unasbt-ctrlfile-50-20171226-963753683-1isn3dmj_1_1-.bak tag=TAG20171226T132123 comment=NONE

channel ch1: backup set complete, elapsed time: 00:00:01

Finished backup at 26-DEC-17

released channel: ch1

RMAN>

生成的4个备份集：

2.设置rman备份参数CONFIGURE CONTROLFILE AUTOBACKUP ON;

执行原来的rman备份脚本：

RMAN> run{

allocate channel ch1 type disk ;

send 'CONFIG_FILE=/tmp/sbt/ora_sbt_prameter_orcl-%s-%T-%t-%U.conf';

backup incremental level 0 database format '/opt/rman/unasbt-database-%s-%T-%t-%U-.bak';

sql 'alter system archive log current';

backup archivelog all format '/opt/rman/unasbt-archlog-%s-%T-%t-%U-.bak' delete all input;

backup current controlfile format '/opt/rman/unasbt-ctrlfile-%s-%T-%t-%U-.bak';

release channel ch1;

}2> 3> 4> 5> 6> 7> 8> 9>