Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Oracle Archivelogs applying but not shipping?

Posted on 2013-12-18
7
422 Views
Last Modified: 2014-01-22
I recently set up my Oracle database to have a physical standby database. When I run this command: select sequence#,applied from v$archived_log order by sequence#; I see the most recent log and that it has applied. However, the physical log is not present in the directory shown when I run archive log list;

I noticed that the global database name is the same for both the primary and standby databases. Is that normal?
0
Comment
Question by:AshleySPM
7 Comments
 
LVL 1

Author Comment

by:AshleySPM
ID: 39727893
I just found that the archivelogs are being stored in the RDBMS folder, which is not the location specified in archive log list or in the log_archive_dest parameter in the init.ora file.
0
 
LVL 12

Expert Comment

by:praveencpk
ID: 39729840
it will be configured in log_archive_dest_n paramter the path if the stand by is configured properly. check these parameter on both primary and secondary standby database.

Also go through the below doc on data gaurd log trasport

http://docs.oracle.com/cd/B19306_01/server.102/b14239/log_transport.htm
0
 
LVL 15

Expert Comment

by:Franck Pachot
ID: 39729881
Hi,

I suppose you are using DG broker.
You can change the standby location with property StandbyArchiveLocation

For example if the standby database is STANDBY the you can:

DGMGRL> edit database 'STANDBY' set property StandbyArchiveLocation='USE_DB_RECOVERY_FILE_DEST';

Open in new window


Regards,
Franck.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 16

Assisted Solution

by:Richard Olutola
Richard Olutola earned 500 total points
ID: 39730348
To answer your other question about the global database name, YES it is normal for this parameter to have same value on both primary and standby. This is becuase the DB_NAME should be  the same on both pri and stby and since the global db name is a concatenation of the DB_NAME and the DB_DOMAIN, it would be the same on both.
The db_unique_name must be different on primary and standby.

Hope this helps in a small measure.

R.
0
 
LVL 1

Accepted Solution

by:
AshleySPM earned 0 total points
ID: 39730594
I don't think we are using a Data Guard Broker. The log_archive_dest_n is configured properly.

Thank you rolutola for that information.
0
 
LVL 1

Assisted Solution

by:AshleySPM
AshleySPM earned 0 total points
ID: 39789467
I did

alter system set standby_archive_dest='proper location';

and then started log recovery.
0
 
LVL 1

Author Closing Comment

by:AshleySPM
ID: 39799500
No one provided the right solution and I found this on my own.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

856 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