Whoever Resembles a People is One of Them. He is not one of us who resembles other than us,
nor who resembles the Jews nor the Christians.(jami-at-tirmidhi-vol-5-ahadith-2695)
O you who believe (who wish to reach ALLAH C.C. before death)! Do not take my and
your enemies for friends!
And although they have denied what has come to you
from the Truth, you still love them (treating them as your friends).
If you go forth to struggle hard in My Way, seeking My Pleasure, (then why) you manifest
love to them and share with them your secrets.
And I know what you conceal and what you manifest. And whoever of you does that, then he
indeed has gone astray from the right Way. 60/Al-Mumtahanah-1
They are driving out the Messenger and yourselves from your land because you
believe in ALLAH C.C., your Lord.
Recite (read and explain to others) that which has been revealed to you of the Book
and keep up the Prayer.
Surely the Prayer keeps away from Al-Fahsh (to do what ALLAH C.C. prohibits) and Al-Munkar
(to deny what ALLAH C.C. commands).
Whoever obeys me, obeys ALLAH C.C., and whoever disobeys me, disobeys ALLAH C.C.
Whoever obeys the ruler, obeys me, and whoever disobeys the ruler, disobeys me. " (Sahih)

Archive Log Moda Alma

1. Klasör oluşturulur.

MS

{code class=”brush: xml;”}
c:\> md D:\oracle\arc1
{/code}

Unix,

{code class=”brush: xml;”}
$ mkdir /oracle/archive1
{/code}

{code class=”brush: xml;”}
#chown –R oracle:orainstall /oracle/archive1
{/code}

{code class=”brush: xml;”}
SQL> connect / as sysdba
{/code}

Değişken Tanımları

%d unique database tanımlayıcısı

%t thread no

%r incarnation no. incomplete recovery lerde öenmli

%s The log switch sequence no.

{code class=”brush: xml;”}
SQL> alter system set log_archive_dest=’/oracle/archive1′ SCOPE=spfile;

SQL> alter system set log_archive_dest = ‘d:\oracle\arc1′ scope=spfile;

SQL> alter system set log_archive_format=’arch_%d_%t_%r_%s.log’ scope=spfile;
{/code}

4. database kapatılır.

{code class=”brush: xml;”}
SQL> shutdown immediate;
{/code}

5. mount mode da açılır.

{code class=”brush: xml;”}
SQL> startup mount;
{/code}

6. database archivelog mode a alınır.

{code class=”brush: xml;”}
SQL> alter database archivelog;
{/code}

7. database açılır.

{code class=”brush: xml;”}
SQL> alter database open;
{/code}

8. test edilir

{code class=”brush: xml;”}
SQL> select log_mode from v$database;
SQL> select archiver from v$instance;
{/code}

9. log switch yapılarak archive üretmesi sağlanır

{code class=”brush: xml;”}
SQL> alter system switch logfile;
{/code}

10. arcvhivelogların isimleri ve lokasyonlarını görmek için

{code class=”brush: xml;”}
SQL> select name from v$archived_log;
{/code}

Bu adımlardan sonra Eğer Database enterprise sürüm ve Flash recovery aktif ise archive log ları USE_DB_RECOVERY_FILE_DEST lokasyonuna alacaktır.

Flash recovery, disable edilirse tanımladığınız lokasyonu görür

pfile daki aşağıda parametre silinere disable edilebilir. Ya da aşağıda anlatılan

log_archive_dest_10 kullanılabilir. Ayrıntılı düşünülmesi gereken bir karar.

*.db_recovery_file_dest=’+RECOVERY’

{code class=”brush: xml;”}
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 2
Next log sequence to archive 4
Current log sequence 4
{/code}

Archive logları farklı bir lokasyona almak için spfile daki parametreler aşağıdaki gibi olması gerekir.

{code class=”brush: xml;”}
alter system set log_archive_format=’arch_%d_%t_%r_%s.log’ scope=spfile;
alter system set log_archive_dest_10=’LOCATION=/oracle/archive1/’ scope=spfile;
{/code}

{code class=”brush: xml;”}
log_archive_dest_1=’LOCATION=/u02/Arc1/ mandatory’
{/code}zorunlu, buraya yazamazsa hang duruma geç anlamındadır. select lere cvp verir insert update lere cvp vermez.

{code class=”brush: xml;”}
log_archive_dest_1=’LOCATION=/u02/Arc1/ mandatory reopen=30′
{/code}30 sn sonra bir daha dene

{code class=”brush: xml;”}
log_archive_dest_2=’LOCATION=/u03/Arc1/ optional’
{/code}yazamazsa bile devam eder.

{code class=”brush: xml;”}
*.db_recovery_file_dest=’/u01/app/oracle/flash_recovery_area’

*.db_recovery_file_dest_size=2147483648

*.user_dump_dest=’/u01/app/oracle/admin/smp/udump’

*.log_archive_dest_10=’LOCATION=/u02/Arc1/’

*.log_archive_format=’arch_%d_%t_%r_%s.log’
{/code}
Tekrar sorguladığımızda,
{code class=”brush: xml;”}
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u02/archive1/
Oldest online log sequence 3
Next log sequence to archive 5
Current log sequence 5
{/code}

 

{jcomments on}

Copyright © 2015 Sysdba All Rights Reserved Web Designer