ITPub博客

在客户现场的一点记录

原创 Oracle 作者:warehouse 时间:2016-05-03 14:11:02 0 删除 编辑

[root@rac1 ~]# dsmadmc
IBM Tivoli Storage Manager
Command Line Administrative Interface - Version 6, Release 4, Level 0.1
(c) Copyright by IBM Corporation and other(s) 1990, 2012. All Rights Reserved.

Enter your user id:  admin

Enter your password: 

Session established with server SERVER1: Windows
  Server Version 6, Release 3, Level 4.0
  Server date/time: 05/03/2016 10:57:48  Last access: 05/03/2016 10:42:31


tsm: SERVER1>

tsm: SERVER1>q vol stgpool=ORAPOOL

Volume Name                  Storage         Device         Estimated       Pct      Volume
                             Pool Name       Class Name      Capacity      Util      Status
------------------------     -----------     ----------     ---------     -----     --------
E:\TSMVOLUME\00000001.B-     ORAPOOL         FILEDEV          100.0 G      99.9       Full 
 FS                                                                                        
E:\TSMVOLUME\00000002.B-     ORAPOOL         FILEDEV          100.0 G      76.5       Full 
 FS                                                                                        
E:\TSMVOLUME\00000003.B-     ORAPOOL         FILEDEV          100.0 G      85.6       Full 
 FS                                                                                        
E:\TSMVOLUME\00000004.B-     ORAPOOL         FILEDEV          100.0 G     100.0       Full 
 FS                                                                                        
E:\TSMVOLUME\00000005.B-     ORAPOOL         FILEDEV          100.0 G     100.0       Full 
 FS                                                                                        
E:\TSMVOLUME\00000006.B-     ORAPOOL         FILEDEV          100.0 G      77.4       Full 
 FS                                                                                        
E:\TSMVOLUME\00000007.B-     ORAPOOL         FILEDEV          100.0 G     100.0       Full 
 FS                                                                                        
E:\TSMVOLUME\00000008.B-     ORAPOOL         FILEDEV          100.0 G     100.0       Full 
 FS                                                                                        
E:\TSMVOLUME\00000009.B-     ORAPOOL         FILEDEV          100.0 G     100.0       Full 
 FS                                                                                        
E:\TSMVOLUME\0000000A.B-     ORAPOOL         FILEDEV          100.0 G     100.0       Full 
 FS                                                                                        
E:\TSMVOLUME\0000000B.B-     ORAPOOL         FILEDEV          100.0 G      30.5     Filling
 FS                                                                                        
E:\TSMVOLUME\0000000E.B-     ORAPOOL         FILEDEV          100.0 G       0.0     Filling
 FS                                                                                        
E:\TSMVOLUME\0000000F.B-     ORAPOOL         FILEDEV          100.0 G     100.0       Full 
 FS                                                                                        
E:\TSMVOLUME\00000011.B-     ORAPOOL         FILEDEV          100.0 G     100.0       Full 
 FS                                                                                        
E:\TSMVOLUME\00000014.B-     ORAPOOL         FILEDEV          100.0 G      76.0       Full 
 FS                                                                                        


tsm: SERVER1>q content E:\TSMVOLUME\00000002BFS 
ANR2401E QUERY CONTENT: Volume E:\TSMVOLUME\00000002BFS is not defined in a storage pool.
ANS8001I Return code 11.

tsm: SERVER1>q content E:\TSMVOLUME\00000002.BFS

Node Name           Type     Filespace      FSID     Client's Name for File               
                             Name                   
---------------     ----     ----------     ----     --------------------------------------
ORA_CLIENT          Bkup     /adsmorc          2     //DB_RAC_62086_1_910298104           
ORA_CLIENT          Bkup     /adsmorc          2     //DB_RAC_62088_1_910299966           
ORA_CLIENT          Bkup     /adsmorc          2     //DB_RAC_62090_1_910301727           
ORA_CLIENT          Bkup     /adsmorc          2     //DB_RAC_62091_1_910303023           
ORA_CLIENT          Bkup     /adsmorc          2     //DB_RAC_62093_1_910303934           
ORA_CLIENT          Bkup     /adsmorc          2     //DB_RAC_62095_1_910306075           
ORA_CLIENT          Bkup     /adsmorc          2     //DB_RAC_62097_1_910307286           
ORA_CLIENT          Bkup     /adsmorc          2     //DB_RAC_62099_1_910308177           
ORA_CLIENT          Bkup     /adsmorc          2     //DB_RAC_62102_1_910309457           
ORA_CLIENT          Bkup     /adsmorc          2     //AL_RAC_62103_1_910321236           
ORA_CLIENT          Bkup     /adsmorc          2     //AL_RAC_62104_1_910321312           
ORA_CLIENT          Bkup     /adsmorc          2     //AL_RAC_62105_1_910321378           
ORA_CLIENT          Bkup     /adsmorc          2     //AL_RAC_62106_1_910321434           
ORA_CLIENT          Bkup     /adsmorc          2     //AL_RAC_62114_1_910321824           
ORA_CLIENT          Bkup     /adsmorc          2     //AL_RAC_62115_1_910321850           
ORA_CLIENT          Bkup     /adsmorc          2     //AL_RAC_62117_1_910321902           
ORA_CLIENT          Bkup     /adsmorc          2     //AL_RAC_62118_1_910321929           
ORA_CLIENT          Bkup     /adsmorc          2     //AL_RAC_62119_1_910321955           
ORA_CLIENT          Bkup     /adsmorc          2     //AL_RAC_62120_1_910321981           
ORA_CLIENT          Bkup     /adsmorc          2     //AL_RAC_62121_1_910322007           
ORA_CLIENT          Bkup     /adsmorc          2     //DB_RAC_62123_1_910375208           

