Oracle建完库后必须先设好的三个参数

无论我们是用dbca建库，还是手工建。在完成了建库的任务后，有三个参数在以后的生产运用中非常重要，通常，我们是需要将其打开的。
第一个是log_checkpoints_to_alert。
SQL> show parameter checkpoint NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_checkpoint_interval              integer     0
log_checkpoint_timeout               integer     1800
log_checkpoints_to_alert             boolean     FALSE
SQL> alter system set log_checkpoints_to_alert=true; System altered.

第二个是archivelog mode
SQL> shutdown immediate
Database closed.
Database dismounted.
Oracle instance shut down.
SQL> startup mount
ORACLE instance started. Total System Global Area 243269632 bytes
Fixed Size                  1218748 bytes
Variable Size              79693636 bytes
Database Buffers          159383552 bytes
Redo Buffers                2973696 bytes
Database mounted.
SQL> alter database noarchivelog; Database altered. SQL> alter database open; Database altered. SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     16
Current log sequence           19
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> shutdown mount
SP2-0717: illegal SHUTDOWN option
SQL> startup mount
ORACLE instance started. Total System Global Area 243269632 bytes
Fixed Size                  1218748 bytes
Variable Size              79693636 bytes
Database Buffers          159383552 bytes
Redo Buffers                2973696 bytes
Database mounted.
SQL> alter database archivelog; Database altered. SQL> alter database open; Database altered. SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     16
Next log sequence to archive   19
Current log sequence           19 第三个是fast_start_mttr_target
这个参数的调整可能比较麻烦。具体请参见： http://www.linuxidc.com/Linux/2012-07/65103.htm
下面简单做一下操作说明：
SQL> show parameter fast_start_mttr_target NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
fast_start_mttr_target               integer     0
SQL> alter system set fast_start_mttr_target=24; System altered. SQL> show parameter fast_start_mttr_target NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
fast_start_mttr_target               integer     24 这里的24秒是个比较靠谱的做法。存储结构之重做日志文件DBA和老板签合同的参数：fast_start_mttr_target相关资讯 Oracle建库

Oracle通过软连接裸设备建库（03/11/2014 14:09:35）
Oracle 11g + ASM DBCA 建库问题解（10/04/2013 20:31:20）
Linux下Oracle 10g手工建库全过程（02/02/2013 07:38:32）

Oracle 11g R2 手动建库（create （11/16/2013 17:05:22）
Oracle 11g（11.2.0）手工建立数据（03/07/2013 09:54:08）
Oracle 9i数据库手工建库过程简记（01/26/2013 19:43:39）

本文评论查看全部评论（0）