Three parameters must be set after the Oracle database is created

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.