Whether we use dbca for database creation or manual creation. After the database creation task is completed, three parameters are very important for future production and use. Generally, we need to open them.
The first one is 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.
The second is 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
The third is fast_start_mttr_target.
This parameter may be difficult to adjust. For details, see:
The following is a brief description of the operation:
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
Here, 24 seconds is a reliable practice.