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

Read this to point you in the right direction:

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96653/manage_ps.htm#1010429

Make specific note of the parameter:
STANDBY_FILE_MANAGEMENT

-- 

Andreas Sheriff
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer
----
"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding, if you don't eat your meat?"

DO NOT REPLY TO THIS EMAIL
Reply only to the group.

<andrei_ursu_at_yahoo.com> wrote in message
news:1147925828.179421.186710_at_g10g2000cwb.googlegroups.com...


> 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

>