![oracle database log oracle database log](http://sapbasisinfo.com/wp-content/uploads/2014/09/alertlog_03.jpg)
This directory is the OPTIONAL Archive log directory. On execution of this statement – We configure our 1st directory. SQL> ALTER SYSTEM SET log_archive_dest_1 = 'location = D:\ArchLog' Once you have decided a location that you want to use as your Archive log destination then issue an ALTER SYSTEM command to register that directory in Oracle Server. C:/> mkdir D:\ArchLogįor the demonstration I will be using a directory named ‘ArchLog’ which I have created in my D:/ drive.
#ORACLE DATABASE LOG HOW TO#
How To Use Log_Archive_Dest_ n Parameter Step 1: Create a Directory at your prefer location. Service Name, if you have a data guard setup.Local folder created on your hard drive somewhere on your system.Using LOG_ARCHIVE_DEST_n you can setup a location which could either be a.Which means if you want to use one, then you have to set it up first. By default there is no Archive log destination directory setup in Oracle Database.It will occupy some extra storage space but from backup perspective it’s always better to have multiple backups. if you have more that one location setup then you will have redundant copies of archive logs created by the Oracle Database server. Using LOG_ARCHIVE_DEST_n we can define up to 10 destinations for saving the archived logs.The prefix n is a number in range of 1 to 10.Here are a few things about this parameter –
![oracle database log oracle database log](https://docs.oracle.com/cd/E69551_01/VSMGU/img/databaseupdatelog.png)
Log_Archive_Dest_n parameter is used to set a location for Archive Log Destination Directory.
![oracle database log oracle database log](https://www.databasedesign-resource.com/image-files/oralog1.jpg)
There are two main parameters that we need to configure to setup Archive log destination directory. How To Setup Archive Log Destination Directory. Archive Log Destination DirectoryĪrchive log destination directory, As the name suggests is a location which Oracle Uses to save the Archived copies of the Online Redo log files during backup operations. That’s what I am going to cover in today’s Oracle Backup and Recovery Tutorial. Now comes the second option which is, setting up Archive log destination Directory.