| How to check oracle replication logs [message #75592] |
Wed, 22 December 2004 21:39  |
chien
Messages: 2
Registered: December 2004
|
Junior Member |
|
|
Hi All,
I have setup Oracle Materialized Views between 2 Oracle 9i databases using Oracle Enterprise Manager tool.
Now I dont know how to monitor and check whether the replication has been run successful or not and how long does it take to run for 1 view/or for all views.
Anybody know which system views/tables/log files need to check please advise. Thank a lot
[Updated on: Fri, 18 February 2005 23:32] Report message to a moderator |
|
|
|
| Re: How to check oracle replication logs [message #75594 is a reply to message #75592] |
Wed, 22 December 2004 22:34  |
Shubhangi
Messages: 1
Registered: December 2004
|
Junior Member |
|
|
Following are the queries which you have to run on both database setups.
1)select job,name ,to_char(next_date,'mm/dd/yyyy hh24:mi:ss') next_date , broken ,
to_char(sysdate,'mm/dd/yyyy hh24:mi:ss') sys_date from dba_refresh_children
where rowner in ('Databaseusr1', 'Databaseusr2') ;
2)select BROKEN,failures, job ,to_char(next_date,'mm/dd/yyyy hh24:mi:ss') next_date ,
to_char(last_Date,'mm/dd/yyyy hh24:mi:ss') last_date from dba_jobs
where LOG_USER in ('Databaseusr1', 'Databaseusr2') ;
The Broken column should be "N" for all the rows that you see and next
at the max one hour away in future from sys_date.
Note: In above query 'Databaseusr1','Databaseusr2' are database username for different setups.
|
|
|
|
| Re: How to check oracle replication logs [message #75595 is a reply to message #75594] |
Wed, 22 December 2004 23:37 |
chien
Messages: 2
Registered: December 2004
|
Junior Member |
|
|
Thank Shubhangi,
Using your scripts i can know whether each view has been replicated successful or not. I can also know last run date, next run date for each view. But I still not know how long does it take for replication.
I schedule the replication job at 9pm every day. I have system backup job scheduled at 11pm. I need to know the timing needed for the whole replication process because at 11pm when backup process start replication process must be finished.
If replication process can finish within 2 hours (before 11pm) I no need to re-schedule backup job, if it take more than 2 hours then i need to put backup job latter.
My problem is I dont know where to check how long the replication running.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
