RMAN进行备份恢复
--RMAN备份是完全联机热备份
RMAN> connect target sys/lubinsu@orcl
connected to target database: ORCL (DBID=1326384392)
RMAN> backup database;
Starting backup at 12-JUN-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=148 devtype=DISK
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
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/12/2013 12:11:36
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 2147483648 limit
continuing other job steps, job failed will not be re-run
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_TAG20130612T120900_8vhx7tnw_.bkp tag=TAG20130612T120900 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:05
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/12/2013 12:11:36
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 2147483648 LIMIT
--这里提示空间不足了,我们来查看下详细的跟踪日志:
[lubinsu@localhost ~]$ cat /home/oracle/oracle/product/10.2.0/db_1/admin/orcl/udump/orclsid_ora_5086.trc
/home/oracle/oracle/product/10.2.0/db_1/admin/orcl/udump/orclsid_ora_5086.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db_1
System name: Linux
Node name: localhost.localdomain
Release: 2.6.18-8.el5
Version: #1 SMP Fri Jan 26 14:15:21 EST 2007
Machine: i686
Instance name: orclsid
Redo thread mounted by this instance: 0
Oracle process number: 15
Unix process pid: 5086, image: oracle@localhost.localdomain (TNS V1-V3)
*** SERVICE NAME:() 2013-05-25 09:58:17.633
*** SESSION ID:(159.1) 2013-05-2