How to get the archive log status of a oracle standby database which is in mount mode?
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.