on 06-11-2009 10:05 AM
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 oracle 10g and 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.
Please provide us any SAP note reference number suggesting the parameter to set to -"AUTO".
Many thanks in advance,
Nike S
Hi Nike,
STANDBY_FILE_MANAGEMENT enables or disables automatic standby file management. When automatic standby file management is enabled, operating system file additions and deletions on the primary database are replicated on the standby database.
Please note that we need to add this parameter in the physical standby database init<sid>.ora file. Set the STANDBY_FILE_MANAGEMENT = AUTO.
Last week I have successfully implemented Data Guard in Oracle 10g with the above parameter, everything is working perfect.
Regards,
Balakrishnan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
It should be AUTO.Check on Primary server
SQL> Show parameter standby_file_management;
If it is not then set
SQL> alter system set standby_file_management='AUTO';
Thnx
SurendraJain
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Check the premission of the folder where the datafile will be saved.
Thanks
Presu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.