--查看当前的日志组
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