Scribd
Upload
6 views2 pages

Managing Oracle Archive Log Files

The document outlines the process for configuring a database in ARCHIVE LOG MODE, including setting the log archive destination and commands to enable archiving. It also provides steps to switch the database to NO ARCHIVE LOG MODE and details on data dictionary views related to archived logs. Additionally, it includes commands for switching log files and managing the database state.

Uploaded by

deekondakartheek
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
6 views2 pages

Managing Oracle Archive Log Files

The document outlines the process for configuring a database in ARCHIVE LOG MODE, including setting the log archive destination and commands to enable archiving. It also provides steps to switch the database to NO ARCHIVE LOG MODE and details on data dictionary views related to archived logs. Additionally, it includes commands for switching log files and managing the database state.

Uploaded by

deekondakartheek
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

Archived Redo Log files

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

It is the dba choice to run the database in ARCHIVE LOG MODE or in NO ARCHIVE LOG
MODE.
It is optional back ground process (ARCn)

parameter:

log_archive_dest=

DEMO
---------------

sys> shutdown normal

]$ vi init$ORACLE_SID.ora

LOG_ARCHIVE_DEST= /disk1/dbaone/arch

:wq

]$ mkdir /disk1/dbaone/arch

]$ sqlplus / as sysdba

sys> startup mount

sys> archive log list

sys> alter database archivelog;

sys> alter database open;

Data Dictionary Views:


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

1.v$archive_log
2.v$archive_dest

To Make database NO Archive log mode:


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

sys> startup mount

sys> archive log list


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

How to switch log file:


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

sys> alter system switch logfile;

sys> alter database noarchivelog;

You might also like