tsm: SERVER1>


RMAN> list backuppiece tag TAG_DB_20160428;


List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
61948   61949   1   1   AVAILABLE   SBT_TAPE    DB_RAC_62146_1_910395916
61949   61950   1   1   AVAILABLE   SBT_TAPE    DB_RAC_62144_1_910394663
61946   61947   1   1   AVAILABLE   SBT_TAPE    DB_RAC_62143_1_910394648
61944   61945   1   1   AVAILABLE   SBT_TAPE    DB_RAC_62142_1_910394002
61945   61946   1   1   AVAILABLE   SBT_TAPE    DB_RAC_62141_1_910393777
61943   61944   1   1   AVAILABLE   SBT_TAPE    DB_RAC_62140_1_910393291
61942   61943   1   1   AVAILABLE   SBT_TAPE    DB_RAC_62139_1_910392576
61941   61942   1   1   AVAILABLE   SBT_TAPE    DB_RAC_62138_1_910391440
61940   61941   1   1   AVAILABLE   SBT_TAPE    DB_RAC_62137_1_910390434
61939   61940   1   1   AVAILABLE   SBT_TAPE    DB_RAC_62136_1_910389689
61938   61939   1   1   AVAILABLE   SBT_TAPE    DB_RAC_62135_1_910389423
61936   61937   1   1   AVAILABLE   SBT_TAPE    DB_RAC_62134_1_910388117
61937   61938   1   1   AVAILABLE   SBT_TAPE    DB_RAC_62133_1_910387682
61935   61936   1   1   AVAILABLE   SBT_TAPE    DB_RAC_62132_1_910386356
61934   61935   1   1   AVAILABLE   SBT_TAPE    DB_RAC_62131_1_910385941
61933   61934   1   1   AVAILABLE   SBT_TAPE    DB_RAC_62130_1_910384515
61932   61933   1   1   AVAILABLE   SBT_TAPE    DB_RAC_62129_1_910384089
61930   61931   1   1   AVAILABLE   SBT_TAPE    DB_RAC_62128_1_910383134
61929   61930   1   1   AVAILABLE   SBT_TAPE    DB_RAC_62127_1_910381998
61928   61929   1   1   AVAILABLE   SBT_TAPE    DB_RAC_62126_1_910380992
61931   61932   1   1   AVAILABLE   SBT_TAPE    DB_RAC_62125_1_910378545
61927   61928   1   1   AVAILABLE   SBT_TAPE    DB_RAC_62123_1_910375208
61926   61927   1   1   AVAILABLE   SBT_TAPE    DB_RAC_62124_1_910375208


tsm: SERVER1>select volume_name,status,access from volumes where stgpool_name='ORAPOOL';
Session established with server SERVER1: Windows
  Server Version 6, Release 3, Level 4.0
  Server date/time: 05/03/2016 12:55:42  Last access: 05/03/2016 11:32:32


VOLUME_NAME: E:\TSMVOLUME\00000001.BFS
     STATUS: FULL
     ACCESS: READWRITE

VOLUME_NAME: E:\TSMVOLUME\00000002.BFS
     STATUS: FULL
     ACCESS: READWRITE

VOLUME_NAME: E:\TSMVOLUME\00000003.BFS
     STATUS: FULL
     ACCESS: READWRITE

VOLUME_NAME: E:\TSMVOLUME\00000004.BFS
     STATUS: FULL
     ACCESS: READWRITE

VOLUME_NAME: E:\TSMVOLUME\00000005.BFS
     STATUS: FULL
     ACCESS: READWRITE

