Tuesday, August 3, 2010

Dimanakah Letak Archive Log?

Caranya cukup mudah..
Karena environment saya di Linux RHEL, so step yang ada disini dilakukan di linux:

1. Masuk ke sqlplus

[prodmgr@hqhcmdb1 ~]$ sqlplus / as sysdba

2. Jalankan perintah berikut
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/db/oracle/data/tech_st/10.2.0/dbs/arch
Oldest online log sequence 720
Next log sequence to archive 721
Current log sequence 721

3. Berdasarkan informasi diatas, diketahui bahwa lokasi archive log ada di:
/u01/db/oracle/data/tech_st/10.2.0/dbs/arch


No comments:

Post a Comment