RMAN进行备份恢复(八)
archived log
archive log filename=/home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/archivelog/2013_06_02/o1_mf_1_177_8toyr3tp_.arc recid=87 stamp=817055875
validation succeeded for archived log
archive log filename=/home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/archivelog/2013_06_02/o1_mf_1_178_8tpohwjv_.arc recid=88 stamp=817079165
validation succeeded for archived log
archive log filename=/home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/archivelog/2013_06_03/o1_mf_1_179_8ts7wknt_.arc recid=89 stamp=817163538
validation succeeded for archived log
archive log filename=/home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/archivelog/2013_06_07/o1_mf_1_180_8v3mt2h6_.arc recid=90 stamp=817503427
validation succeeded for archived log
archive log filename=/home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/archivelog/2013_06_07/o1_mf_1_181_8v3rrjnq_.arc recid=91 stamp=817508501
validation succeeded for archived log
archive log filename=/home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/archivelog/2013_06_12/o1_mf_1_182_8vhwx38v_.arc recid=92 stamp=817905955
Crosschecked 59 objects
RMAN> delete expired archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=148 devtype=DISK
specification does not match any archive log in the recovery catalog
--看来没有找到匹配的可以删除的无效的归档日志
--扩大 db_recovery_file_dest_size 空间的大小
SQL> alter system set db_recovery_file_dest_size=8G scope=both;
System altered.
--现在重新备份下：
RMAN> backup database;
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_TAG20130612T125054_8vhzkgdt_.bkp tag=TAG20130612T125054 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:06:26
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/20