Pazartesi

How to Enable Oracle 9i archive logs


SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /sun2int3/app/oracle/product/9.2.0.1.0/dbs/arch
Oldest online log sequence 0
Current log sequence 1



shutdown immediate;

SQL> startup mount
ORACLE instance started.

Total System Global Area 320308312 bytes
Fixed Size 730200 bytes
Variable Size 285212672 bytes
Database Buffers 33554432 bytes
Redo Buffers 811008 bytes
Database mounted.


SQL> alter database ARCHIVELOG;

Database altered.

Hiç yorum yok:

Yorum Gönder