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博客

[20171116]11GR2控制文件自动备份.txt

最新文章