rman的常用命令和asm檢視的命令

自己使用命令的時候，老是記不住，這次總結下，以後好查詢

 

 

1.檢視v$asm_diskgroup;
SQL> select group_number,name from v$asm_diskgroup;

GROUP_NUMBER NAME
------------ ----------
           1 ARCHDG
           2 DATADG
           3 GRIDDG

 

2.檢視v$asm_disk
SQL> col name format a10;
SQL> col path format a20;
SQL> select path, name from v$asm_disk;

PATH                 NAME
-------------------- ----------
/dev/rdisk/disk120   DATADG_000
                     0

/dev/rdisk/disk121   DATADG_000
                     1

/dev/rdisk/disk122   DATADG_000
                     2

/dev/rdisk/disk123   DATADG_000
                     3

 

 

asm磁碟組的使用者是gird

 

CBDBS02[/]su - grid

CBDBS02-> asmcmd
ASMCMD> ls
ARCHDG/
DATADG/
GRIDDG/
ASMCMD> lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N        1024   4096  1048576    512000   181649                0          181649              0             N  ARCHDG/
MOUNTED  EXTERN  N        1024   4096  1048576   5632000  5550615                0         5550615              0             N  DATADG/
MOUNTED  EXTERN  N        1024   4096  1048576      5120     4692                0            4692              0             N  GRIDDG/
ASMCMD> --help

        commands:
        --------

        md_backup, md_restore

        lsattr, setattr

        cd, cp, du, find, help, ls, lsct, lsdg, lsof, mkalias
        mkdir, pwd, rm, rmalias

        chdg, chkdg, dropdg, iostat, lsdsk, lsod, mkdg, mount
        offline, online, rebal, remap, umount

        dsget, dsset, lsop, shutdown, spbackup, spcopy, spget
        spmove, spset, startup

        chtmpl, lstmpl, mktmpl, rmtmpl

        chgrp, chmod, chown, groups, grpmod, lsgrp, lspwusr, lsusr
        mkgrp, mkusr, orapwusr, passwd, rmgrp, rmusr

        volcreate, voldelete, voldisable, volenable, volinfo
        volresize, volset, volstat

 

list backup of database(檢視資料庫的全庫備份，全部細節都包括)

list backup of tablespace users (檢視users表空間的備份)

list backup of datafile 5;(5是表空間對應的檔案id)

list backup of controlfile（看出控制文資訊的備份）

list backup of datafile '+DATADG/cboms/datafile/users.264.735423243';(根據具體的資料檔案的具體位置，檢視備份)

list expired backup；(無效的備份)

list expired archivelog all;(檢視無效的archive log 日誌)

 

list backup of database summary(這個是對概況性的，對資料庫有個直觀，全面的瞭解)

list backup of database summary 
list backup of archivelog all summary 
list backup of tablespace users summary 
list backup of datafile 5 summary