Dbvisit Community Dbvisit home       

Go Back   Dbvisit Community > Dbvisit Standby - Technical > Dbvisit Standby - Technical Questions or Issues

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 06-09-2008, 09:29 PM
Arjen Visser Arjen Visser is offline
Dbvisit Team
 
Join Date: Jan 2008
Location: Auckland, New Zealand
Posts: 381
Default Querying Dbvisit transfer process

The following query can be used to display the entries from the Dbvisit transfer process from the primary server to the standby server.
This SQL will create a spool file called dbv_transfer.log which contains the records.

clear col
set heading on
column c1 heading SID format A10
column c2 heading seq format 999999
column c3 heading archive format A32
column c4 heading timestamp format A15
column c5 heading process format A8
column c6 heading start format A17
column c7 heading end format A17
column c8 heading source format A10
column c9 heading dest format A10
column c10 heading MB format 999999
column c11 heading CMP format A3
column c12 heading LOG_ID format 99999999999
set pagesize 100
set linesize 10000
set trimspool on
set verify off
set echo off
set tab off
set space 1
set serveroutput on
spool dbv_transfer.log
select
ORACLE_SID c1
,SEQUENCE# c2
,substr(ARCHIVE_NAME,length(ARCHIVE_NAME)-30, length(ARCHIVE_NAME)) c3
,PROCESS c5
,TIMESTAMP c4
,to_char(START_TIME_DATE,'yyyymmdd hh24:mi:ss') c6
,to_char(END_TIME_DATE,'yyyymmdd hh24:mi:ss') c7
,UPPER_SOURCE_HOST c8
,UPPER_DESTINATION_HOST c9
,round(SIZE_IN_BYTES/1024/1024,2) c10
,PROCESS_COMPLETED c11
,LOG_ID c12
from dbvisit.dbv_transfer_log
order by sequence#,
process
;
spool off
set heading off
/
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT +12. The time now is 08:37 PM.