Pages

Thursday 19 November 2015

Archive Log Ora10g

Mengaktifkan Archive Log :

SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-01126: database must be mounted in this instance and not open in anyinstance
 
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database archivelog;
SQL> alter database open;
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u02/archive/archive01
Oldest online log sequence 2
Next log sequence to archive 4
Current log sequence 4
SQL> exit

Konfigurasi direktori Archive Log Ora10g :

[oracle@dbserv bin]$ sqlplus / as sysdba
SQL> host
[oracle@dbserv ~]$ mkdir /u02/archive
[oracle@dbserv ~]$ exit
 
SQL> alter system set log_archive_dest_1=’location=/u02/archive/archive01';
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Enabled
Archive destination /u02/archive/archive01
Oldest online log sequence 4
Next log sequence to archive 6
Current log sequence 6

1 comment:

Jenis Display Port

  1.     VGA (Video Graphic Adapter) Port paling tua sejak pasar meninggalkan generasi CGA dan EGA. Digunakan di era tahun 90-an dan tek...