oracle备份文件命令,oracle备份常用命令

RMAN> backup tablespace users format '/backup/rmanbackup/userscp';

Starting backup at 21-APR-12

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/oradata/dbtest/users01.dbf

channel ORA_DISK_1: starting piece 1 at 21-APR-12

channel ORA_DISK_1: finished piece 1 at 21-APR-12

piece handle=/backup/rmanbackup/userscp tag=TAG20120421T155115 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 21-APR-12

RMAN> list backup of tablespace users;

List of Backup Sets

===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

24      Full    2.02M      DISK        00:00:00     21-APR-12

BP Key: 28   Status: AVAILABLE  Compressed: NO  Tag: TAG20120421T155115

Piece Name: /backup/rmanbackup/userscp

List of Datafiles in backup set 24

File LV Type Ckp SCN    Ckp Time  Name

---- -- ---- ---------- --------- ----

4       Full 1388204    21-APR-12 /u01/oradata/dbtest/users01.dbf

RMAN> change backup of tablespace users unavailable;

changed backup piece unavailable

backup piece handle=/backup/rmanbackup/userscp recid=28 stamp=781199475

Changed 1 objects to UNAVAILABLE status

RMAN> list backup of tablespace users;

List of Backup Sets

===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

24      Full    2.02M      DISK        00:00:00     21-APR-12

BP Key: 28   Status: UNAVAILABLE Compressed: NO  Tag: TAG20120421T155115

Piece Name: /backup/rmanbackup/userscp

List of Datafiles in backup set 24

File LV Type Ckp SCN    Ckp Time  Name

---- -- ---- ---------- --------- ----

4       Full 1388204    21-APR-12 /u01/oradata/dbtest/users01.dbf

RMAN>