Re: adding datafile to prod and standby issues

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 17 Mar 2004 06:36:58 +0100
Message-ID: <tqof50pglvdgvkgf5hnbr9p97b5u04ne8d@4ax.com>

On 16 Mar 2004 20:56:30 -0800, yls177_at_hotmail.com (yls177) wrote:

>hi, wanted to confirm my analysis
>
>1) add datafile in prod
>standby cant add have to wait.. cos
>ORA-01156: recovery in progress may need access to files
>
>am i right?

Adding datafiles to a production/standby situation is described in the standby manual. IIRC you need to get the standby database out of managed recovery, create an empty datafile, and apply any logs created at the production since you stopped manage recovery. Please review the standby documentation instead of experimenting on-the-fly. 228 datafiles for a database looks like sheer madness to me.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Mar 16 2004 - 23:36:58 CST