本帖最后由 tyuthaoban 于 2018-11-9 16:14 编辑 rondon9799 发表于 2018-11-9 15:19
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '+DATA/%F'; 这样不就自动备份到共享存 ...
请先搞清楚控制文件自动备份位置和控制文件快照位置的区别,哪个文档说控制文件自动备份要这么配了??
tyuthaoban 发表于 2018-11-9 16:10
请先搞清楚控制文件自动备份位置和控制文件快照位置的区别,哪个文档说控制文件自动备份要这么配了??
CONFIGURE CONTROLFILE AUTOBACKUP 与 CONFIGURE SNAPSHOT CONTROLFILE 是两个不同的配置选项吧?你看清楚楼主想要的是什么
如果我想讲控制文件自动备份位置改到ASM上,为何不可以?
You can change the default format by using the following command, where deviceSpecifier is any valid device type, and 'string' must contain the substitution variable %F (and no other substitution variables) and is a valid handle for the specified device:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT
FOR DEVICE TYPE deviceSpecifier TO 'string';
For example, you can run the following command to specify a nondefault file name for the control file autobackup. In the file name, ? stands for ORACLE_HOME.
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT
FOR DEVICE TYPE DISK TO '?/oradata/cf_%F';
The following example configures the autobackup to write to an Automatic Storage Management disk group:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT
FOR DEVICE TYPE DISK TO '+dgroup1/%F';