Solved

Oracle Archivelogs applying but not shipping?

Posted on 2013-12-18
7
433 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
[X]
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
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
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 
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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

726 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