An expert on Standby ? ORA-01157 error after adding a new datafile

Hi,
I'm using 9.2.0.4.0
on Linux 2.4.21-15.ELhugemem #1 SMP i686 with physical standby (not DataGuard). Working OK for a while:
- status is VALID in V$ARCHIVE_DEST_STATUS on primary.

• MR(fg) in status WAIT_FOR_LOG in V$MANAGED_STANDBY on standby.

Needed to add an new datafile on primary. Did the following on primary:
alter system set STANDBY_FILE_MANAGEMENT = AUTO -- system altered
alter TABLESPACE ... add datafile size 1024M AUTOEXTEND ON NEXT 1024M MAXSIZE 30720M;
-- tablespace altered, file is there.
ALTER SYSTEM ARCHIVE LOG CURRENT;
-- after a minute, file shows up in V$DATAFILE on standby server

NOW THE PROBLEM:
- file is not in the UNIX fine system on standby server, AND

• got error on standby: ORA-01157: cannot identify/lock data file 23 - see DBWR trace file ORA-01110: data file 23: '<file name>' ... ORA-283 signalled during: ALTER DATABASE RECOVER MANAGED STANDBY AND
• process MR(fg) not running in V$MANAGED_STANDBY any longer

Any ideas ?
I'd very much appreciate any and all help you can give me. Thanks much
Andrei Received on Wed May 17 2006 - 23:17:08 CDT