ITPub博客

首页 > Linux操作系统 > Linux操作系统 > recover datafile时候碰到ora-04030

recover datafile时候碰到ora-04030

原创 Linux操作系统 作者:myownstars 时间:2010-08-12 16:43:11 0 删除 编辑
刚刚做一个恢复测试

RMAN> sql 'alter database datafile 17 offline';

sql statement: alter database datafile 17 offline

RMAN> restore datafile 17;

Starting restore at 12-AUG-10
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00017 to D:\APPS\APPS_ADM\ORACLE\ORADATA\AP159DB\TEST.DBF
channel ORA_DISK_1: reading from backup piece D:\ORACLE_BACKUP\RMANBACKUP\0VLL5NU2726851522
channel ORA_DISK_1: restored backup piece 1
piece handle=D:\ORACLE_BACKUP\RMANBACKUP\0VLL5NU2726851522 tag=17
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
Finished restore at 12-AUG-10

RMAN> recover datafile 17;

Starting recover at 12-AUG-10
using channel ORA_DISK_1

starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 08/12/2010 15:30:47
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
datafile 17
ORA-00283: recovery session canceled due to errors
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga heap,redo overflow buffer)
执行recover步骤时候总是报错ora-04030,刚开始以为是pga太小造成的,

SQL> show parameter pga;

NAME                                 TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
pga_aggregate_target                 big integer
194M
将其增大到400m,但是依旧不能成功执行recover

SQL> alter system set pga_aggregate_target = 400M scope=both;

System altered.

google了ora-04030,给出的建议大多都是增大pga而已,但是在这个例子中明显不好使,不知道是我方法不对还是找错方向了,求高手解答

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15480802/viewspace-688353/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-03-18

  • 博文量
    375
  • 访问量
    3112943