Database Administration (MOSC)

MOSC Banner

How to get the archive log status of a oracle standby database which is in mount mode?

edited Jul 26, 2016 5:00AM in Database Administration (MOSC) 3 commentsAnswered

Hi,

I want to know the archive log status (gv$log_history) of a standby database (Say Standby1) using database link from a primary databse (say Primary1).

I have created a public database link (pr_to_sb) in primary database.

CREATE PUBLIC DATABASE LINK pr_to_sb CONNECT TO system IDENTIFIED BY password USING 'some_link';

After this I fired the following query.

select * from gv$log_history@pr_to_sb;

I am getting following erros:

16:20:25  ORA-03150: end-of-file on communication channel for database link

16:20:25  ORA-02063: preceding line from pr_to_sb

Please help to fix the issue.

My aim is to get archive log status of standby database and then send email using pl/sql.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center