RMAN进行备份恢复(二)
5 09:58:17.633
kccsga_update_ckpt: num_1 = 8, num_2 = 0, num_3 = 0, lbn_2 = 0, lbn_3 = 0
/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: 1
Oracle process number: 23
Unix process pid: 5086, image: oracleorclsid@localhost.localdomain
*** 2013-06-12 12:10:18.861
*** ACTION NAME:(0000022 STARTED16) 2013-06-12 12:10:18.826
*** MODULE NAME:(backup full datafile) 2013-06-12 12:10:18.826
*** SERVICE NAME:(orcl) 2013-06-12 12:10:18.826
*** SESSION ID:(148.13) 2013-06-12 12:10:18.826
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 86.98% used, and has 279703040 remaining bytes available.
*** 2013-06-12 12:10:18.862
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
*** 2013-06-12 12:11:15.771
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 99.18% used, and has 17559040 remaining bytes available.
*** 2013-06-12 12:11:15.771
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
*** 2013-06-12 12:11:27.166
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% used, and has 0 remaining bytes available.
*** 2013-06-12 12:11:27.166
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and incr