常用rman命令

<pre name="code" class="sql">device type disk
 
RMAN> validate device type disk backupset 37;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "device": expecting one of: "backupset"
RMAN-01007: at line 1 column 10 file: standard input

RMAN> validate backupset 37;

using channel ORA_DISK_1
channel ORA_DISK_1: starting validation of datafile backupset
channel ORA_DISK_1: reading from backup piece /u01/oracle/11G/dbs/mvdiry/15puabjq_1_1
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/oracle/11G/dbs/mvdiry/15puabjq_1_1 tag=TAG20150203T012058
channel ORA_DISK_1: validation complete, elapsed time: 00:00:00

RMAN> list backupset of database;


List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
35      Full    7.46M      DISK        00:00:00     03-FEB-15      
        BP Key: 35   Status: AVAILABLE  Compressed: NO  Tag: TAG20150203T011637
        Piece Name: /u01/oracle/11G/dbs/13puabbl_1_1
  List of Datafiles in backup set 35
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 1355964    03-FEB-15 /u01/oracle/oradata/db01/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
37      Full    7.46M      DISK        00:00:01     03-FEB-15      
        BP Key: 39   Status: AVAILABLE  Compressed: NO  Tag: TAG20150203T012058
        Piece Name: /u01/oracle/11G/dbs/mvdiry/15puabjq_1_1
  List of Datafiles in backup set 37
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 1356093    03-FEB-15 /u01/oracle/oradata/db01/users01.dbf

根据标签找备份,空就是找所有的。

RMAN> list backupset tag '';


List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
35      Full    7.46M      DISK        00:00:00     03-FEB-15      
        BP Key: 35   Status: AVAILABLE  Compressed: NO  Tag: TAG20150203T011637
        Piece Name: /u01/oracle/11G/dbs/13puabbl_1_1
  List of Datafiles in backup set 35
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 1355964    03-FEB-15 /u01/oracle/oradata/db01/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
37      Full    7.46M      DISK        00:00:01     03-FEB-15      
        BP Key: 39   Status: AVAILABLE  Compressed: NO  Tag: TAG20150203T012058
        Piece Name: /u01/oracle/11G/dbs/mvdiry/15puabjq_1_1
  List of Datafiles in backup set 37
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 1356093    03-FEB-15 /u01/oracle/oradata/db01/users01.dbf

RMAN> backup tablespace users;

Starting backup at 03-FEB-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00004 name=/u01/oracle/oradata/db01/users01.dbf
channel ORA_DISK_1: starting piece 1 at 03-FEB-15
channel ORA_DISK_1: finished piece 1 at 03-FEB-15
piece handle=/u01/oracle/11G/dbs/16puaftp_1_1 tag=TAG20150203T023433 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 03-FEB-15

RMAN> list backupset of database;


List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
35      Full    7.46M      DISK        00:00:00     03-FEB-15      
        BP Key: 35   Status: AVAILABLE  Compressed: NO  Tag: TAG20150203T011637
        Piece Name: /u01/oracle/11G/dbs/13puabbl_1_1
  List of Datafiles in backup set 35
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 1355964    03-FEB-15 /u01/oracle/oradata/db01/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
37      Full    7.46M      DISK        00:00:01     03-FEB-15      
        BP Key: 39   Status: AVAILABLE  Compressed: NO  Tag: TAG20150203T012058
        Piece Name: /u01/oracle/11G/dbs/mvdiry/15puabjq_1_1
  List of Datafiles in backup set 37
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 1356093    03-FEB-15 /u01/oracle/oradata/db01/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
38      Full    7.46M      DISK        00:00:01     03-FEB-15      
        BP Key: 40   Status: AVAILABLE  Compressed: NO  Tag: TAG20150203T023433
        Piece Name: /u01/oracle/11G/dbs/16puaftp_1_1
  List of Datafiles in backup set 38
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 1357865    03-FEB-15 /u01/oracle/oradata/db01/users01.dbf

找指定标签的备份。

RMAN> list backupset tag 'TAG20150203T011637';


List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
35      Full    7.46M      DISK        00:00:00     03-FEB-15      
        BP Key: 35   Status: AVAILABLE  Compressed: NO  Tag: TAG20150203T011637
        Piece Name: /u01/oracle/11G/dbs/13puabbl_1_1
  List of Datafiles in backup set 35
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 1355964    03-FEB-15 /u01/oracle/oradata/db01/users01.dbf

RMAN> 

RMAN> report schema;

using target database control file instead of recovery catalog
Report of database schema

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    300      SYSTEM               ***     /u01/oracle/oradata/db01/system01.dbf
2    200      UNDOTBS1             ***     /u01/oracle/oradata/db01/undotbs01.dbf
3    120      SYSAUX               ***     /u01/oracle/oradata/db01/sysaux01.dbf
4    175      USERS                ***     /u01/oracle/oradata/db01/users01.dbf
5    10       DTFILETS             ***     /u01/oracle/oradata/db01/ts_move/ts_DTFILETS01.dbf
6    5        FRANKS               ***     /u01/oracle/oradata/db01/ts_test_me/frankts01.dbf
7    20       DEMOTS               ***     /u01/oracle/oradata/db01/ts_test_me/demots01.dbf
8    100      UNDOTS               ***     /u01/oracle/oradata/db01/ts_test_me/undots01.dbf
9    5        FRANKS               ***     /u01/oracle/oradata/db01/ts_test_me/frankts2.dbf
10   30       BIGTS                ***     /u01/oracle/oradata/db01/ts_test_me/bigts01.dbf
11   5        NEUSPACE             ***     /u01/oracle/oradata/db01/ts_test_me/new.dbf
12   10       NEUSPACE             ***     /u01/oracle/oradata/db01/ts_test_me/append.dbf
18   12       TEST_TBS             ***     /u01/test.dbf
20   64       TEST                 ***     /u01/oracle/11G/dbs/f:test.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 20          /u01/oracle/oradata/db01/temp01.dbf
2    10       TEMP1498             100         /u01/oracle/oradata/db01/temp1498.dbf

