1.338 STANDBY_FILE_MANAGEMENT
STANDBY_FILE_MANAGEMENT
enables or disables automatic standby file management.
Property | Description |
---|---|
Parameter type |
String |
Syntax |
|
Default value |
|
Modifiable |
|
Modifiable in a PDB |
No |
Basic |
No |
When automatic standby file management is enabled, operating system file additions and deletions on the primary database are replicated on the standby database. STANDBY_FILE_MANAGEMENT
is only applicable to physical standby databases.
Values
-
MANUAL
Disables automatic standby file management
-
AUTO
Enables automatic standby file management
Setting STANDBY_FILE_MANAGEMENT
to AUTO
causes Oracle to automatically create files on the standby database and, in some cases, overwrite existing files. Care must be taken when setting STANDBY_FILE_MANAGEMENT
and DB_FILE_NAME_CONVERT
so that existing standby files will not be accidentally overwritten.
If the standby database is on the same system as the primary database, then ensure that the primary and standby systems do not point to the same files.
See Also:
Oracle Data Guard Concepts and Administration for more information about setting this parameter