oracle plus archivelog,Oracle 11g RMAN备份-RMAN的backup database plus archivelog命令背后的操作...

--查看当前的日志组

sys@TESTDB11>selectsequence#,group#,statusfromv$log;

SEQUENCE#GROUP# STATUS

---------- ---------- ----------------

191INACTIVE

202INACTIVE

213CURRENT

--查看归档的日志信息

sys@TESTDB11>selectsequence#,name,first_change#,next_change#fromv$archived_log;

SEQUENCE# NAMEFIRST_CHANGE# NEXT_CHANGE#

---------- --------------------------------------------------

------------- ------------

93/archive1/1_93_813665348.dbf25217502522412

93/archive2/1_93_813665348.dbf25217502522412

94/archive1/1_94_813665348.dbf25224122523213

94/archive2/1_94_813665348.dbf25224122523213

95/archive1/1_95_813665348.dbf25232132525452

95/archive2/1_95_813665348.dbf25232132525452

94/archive1/1_94_813665348.dbf25224122523213

94/archive2/1_94_813665348.dbf25224122523213

95/archive1/1_95_813665348.dbf25232132525452

95/archive2/1_95_813665348.dbf25232132525452

96/archive1/1_96_813665348.dbf25254522526072

96/archive2/1_96_813665348.dbf25254522526072

1/archive1/1_1_823322444.dbf25260722527038

1/archive2/1_1_823322444.dbf25260722527038

2/archive1/1_2_823322444.dbf25270382527103

2/archive2/1_2_823322444.dbf25270382527103

4/archive1/1_4_823322444.dbf25292062529221

4/archive2/1_4_823322444.dbf25292062529221

5/archive1/1_5_823322444.dbf25292212529225

5/archive2/1_5_823322444.dbf25292212529225

6/archive1/1_6_823322444.dbf25292252529729

6/archive2/1_6_823322444.dbf25292252529729

1/archive1/1_1_823328120.dbf25292472545708

1/archive2/1_1_823328120.dbf25292472545708

2/archive1/1_2_823328120.dbf25457082556339

2/archive2/1_2_823328120.dbf25457082556339

3/archive1/1_3_823328120.dbf25563392556342

3/archive2/1_3_823328120.dbf25563392556342

4/archive1/1_4_823328120.dbf25563422556346

4/archive2/1_4_823328120.dbf25563422556346

5/archive1/1_5_823328120.dbf25563462556446

5/archive2/1_5_823328120.dbf25563462556446

6/archive1/1_6_823328120.dbf25564462556732

6/archive2/1_6_823328120.dbf25564462556732

7/archive1/1_7_823328120.dbf25567322557582

7/archive2/1_7_823328120.dbf25567322557582

8/archive1/1_8_823328120.dbf25575822557673

8/archive2/1_8_823328120.dbf25575822557673

9/archive1/1_9_823328120.dbf25576732557679

9/archive2/1_9_823328120.dbf25576732557679

10/archive1/1_10_823328120.dbf25576792557683

10/archive2/1_10_823328120.dbf25576792557683

11/archive1/1_11_823328120.dbf25576832558272

11/archive2/1_11_823328120.dbf25576832558272

12/archive1/1_12_823328120.dbf25582722558275

12/archive2/1_12_823328120.dbf25582722558275

13/archive1/1_13_823328120.dbf25582752558279

13/archive2/1_13_823328120.dbf25582752558279

14/archive1/1_14_823328120.dbf25582792562366

14/archive2/1_14_823328120.dbf25582792562366

15/archive1/1_15_823328120.dbf25623662564946

15/archive2/1_15_823328120.dbf25623662564946

16/archive1/1_16_823328120.dbf25649462591557

16/archive2/1_16_823328120.dbf25649462591557

17/archive1/1_17_823328120.dbf25915572594600

17/archive2/1_17_823328120.dbf25915572594600

18/archive1/1_18_823328120.dbf25946002614512

18/archive2/1_18_823328120.dbf25946002614512

19/archive1/1_19_823328120.dbf26145122623468

19/archive2/1_19_823328120.dbf26145122623468

20/archive1/1_20_823328120.dbf26234682642417

20/archive2/1_20_823328120.dbf26234682642417

62rowsselected.

--进行整个库和归档的备份

RMAN>backup database plus archivelog;

Starting backupat2013-08-1404:48:25

currentlogarchived

