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

Thanks much for your reply. I did turn STANDBY_FILE_MANAGEMENT to AUTO on primary.
Yet the file was not copied over, and got error ORA-01157. I copied the file manually to the standby. Ran ALTER SYSTEM CHECK DATAFILES.
I then turned STANDBY_FILE_MANAGEMENT to AUTO on secondary.

Yet the file is still in RECOVER status in V$DATAFILE, and the MR process in V$MANAGED_STANDBY still does not show up.

Thanks again
Andrei

Andreas Sheriff wrote:
> 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
> >
Received on Thu May 18 2006 - 12:49:21 CDT