Re: changing logging mode

Don't know about a better approach but this will work. There is/was a problem of changing the logging mode when not using /dev/null, the database would stay in an 'inconsistent state' rkusenet wrote: > > I will be changing the logging mode of some databases pretty > soon. The only method I know is to use ontape -s -U dbname. > Now we don't have access to tape drive. The backup is taken > by EDS using onbar. I am not too familiar with onbar. I looked > up the options of onbar and saw no options to change the logging > mode of a database. > > I think this is what it needs to be done if I have to change > the logging mode without bouncing the server and involving > EDS. > > 1. use onmonitor to change the TAPEDEV parameter to /dev/null. > > 2. use ontape -s -U dbname option for a quick change of logging > mode without taking any real backup. > > 3. use onmonitor to set the TAPEDEV parameter back to its actual > value. > > Is there a better approach. > > TIA. > > ravi -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #