I thought it was controlled using the -os option on the dbeng12/dbsrv12 command line, but from what I've read, -os seems to be for the console log. ??? asked 06 May '11, 14:54 Margaret Kam... |
I've answered my own question.... it's not the start command at all. Oops! I have to use the -r option on the dbbackup command. answered 06 May '11, 16:22 Margaret Kam... |
A general approach to automate this task would use an event of the GrowLog type: Here is an example from the 12.0.1 docs: Limit the transaction log size to 10 MB: CREATE EVENT LogLimit TYPE GrowLog WHERE event_condition( 'LogSize' ) > 10 HANDLER BEGIN IF EVENT_PARAMETER( 'NumActive' ) = 1 THEN BACKUP DATABASE DIRECTORY 'c:\\logs' TRANSACTION LOG ONLY TRANSACTION LOG RENAME MATCH; END IF; END; answered 07 May '11, 16:14 Volker Barth |