usingchannel ORA_DISK_1

channel ORA_DISK_1:starting archivedlogbackupset

channel ORA_DISK_1:specifying archivedlog(s)inbackupset

inputarchivedlogthread=1sequence=93RECID=2STAMP=823320816

inputarchivedlogthread=1sequence=94RECID=8STAMP=823322447

inputarchivedlogthread=1sequence=95RECID=9STAMP=823322447

inputarchivedlogthread=1sequence=96RECID=12STAMP=823322448

channel ORA_DISK_1:starting piece1at2013-08-1404:48:25

channel ORA_DISK_1:finished piece1at2013-08-1404:48:28

piece handle=/pooldisk02/backup03/1ioh8ekp_1_1 tag=TAG20130814T044825comment=NONE

channel ORA_DISK_1:backupsetcomplete,elapsedtime:00:00:03

channel ORA_DISK_1:starting archivedlogbackupset

channel ORA_DISK_1:specifying archivedlog(s)inbackupset

inputarchivedlogthread=1sequence=1RECID=14STAMP=823323373

inputarchivedlogthread=1sequence=2RECID=15STAMP=823323515

inputarchivedlogthread=1sequence=4RECID=18STAMP=823328120

inputarchivedlogthread=1sequence=5RECID=20STAMP=823328120

inputarchivedlogthread=1sequence=6RECID=21STAMP=823328120

channel ORA_DISK_1:starting piece1at2013-08-1404:48:28

channel ORA_DISK_1:finished piece1at2013-08-1404:48:29

piece handle=/pooldisk02/backup03/1joh8eks_1_1 tag=TAG20130814T044825comment=NONE

channel ORA_DISK_1:backupsetcomplete,elapsedtime:00:00:01

channel ORA_DISK_1:starting archivedlogbackupset

channel ORA_DISK_1:specifying archivedlog(s)inbackupset

inputarchivedlogthread=1sequence=1RECID=24STAMP=823349716

inputarchivedlogthread=1sequence=2RECID=26STAMP=823363531

inputarchivedlogthread=1sequence=3RECID=28STAMP=823363532

inputarchivedlogthread=1sequence=4RECID=30STAMP=823363534

inputarchivedlogthread=1sequence=5RECID=32STAMP=823363729

inputarchivedlogthread=1sequence=6RECID=34STAMP=823363769

inputarchivedlogthread=1sequence=7RECID=36STAMP=823363777

inputarchivedlogthread=1sequence=8RECID=37STAMP=823363948

inputarchivedlogthread=1sequence=9RECID=40STAMP=823363951

inputarchivedlogthread=1sequence=10RECID=42STAMP=823363954

inputarchivedlogthread=1sequence=11RECID=44STAMP=823364155

inputarchivedlogthread=1sequence=12RECID=46STAMP=823364156

inputarchivedlogthread=1sequence=13RECID=48STAMP=823364158

inputarchivedlogthread=1sequence=14RECID=50STAMP=823364525

inputarchivedlogthread=1sequence=15RECID=51STAMP=823364546

inputarchivedlogthread=1sequence=16RECID=54STAMP=823365806

inputarchivedlogthread=1sequence=17RECID=55STAMP=823367914

inputarchivedlogthread=1sequence=18RECID=58STAMP=823384872

inputarchivedlogthread=1sequence=19RECID=59STAMP=823392030

inputarchivedlogthread=1sequence=20RECID=62STAMP=823408208

inputarchivedlogthread=1sequence=21RECID=63STAMP=823409305

channel ORA_DISK_1:starting piece1at2013-08-1404:48:29

channel ORA_DISK_1:finished piece1at2013-08-1404:48:44

piece handle=/pooldisk02/backup03/1koh8ekt_1_1 tag=TAG20130814T044825comment=NONE

channel ORA_DISK_1:backupsetcomplete,elapsedtime:00:00:15

Finished backupat2013-08-1404:48:44

Starting backupat2013-08-1404:48:45

usingchannel ORA_DISK_1

channel ORA_DISK_1:starting full datafile backupset

channel ORA_DISK_1:specifying datafile(s)inbackupset

inputdatafilefilenumber=00001name=/oradata/system01.dbf

inputdatafilefilenumber=00002name=/oradata/sysaux01.dbf

inputdatafilefilenumber=00005name=/oradata/example01.dbf

inputdatafilefilenumber=00003name=/oradata/undotbs01.dbf

