TSM備份ANS0326E錯誤及解決
問題描述:
磁帶庫為雙驅動器,在原來的備份策略中只開啟單個通道(只使用一個驅動器),為了縮短備份時間,故多分配通道T2,以實現並備份資料流,在測試中出現如下錯誤:
$ cat full_baklog_080109*
Recovery Manager: Release 10.2.0.3.0 - Production on Wed Jan 9 16:41:05 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN> connect catalog *
2> connect target *
3> run {
4> allocate channel t1 type sbt;
5> allocate channel t2 type sbt;
6> send 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
7> backup format 'orcl_full_%T_%t_%U'database;
8> sql 'alter system archive log current';
9> backup format 'orcl_arhc_%T_%t_%U' archivelog all delete all input;
10> release channel t1;
11> release channel t2;
12> }
13>
14>
15>
connected to recovery catalog database
connected to target database: ORCL (DBID=1164610617)
allocated channel: t1
channel t1: sid=1064 instance=orcl1 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.4.1.0
allocated channel: t2
channel t2: sid=1080 instance=orcl1 devtype=SBT_TAPE
channel t2: Data Protection for Oracle: version 5.4.1.0
sent command to channel: t1
sent command to channel: t2
Starting backup at 01/09/2008 16:41:07
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00001 name=+DATA/orcl/datafile/system.262.636829895
input datafile fno=00003 name=+DATA/orcl/datafile/sysaux.264.636829905
input datafile fno=00007 name=+DATA/orcl/datafile/tivoliorts.dbf
input datafile fno=00005 name=+DATA/orcl/datafile/users.267.636829913
channel t1: starting piece 1 at 01/09/2008 16:41:08
channel t2: starting full datafile backupset
channel t2: specifying datafile(s) in backupset
input datafile fno=00006 name=+DATA/orcl/datafile/icqs_sys_data01.ora
input datafile fno=00002 name=+DATA/orcl/datafile/undotbs1.263.636829903
input datafile fno=00004 name=+DATA/orcl/datafile/undotbs2.266.636829911
channel t2: starting piece 1 at 01/09/2008 16:41:08
RMAN-03009: failure of backup command on t2 channel at 01/09/2008 16:41:11
ORA-19502: write error on file "orcl_full_20080109_643567268_9qj5o3l4_1_1", blockno 12289 (blocksize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
ANS0326E (RC41) This node has exceeded its maximum number of mount points.
channel t2 disabled, job failed on it will be run on another channel
channel t1: finished piece 1 at 01/09/2008 16:43:36
piece handle=orcl_full_20080109_643567268_9pj5o3l4_1_1 tag=TAG20080109T164107 comment=API Version 2.0,MMS Version 5.4.1.0
channel t1: backup set complete, elapsed time: 00:02:28
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00006 name=+DATA/orcl/datafile/icqs_sys_data01.ora
input datafile fno=00002 name=+DATA/orcl/datafile/undotbs1.263.636829903
input datafile fno=00004 name=+DATA/orcl/datafile/undotbs2.266.636829911
channel t1: starting piece 1 at 01/09/2008 16:43:36
channel t1: finished piece 1 at 01/09/2008 16:45:21
piece handle=orcl_full_20080109_643567416_9rj5o3po_1_1 tag=TAG20080109T164107 comment=API Version 2.0,MMS Version 5.4.1.0
channel t1: backup set complete, elapsed time: 00:01:45
Finished backup at 01/09/2008 16:45:21
Starting Control File and SPFILE Autobackup at 01/09/2008 16:45:21
piece handle=c-1164610617-20080109-0a comment=API Version 2.0,MMS Version 5.4.1.0
Finished Control File and SPFILE Autobackup at 01/09/2008 16:45:30
sql statement: alter system archive log current
Starting backup at 01/09/2008 16:45:42
current log archived
channel t1: starting archive log backupset
channel t1: specifying archive log(s) in backup set
input archive log thread=1 sequence=232 recid=383 stamp=643567536
input archive log thread=1 sequence=233 recid=386 stamp=643567545
input archive log thread=2 sequence=167 recid=384 stamp=643567545
input archive log thread=2 sequence=168 recid=385 stamp=643567551
channel t1: starting piece 1 at 01/09/2008 16:45:48
channel t1: finished piece 1 at 01/09/2008 16:45:51
piece handle=orcl_arhc_20080109_643567547_9tj5o3tr_1_1 tag=TAG20080109T164547 comment=API Version 2.0,MMS Version 5.4.1.0
channel t1: backup set complete, elapsed time: 00:00:04
channel t1: deleting archive log(s)
archive log filename=+DATA/orcl/1_232_636829881.dbf recid=383 stamp=643567536
archive log filename=+DATA/orcl/1_233_636829881.dbf recid=386 stamp=643567545
archive log filename=+DATA/orcl/2_167_636829881.dbf recid=384 stamp=643567545
archive log filename=+DATA/orcl/2_168_636829881.dbf recid=385 stamp=643567551
Finished backup at 01/09/2008 16:45:51
Starting Control File and SPFILE Autobackup at 01/09/2008 16:45:51
piece handle=c-1164610617-20080109-0b comment=API Version 2.0,MMS Version 5.4.1.0
Finished Control File and SPFILE Autobackup at 01/09/2008 16:46:00
released channel: t1
released channel: t2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of release command at 01/09/2008 16:46:06
RMAN-06012: channel: t2 not allocated
Recovery Manager complete.
問題原因:
ANS0326E (RC41) This node has exceeded its maximum number of mount points
解決方法:
q node qbypdb f=d
可以檢視到Maximum Mount Points Allowed的值為1
當分配兩個通道超過了其最大值
1.執行以下命令:
tsm: TSM_SERVER1>update node QBYPDB maxnummp=2
ANR2063I Node QBYPDB updated.
2.確認修改結果
tsm: TSM_SERVER1>q node QBYPDB f=d
Node Name: QBYPDB
Platform.: TDP Oracle AIX
Client OS Level: 5.3
Client Version: Version 5, Release 4, Level 1.0
Policy Domain Name: STANDARD
Last Access Date/Time: 01/09/08 16:47:15
Days Since Last Access: <1
Password Set Date/Time: 10/30/07 10:54:08
Days Since Password Set: 71
Invalid Sign-on Count: 0
Locked?: No
Contact:
Compression: Client
Archive Delete Allowed?: Yes
Backup Delete Allowed?: Yes
Registration Date/Time: 10/30/07 10:25:33
Registering Administrator: OPEN_REGISTRATION
Last Communication Method Used: Tcp/Ip
Bytes Received Last Session: 11.00 M
Bytes Sent Last Session: 1,289
Duration of Last Session: 2.00
more... (<ENTER> to continue, 'C' to cancel)
Pct. Idle Wait Last Session: 0.00
Pct. Comm. Wait Last Session: 50.00
Pct. Media Wait Last Session: 0.00
Optionset:
URL:
Node Type: Client
Password Expiration Period:
Keep Mount Point?: No
Maximum Mount Points Allowed: 2
Auto Filespace Rename : No
Validate Protocol: No
TCP/IP Name: qbypdb1
TCP/IP Address: 10.133.129.25
Globally Unique ID: 5f.d9.a5.42.86.fc.11.dc.a3.13.08.63.0a.85.81.19
Transaction Group Max: 0
Data Write Path: ANY
Data Read Path: ANY
Session Initiation: ClientOrServer
3.備份測試
$ cat full_baklog_080109*
Recovery Manager: Release 10.2.0.3.0 - Production on Wed Jan 9 17:35:41 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN> connect catalog *
2> connect target *
3> run {
4> allocate channel t1 type sbt;
5> allocate channel t2 type sbt;
6> send 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
7> backup format 'orcl_full_%T_%t_%U'database;
8> sql 'alter system archive log current';
9> backup format 'orcl_arhc_%T_%t_%U' archivelog all delete all input;
10> release channel t1;
11> release channel t2;
12> }
13>
14>
15>
connected to recovery catalog database
connected to target database: ORCL (DBID=1164610617)
allocated channel: t1
channel t1: sid=1062 instance=orcl1 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.4.1.0
allocated channel: t2
channel t2: sid=1080 instance=orcl1 devtype=SBT_TAPE
channel t2: Data Protection for Oracle: version 5.4.1.0
sent command to channel: t1
sent command to channel: t2
Starting backup at 01/09/2008 17:35:44
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00001 name=+DATA/orcl/datafile/system.262.636829895
input datafile fno=00003 name=+DATA/orcl/datafile/sysaux.264.636829905
input datafile fno=00007 name=+DATA/orcl/datafile/tivoliorts.dbf
input datafile fno=00005 name=+DATA/orcl/datafile/users.267.636829913
channel t1: starting piece 1 at 01/09/2008 17:35:44
channel t2: starting full datafile backupset
channel t2: specifying datafile(s) in backupset
input datafile fno=00006 name=+DATA/orcl/datafile/icqs_sys_data01.ora
input datafile fno=00002 name=+DATA/orcl/datafile/undotbs1.263.636829903
input datafile fno=00004 name=+DATA/orcl/datafile/undotbs2.266.636829911
channel t2: starting piece 1 at 01/09/2008 17:35:44
channel t1: finished piece 1 at 01/09/2008 17:37:09
piece handle=orcl_full_20080109_643570544_9vj5o6rg_1_1 tag=TAG20080109T173544 comment=API Version 2.0,MMS Version 5.4.1.0
channel t1: backup set complete, elapsed time: 00:01:25
channel t2: finished piece 1 at 01/09/2008 17:38:54
piece handle=orcl_full_20080109_643570544_a0j5o6rg_1_1 tag=TAG20080109T173544 comment=API Version 2.0,MMS Version 5.4.1.0
channel t2: backup set complete, elapsed time: 00:03:10
Finished backup at 01/09/2008 17:38:54
Starting Control File and SPFILE Autobackup at 01/09/2008 17:38:54
piece handle=c-1164610617-20080109-0c comment=API Version 2.0,MMS Version 5.4.1.0
Finished Control File and SPFILE Autobackup at 01/09/2008 17:39:03
sql statement: alter system archive log current
Starting backup at 01/09/2008 17:39:15
current log archived
channel t1: starting archive log backupset
channel t1: specifying archive log(s) in backup set
input archive log thread=2 sequence=169 recid=388 stamp=643570758
channel t1: starting piece 1 at 01/09/2008 17:39:22
channel t2: starting archive log backupset
channel t2: specifying archive log(s) in backup set
input archive log thread=1 sequence=234 recid=387 stamp=643570749
input archive log thread=1 sequence=235 recid=390 stamp=643570758
channel t2: starting piece 1 at 01/09/2008 17:39:22
channel t1: finished piece 1 at 01/09/2008 17:39:29
piece handle=orcl_arhc_20080109_643570761_a2j5o729_1_1 tag=TAG20080109T173920 comment=API Version 2.0,MMS Version 5.4.1.0
channel t1: backup set complete, elapsed time: 00:00:08
channel t1: deleting archive log(s)
archive log filename=+DATA/orcl/2_169_636829881.dbf recid=388 stamp=643570758
channel t2: finished piece 1 at 01/09/2008 17:39:29
piece handle=orcl_arhc_20080109_643570761_a3j5o729_1_1 tag=TAG20080109T173920 comment=API Version 2.0,MMS Version 5.4.1.0
channel t2: backup set complete, elapsed time: 00:00:08
channel t2: deleting archive log(s)
archive log filename=+DATA/orcl/1_234_636829881.dbf recid=387 stamp=643570749
archive log filename=+DATA/orcl/1_235_636829881.dbf recid=390 stamp=643570758
channel t1: starting archive log backupset
channel t1: specifying archive log(s) in backup set
input archive log thread=2 sequence=170 recid=389 stamp=643570764
channel t1: starting piece 1 at 01/09/2008 17:39:29
channel t1: finished piece 1 at 01/09/2008 17:39:32
piece handle=orcl_arhc_20080109_643570769_a4j5o72h_1_1 tag=TAG20080109T173920 comment=API Version 2.0,MMS Version 5.4.1.0
channel t1: backup set complete, elapsed time: 00:00:03
channel t1: deleting archive log(s)
archive log filename=+DATA/orcl/2_170_636829881.dbf recid=389 stamp=643570764
Finished backup at 01/09/2008 17:39:32
Starting Control File and SPFILE Autobackup at 01/09/2008 17:39:32
piece handle=c-1164610617-20080109-0d comment=API Version 2.0,MMS Version 5.4.1.0
Finished Control File and SPFILE Autobackup at 01/09/2008 17:39:41
released channel: t1
released channel: t2
Recovery Manager complete.
磁帶庫為雙驅動器,在原來的備份策略中只開啟單個通道(只使用一個驅動器),為了縮短備份時間,故多分配通道T2,以實現並備份資料流,在測試中出現如下錯誤:
$ cat full_baklog_080109*
Recovery Manager: Release 10.2.0.3.0 - Production on Wed Jan 9 16:41:05 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN> connect catalog *
2> connect target *
3> run {
4> allocate channel t1 type sbt;
5> allocate channel t2 type sbt;
6> send 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
7> backup format 'orcl_full_%T_%t_%U'database;
8> sql 'alter system archive log current';
9> backup format 'orcl_arhc_%T_%t_%U' archivelog all delete all input;
10> release channel t1;
11> release channel t2;
12> }
13>
14>
15>
connected to recovery catalog database
connected to target database: ORCL (DBID=1164610617)
allocated channel: t1
channel t1: sid=1064 instance=orcl1 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.4.1.0
allocated channel: t2
channel t2: sid=1080 instance=orcl1 devtype=SBT_TAPE
channel t2: Data Protection for Oracle: version 5.4.1.0
sent command to channel: t1
sent command to channel: t2
Starting backup at 01/09/2008 16:41:07
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00001 name=+DATA/orcl/datafile/system.262.636829895
input datafile fno=00003 name=+DATA/orcl/datafile/sysaux.264.636829905
input datafile fno=00007 name=+DATA/orcl/datafile/tivoliorts.dbf
input datafile fno=00005 name=+DATA/orcl/datafile/users.267.636829913
channel t1: starting piece 1 at 01/09/2008 16:41:08
channel t2: starting full datafile backupset
channel t2: specifying datafile(s) in backupset
input datafile fno=00006 name=+DATA/orcl/datafile/icqs_sys_data01.ora
input datafile fno=00002 name=+DATA/orcl/datafile/undotbs1.263.636829903
input datafile fno=00004 name=+DATA/orcl/datafile/undotbs2.266.636829911
channel t2: starting piece 1 at 01/09/2008 16:41:08
RMAN-03009: failure of backup command on t2 channel at 01/09/2008 16:41:11
ORA-19502: write error on file "orcl_full_20080109_643567268_9qj5o3l4_1_1", blockno 12289 (blocksize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
ANS0326E (RC41) This node has exceeded its maximum number of mount points.
channel t2 disabled, job failed on it will be run on another channel
channel t1: finished piece 1 at 01/09/2008 16:43:36
piece handle=orcl_full_20080109_643567268_9pj5o3l4_1_1 tag=TAG20080109T164107 comment=API Version 2.0,MMS Version 5.4.1.0
channel t1: backup set complete, elapsed time: 00:02:28
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00006 name=+DATA/orcl/datafile/icqs_sys_data01.ora
input datafile fno=00002 name=+DATA/orcl/datafile/undotbs1.263.636829903
input datafile fno=00004 name=+DATA/orcl/datafile/undotbs2.266.636829911
channel t1: starting piece 1 at 01/09/2008 16:43:36
channel t1: finished piece 1 at 01/09/2008 16:45:21
piece handle=orcl_full_20080109_643567416_9rj5o3po_1_1 tag=TAG20080109T164107 comment=API Version 2.0,MMS Version 5.4.1.0
channel t1: backup set complete, elapsed time: 00:01:45
Finished backup at 01/09/2008 16:45:21
Starting Control File and SPFILE Autobackup at 01/09/2008 16:45:21
piece handle=c-1164610617-20080109-0a comment=API Version 2.0,MMS Version 5.4.1.0
Finished Control File and SPFILE Autobackup at 01/09/2008 16:45:30
sql statement: alter system archive log current
Starting backup at 01/09/2008 16:45:42
current log archived
channel t1: starting archive log backupset
channel t1: specifying archive log(s) in backup set
input archive log thread=1 sequence=232 recid=383 stamp=643567536
input archive log thread=1 sequence=233 recid=386 stamp=643567545
input archive log thread=2 sequence=167 recid=384 stamp=643567545
input archive log thread=2 sequence=168 recid=385 stamp=643567551
channel t1: starting piece 1 at 01/09/2008 16:45:48
channel t1: finished piece 1 at 01/09/2008 16:45:51
piece handle=orcl_arhc_20080109_643567547_9tj5o3tr_1_1 tag=TAG20080109T164547 comment=API Version 2.0,MMS Version 5.4.1.0
channel t1: backup set complete, elapsed time: 00:00:04
channel t1: deleting archive log(s)
archive log filename=+DATA/orcl/1_232_636829881.dbf recid=383 stamp=643567536
archive log filename=+DATA/orcl/1_233_636829881.dbf recid=386 stamp=643567545
archive log filename=+DATA/orcl/2_167_636829881.dbf recid=384 stamp=643567545
archive log filename=+DATA/orcl/2_168_636829881.dbf recid=385 stamp=643567551
Finished backup at 01/09/2008 16:45:51
Starting Control File and SPFILE Autobackup at 01/09/2008 16:45:51
piece handle=c-1164610617-20080109-0b comment=API Version 2.0,MMS Version 5.4.1.0
Finished Control File and SPFILE Autobackup at 01/09/2008 16:46:00
released channel: t1
released channel: t2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of release command at 01/09/2008 16:46:06
RMAN-06012: channel: t2 not allocated
Recovery Manager complete.
問題原因:
ANS0326E (RC41) This node has exceeded its maximum number of mount points
解決方法:
q node qbypdb f=d
可以檢視到Maximum Mount Points Allowed的值為1
當分配兩個通道超過了其最大值
1.執行以下命令:
tsm: TSM_SERVER1>update node QBYPDB maxnummp=2
ANR2063I Node QBYPDB updated.
2.確認修改結果
tsm: TSM_SERVER1>q node QBYPDB f=d
Node Name: QBYPDB
Platform.: TDP Oracle AIX
Client OS Level: 5.3
Client Version: Version 5, Release 4, Level 1.0
Policy Domain Name: STANDARD
Last Access Date/Time: 01/09/08 16:47:15
Days Since Last Access: <1
Password Set Date/Time: 10/30/07 10:54:08
Days Since Password Set: 71
Invalid Sign-on Count: 0
Locked?: No
Contact:
Compression: Client
Archive Delete Allowed?: Yes
Backup Delete Allowed?: Yes
Registration Date/Time: 10/30/07 10:25:33
Registering Administrator: OPEN_REGISTRATION
Last Communication Method Used: Tcp/Ip
Bytes Received Last Session: 11.00 M
Bytes Sent Last Session: 1,289
Duration of Last Session: 2.00
more... (<ENTER> to continue, 'C' to cancel)
Pct. Idle Wait Last Session: 0.00
Pct. Comm. Wait Last Session: 50.00
Pct. Media Wait Last Session: 0.00
Optionset:
URL:
Node Type: Client
Password Expiration Period:
Keep Mount Point?: No
Maximum Mount Points Allowed: 2
Auto Filespace Rename : No
Validate Protocol: No
TCP/IP Name: qbypdb1
TCP/IP Address: 10.133.129.25
Globally Unique ID: 5f.d9.a5.42.86.fc.11.dc.a3.13.08.63.0a.85.81.19
Transaction Group Max: 0
Data Write Path: ANY
Data Read Path: ANY
Session Initiation: ClientOrServer
3.備份測試
$ cat full_baklog_080109*
Recovery Manager: Release 10.2.0.3.0 - Production on Wed Jan 9 17:35:41 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN> connect catalog *
2> connect target *
3> run {
4> allocate channel t1 type sbt;
5> allocate channel t2 type sbt;
6> send 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
7> backup format 'orcl_full_%T_%t_%U'database;
8> sql 'alter system archive log current';
9> backup format 'orcl_arhc_%T_%t_%U' archivelog all delete all input;
10> release channel t1;
11> release channel t2;
12> }
13>
14>
15>
connected to recovery catalog database
connected to target database: ORCL (DBID=1164610617)
allocated channel: t1
channel t1: sid=1062 instance=orcl1 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.4.1.0
allocated channel: t2
channel t2: sid=1080 instance=orcl1 devtype=SBT_TAPE
channel t2: Data Protection for Oracle: version 5.4.1.0
sent command to channel: t1
sent command to channel: t2
Starting backup at 01/09/2008 17:35:44
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00001 name=+DATA/orcl/datafile/system.262.636829895
input datafile fno=00003 name=+DATA/orcl/datafile/sysaux.264.636829905
input datafile fno=00007 name=+DATA/orcl/datafile/tivoliorts.dbf
input datafile fno=00005 name=+DATA/orcl/datafile/users.267.636829913
channel t1: starting piece 1 at 01/09/2008 17:35:44
channel t2: starting full datafile backupset
channel t2: specifying datafile(s) in backupset
input datafile fno=00006 name=+DATA/orcl/datafile/icqs_sys_data01.ora
input datafile fno=00002 name=+DATA/orcl/datafile/undotbs1.263.636829903
input datafile fno=00004 name=+DATA/orcl/datafile/undotbs2.266.636829911
channel t2: starting piece 1 at 01/09/2008 17:35:44
channel t1: finished piece 1 at 01/09/2008 17:37:09
piece handle=orcl_full_20080109_643570544_9vj5o6rg_1_1 tag=TAG20080109T173544 comment=API Version 2.0,MMS Version 5.4.1.0
channel t1: backup set complete, elapsed time: 00:01:25
channel t2: finished piece 1 at 01/09/2008 17:38:54
piece handle=orcl_full_20080109_643570544_a0j5o6rg_1_1 tag=TAG20080109T173544 comment=API Version 2.0,MMS Version 5.4.1.0
channel t2: backup set complete, elapsed time: 00:03:10
Finished backup at 01/09/2008 17:38:54
Starting Control File and SPFILE Autobackup at 01/09/2008 17:38:54
piece handle=c-1164610617-20080109-0c comment=API Version 2.0,MMS Version 5.4.1.0
Finished Control File and SPFILE Autobackup at 01/09/2008 17:39:03
sql statement: alter system archive log current
Starting backup at 01/09/2008 17:39:15
current log archived
channel t1: starting archive log backupset
channel t1: specifying archive log(s) in backup set
input archive log thread=2 sequence=169 recid=388 stamp=643570758
channel t1: starting piece 1 at 01/09/2008 17:39:22
channel t2: starting archive log backupset
channel t2: specifying archive log(s) in backup set
input archive log thread=1 sequence=234 recid=387 stamp=643570749
input archive log thread=1 sequence=235 recid=390 stamp=643570758
channel t2: starting piece 1 at 01/09/2008 17:39:22
channel t1: finished piece 1 at 01/09/2008 17:39:29
piece handle=orcl_arhc_20080109_643570761_a2j5o729_1_1 tag=TAG20080109T173920 comment=API Version 2.0,MMS Version 5.4.1.0
channel t1: backup set complete, elapsed time: 00:00:08
channel t1: deleting archive log(s)
archive log filename=+DATA/orcl/2_169_636829881.dbf recid=388 stamp=643570758
channel t2: finished piece 1 at 01/09/2008 17:39:29
piece handle=orcl_arhc_20080109_643570761_a3j5o729_1_1 tag=TAG20080109T173920 comment=API Version 2.0,MMS Version 5.4.1.0
channel t2: backup set complete, elapsed time: 00:00:08
channel t2: deleting archive log(s)
archive log filename=+DATA/orcl/1_234_636829881.dbf recid=387 stamp=643570749
archive log filename=+DATA/orcl/1_235_636829881.dbf recid=390 stamp=643570758
channel t1: starting archive log backupset
channel t1: specifying archive log(s) in backup set
input archive log thread=2 sequence=170 recid=389 stamp=643570764
channel t1: starting piece 1 at 01/09/2008 17:39:29
channel t1: finished piece 1 at 01/09/2008 17:39:32
piece handle=orcl_arhc_20080109_643570769_a4j5o72h_1_1 tag=TAG20080109T173920 comment=API Version 2.0,MMS Version 5.4.1.0
channel t1: backup set complete, elapsed time: 00:00:03
channel t1: deleting archive log(s)
archive log filename=+DATA/orcl/2_170_636829881.dbf recid=389 stamp=643570764
Finished backup at 01/09/2008 17:39:32
Starting Control File and SPFILE Autobackup at 01/09/2008 17:39:32
piece handle=c-1164610617-20080109-0d comment=API Version 2.0,MMS Version 5.4.1.0
Finished Control File and SPFILE Autobackup at 01/09/2008 17:39:41
released channel: t1
released channel: t2
Recovery Manager complete.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/31344955/viewspace-2103781/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORACLE tsm 備份錯誤Oracle
- TSM無法備份故障解決(續)
- sap brtools發起oracle備份失敗,tsm備份軟體備份報錯Oracle
- TSM for Oracle備份指令碼及策略說明Oracle指令碼
- TSM ORACLE 備份排程Oracle
- TSM備份時提示認證失敗(Authentication failure)問題的解決AI
- 基於tsm的oracle資料庫備份及恢復Oracle資料庫
- TSM + Oracle備份出現問題Oracle
- oracle rman備份時出現ORA-19502錯誤解決案例Oracle
- AIX 上配置完成TSM API後,備份DB2時報SQL2062N錯誤AIAPIDB2SQL
- 【oracle 錯誤及解決】ORA-39139Oracle
- oracle錯誤及解決方式集(轉)Oracle
- TSM管理及備份資料到帶庫的方法及具體命令使用示例
- 原:Mozy:不錯的線上備份解決方案
- Hadoop常見錯誤及解決方案Hadoop
- 開發常見錯誤及解決方案
- PHP編譯錯誤及解決辦法PHP編譯
- ORA-14452錯誤及解決方法
- sqplus 的 segmentation fault錯誤及解決!Segmentation
- IMP-00098 錯誤及解決方法
- TSM備份軟體實施步驟
- TSM備份 ANS1025E (RC137) Session rejected: Authentication failure解決。SessionAI
- SQLServer錯誤程式碼及解釋(留著備用)SQLServer
- RMAN備份時出現RMAN-06056: could not access datafile 6 錯誤,解決方法!!
- 平臺配置及測試錯誤提示及解決方案
- 主流備份軟體比較及特點分析,NBU/TSM/Legato/DP/Bakbone
- Oracle 錯誤總結及問題解決 ORAOracle
- iOS路上遇到的錯誤及解決辦法iOS
- 【oracle 錯誤及解決】ORA-01659Oracle
- ORA-00257 錯誤分析及解決方法
- TSM+RMAN 自動備份指令碼 on aix指令碼AI
- SQL Server錯誤程式碼及解釋(留著備用)SQLServer
- Ocelot錯誤解決
- 對資料備份的誤解
- 主流備份軟體比較及特點分析,NBU/TSM/Legato/DP/NetVault
- 爬蟲常見錯誤程式碼及解決措施爬蟲
- ORA-39006錯誤原因及解決辦法
- Elasticsearch常見的5個錯誤及解決策略Elasticsearch