Re: Logical Log Backup Method

Mr Cheuk Kong Lo wrote: > > Hello, > > If I'm pointing the LTAPEDEV to a tape device, and I understand > if the tape is full, then logical log can't backup and the database > will eventually hang. > > In this case, e.g., if the tape drive is bad, can I just change the LTAPEDEV > device to /dev/null and do a ontape -c to resume ONLINE asap? Unlike TAPEDEV, LTAPEDEV must also be changed in shared memory so you must use onmonitor to change LTAPEDEV for the current session, changing it in the config file only will take effect when the server is bounced. > Also, if I'm using a file for LTAPEDEV, can I switch file while logical > log is idle? I cannot answer this one, sorry. > We are looking at ON-Bar, but it is not really as easy/fast or trouble-free > as we thought to be. Art S. Kagel