YOU HAVE NEW MAIL]
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> ry Manager: Release 10.2.0.4.0 - Production on Mon Feb 21 03:00:00 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: YJZH (DBID=4242827070)
connected to recovery catalog database
RMAN> allocate channel for maintenance type disk;
2> change archivelog all validate;
3> release channel;
4> report obsolete;
5> allocate channel for maintenance device type 'sbt_tape' parms
6> 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
7> delete noprompt obsolete;
8> RUN {
9> allocate channel t1 type 'sbt_tape' parms
10> 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
11> backup incremental level 0 database include current controlfile format 'df_%t_%s_%p' filesperset=10;
12> sql 'alter system archive log current';
13> backup filesperset 20 format 'al_t%t_s%s_p%p' (archivelog all delete input);
14> RELEASE CHANNEL t1;
15> }
16> exit
allocated channel: ORA_MAINT_DISK_1
channel ORA_MAINT_DISK_1: sid=270 devtype=DISK
validation failed for archived log
archive log filename=/arch/yjzh/yjzh_1_1341_719598142.arc recid=1245 stamp=742888844
validation failed for archived log
archive log filename=/arch/yjzh/yjzh_1_1342_719598142.arc recid=1246 stamp=742950939
validation succeeded for archived log
archive log filename=/arch/yjzh/yjzh_1_1589_719598142.arc recid=1493 stamp=743649889
Crosschecked 249 objects
released channel: ORA_MAINT_DISK_1
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 6271427 21-JAN-11
Backup Piece 6271430 21-JAN-11 df_741012206_260_1
Backup Set 6271453 21-JAN-11
Backup Piece 6271458 21-JAN-11 df_741013048_264_1
Archive Log 6498608 12-FEB-11 /arch/yjzh/yjzh_1_1341_719598142.arc
Backup Set 6271454 21-JAN-11
Backup Piece 6271459 21-JAN-11 df_741013223_265_1
Archive Log 6498609 12-FEB-11 /arch/yjzh/yjzh_1_1342_719598142.arc
Archive Log 6498633 13-FEB-11 /arch/yjzh/yjzh_1_1366_719598142.arc
allocated channel: ORA_MAINT_SBT_TAPE_1
channel ORA_MAINT_SBT_TAPE_1: sid=270 devtype=SBT_TAPE
channel ORA_MAINT_SBT_TAPE_1: Data Protection for Oracle: version 5.5.1.0
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 6271427 21-JAN-11
Backup Piece 6271430 21-JAN-11 df_741012206_260_1
Backup Set 6271428 21-JAN-11
Backup Piece 6271431 21-JAN-11 df_741012501_261_1
Backup Set 6271429 21-JAN-11
Backup Piece 6271432 21-JAN-11 df_741012667_262_1
Backup Set 6271452 21-JAN-11
Backup Piece 6271457 21-JAN-11 df_741012753_263_1
Backup Set 6271453 21-JAN-11
Backup Piece 6271458 21-JAN-11 df_741013048_264_1
Archive Log 6498608 12-FEB-11 /arch/yjzh/yjzh_1_1341_719598142.arc
Backup Set 6271454 21-JAN-11
Backup Piece 6271459 21-JAN-11 df_741013223_265_1
Archive Log 6498609 12-FEB-11 /arch/yjzh/yjzh_1_1342_719598142.arc
Archive Log 6498610 13-FEB-11 /arch/yjzh/yjzh_1_1343_719598142.arc
Archive Log 6498632 13-FEB-11 /arch/yjzh/yjzh_1_1365_719598142.arc
Archive Log 6498633 13-FEB-11 /arch/yjzh/yjzh_1_1366_719598142.arc
Backup Set 6498634 12-FEB-11
Backup Piece 6498639 12-FEB-11 df_742878016_341_1
Backup Set 6498635 12-FEB-11
Backup Piece 6498640 12-FEB-11 df_742879552_342_1
Backup Set 6498636 12-FEB-11
Backup Piece 6498641 12-FEB-11 df_742879967_343_1
deleted archive log
archive log filename=/arch/yjzh/yjzh_1_1341_719598142.arc recid=1245 stamp=742888844
deleted archive log
archive log filename=/arch/yjzh/yjzh_1_1366_719598142.arc recid=1270 stamp=742956401
Deleted 26 objects
deleted backup piece
backup piece handle=df_742878016_341_1 recid=336 stamp=742878024
deleted backup piece
backup piece handle=df_742879552_342_1 recid=337 stamp=742879556
deleted backup piece
backup piece handle=df_742879967_343_1 recid=338 stamp=742879968
Deleted 3 objects
RMAN-06207: WARNING: 6 objects could not be deleted for SBT_TAPE channel(s) due
RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212: Object Type Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Backup Piece df_741012206_260_1
RMAN-06214: Backup Piece df_741012501_261_1
allocated channel: t1
channel t1: sid=271 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.5.1.0
Starting backup at 21-FEB-11
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00009 name=/yjzh/oradata/datafile/TS_YJ02.ORA
input datafile fno=00011 name=/yjzh/oradata/datafile/TS_YJXT_INTF01.ORA
input datafile fno=00002 name=/yjzh/yjzh/undotbs01.dbf
input datafile fno=00012 name=/yjzh/oradata/datafile/TS_YJXT_INTF02.ORA
input datafile fno=00015 name=/yjzh/oradata/datafile/TS_YJ_INDEX02.ORA
input datafile fno=00003 name=/yjzh/yjzh/sysaux01.dbf
input datafile fno=00016 name=/yjzh/oradata/datafile/TS_YJ_INDEX03.ORA
channel t1: starting piece 1 at 21-FEB-11
channel t1: finished piece 1 at 21-FEB-11
piece handle=df_743655613_370_1 tag=TAG20110221T030013 comment=API Version 2.0,MMS Version 5.5.1.0
channel t1: backup set complete, elapsed time: 00:06:06
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00008 name=/yjzh/oradata/datafile/TS_YJ01.ORA
input datafile fno=00010 name=/yjzh/oradata/datafile/TS_YJ03.ORA
input datafile fno=00014 name=/yjzh/oradata/datafile/TS_YJ_INDEX01.ORA
input datafile fno=00013 name=/yjzh/oradata/datafile/TS_YJXT_INTF03.ORA
input datafile fno=00001 name=/yjzh/yjzh/system01.dbf
input datafile fno=00004 name=/yjzh/yjzh/users01.dbf
channel t1: starting piece 1 at 21-FEB-11
channel t1: finished piece 1 at 21-FEB-11
piece handle=df_743655979_371_1 tag=TAG20110221T030013 comment=API Version 2.0,MMS Version 5.5.1.0
channel t1: backup set complete, elapsed time: 00:03:25
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel t1: starting piece 1 at 21-FEB-11
channel t1: finished piece 1 at 21-FEB-11
piece handle=df_743656184_372_1 tag=TAG20110221T030013 comment=API Version 2.0,MMS Version 5.5.1.0
channel t1: backup set complete, elapsed time: 00:00:02
Finished backup at 21-FEB-11
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06004: ORACLE error from recovery catalog database: ORA-03135: connection lost contact
ORACLE error from recovery catalog database: ORA-03114: not connected to ORACLE
Recovery Manager complete.
Backup End
Mon Feb 21 03:09:47 GMT+08:00 2011
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> ry Manager: Release 10.2.0.4.0 - Production on Mon Feb 21 03:00:00 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: YJZH (DBID=4242827070)
connected to recovery catalog database
RMAN> allocate channel for maintenance type disk;
2> change archivelog all validate;
3> release channel;
4> report obsolete;
5> allocate channel for maintenance device type 'sbt_tape' parms
6> 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
7> delete noprompt obsolete;
8> RUN {
9> allocate channel t1 type 'sbt_tape' parms
10> 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
11> backup incremental level 0 database include current controlfile format 'df_%t_%s_%p' filesperset=10;
12> sql 'alter system archive log current';
13> backup filesperset 20 format 'al_t%t_s%s_p%p' (archivelog all delete input);
14> RELEASE CHANNEL t1;
15> }
16> exit
allocated channel: ORA_MAINT_DISK_1
channel ORA_MAINT_DISK_1: sid=270 devtype=DISK
validation failed for archived log
archive log filename=/arch/yjzh/yjzh_1_1341_719598142.arc recid=1245 stamp=742888844
validation failed for archived log
archive log filename=/arch/yjzh/yjzh_1_1342_719598142.arc recid=1246 stamp=742950939
validation succeeded for archived log
archive log filename=/arch/yjzh/yjzh_1_1589_719598142.arc recid=1493 stamp=743649889
Crosschecked 249 objects
released channel: ORA_MAINT_DISK_1
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 6271427 21-JAN-11
Backup Piece 6271430 21-JAN-11 df_741012206_260_1
Backup Set 6271453 21-JAN-11
Backup Piece 6271458 21-JAN-11 df_741013048_264_1
Archive Log 6498608 12-FEB-11 /arch/yjzh/yjzh_1_1341_719598142.arc
Backup Set 6271454 21-JAN-11
Backup Piece 6271459 21-JAN-11 df_741013223_265_1
Archive Log 6498609 12-FEB-11 /arch/yjzh/yjzh_1_1342_719598142.arc
Archive Log 6498633 13-FEB-11 /arch/yjzh/yjzh_1_1366_719598142.arc
allocated channel: ORA_MAINT_SBT_TAPE_1
channel ORA_MAINT_SBT_TAPE_1: sid=270 devtype=SBT_TAPE
channel ORA_MAINT_SBT_TAPE_1: Data Protection for Oracle: version 5.5.1.0
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 6271427 21-JAN-11
Backup Piece 6271430 21-JAN-11 df_741012206_260_1
Backup Set 6271428 21-JAN-11
Backup Piece 6271431 21-JAN-11 df_741012501_261_1
Backup Set 6271429 21-JAN-11
Backup Piece 6271432 21-JAN-11 df_741012667_262_1
Backup Set 6271452 21-JAN-11
Backup Piece 6271457 21-JAN-11 df_741012753_263_1
Backup Set 6271453 21-JAN-11
Backup Piece 6271458 21-JAN-11 df_741013048_264_1
Archive Log 6498608 12-FEB-11 /arch/yjzh/yjzh_1_1341_719598142.arc
Backup Set 6271454 21-JAN-11
Backup Piece 6271459 21-JAN-11 df_741013223_265_1
Archive Log 6498609 12-FEB-11 /arch/yjzh/yjzh_1_1342_719598142.arc
Archive Log 6498610 13-FEB-11 /arch/yjzh/yjzh_1_1343_719598142.arc
Archive Log 6498632 13-FEB-11 /arch/yjzh/yjzh_1_1365_719598142.arc
Archive Log 6498633 13-FEB-11 /arch/yjzh/yjzh_1_1366_719598142.arc
Backup Set 6498634 12-FEB-11
Backup Piece 6498639 12-FEB-11 df_742878016_341_1
Backup Set 6498635 12-FEB-11
Backup Piece 6498640 12-FEB-11 df_742879552_342_1
Backup Set 6498636 12-FEB-11
Backup Piece 6498641 12-FEB-11 df_742879967_343_1
deleted archive log
archive log filename=/arch/yjzh/yjzh_1_1341_719598142.arc recid=1245 stamp=742888844
deleted archive log
archive log filename=/arch/yjzh/yjzh_1_1366_719598142.arc recid=1270 stamp=742956401
Deleted 26 objects
deleted backup piece
backup piece handle=df_742878016_341_1 recid=336 stamp=742878024
deleted backup piece
backup piece handle=df_742879552_342_1 recid=337 stamp=742879556
deleted backup piece
backup piece handle=df_742879967_343_1 recid=338 stamp=742879968
Deleted 3 objects
RMAN-06207: WARNING: 6 objects could not be deleted for SBT_TAPE channel(s) due
RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212: Object Type Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Backup Piece df_741012206_260_1
RMAN-06214: Backup Piece df_741012501_261_1
allocated channel: t1
channel t1: sid=271 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.5.1.0
Starting backup at 21-FEB-11
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00009 name=/yjzh/oradata/datafile/TS_YJ02.ORA
input datafile fno=00011 name=/yjzh/oradata/datafile/TS_YJXT_INTF01.ORA
input datafile fno=00002 name=/yjzh/yjzh/undotbs01.dbf
input datafile fno=00012 name=/yjzh/oradata/datafile/TS_YJXT_INTF02.ORA
input datafile fno=00015 name=/yjzh/oradata/datafile/TS_YJ_INDEX02.ORA
input datafile fno=00003 name=/yjzh/yjzh/sysaux01.dbf
input datafile fno=00016 name=/yjzh/oradata/datafile/TS_YJ_INDEX03.ORA
channel t1: starting piece 1 at 21-FEB-11
channel t1: finished piece 1 at 21-FEB-11
piece handle=df_743655613_370_1 tag=TAG20110221T030013 comment=API Version 2.0,MMS Version 5.5.1.0
channel t1: backup set complete, elapsed time: 00:06:06
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00008 name=/yjzh/oradata/datafile/TS_YJ01.ORA
input datafile fno=00010 name=/yjzh/oradata/datafile/TS_YJ03.ORA
input datafile fno=00014 name=/yjzh/oradata/datafile/TS_YJ_INDEX01.ORA
input datafile fno=00013 name=/yjzh/oradata/datafile/TS_YJXT_INTF03.ORA
input datafile fno=00001 name=/yjzh/yjzh/system01.dbf
input datafile fno=00004 name=/yjzh/yjzh/users01.dbf
channel t1: starting piece 1 at 21-FEB-11
channel t1: finished piece 1 at 21-FEB-11
piece handle=df_743655979_371_1 tag=TAG20110221T030013 comment=API Version 2.0,MMS Version 5.5.1.0
channel t1: backup set complete, elapsed time: 00:03:25
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel t1: starting piece 1 at 21-FEB-11
channel t1: finished piece 1 at 21-FEB-11
piece handle=df_743656184_372_1 tag=TAG20110221T030013 comment=API Version 2.0,MMS Version 5.5.1.0
channel t1: backup set complete, elapsed time: 00:00:02
Finished backup at 21-FEB-11
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06004: ORACLE error from recovery catalog database: ORA-03135: connection lost contact
ORACLE error from recovery catalog database: ORA-03114: not connected to ORACLE
Recovery Manager complete.
Backup End
Mon Feb 21 03:09:47 GMT+08:00 2011
解决方案 »
免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货