Příklad, jak nastavit dvě lokace pro ukládání archívních logů. Databáze bude funkční i v případě, že jedna lokace je nedostupná.

Nastavení

SQL> alter system set log_archive_dest_1 = 'LOCATION=USE_DB_RECOVERY_FILE_DEST' scope=both;
System altered.
SQL> alter system set log_archive_dest_2 = 'LOCATION=/mnt/backup/obsp/arch' scope=both;
System altered.
SQL> alter system set log_archive_dest_state_1 = enable;
System altered.
SQL> alter system set log_archive_dest_state_2 = enable;
System altered.
SQL> alter system set log_archive_min_succeed_dest = 1;
System altered.
SQL>
SQL> show parameter arch
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1 string LOCATION=USE_DB_RECOVERY_FILE_DEST
log_archive_dest_2 string LOCATION=/mnt/backup/racdb/arch
SQL> alter system set LOG_ARCHIVE_FORMAT = 'log%t_%s_%r.arc' scope=spfile;
System altered.

Kontrola

SQL> alter system switch logfile;
System altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 75
Next log sequence to archive 76
Current log sequence 76
ASMCMD> pwd
+reco/racdb/archivelog/2014_05_10
ASMCMD> ls -lt
Type Redund Striped Time Sys Name
ARCHIVELOG MIRROR COARSE MAY 10 15:00:00 Y thread_1_seq_75.492.847206401
[root@oda1 arch]# pwd
/mnt/backup/racdb/arch
[root@oda1 arch]# ls -ltr
total 1716
-rw-r----- 1 oracle asmadmin 1747968 May 10 2014 log1_75_847014723.arc


Komentáře