How to change the Oracle 11g Archive mode on Windows 7

Source: Internet
Author: User
Tags oracle database

Change the Oracle 11g archive mode on the Win7, describing the errors that may be encountered, as well as the original purpose of writing this blog in order for other channels to avoid the same error, or how to solve the same error guidance, because the command is already clear, so it is not explained in detail.

Sql> Conn Sys/oracle@osid as Sysdba

is connected.

Sql> select instance_name from V$instance;

Instance_name

--------------------------------

Osid

Sql> Archive Log List

Database log mode non-archive mode

AutoArchive disabled

Archive Endpoint Use_db_recovery_file_dest

The oldest online log sequence 18

Current log Sequence 20

Sql> show parameter cluster;

NAME TYPE

------------------------------------ ----------------------

VALUE

------------------------------

Cluster_database Boolean

FALSE

Cluster_database_instances integer

1

Cluster_interconnects string

sql> shutdown Immediate

The database has been closed.

The database has been unloaded.

The ORACLE routine has been closed.

Sql> Startup Mount

Ora-12514:tns: The listener is currently unable to recognize the service requested in the connection descriptor

Sql> Startup Osid Mount

sp2-0714: Invalid STARTUP option combination

Sql> Startup

ORA-24324: Service Handle not initialized

ORA-01041: Internal error, Hostdef extension does not exist

sql> Startup Mount Osid

ORA-24324: Service Handle not initialized

ORA-01041: Internal error, Hostdef extension does not exist

Sql> Startup Unmount

sp2-0714: Invalid STARTUP option combination

Sql> Startup Mount

ORA-24324: Service Handle not initialized

ORA-01041: Internal error, Hostdef extension does not exist

Sql> Startup Mount

ORA-24324: Service Handle not initialized

ORA-01041: Internal error, Hostdef extension does not exist

Sql> disconn

From Oracle Database 11g Enterprise Edition release 11.2.0.1.0-64bit Production

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

With the partitioning, OLAP, Data Mining and real application testing options Disconnect

Sql> Conn/as SYSDBA

You are connected to an idle routine.

Sql> Startup Mount

The ORACLE routine has started.

Total System Global area 1068937216 bytes

Fixed Size 2182592 bytes

Variable Size 767558208 bytes

Database buffers 293601280 bytes

Redo buffers 5595136 bytes

Database loading complete.

sql> ALTER DATABASE Archivelog;

The database has changed.

sql> ALTER DATABASE open;

The database has changed.

Sql> Show parameter log_archive_max_processes;

NAME TYPE

------------------------------------ ----------------------

VALUE

------------------------------

Log_archive_max_processes integer

4

Sql> Show Parameter Log_archive_format

NAME TYPE

------------------------------------ ----------------------

VALUE

------------------------------

Log_archive_format string

Arc%s_%r.%t

Sql> Archive Log List

Database log Mode archive mode

AutoArchive enabled

Archive Endpoint Use_db_recovery_file_dest

The oldest online log sequence 18

Next Archive log sequence 20

Current log Sequence 20

Sql>

This article comes from "the power from absolute sincerity love!" "Blog, please be sure to keep this source http://stevex.blog.51cto.com/4300375/793328

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.