Solved

log_archive_dest

Posted on 2013-05-24
3
371 Views
Last Modified: 2013-06-04
ideally where is log_archive_dest


my oracle home is
[oracle@mac primary]$ cd $ORACLE_HOME
[oracle@mac db_1]$ pwd
/u01/app/oracle/product/11.2.0/db_1
[oracle@mac db_1]$
SQL> show parameter log_archive_dest_1;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1                   string
log_archive_dest_10                  string
log_archive_dest_11                  string
log_archive_dest_12                  string
log_archive_dest_13                  string
log_archive_dest_14                  string
log_archive_dest_15                  string
log_archive_dest_16                  string
log_archive_dest_17                  string
log_archive_dest_18                  string
log_archive_dest_19                  string
SQL>



I want to give values to log_archive_dest

"which directory is good for that....
0
Comment
Question by:walkerdba
3 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39195533
The docs:
http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams122.htm#REFRN10085

If LOG_ARCHIVE_DEST is not explicitly defined and all the LOG_ARCHIVE_DEST_n parameters have null string values, LOG_ARCHIVE_DEST is set to an operating system-specific default value on instance startup.

http://docs.oracle.com/cd/E11882_01/server.112/e25494/archredo004.htm#ADMIN11338

Specifying Archive Destinations


>>"which directory is good for that....

Pick one.  There is no hard and fast rule on where they go.

Typically you want them in the same basic folder structure that your other database files are.  You also want to try to get them on different disks so writing to them doesn't interfere with normal database activity.
0
 
LVL 15

Accepted Solution

by:
Franck Pachot earned 500 total points
ID: 39196251
Hi,

It's a good idea to use the recovery area.
Can you show parameter db_recovery_file_dest

If it's ok then set log_archive_dest='LOCATION=USE_DB_RECOVERY_FILE_DEST'
 The big advantage is that you can use archive deletion policy with that.

Regards,
Franck.
0
 

Author Closing Comment

by:walkerdba
ID: 39219946
yes
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Best way to virtualise a remote Linux server 2 50
Oracle - Create Procedure with Paramater 16 56
nagios 4 php error after installation 6 73
linux redhat 7.2 10 36
SSH (Secure Shell) - Tips and Tricks As you all know SSH(Secure Shell) is a network protocol, which we use to access/transfer files securely between two networked devices. SSH was actually designed as a replacement for insecure protocols that sen…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to recover a database from a user managed backup

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now