Data Guard

[Thomas7]

I Have DG setup. My standby is running out of space and I need to add datafile's to my primary. What could be the consequences in this situation and solution for this issue. Thanks in advance for your advice.

[Thomas7]

I think Stopping the redo apply adding the a datafile and resuming the redo apply will do it. Correct me if i am wrong

[Rayyah]

In such cases the MRP0 process will stop on the standby site and redo apply operations will cease.Always have equal space on mount points on both primary and standby db's so as to avoid this kind of problems.

solution could be create a new db_file_name_convert path as the file in question has to be moved to different disks where space exists and recreate standby controlfile.

[Chintz]

The new datafile is created and added to the standby databases if you have set up the STANDBY_FILE_MANAGEMENT and DB_FILE_NAME_CONVERT initialization parameters.

Just to explain the process of adding a file to the primary database is :
Adding a datafile to your primary database generates redo data that, when applied at your standby database, automatically adds the datafile name to the standby control file. If the standby database locates the new file
with the new filename, the recovery process continues. If the standby database is unable to locate the new datafile, recovery terminates.

Hope this helps,
Chintz