20171116]11GR2控制文件自动备份.txt
SYS@book> @ &r/ver1
PORT_STRING VERSION BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
--//当数据库发生变更时,如果在rman设置CONFIGURE CONTROLFILE AUTOBACKUP ON;,发生变化会做控制文件备份.
RMAN> show CONTROLFILE AUTOBACKUP;
RMAN configuration parameters for database with db_unique_name BOOK are:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
--//实际上在11G上不会马上发生,而是存在一定延迟.受参数_controlfile_autobackup_delay控制.
SYS@book> @ &r/hide _controlfile_autobackup_delay
NAME DESCRIPTION DEFAULT_VALUE SESSION_VALUE SYSTEM_VALUE
----------------------------- ------------------------------------------------------------------ ------------- ------------- ------------
_controlfile_autobackup_delay time delay (in seconds) for performing controlfile autobackups TRUE 300 300
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/267265/viewspace-2147386/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/267265/viewspace-2147386/