✎ 编程开发网

RMAN进行备份恢复(四)

2014-11-24 15:08:47 · 作者: · 浏览: 6

标签: RMAN 进行备份恢复

ease 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:39.945

*** ACTION NAME:(0000039 STARTED16) 2013-06-12 12:11:39.945

--这里提示 db_recovery_file_dest_size 备份时空间不足了，并且给出了几个建议：

************************************************************************

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.

************************************************************************

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.

--删除不需要的文件

RMAN> delete backup;

using channel ORA_DISK_1

List of Backup Pieces

BP Key BS Key Pc# Cp# Status Device Type Piece Name

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

1 1 1 1 AVAILABLE DISK /home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/backupset/2013_06_12/o1_mf_ncsnf_TAG20130612T120900_8vhx7tnw_.bkp

Do you really want to delete the above objects (enter YES or NO) YES

deleted backup piece

backup piece handle=/home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/backupset/2013_06_12/o1_mf_ncsnf_TAG20130612T120900_8vhx7tnw_.bkp recid=1 stamp=817906298

Deleted 1 objects

--删除过期的无效的归档日志：

--先检查

RMAN> crosscheck archivelog all;

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=148 devtype=DISK