inputdatafilefilenumber=00007name=/oradata/fbtbs01.dbf

inputdatafilefilenumber=00008name=/oradata/users02.dbf

inputdatafilefilenumber=00006name=/oradata/newts01.dbf

inputdatafilefilenumber=00004name=/oradata/users01.dbf

channel ORA_DISK_1:starting piece1at2013-08-1404:48:45

channel ORA_DISK_1:finished piece1at2013-08-1404:51:10

piece handle=/pooldisk02/backup03/1loh8eld_1_1 tag=TAG20130814T044845comment=NONE

channel ORA_DISK_1:backupsetcomplete,elapsedtime:00:02:25

Finished backupat2013-08-1404:51:10

Starting backupat2013-08-1404:51:10

currentlogarchived

usingchannel ORA_DISK_1

channel ORA_DISK_1:starting archivedlogbackupset

channel ORA_DISK_1:specifying archivedlog(s)inbackupset

inputarchivedlogthread=1sequence=22RECID=65STAMP=823409470

channel ORA_DISK_1:starting piece1at2013-08-1404:51:10

channel ORA_DISK_1:finished piece1at2013-08-1404:51:11

piece handle=/pooldisk02/backup03/1moh8epu_1_1 tag=TAG20130814T045110comment=NONE

channel ORA_DISK_1:backupsetcomplete,elapsedtime:00:00:01

Finished backupat2013-08-1404:51:11

Starting ControlFileandSPFILE Autobackupat2013-08-1404:51:11

piece handle=/u01/app/oracle/fast_recovery_area/TESTDB11/autobackup/2013_08_14/o1_mf_s_823409472_90pnrjhy_.bkpcomment=NONE

Finished ControlFileandSPFILE Autobackupat2013-08-1404:51:15

--再次查看当前日志,发现在rman备份的过程中进行了日志切换,并将原来的当前日志组备份了出来

sys@TESTDB11>selectsequence#,group#,statusfromv$log;

SEQUENCE#GROUP# STATUS

---------- ---------- ----------------

221ACTIVE

232CURRENT

213INACTIVE

--注意：在备份日志的时候最好多切换一个备份出来

--与backup

database plus archivelog等待的做法是

RMAN>run{

2>backup database;

3>sql'alter system switch logfile';

4>backup archivelogall;

5>}

--备份归档日志,同时删除原来的归档

RMAN>backup archivelogalldeleteinput;

Starting backupat2013-08-1405:10:45

currentlogarchived

usingchannel ORA_DISK_1

channel ORA_DISK_1:starting archivedlogbackupset

channel ORA_DISK_1:specifying archivedlog(s)inbackupset

inputarchivedlogthread=1sequence=1RECID=24STAMP=823349716

inputarchivedlogthread=1sequence=2RECID=25STAMP=823363531

inputarchivedlogthread=1sequence=3RECID=27STAMP=823363532

inputarchivedlogthread=1sequence=4RECID=30STAMP=823363534

inputarchivedlogthread=1sequence=5RECID=31STAMP=823363729

inputarchivedlogthread=1sequence=6RECID=33STAMP=823363769

inputarchivedlogthread=1sequence=7RECID=35STAMP=823363777

inputarchivedlogthread=1sequence=8RECID=37STAMP=823363948

inputarchivedlogthread=1sequence=9RECID=39STAMP=823363951

inputarchivedlogthread=1sequence=10RECID=42STAMP=823363954

inputarchivedlogthread=1sequence=11RECID=43STAMP=823364155

inputarchivedlogthread=1sequence=12RECID=46STAMP=823364156

inputarchivedlogthread=1sequence=13RECID=48STAMP=823364158

inputarchivedlogthread=1sequence=14RECID=49STAMP=823364525

inputarchivedlogthread=1sequence=15RECID=51STAMP=823364546

inputarchivedlogthread=1sequence=16RECID=54STAMP=823365806

inputarchivedlogthread=1sequence=17RECID=55STAMP=823367914

inputarchivedlogthread=1sequence=18RECID=57STAMP=823384872

inputarchivedlogthread=1sequence=19RECID=59STAMP=823392030

inputarchivedlogthread=1sequence=20RECID=61STAMP=823408208

inputarchivedlogthread=1sequence=21RECID=63STAMP=823409305

inputarchivedlogthread=1sequence=22RECID=66STAMP=823409470

