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
Helpfull
ReplyDelete