Solved: standby_file_management

Former Member · ‎04-19-2009

Hello All,

I have added a datafile in production system and monitored a backup which was succesful. But the backup didnot get succeded on Disaster Recovery (Stand by) System. It ended up in an error. We have to add the datafile manually.

We have upgraded our oracle from 9i to 10g and we have sap 4.6c.

When i checked the profile standby_file_management it is manual. Should it be set to " Auto".

Please give more inputs on this. Is it specific to oracle version because previously as per my knowledge we didn't get this error when we were in oracle 9i.

Many thanks in advance,

Nike S

stefan_koehler · ‎04-19-2009

Hello Nike,

>it specific to oracle version because previously as per my knowledge we didn't get this error when we were in oracle 9i.

The default value of both oracle versions is "MANUAL", but maybe you have forgotten to set this "non SAP standard" parameter (sapnote #830576) after the upgrade again.

Oracle 9i: http://download.oracle.com/docs/cd/B10501_01/server.920/a96536/ch1203.htm#REFRN10212

Oraclei 10g: http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams209.htm#CHDIBFDJ

> Please give more inputs on this.

More information about this can be found in the parameter or in the Data Guard Documentation:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams209.htm#CHDIBFDJ

http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/manage_ps.htm#i1010448

Regards

Stefan