RMAN管理备份(五)

2014-11-24 16:15:56 · 作者: · 浏览: 10
t/10.2.0/oradata/orcl/system01.dbf
2 295 UNDOTBS1 *** /home/oracle/oracle/product/10.2.0/oradata/orcl/undotbs01.dbf
3 290 SYSAUX *** /home/oracle/oracle/product/10.2.0/oradata/orcl/sysaux01.dbf
4 1003 USERS *** /home/oracle/oracle/product/10.2.0/oradata/orcl/users01.dbf
5 20 TBS_ORCL_DATA *** /home/oracle/oracle/product/10.2.0/db_1/dbs/TBS_ORCL_DATA01.DBF
6 20 TBS_ORCL_IDX *** /home/oracle/oracle/product/10.2.0/db_1/dbs/TBS_ORCL_IDX01.DBF
7 490 TBS_LUBINSU_DATA *** /home/oracle/oracle/product/10.2.0/oradata/orcl/tbs_data.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20 TEMP 32767 /home/oracle/oracle/product/10.2.0/oradata/orcl/temp01.dbf
--现在来做一个完整的备份,并删除废弃的备份:
RMAN> run{
2> backup database;
3> delete noprompt obsolete;
4> backup archivelog all;
5> }
Starting backup at 12-JUN-13
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=/home/oracle/oracle/product/10.2.0/oradata/orcl/users01.dbf
input datafile fno=00001 name=/home/oracle/oracle/product/10.2.0/oradata/orcl/system01.dbf
input datafile fno=00007 name=/home/oracle/oracle/product/10.2.0/oradata/orcl/tbs_data.dbf
input datafile fno=00002 name=/home/oracle/oracle/product/10.2.0/oradata/orcl/undotbs01.dbf
input datafile fno=00003 name=/home/oracle/oracle/product/10.2.0/oradata/orcl/sysaux01.dbf
input datafile fno=00005 name=/home/oracle/oracle/product/10.2.0/db_1/dbs/TBS_ORCL_DATA01.DBF
input datafile fno=00006 name=/home/oracle/oracle/product/10.2.0/db_1/dbs/TBS_ORCL_IDX01.DBF
channel ORA_DISK_1: starting piece 1 at 12-JUN-13
channel ORA_DISK_1: finished piece 1 at 12-JUN-13
piece handle=/home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/backupset/2013_06_12/o1_mf_nnndf_TAG20130612T155439_8vjbb07f_.bkp tag=TAG20130612T155439 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:08:07
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 12-JUN-13
channel ORA_DISK_1: finished piece 1 at 12-JUN-13
piece handle=/home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/backupset/2013_06_12/o1_mf_ncsnf_TAG20130612T155439_8vjbs9gx_.bkp tag=TAG20130612T155439 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:05
Finished backup at 12-JUN-13
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 2 12-JUN-13
Backup Piece 2 12-JUN-13 /home/oracle/oracle/product/10