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

From: Jerome Vitalis <vitalismanREMOVETHAT_at_gmail.com>
Date: Fri, 19 May 2006 10:32:31 +0200
Message-ID: <pan.2006.05.19.08.32.31.784000@gmail.com>

On Thu, 18 May 2006 10:49:21 -0700, andrei_ursu wrote:

> 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.

You don't have any trace files generated at the time the datafile should have been automatically created? Received on Fri May 19 2006 - 03:32:31 CDT