1.管理员身份连接数据库

C:\Users\Administrator>sqlplussys/sys@prjdbassysdba

sql*Plus:Release11.2.0.1.0ProductiononTueJun1723:50:552014Copyright(c)1982,2010,Oracle.Allrightsreserved.


Connectedto:
OracleDatabase11gEnterpriseEditionRelease11.2.0.1.0-64bitProductionWiththePartitioning,OLAP,DataMiningandRealApplicationTestingoptions

2.查看当前归档模式，是归档还是非归档

sql>archiveloglist;DatabaselogmodeNoArchiveMode
AutomaticarchivalDisabled
ArchivedestinationUSE_DB_RECOVERY_FILE_DEST
Oldestonlinelogsequence228Currentlogsequence230

3.关闭数据库

sql>shutdownimmediate;Databaseclosed.Databasedismounted.
ORACLEinstanceshutdown.

4.启动数据库到mount状态

sql>startupmount;
ORACLEinstancestarted.

TotalSystemGlobalArea3423965184bytes
FixedSize2180544bytes
VariableSize2013268544bytesDatabaseBuffers1392508928bytes
RedoBuffers16007168bytesDatabasemounted.

5.启动归档模式

sql>alterdatabasearchivelog;Databasealtered.

sql>archiveloglist;DatabaselogmodeArchiveMode
AutomaticarchivalEnabled
ArchivedestinationUSE_DB_RECOVERY_FILE_DEST
Oldestonlinelogsequence228Nextlogsequencetoarchive230Currentlogsequence230

6.启动数据库

sql>alterdatabaSEOpen;Databasealtered.

7.关闭归档模式

sql>shutdownimmediate;Databaseclosed.Databasedismounted.
ORACLEinstanceshutdown.
sql>startupmount;
ORACLEinstancestarted.

TotalSystemGlobalArea3423965184bytes
FixedSize2180544bytes
VariableSize2013268544bytesDatabaseBuffers1392508928bytes
RedoBuffers16007168bytesDatabasemounted.
sql>alterdatabasenoarchivelog;Databasealtered.

sql>archiveloglist;DatabaselogmodeNoArchiveMode
AutomaticarchivalDisabled
ArchivedestinationUSE_DB_RECOVERY_FILE_DEST
Oldestonlinelogsequence228Currentlogsequence230sql>