RMANでフルバックアップを取る
カタログデータベースを使用せず、制御ファイルを使用する。
show all;で設定を確認する。
RMAN> show all;
RMAN configuration parameters for database with db_unique_name RMAN 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 'BZIP2'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 3 TIMES TO DISK;
（アーカイブログを三世代保持する設定らしい。検証ポイント）
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/app/oracle/product/11.1.0/db11106/dbs/snapcf_rman.f'; # default
RMAN>
run
{
backup database
format '/backup/oradata/rman/weekly_%I_%T_%s_dbf.bak'
include current controlfile
plus archivelog
(archivelog current、アーカイブログバックアップ、再度arhivelog current、最後のアーカイブログバックアップの順に実施する手順)
format '/backup/oradata/rman/weekly_%I_%T_%s_arc.bak';
}
でフルバックアップを取る。
Starting backup at 2009/09/11 18:35:36
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=12 RECID=1 STAMP=697275933
input archived log thread=1 sequence=13 RECID=2 STAMP=697311969
input archived log thread=1 sequence=14 RECID=3 STAMP=697312496
input archived log thread=1 sequence=15 RECID=4 STAMP=697313508
input archived log thread=1 sequence=16 RECID=5 STAMP=697313530
input archived log thread=1 sequence=17 RECID=6 STAMP=697313708
input archived log thread=1 sequence=18 RECID=7 STAMP=697313739
input archived log thread=1 sequence=19 RECID=8 STAMP=697314936
channel ORA_DISK_1: starting piece 1 at 2009/09/11 18:35:36
channel ORA_DISK_1: finished piece 1 at 2009/09/11 18:35:39
piece handle=/backup/oradata/rman/weekly_1583660449_20090911_11_arc.bak tag=TAG20090911T183536 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 2009/09/11 18:35:39
Starting backup at 2009/09/11 18:35:39
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/opt/app/oracle/oradata/rman/system01.dbf
input datafile file number=00003 name=/opt/app/oracle/oradata/rman/undotbs01.dbf
input datafile file number=00002 name=/opt/app/oracle/oradata/rman/sysaux01.dbf
input datafile file number=00004 name=/opt/app/oracle/oradata/rman/users01.dbf
channel ORA_DISK_1: starting piece 1 at 2009/09/11 18:35:39
channel ORA_DISK_1: finished piece 1 at 2009/09/11 18:35:54
piece handle=/backup/oradata/rman/weekly_1583660449_20090911_12_dbf.bak tag=TAG20090911T183539 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 2009/09/11 18:35:55
channel ORA_DISK_1: finished piece 1 at 2009/09/11 18:35:56
piece handle=/backup/oradata/rman/weekly_1583660449_20090911_13_dbf.bak tag=TAG20090911T183539 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2009/09/11 18:35:56
Starting backup at 2009/09/11 18:35:57
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20 RECID=9 STAMP=697314957
channel ORA_DISK_1: starting piece 1 at 2009/09/11 18:35:57
channel ORA_DISK_1: finished piece 1 at 2009/09/11 18:35:58
piece handle=/backup/oradata/rman/weekly_1583660449_20090911_14_arc.bak tag=TAG20090911T183557 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2009/09/11 18:35:58
RMAN>
list bakcupとcrosscheck backupsetを実施
RMAN> list backup;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
11 63.58M DISK 00:00:02 2009/09/11 18:35:38
BP Key: 11 Status: AVAILABLE Compressed: NO Tag: TAG20090911T183536
Piece Name: /backup/oradata/rman/weekly_1583660449_20090911_11_arc.bak
List of Archived Logs in backup set 11
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 12 217396 2009/09/10 23:09:07 243568 2009/09/11 07:45:27
1 13 243568 2009/09/11 07:45:27 275466 2009/09/11 17:46:07
1 14 275466 2009/09/11 17:46:07 275798 2009/09/11 17:54:56
1 15 275798 2009/09/11 17:54:56 276851 2009/09/11 18:11:48
1 16 276851 2009/09/11 18:11:48 276870 2009/09/11 18:12:10
1 17 276870 2009/09/11 18:12:10 276996 2009/09/11 18:15:08
1 18 276996 2009/09/11 18:15:08 277016 2009/09/11 18:15:38
1 19 277016 2009/09/11 18:15:38 277543 2009/09/11 18:35:36
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
12 Full 235.85M DISK 00:00:12 2009/09/11 18:35:51
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20090911T183539
Piece Name: /backup/oradata/rman/weekly_1583660449_20090911_12_dbf.bak
List of Datafiles in backup set 12
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 Full 277549 2009/09/11 18:35:39 /opt/app/oracle/oradata/rman/system01.dbf
2 Full 277549 2009/09/11 18:35:39 /opt/app/oracle/oradata/rman/sysaux01.dbf
3 Full 277549 2009/09/11 18:35:39 /opt/app/oracle/oradata/rman/undotbs01.dbf
4 Full 277549 2009/09/11 18:35:39 /opt/app/oracle/oradata/rman/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
13 Full 9.36M DISK 00:00:02 2009/09/11 18:35:56
BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20090911T183539
Piece Name: /backup/oradata/rman/weekly_1583660449_20090911_13_dbf.bak
SPFILE Included: Modification time: 2009/09/11 17:46:05
SPFILE db_unique_name: RMAN
Control File Included: Ckp SCN: 277555 Ckp time: 2009/09/11 18:35:54
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
14 2.50K DISK 00:00:00 2009/09/11 18:35:57
BP Key: 14 Status: AVAILABLE Compressed: NO Tag: TAG20090911T183557
Piece Name: /backup/oradata/rman/weekly_1583660449_20090911_14_arc.bak
List of Archived Logs in backup set 14
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 20 277543 2009/09/11 18:35:36 277560 2009/09/11 18:35:57
RMAN>
RMAN> crosscheck backupset;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backup/oradata/rman/weekly_1583660449_20090911_11_arc.bak RECID=11 STAMP=697314936
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backup/oradata/rman/weekly_1583660449_20090911_12_dbf.bak RECID=12 STAMP=697314939
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backup/oradata/rman/weekly_1583660449_20090911_13_dbf.bak RECID=13 STAMP=697314955
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backup/oradata/rman/weekly_1583660449_20090911_14_arc.bak RECID=14 STAMP=697314957
Crosschecked 4 objects
RMAN>
アラートログのswitch履歴
Fri Sep 11 18:35:36 2009
ALTER SYSTEM ARCHIVE LOG
Fri Sep 11 18:35:36 2009
Thread 1 advanced to log sequence 20 (LGWR switch)
Current log# 2 seq# 20 mem# 0: /opt/app/oracle/oradata/rman/redo02.log
Fri Sep 11 18:35:57 2009
ALTER SYSTEM ARCHIVE LOG
Fri Sep 11 18:35:57 2009
Thread 1 advanced to log sequence 21 (LGWR switch)
Current log# 3 seq# 21 mem# 0: /opt/app/oracle/oradata/rman/redo03.log
時間的にもぴったり。
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 3 TIMES TO DISK;
（アーカイブログを三世代保持する設定らしい。検証ポイント）
↓
アーカイブログを三世代保持するためには、
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 4 TIMES TO DISK;
のように設定しなければならない。
show all;で設定を確認する。
RMAN> show all;
RMAN configuration parameters for database with db_unique_name RMAN 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 'BZIP2'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 3 TIMES TO DISK;
（アーカイブログを三世代保持する設定らしい。検証ポイント）
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/app/oracle/product/11.1.0/db11106/dbs/snapcf_rman.f'; # default
RMAN>
run
{
backup database
format '/backup/oradata/rman/weekly_%I_%T_%s_dbf.bak'
include current controlfile
plus archivelog
(archivelog current、アーカイブログバックアップ、再度arhivelog current、最後のアーカイブログバックアップの順に実施する手順)
format '/backup/oradata/rman/weekly_%I_%T_%s_arc.bak';
}
でフルバックアップを取る。
Starting backup at 2009/09/11 18:35:36
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=12 RECID=1 STAMP=697275933
input archived log thread=1 sequence=13 RECID=2 STAMP=697311969
input archived log thread=1 sequence=14 RECID=3 STAMP=697312496
input archived log thread=1 sequence=15 RECID=4 STAMP=697313508
input archived log thread=1 sequence=16 RECID=5 STAMP=697313530
input archived log thread=1 sequence=17 RECID=6 STAMP=697313708
input archived log thread=1 sequence=18 RECID=7 STAMP=697313739
input archived log thread=1 sequence=19 RECID=8 STAMP=697314936
channel ORA_DISK_1: starting piece 1 at 2009/09/11 18:35:36
channel ORA_DISK_1: finished piece 1 at 2009/09/11 18:35:39
piece handle=/backup/oradata/rman/weekly_1583660449_20090911_11_arc.bak tag=TAG20090911T183536 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 2009/09/11 18:35:39
Starting backup at 2009/09/11 18:35:39
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/opt/app/oracle/oradata/rman/system01.dbf
input datafile file number=00003 name=/opt/app/oracle/oradata/rman/undotbs01.dbf
input datafile file number=00002 name=/opt/app/oracle/oradata/rman/sysaux01.dbf
input datafile file number=00004 name=/opt/app/oracle/oradata/rman/users01.dbf
channel ORA_DISK_1: starting piece 1 at 2009/09/11 18:35:39
channel ORA_DISK_1: finished piece 1 at 2009/09/11 18:35:54
piece handle=/backup/oradata/rman/weekly_1583660449_20090911_12_dbf.bak tag=TAG20090911T183539 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 2009/09/11 18:35:55
channel ORA_DISK_1: finished piece 1 at 2009/09/11 18:35:56
piece handle=/backup/oradata/rman/weekly_1583660449_20090911_13_dbf.bak tag=TAG20090911T183539 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2009/09/11 18:35:56
Starting backup at 2009/09/11 18:35:57
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20 RECID=9 STAMP=697314957
channel ORA_DISK_1: starting piece 1 at 2009/09/11 18:35:57
channel ORA_DISK_1: finished piece 1 at 2009/09/11 18:35:58
piece handle=/backup/oradata/rman/weekly_1583660449_20090911_14_arc.bak tag=TAG20090911T183557 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2009/09/11 18:35:58
RMAN>
list bakcupとcrosscheck backupsetを実施
RMAN> list backup;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
11 63.58M DISK 00:00:02 2009/09/11 18:35:38
BP Key: 11 Status: AVAILABLE Compressed: NO Tag: TAG20090911T183536
Piece Name: /backup/oradata/rman/weekly_1583660449_20090911_11_arc.bak
List of Archived Logs in backup set 11
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 12 217396 2009/09/10 23:09:07 243568 2009/09/11 07:45:27
1 13 243568 2009/09/11 07:45:27 275466 2009/09/11 17:46:07
1 14 275466 2009/09/11 17:46:07 275798 2009/09/11 17:54:56
1 15 275798 2009/09/11 17:54:56 276851 2009/09/11 18:11:48
1 16 276851 2009/09/11 18:11:48 276870 2009/09/11 18:12:10
1 17 276870 2009/09/11 18:12:10 276996 2009/09/11 18:15:08
1 18 276996 2009/09/11 18:15:08 277016 2009/09/11 18:15:38
1 19 277016 2009/09/11 18:15:38 277543 2009/09/11 18:35:36
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
12 Full 235.85M DISK 00:00:12 2009/09/11 18:35:51
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20090911T183539
Piece Name: /backup/oradata/rman/weekly_1583660449_20090911_12_dbf.bak
List of Datafiles in backup set 12
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 Full 277549 2009/09/11 18:35:39 /opt/app/oracle/oradata/rman/system01.dbf
2 Full 277549 2009/09/11 18:35:39 /opt/app/oracle/oradata/rman/sysaux01.dbf
3 Full 277549 2009/09/11 18:35:39 /opt/app/oracle/oradata/rman/undotbs01.dbf
4 Full 277549 2009/09/11 18:35:39 /opt/app/oracle/oradata/rman/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
13 Full 9.36M DISK 00:00:02 2009/09/11 18:35:56
BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20090911T183539
Piece Name: /backup/oradata/rman/weekly_1583660449_20090911_13_dbf.bak
SPFILE Included: Modification time: 2009/09/11 17:46:05
SPFILE db_unique_name: RMAN
Control File Included: Ckp SCN: 277555 Ckp time: 2009/09/11 18:35:54
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
14 2.50K DISK 00:00:00 2009/09/11 18:35:57
BP Key: 14 Status: AVAILABLE Compressed: NO Tag: TAG20090911T183557
Piece Name: /backup/oradata/rman/weekly_1583660449_20090911_14_arc.bak
List of Archived Logs in backup set 14
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 20 277543 2009/09/11 18:35:36 277560 2009/09/11 18:35:57
RMAN>
RMAN> crosscheck backupset;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backup/oradata/rman/weekly_1583660449_20090911_11_arc.bak RECID=11 STAMP=697314936
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backup/oradata/rman/weekly_1583660449_20090911_12_dbf.bak RECID=12 STAMP=697314939
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backup/oradata/rman/weekly_1583660449_20090911_13_dbf.bak RECID=13 STAMP=697314955
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backup/oradata/rman/weekly_1583660449_20090911_14_arc.bak RECID=14 STAMP=697314957
Crosschecked 4 objects
RMAN>
アラートログのswitch履歴
Fri Sep 11 18:35:36 2009
ALTER SYSTEM ARCHIVE LOG
Fri Sep 11 18:35:36 2009
Thread 1 advanced to log sequence 20 (LGWR switch)
Current log# 2 seq# 20 mem# 0: /opt/app/oracle/oradata/rman/redo02.log
Fri Sep 11 18:35:57 2009
ALTER SYSTEM ARCHIVE LOG
Fri Sep 11 18:35:57 2009
Thread 1 advanced to log sequence 21 (LGWR switch)
Current log# 3 seq# 21 mem# 0: /opt/app/oracle/oradata/rman/redo03.log
時間的にもぴったり。
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 3 TIMES TO DISK;
（アーカイブログを三世代保持する設定らしい。検証ポイント）
↓
アーカイブログを三世代保持するためには、
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 4 TIMES TO DISK;
のように設定しなければならない。
Labels: Oracle10g, Oracle11g, software_oracle
posted by henbeibi at
3:40 AM
0 Comments:
Post a Comment
<< Home