Tuesday, January 8, 2008

STANDBY_FILE_MANAGEMENT MANUAL, ORA-01110

If STANDBY_FILE_MANAGEMENT system parameter is MANUAL and a datafile is added to primary database, the same datafile should be added manually to the standby database after ORA-01110 error. However, by setting STANDBY_FILE_MANAGEMENT=AUTO, you can allow standby database to create its own datafile automatically whenever a datafile is added to the primary.

SQL> alter system set STANDBY_FILE_MANAGEMENT=MANUAL;
SQL> alter database create datafile '...DBF' as '...DBF' size ...M;
SQL> alter system set STANDBY_FILE_MANAGEMENT=AUTO;

SQL> alter system set STANDBY_FILE_MANAGEMENT=AUTO scope=spfile; or change/add initora parameter.