VOLUME_NAME: E:\TSMVOLUME\00000006.BFS
     STATUS: FULL
     ACCESS: READWRITE

VOLUME_NAME: E:\TSMVOLUME\00000007.BFS
     STATUS: FULL
     ACCESS: READWRITE

VOLUME_NAME: E:\TSMVOLUME\00000008.BFS
     STATUS: FULL
     ACCESS: READWRITE

VOLUME_NAME: E:\TSMVOLUME\00000009.BFS
     STATUS: FULL
     ACCESS: READWRITE

VOLUME_NAME: E:\TSMVOLUME\0000000A.BFS
     STATUS: FULL
     ACCESS: READWRITE

VOLUME_NAME: E:\TSMVOLUME\0000000B.BFS
     STATUS: FILLING
     ACCESS: READWRITE

VOLUME_NAME: E:\TSMVOLUME\0000000E.BFS
     STATUS: FILLING
     ACCESS: READWRITE

VOLUME_NAME: E:\TSMVOLUME\0000000F.BFS
     STATUS: FULL
     ACCESS: READWRITE

VOLUME_NAME: E:\TSMVOLUME\00000011.BFS
     STATUS: FULL
     ACCESS: READWRITE

VOLUME_NAME: E:\TSMVOLUME\00000014.BFS
more...   (<ENTER> to continue, 'C' to cancel)

     STATUS: FULL
     ACCESS: READWRITE


tsm: SERVER1>

VOLUME_NAME: E:\TSMVOLUME\0000000B.BFS
     STATUS: FILLING
     ACCESS: READWRITE

 

tsm: SERVER1>select * from volumes where stgpool_name='ORAPOOL';           

      VOLUME_NAME: E:\TSMVOLUME\00000001.BFS
     STGPOOL_NAME: ORAPOOL
    DEVCLASS_NAME: FILEDEV
  EST_CAPACITY_MB: 102374.0
SCALEDCAP_APPLIED:
     PCT_UTILIZED: 99.9
           STATUS: FULL
           ACCESS: READWRITE
      PCT_RECLAIM: 0.1
          SCRATCH: YES
      ERROR_STATE: NO
        NUM_SIDES: 1
    TIMES_MOUNTED: 36
       WRITE_PASS: 1
  LAST_WRITE_DATE: 2016-04-29 19:40:57.000000
   LAST_READ_DATE: 2016-04-28 19:41:32.000000
     PENDING_DATE:
     WRITE_ERRORS: 0
      READ_ERRORS: 0
         LOCATION:
    MVSLF_CAPABLE: No
         CHG_TIME: 2016-04-28 19:07:50.000000
        CHG_ADMIN:
  BEGIN_RCLM_DATE:
    END_RCLM_DATE:
  VOL_ENCR_KEYMGR:
    BLOCK_PROTECT: No
..........

tsm: SERVER1>select count(*) from backups where node_name='ORA_CLIENT' and filespace_name='/adsmorc' and BACKUP_DATE like '2016-04-28%' and ll_name like 'DB%';

  Unnamed[1]
------------
          23

tsm: SERVER1>select ll_name from backups where node_name='ORA_CLIENT' and filespace_name='/adsmorc' and BACKUP_DATE like '2016-04-28%' and ll_name like 'DB%';

LL_NAME: DB_RAC_62123_1_910375208

LL_NAME: DB_RAC_62124_1_910375208

LL_NAME: DB_RAC_62126_1_910380992

LL_NAME: DB_RAC_62127_1_910381998

LL_NAME: DB_RAC_62128_1_910383134

LL_NAME: DB_RAC_62125_1_910378545

LL_NAME: DB_RAC_62129_1_910384089

LL_NAME: DB_RAC_62130_1_910384515

LL_NAME: DB_RAC_62131_1_910385941

LL_NAME: DB_RAC_62132_1_910386356

LL_NAME: DB_RAC_62134_1_910388117

LL_NAME: DB_RAC_62133_1_910387682

LL_NAME: DB_RAC_62135_1_910389423

LL_NAME: DB_RAC_62136_1_910389689

LL_NAME: DB_RAC_62137_1_910390434

LL_NAME: DB_RAC_62138_1_910391440

LL_NAME: DB_RAC_62139_1_910392576

LL_NAME: DB_RAC_62140_1_910393291

LL_NAME: DB_RAC_62142_1_910394002

LL_NAME: DB_RAC_62141_1_910393777

LL_NAME: DB_RAC_62143_1_910394648

LL_NAME: DB_RAC_62146_1_910395916

LL_NAME: DB_RAC_62144_1_910394663

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/19602/viewspace-2092671/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2007-12-07

  • 博文量
    715
  • 访问量
    5059624