inputarchivedlogthread=1sequence=23RECID=67STAMP=823410645

channel ORA_DISK_1:starting piece1at2013-08-1405:10:46

channel ORA_DISK_1:finished piece1at2013-08-1405:11:11

piece handle=/pooldisk02/backup03/1ooh8fum_1_1 tag=TAG20130814T051045comment=NONE

channel ORA_DISK_1:backupsetcomplete,elapsedtime:00:00:25

channel ORA_DISK_1:deleting archivedlog(s)

archivedlogfilename=/archive2/1_1_823328120.dbf RECID=24STAMP=823349716

archivedlogfilename=/archive1/1_2_823328120.dbf RECID=25STAMP=823363531

archivedlogfilename=/archive1/1_3_823328120.dbf RECID=27STAMP=823363532

archivedlogfilename=/archive2/1_4_823328120.dbf RECID=30STAMP=823363534

archivedlogfilename=/archive1/1_5_823328120.dbf RECID=31STAMP=823363729

archivedlogfilename=/archive1/1_6_823328120.dbf RECID=33STAMP=823363769

archivedlogfilename=/archive1/1_7_823328120.dbf RECID=35STAMP=823363777

archivedlogfilename=/archive1/1_8_823328120.dbf RECID=37STAMP=823363948

archivedlogfilename=/archive1/1_9_823328120.dbf RECID=39STAMP=823363951

archivedlogfilename=/archive2/1_10_823328120.dbf RECID=42STAMP=823363954

archivedlogfilename=/archive1/1_11_823328120.dbf RECID=43STAMP=823364155

archivedlogfilename=/archive2/1_12_823328120.dbf RECID=46STAMP=823364156

archivedlogfilename=/archive2/1_13_823328120.dbf RECID=48STAMP=823364158

archivedlogfilename=/archive1/1_14_823328120.dbf RECID=49STAMP=823364525

archivedlogfilename=/archive1/1_15_823328120.dbf RECID=51STAMP=823364546

archivedlogfilename=/archive2/1_16_823328120.dbf RECID=54STAMP=823365806

archivedlogfilename=/archive1/1_17_823328120.dbf RECID=55STAMP=823367914

archivedlogfilename=/archive1/1_18_823328120.dbf RECID=57STAMP=823384872

archivedlogfilename=/archive1/1_19_823328120.dbf RECID=59STAMP=823392030

archivedlogfilename=/archive1/1_20_823328120.dbf RECID=61STAMP=823408208

archivedlogfilename=/archive1/1_21_823328120.dbf RECID=63STAMP=823409305

archivedlogfilename=/archive2/1_22_823328120.dbf RECID=66STAMP=823409470

archivedlogfilename=/archive1/1_23_823328120.dbf RECID=67STAMP=823410645

Finished backupat2013-08-1405:11:12

Starting ControlFileandSPFILE Autobackupat2013-08-1405:11:12

piece handle=/u01/app/oracle/fast_recovery_area/TESTDB11/autobackup/2013_08_14/o1_mf_s_823410672_90poy1w2_.bkpcomment=NONE

Finished ControlFileandSPFILE Autobackupat2013-08-1405:11:15

--查看原来的位置,都已经被删除了

[oracle@S1011:/u02/block_change_tracking2]$ cd/archive1

[oracle@S1011:/archive1]$ ls

--控制文件和初始化参数文件的备份,可以自动进行，也可以在rman中手工进行

--1.rman中手工备份当前的控制文件

RMAN>backupcurrentcontrolfile;

Starting backupat2013-08-1405:14:42

usingchannel ORA_DISK_1

channel ORA_DISK_1:starting full datafile backupset

channel ORA_DISK_1:specifying datafile(s)inbackupset

includingcurrentcontrolfileinbackupset

channel ORA_DISK_1:starting piece1at2013-08-1405:14:43

channel ORA_DISK_1:finished piece1at2013-08-1405:14:44

piece handle=/pooldisk02/backup03/1qoh8g62_1_1 tag=TAG20130814T051442comment=NONE

channel ORA_DISK_1:backupsetcomplete,elapsedtime:00:00:01

Finished backupat2013-08-1405:14:44

Starting ControlFileandSPFILE Autobackupat2013-08-1405:14:44

piece handle=/u01/app/oracle/fast_recovery_area/TESTDB11/autobackup/2013_08_14/o1_mf_s_823410884_90pp4o15_.bkpcomment=NONE

