RMAN test recovery

catalog start with '......' noprompt;

RMAN> recover datafile 3 test;

Starting recover at 22-JUN-2011 10:50:56
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=158 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=132 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=131 devtype=DISK

starting media recovery
RMAN-11006: WARNING: test recovery results:
ORA-10574: Test recovery did not corrupt any data block
ORA-10573: Test recovery tested redo from change 1153602 to 1153605
ORA-10572: Test recovery canceled due to errors
ORA-10585: Test recovery can not apply redo that may modify control file

media recovery complete, elapsed time: 00:00:01

Finished recover at 22-JUN-2011 10:51:04

RMAN> recover datafile 3;

Starting recover at 22-JUN-2011 10:51:46
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3

starting media recovery
media recovery complete, elapsed time: 00:00:02

Finished recover at 22-JUN-2011 10:51:49

RMAN> sql 'alter database datafile 3 online';

sql statement: alter database datafile 3 online

RMAN> exit


Recovery Manager complete.

F:\export>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jun 22 10:52:15 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select * from v$recover_file;

no rows selected

Alert Log Messages
==================
Wed Jun 22 10:51:03 2011
alter database recover if needed
 datafile 3 test

Test Media Recovery Start
 ALLOW CORRUPTION option must use serial recovery
Wed Jun 22 10:51:03 2011
Recovery of Online Redo Log: Thread 1 Group 3 Seq 321 Reading mem 0
  Mem# 0 errs 0: F:\ORACLE\ORADATA\NEW1\REDO3.LOG
Test recovery cannot apply redo (17.3) that may modify controlfile
Wed Jun 22 10:51:04 2011
Test recovery canceled due to errors
Test recovery tested redo from change 1153602 to 1153605
Test recovery found no problems
ORA-10574 signalled during: alter database recover if needed
 datafile 3 test
...
Wed Jun 22 10:51:47 2011
alter database recover datafile list clear
Wed Jun 22 10:51:47 2011
Completed: alter database recover datafile list clear
Wed Jun 22 10:51:47 2011
alter database recover if needed
 datafile 3

Media Recovery Start