[20171116]11GR2控制檔案自動備份.txt

20171116]11GR2控制檔案自動備份.txt

> @ &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