Oracle 10g support Initiates manual archiving

It's not good to look at Doc.

sql> shutdown Immediate

The database has been closed.

The database has been unloaded.

The ORACLE routine has been closed.

Sql> Startup Mount

The ORACLE routine has started.

Total System Global area 104857600 bytes

Fixed Size 1247540 bytes

Variable Size 96470732 bytes

Database buffers 4194304 bytes

Redo buffers 2945024 bytes

Database loading complete.

--Enable manual archiving

sql> ALTER DATABASE Archivelog manual;

The database has changed.

Sql> select Log_mode from V$database;

Log_mode

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

MANUAL

sql> ALTER DATABASE open;

The database has changed.

Sql> Show Parameter log_archive_max_processes

NAME TYPE VALUE

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

Log_archive_max_processes Integer 4

--The archive process is up.

Sql> SELECT * from v$archive_processes where status= ' ACTIVE ';

PROCESS STATUS log_sequence STAT

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

0 ACTIVE 0 IDLE

1 ACTIVE 0 IDLE

2 ACTIVE 0 IDLE

3 ACTIVE 0 IDLE

4 ACTIVE 0 IDLE

--AutoArchive displays ' Enable '

sql> archive log list;

Database log Mode archive mode

AutoArchive enabled

Archive Endpoint Use_db_recovery_file_dest

The oldest online log sequence 111

Next Archive log sequence 112

Current log Sequence 112

sql> alter system switch logfile;

The system has changed.

sql> alter system switch logfile;

--Hang on here ...

--======================================

To open another session:

Sql> alter system archive log current;

The system has changed.

Sql>

Author: 51cto Blog Oracle Little Bastard

More Wonderful content: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/