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%20Kammermayer's gravatar image

Margaret Kam...
3316819
accept rate: 50%


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.

permanent link

answered 06 May '11, 16:22

Margaret%20Kammermayer's gravatar image

Margaret Kam...
3316819
accept rate: 50%

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;
permanent link

answered 07 May '11, 16:14

Volker%20Barth's gravatar image

Volker Barth
30.3k301452660
accept rate: 32%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×47
×15

question asked: 06 May '11, 14:54

question was seen: 2,350 times

last updated: 07 May '11, 16:14