常用rman命令
来源:互联网 发布:手机淘宝怎么提交改价 编辑:程序博客网 时间:2024/04/19 15:56
<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 commandsRMAN-01009: syntax error: found "device": expecting one of: "backupset"RMAN-01007: at line 1 column 10 file: standard inputRMAN> validate backupset 37;using channel ORA_DISK_1channel ORA_DISK_1: starting validation of datafile backupsetchannel ORA_DISK_1: reading from backup piece /u01/oracle/11G/dbs/mvdiry/15puabjq_1_1channel ORA_DISK_1: restored backup piece 1piece handle=/u01/oracle/11G/dbs/mvdiry/15puabjq_1_1 tag=TAG20150203T012058channel ORA_DISK_1: validation complete, elapsed time: 00:00:00RMAN> 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.dbfBS 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.dbfBS 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.dbfRMAN> backup tablespace users;Starting backup at 03-FEB-15using channel ORA_DISK_1channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=00004 name=/u01/oracle/oradata/db01/users01.dbfchannel ORA_DISK_1: starting piece 1 at 03-FEB-15channel ORA_DISK_1: finished piece 1 at 03-FEB-15piece handle=/u01/oracle/11G/dbs/16puaftp_1_1 tag=TAG20150203T023433 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01Finished backup at 03-FEB-15RMAN> 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.dbfBS 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.dbfBS 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.dbfRMAN>
RMAN> report schema;using target database control file instead of recovery catalogReport of database schemaList of Permanent Datafiles===========================File Size(MB) Tablespace RB segs Datafile Name---- -------- -------------------- ------- ------------------------1 300 SYSTEM *** /u01/oracle/oradata/db01/system01.dbf2 200 UNDOTBS1 *** /u01/oracle/oradata/db01/undotbs01.dbf3 120 SYSAUX *** /u01/oracle/oradata/db01/sysaux01.dbf4 175 USERS *** /u01/oracle/oradata/db01/users01.dbf5 10 DTFILETS *** /u01/oracle/oradata/db01/ts_move/ts_DTFILETS01.dbf6 5 FRANKS *** /u01/oracle/oradata/db01/ts_test_me/frankts01.dbf7 20 DEMOTS *** /u01/oracle/oradata/db01/ts_test_me/demots01.dbf8 100 UNDOTS *** /u01/oracle/oradata/db01/ts_test_me/undots01.dbf9 5 FRANKS *** /u01/oracle/oradata/db01/ts_test_me/frankts2.dbf10 30 BIGTS *** /u01/oracle/oradata/db01/ts_test_me/bigts01.dbf11 5 NEUSPACE *** /u01/oracle/oradata/db01/ts_test_me/new.dbf12 10 NEUSPACE *** /u01/oracle/oradata/db01/ts_test_me/append.dbf18 12 TEST_TBS *** /u01/test.dbf20 64 TEST *** /u01/oracle/11G/dbs/f:test.dbfList of Temporary Files=======================File Size(MB) Tablespace Maxsize(MB) Tempfile Name---- -------- -------------------- ----------- --------------------1 20 TEMP 20 /u01/oracle/oradata/db01/temp01.dbf2 10 TEMP1498 100 /u01/oracle/oradata/db01/temp1498.dbfRMAN>
RMAN> report need backup redundancy 3;Report of files with less than 3 redundant backupsFile #bkps Name---- ----- -----------------------------------------------------1 0 /u01/oracle/oradata/db01/system01.dbf2 0 /u01/oracle/oradata/db01/undotbs01.dbf3 0 /u01/oracle/oradata/db01/sysaux01.dbf5 0 /u01/oracle/oradata/db01/ts_move/ts_DTFILETS01.dbf6 0 /u01/oracle/oradata/db01/ts_test_me/frankts01.dbf7 0 /u01/oracle/oradata/db01/ts_test_me/demots01.dbf8 0 /u01/oracle/oradata/db01/ts_test_me/undots01.dbf9 0 /u01/oracle/oradata/db01/ts_test_me/frankts2.dbf10 0 /u01/oracle/oradata/db01/ts_test_me/bigts01.dbf11 0 /u01/oracle/oradata/db01/ts_test_me/new.dbf12 0 /u01/oracle/oradata/db01/ts_test_me/append.dbf18 0 /u01/test.dbf20 0 /u01/oracle/11G/dbs/f:test.dbfRMAN> report need backup redundancy 4;Report of files with less than 4 redundant backupsFile #bkps Name---- ----- -----------------------------------------------------1 0 /u01/oracle/oradata/db01/system01.dbf2 0 /u01/oracle/oradata/db01/undotbs01.dbf3 0 /u01/oracle/oradata/db01/sysaux01.dbf4 3 /u01/oracle/oradata/db01/users01.dbf5 0 /u01/oracle/oradata/db01/ts_move/ts_DTFILETS01.dbf6 0 /u01/oracle/oradata/db01/ts_test_me/frankts01.dbf7 0 /u01/oracle/oradata/db01/ts_test_me/demots01.dbf8 0 /u01/oracle/oradata/db01/ts_test_me/undots01.dbf9 0 /u01/oracle/oradata/db01/ts_test_me/frankts2.dbf10 0 /u01/oracle/oradata/db01/ts_test_me/bigts01.dbf11 0 /u01/oracle/oradata/db01/ts_test_me/new.dbf12 0 /u01/oracle/oradata/db01/ts_test_me/append.dbf18 0 /u01/test.dbf20 0 /u01/oracle/11G/dbs/f:test.dbfRMAN> 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.dbfBS 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.dbfBS 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.dbfRMAN> 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.dbfBS 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.dbfBS 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.dbfRMAN> list archivelog all;specification does not match any archive log in the recovery catalogRMAN>
0 0
- RMAN常用的命令
- 常用rman命令
- RMAN中常用backup命令
- RMAN中常用configure命令
- RMAN中常用的命令
- RMAN中常用backup命令
- RMAN常用配置命令解释
- RMAN中常用backup命令
- 常用的一些rman备份恢复命令
- RMAN常用的命令和操作
- 【RMAN】数据库备份之常用备份命令
- 常用的一些rman备份恢复命令
- rman 命令
- rman命令
- rman命令
- rman命令
- rman命令
- rman命令
- Android 从小白到大拿之路——数字时钟和虚拟时钟的实现
- Delphi中如何读取出MP3文件的信息
- poj 1002 487-3279 AC代码
- 二进制包安装mysql
- UVa102 Ecological Bin Packing(翻译+题解)
- 常用rman命令
- 20150203-ServletResponse和ServletRequest
- [每天一个知识点]23-软件工程-有什么必要要提高生产力
- Linux内核的Nand驱动流程分析
- BP神经网络算法学习
- oracle计算时间差
- 大二寒假读书笔记150203
- poj3125 Printer Queue
- 机器学习----逻辑回归模型及求解过程[基础篇]