How Oracle database is set to archive mode

Source: Internet
Author: User

Oracle Archive mode is very important!
It is dangerous for some databases to be non-archived after they have just been installed! For the sake of security, be sure to remember: for Oracle database, must be set to the archive mode, especially the production library, only in order to achieve the effective full recovery of the database! Here's how to set the Oracle database to archive mode:

1) View the current archive mode of the database
In the SYS user log in to the database, enter select Log_mode from V$database as shown in:

Next, look at the automatic archive status and archive process as shown in: ( only if turn to enable is the Automatic archive mode )

Then continue to view:

Obviously, there is no automatic archive, no archiving process, and not archiving mode. To turn on archive mode, set the following:

2) Close the database and boot to mount state

Note: The above error is not in the middle of the tube, no effect. Because I have modified a log_archive_start parameter in the operation, in fact, this parameter only oracle10g before the version needs to be modified, here mistakenly operation of this parameter, but does not affect.

3) Modify the database to archive mode

At this point, the Oracle database has been set to archive mode!

How Oracle database is set to archive mode

Related Article

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.