<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>