Adding datafiles using ASM in a Data Guard configuration
Just a quick note to self when adding datafiles located on ASM when using Data Guard. If the initialization parameter STANDBY_FILE_MANAGEMENT is set to AUTO then any datafile added on the primary database is automatically propagated to the standby site. Before adding the datafile on the primary site you need to verify that adequate disk space is available in the disk groups on both primary and standby. If not done, then your managed recovery will cease to operate thus causing risks to your disaster recovery database. Consider the example below. Datafile gets added on the primary database. ALTER TABLESPACE "FTSBCAUDIT" ADD DATAFILE '+DG_DATA' SIZE 8G REUSE AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED Fri Oct 21 18:49:22 2011 Starting control autobackup Control autobackup written to DISK device handle '/archivelogs/ftsora01/ftpprd/c-117026708-20111021-13' Completed: ALTER TABLESPACE "FTSBCAUDIT" ADD DATAFILE '+DG_DATA' SIZE 8G REUSE ...