Detailed steps for Oracle to change from archive mode to non-archive Mode

Source: Internet
Author: User
To change the non-archive mode of the Oracle database, you need to restart the database and modify it in mount mode. Step 1 closes the database in shutdownimmediate mode and Step 2 starts the database.

To change the non-archive mode of the Oracle database, you need to restart the database and modify it in mount mode. Step 1 closes the database in shutdown immediate Mode and Step 2 starts the database.

Detailed steps for Oracle to change from archive mode to non-archive Mode

[Date:] Source: Linux Author: mengzhaoliang [Font:]

To change the non-archive mode of an Oracle database, restart the database and modify it in mount mode.

1. Shut down the database in shutdown immediate Mode

2. Start the instance to the mount status.

3. Change the non-running mode and open the database

Procedure:

1. log on to the database to view the archiving status of the database.

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 2923

Next log sequence to archive 2925

Current log sequence 2925

2. Shut down the database

SQL> shutdown immediate;

3. Start the database to the mount status.

SQL> startup mount;

4. Start the archive Mode

SQL> alter database noarchivelog; (non-archive mode: alter database noarchivelog)

If an error is reported:

SQL> alter database noarchivelog;

Alter database noarchivelog

*

ERROR at line 1:

ORA-38774: cannot disable media recovery-flashback database is enabled

Close flashback first

SQL> alter database flashback off;

Database altered.

Change to non-archive Mode

SQL> alter database noarchivelog;

Database altered.

5 open the database

SQL> alter database open;

  • 0
  • Sys, system, scott, hr users in Oracle

    Migrate Oracle 10g R2 data in AIX to Oracle 11g R2 in the HP Cluster

    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.