Finished ControlFileandSPFILE Autobackupat2013-08-1405:14:45

--进行自动备份，只需要打开相应的参数

RMAN>showall;

RMAN configurationparametersfordatabasewithdb_unique_name TESTDB11are:

CONFIGURE RETENTION POLICYTOREDUNDANCY1;#default

CONFIGURE BACKUP OPTIMIZATIONOFF;#default

CONFIGUREDEFAULTDEVICETYPETODISK;#default

CONFIGURE CONTROLFILE AUTOBACKUPON;

CONFIGURE CONTROLFILE AUTOBACKUPFORMATFORDEVICETYPEDISKTO'%F';#default

CONFIGURE DEVICETYPEDISK PARALLELISM1BACKUPTYPETOBACKUPSET;

CONFIGURE DATAFILE BACKUP COPIESFORDEVICETYPEDISKTO1;#default

CONFIGURE ARCHIVELOG BACKUP COPIESFORDEVICETYPEDISKTO1;#default

CONFIGURE CHANNEL1DEVICETYPEDISKFORMAT'/pooldisk02/backup03/%U';

CONFIGURE CHANNEL2DEVICETYPEDISKFORMAT'/pooldisk02/backup04/%U';

CONFIGURE MAXSETSIZETOUNLIMITED;#default

CONFIGURE ENCRYPTIONFORDATABASEOFF;#default

CONFIGURE ENCRYPTION ALGORITHM'AES128';#default

CONFIGURE COMPRESSION ALGORITHM'BASIC'ASOFRELEASE'DEFAULT'OPTIMIZEFORLOADTRUE;#default

CONFIGURE ARCHIVELOG DELETION POLICYTONONE;#default

CONFIGURE SNAPSHOT CONTROLFILE NAMETO'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_TestDB11.f';#default

RMAN>CONFIGURE CONTROLFILE AUTOBACKUPON;

oldRMAN configurationparameters:

CONFIGURE CONTROLFILE AUTOBACKUPON;

newRMAN configurationparameters:

CONFIGURE CONTROLFILE AUTOBACKUPON;

newRMAN configurationparametersaresuccessfully

stored

--或备份集中包含数据文件1，就会自动备份控制文件

RMAN>backup tablespace system;

Starting backupat2013-08-1405:17:03

usingchannel ORA_DISK_1

channel ORA_DISK_1:starting full datafile backupset

channel ORA_DISK_1:specifying datafile(s)inbackupset

inputdatafilefilenumber=00001name=/oradata/system01.dbf

channel ORA_DISK_1:starting piece1at2013-08-1405:17:03

channel ORA_DISK_1:finished piece1at2013-08-1405:17:58

piece handle=/pooldisk02/backup03/1soh8gaf_1_1 tag=TAG20130814T051703comment=NONE

channel ORA_DISK_1:backupsetcomplete,elapsedtime:00:00:55

Finished backupat2013-08-1405:17:58

Starting ControlFileandSPFILE Autobackupat2013-08-1405:17:58

piece handle=/u01/app/oracle/fast_recovery_area/TESTDB11/autobackup/2013_08_14/o1_mf_s_823411078_90ppbqdv_.bkpcomment=NONE

Finished ControlFileandSPFILE Autobackupat2013-08-1405:18:01

--备份初始化参数文件

RMAN>backup spfile;

Starting backupat2013-08-1405:20:44

usingchannel ORA_DISK_1

channel ORA_DISK_1:starting full datafile backupset

channel ORA_DISK_1:specifying datafile(s)inbackupset

includingcurrentSPFILEinbackupset

channel ORA_DISK_1:starting piece1at2013-08-1405:20:44

channel ORA_DISK_1:finished piece1at2013-08-1405:20:45

piece handle=/pooldisk02/backup03/1uoh8ghc_1_1 tag=TAG20130814T052044comment=NONE

channel ORA_DISK_1:backupsetcomplete,elapsedtime:00:00:01

Finished backupat2013-08-1405:20:45

Starting ControlFileandSPFILE Autobackupat2013-08-1405:20:45

piece handle=/u01/app/oracle/fast_recovery_area/TESTDB11/autobackup/2013_08_14/o1_mf_s_823411245_90pphxjk_.bkpcomment=NONE

Finished ControlFileandSPFILE Autobackupat2013-08-1405:20:46