DATABASE'i ARCHIVE LOG MODUNA ALMA

---------------------------------------------------------------------------
DB Version : 9i

initDBNAME.ora 'da aşağıdakiler değiştirilir.

*.log_archive_start=TRUE
*.log_archive_dest='/export/d3101/oradata/ORA09/arch'

Database kapatılır.

sqlplus "/ as sysdba"

shutdown immediate;

create spfile from pfile;

startup mount

alter database archivelog;

alter database open;

-- dikkat parametre değişiklikleri pfile'da olmalıdır.

alter system switch logfile; ile archive log 'un ilerlediği görülmelidir.


-----------------------------------------------------------------------------


DB Version 10

Sadece aşağıdaki parametrelerle database 'in açılması yeterlidir.

*.LOG_ARCHIVE_DEST_STATE_1=ENABLE
*.log_archive_dest_1='LOCATION=/export/d3101/oradata/ORA09/arch'


log_archive_dest_n parametreleri

n enabled
Specifies that a valid log archive destination can be used for a subsequent
archiving operation (automatic or manual). This is the default.
n defer
Specifies that valid destination information and attributes are preserved, but the
destination is excluded from archiving operations until re-enabled.
n alternate
Specifies that a log archive destination is not enabled but will become enabled if
communications to another destination fail