Versions Compared

Old Version 1

changes.mady.by.user Anton Els

Saved on

compared with

New Version 2

changes.mady.by.user Anton Els

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Dbvisit Standby Repository

...

Note
titleIMPORTANT

Do not update any entries or modify the structure of these tables.

 


Using "dbv_functions" 

Using the Dbvisit Standby supplied utility called dbv_functions. The option -N will extract information from the DDR. Type dbv_functions -h for help on the command and to show the different options.


Example:

Section
Column
width5%

 

Column
width95
Panel
bgColorCCC
 dbv_functions -N dbvisitp 
 Dbvisit Database configuration (DDC) file dbv_dbvisitp.env. 
 <<<<DBV_TRANSFER_LOG>>>> 
 oracle_sid => dbvisitp 
 sequence# => 3718 
 thread_num => 
 log_id => 562150315 
 archive_name => /oracle/oraarch/dbvisitp/1_3718_0562150315.log.gz 
 process_id => 19547 
 process => TRANSFER 
 timestamp => 200901221633 
 datestamp => 2009/01/22:16:33 
 start_time_date => 2009/01/22:16:34 
 end_time_date => 2009/01/22:16:34 
 source_host => dbvisit12 
 destination_host => dbvisit11 
 checksum => 1186970607 
 size_in_bytes => 22944 
 size_in_mb => .02 
 process_completed => Y

Where dbvisitp is the name of the database. If no sequence number is given as part of the argument, then the last archive sequence is displayed.

...

Section
Column
width5%
 
Column
width95%
Panel
bgColorCCC
SELECT oracle_sid,datestamp,archive_log_gap FROM dbvisit.dbv_sequence_log ORDER BY datestamp;