RMAN> 

RMAN> report need backup redundancy 3;

Report of files with less than 3 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------
1    0     /u01/oracle/oradata/db01/system01.dbf
2    0     /u01/oracle/oradata/db01/undotbs01.dbf
3    0     /u01/oracle/oradata/db01/sysaux01.dbf
5    0     /u01/oracle/oradata/db01/ts_move/ts_DTFILETS01.dbf
6    0     /u01/oracle/oradata/db01/ts_test_me/frankts01.dbf
7    0     /u01/oracle/oradata/db01/ts_test_me/demots01.dbf
8    0     /u01/oracle/oradata/db01/ts_test_me/undots01.dbf
9    0     /u01/oracle/oradata/db01/ts_test_me/frankts2.dbf
10   0     /u01/oracle/oradata/db01/ts_test_me/bigts01.dbf
11   0     /u01/oracle/oradata/db01/ts_test_me/new.dbf
12   0     /u01/oracle/oradata/db01/ts_test_me/append.dbf
18   0     /u01/test.dbf
20   0     /u01/oracle/11G/dbs/f:test.dbf

RMAN> report need backup redundancy 4;

Report of files with less than 4 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------
1    0     /u01/oracle/oradata/db01/system01.dbf
2    0     /u01/oracle/oradata/db01/undotbs01.dbf
3    0     /u01/oracle/oradata/db01/sysaux01.dbf
4    3     /u01/oracle/oradata/db01/users01.dbf
5    0     /u01/oracle/oradata/db01/ts_move/ts_DTFILETS01.dbf
6    0     /u01/oracle/oradata/db01/ts_test_me/frankts01.dbf
7    0     /u01/oracle/oradata/db01/ts_test_me/demots01.dbf
8    0     /u01/oracle/oradata/db01/ts_test_me/undots01.dbf
9    0     /u01/oracle/oradata/db01/ts_test_me/frankts2.dbf
10   0     /u01/oracle/oradata/db01/ts_test_me/bigts01.dbf
11   0     /u01/oracle/oradata/db01/ts_test_me/new.dbf
12   0     /u01/oracle/oradata/db01/ts_test_me/append.dbf
18   0     /u01/test.dbf
20   0     /u01/oracle/11G/dbs/f:test.dbf

RMAN> list backup of  tablespace users;


List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
35      Full    7.46M      DISK        00:00:00     03-FEB-15      
        BP Key: 35   Status: AVAILABLE  Compressed: NO  Tag: TAG20150203T011637
        Piece Name: /u01/oracle/11G/dbs/13puabbl_1_1
  List of Datafiles in backup set 35
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 1355964    03-FEB-15 /u01/oracle/oradata/db01/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
37      Full    7.46M      DISK        00:00:01     03-FEB-15      
        BP Key: 39   Status: AVAILABLE  Compressed: NO  Tag: TAG20150203T012058
        Piece Name: /u01/oracle/11G/dbs/mvdiry/15puabjq_1_1
  List of Datafiles in backup set 37
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 1356093    03-FEB-15 /u01/oracle/oradata/db01/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
38      Full    7.46M      DISK        00:00:01     03-FEB-15      
        BP Key: 40   Status: AVAILABLE  Compressed: NO  Tag: TAG20150203T023433
        Piece Name: /u01/oracle/11G/dbs/16puaftp_1_1
  List of Datafiles in backup set 38
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 1357865    03-FEB-15 /u01/oracle/oradata/db01/users01.dbf

RMAN> list backupset of  tablespace users;


List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
35      Full    7.46M      DISK        00:00:00     03-FEB-15      
        BP Key: 35   Status: AVAILABLE  Compressed: NO  Tag: TAG20150203T011637
        Piece Name: /u01/oracle/11G/dbs/13puabbl_1_1
  List of Datafiles in backup set 35
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 1355964    03-FEB-15 /u01/oracle/oradata/db01/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
37      Full    7.46M      DISK        00:00:01     03-FEB-15      
        BP Key: 39   Status: AVAILABLE  Compressed: NO  Tag: TAG20150203T012058
        Piece Name: /u01/oracle/11G/dbs/mvdiry/15puabjq_1_1
  List of Datafiles in backup set 37
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 1356093    03-FEB-15 /u01/oracle/oradata/db01/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
38      Full    7.46M      DISK        00:00:01     03-FEB-15      
        BP Key: 40   Status: AVAILABLE  Compressed: NO  Tag: TAG20150203T023433
        Piece Name: /u01/oracle/11G/dbs/16puaftp_1_1
  List of Datafiles in backup set 38
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 1357865    03-FEB-15 /u01/oracle/oradata/db01/users01.dbf

RMAN> list archivelog all;

specification does not match any archive log in the recovery catalog

RMAN>






  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

5icode.top

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值