RMAN> report schema;
using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name HUATENG
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 680 SYSTEM *** /u01/app/oracle/oradata/huateng/system01.dbf
2 480 SYSAUX *** /u01/app/oracle/oradata/huateng/sysaux01.dbf
3 85 UNDOTBS1 *** /u01/app/oracle/oradata/huateng/undotbs01.dbf
4 5 USERS *** /u01/app/oracle/oradata/huateng/users01.dbf
5 100 EXAMPLE *** /u01/app/oracle/oradata/huateng/example01.dbf
6 57 HTYANSP *** /u01/app/oracle/oradata/huateng/htyansp01.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 29 TEMP 32767 /u01/app/oracle/oradata/huateng/temp01.dbf
RMAN> backup database filesperset 3 format '/dbbackup/%U.bak';
Starting backup at 2012-08-09 15:31:44
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=17 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/huateng/system01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/huateng/users01.dbf
input datafile file number=00006 name=/u01/app/oracle/oradata/huateng/htyansp01.dbf
channel ORA_DISK_1: starting piece 1 at 2012-08-09 15:31:45
channel ORA_DISK_1: finished piece 1 at 2012-08-09 15:32:30
piece handle=/dbbackup/05ni7iv1_1_1.bak tag=TAG20120809T153145 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=/u01/app/oracle/oradata/huateng/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/huateng/example01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/huateng/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 2012-08-09 15:32:31
channel ORA_DISK_1: finished piece 1 at 2012-08-09 15:33:06
piece handle=/dbbackup/06ni7j0f_1_1.bak tag=TAG20120809T153145 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 2012-08-09 15:33:09
channel ORA_DISK_1: finished piece 1 at 2012-08-09 15:33:12
piece handle=/dbbackup/07ni7j1i_1_1.bak tag=TAG20120809T153145 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 2012-08-09 15:33:13
RMAN> list backupset;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
3 Full 591.58M DISK 00:00:37 2012-08-09 15:32:22
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20120809T153145
Piece Name: /dbbackup/05ni7iv1_1_1.bak
List of Datafiles in backup set 3
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 Full 2078954 2012-08-07 23:51:26 /u01/app/oracle/oradata/huateng/system01.dbf
4 Full 2078954 2012-08-07 23:51:26 /u01/app/oracle/oradata/huateng/users01.dbf
6 Full 2078954 2012-08-07 23:51:26 /u01/app/oracle/oradata/huateng/htyansp01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
4 Full 435.73M DISK 00:00:32 2012-08-09 15:33:03
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20120809T153145
Piece Name: /dbbackup/06ni7j0f_1_1.bak
List of Datafiles in backup set 4
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
2 Full 2078954 2012-08-07 23:51:26 /u01/app/oracle/oradata/huateng/sysaux01.dbf
3 Full 2078954 2012-08-07 23:51:26 /u01/app/oracle/oradata/huateng/undotbs01.dbf
5 Full 2078954 2012-08-07 23:51:26 /u01/app/oracle/oradata/huateng/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
5 Full 9.36M DISK 00:00:05 2012-08-09 15:33:11
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20120809T153145
Piece Name: /dbbackup/07ni7j1i_1_1.bak
SPFILE Included: Modification time: 2012-08-09 15:30:17
SPFILE db_unique_name: HUATENG
Control File Included: Ckp SCN: 2078954 Ckp time: 2012-08-07 23:51:26
RMAN> list backupset of controlfile;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
5 Full 9.36M DISK 00:00:05 2012-08-09 15:33:11
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20120809T153145
Piece Name: /dbbackup/07ni7j1i_1_1.bak
Control File Included: Ckp SCN: 2078954 Ckp time: 2012-08-07 23:51:26
RMAN>