刚刚做一个恢复测试

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而已，但是在这个例子中明显不好使，不知道是我方法不对还是找错方向了，求高手解答