在客户现场的一点记录

最新推荐文章于 2024-06-12 17:42:27 发布

clt3617

最新推荐文章于 2024-06-12 17:42:27 发布

阅读量112

点赞数

[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