?
Solved

Change destination for archived logs

Posted on 2011-10-25
9
Medium Priority
?
378 Views
Last Modified: 2012-05-12
I'm trying to have archived logs go to  different destinations.


SQL> alter system set log_archive_dest_1='LOCATION=/u08
  2  VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
  3  db_unique_name=primary' scope=BOTH;

alter system set log_archive_dest_2='location=/u09' scope=BOTH;

When i check, nothing has changed.

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u04/archived_logs
Oldest online log sequence     130442
Next log sequence to archive   130449
Current log sequence           130449

What else do I need to do?
0
Comment
Question by:xoxomos
  • 5
  • 4
9 Comments
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37028135
See what log_archive_dest is set to.

The _n are for multiplexing.

Wait for a log switch or force one and see if the other folders get one as well.
0
 

Author Comment

by:xoxomos
ID: 37028222
I understand if you have log_archive_dest_n then you cannot have also a log_archive_dest.
No?
0
 

Author Comment

by:xoxomos
ID: 37028226
I switched log files, forced checkpoint, create pfile from spfile then looked in pifile.  Pfile has the new /u08 and /u09.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37028233
On mobile and cannot confirm/test.

Just thought of something.  Did the database start with an spfile?  Check the spfile parameter.

If you are using an spfile and set the parameters, try bouncing the database.
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37028237
I was typing:  pfile?  Scpoe=both is spfile.
0
 

Author Comment

by:xoxomos
ID: 37028364
I think this is the 'root' of the problem

drwxr-xr-x   8 oracle   oracle      1024 Oct 12 15:57 u05
drwxr-xr-x   4 oracle   oracle       512 Aug 12 15:03 u07
drwxr-xr-x   3 root     root        4096 Oct 19 10:44 u08
drwxr-xr-x   3 root     root        4096 Oct 19 10:48 u09
0
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 1000 total points
ID: 37028391
If the filesystems are mounted on them and orcle:dba isn't the owner, it is likely the issue but I would ecpect some error in the alert log stating there is a permission problem.

Oracle tends to not just change things and not tell you somewhere.

Please clarify the pfile/spfile issue.
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37028397
Do a df -k to verify the file systems are mounted.
0
 

Author Closing Comment

by:xoxomos
ID: 37028414
Yes, it appears that was the problem.  Chown to oracle and they are showing up where I want. :-)
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

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…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

864 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