Results 1 to 7 of 7

Thread: stop/start oracle for coldbackup

  1. #1
    Join Date
    Sep 2010
    Location
    Amsterdam
    Posts
    13

    Default stop/start oracle for coldbackup

    I'm using the applications to stop and start our Oracle DB from the DLE but somehow it looks like it is not working like I expect it.

    DLE ;
    DB-SERVER / ora-tar-begin
    DB-SERVER /usr comp-tar
    DB-SERVER /var comp-tar
    DB-SERVER /opt comp-tar
    DB-SERVER /home comp-tar
    DB-SERVER /oracle comp-tar
    DB-SERVER /oracle_sid comp-tar
    DB-SERVER /opt/sid_prt ora-tar-end

    amanda.conf ;

    define dumptype ora-tar-begin {
    comment "To stop Oracle DB before the backup"
    global
    script "dbora_stop"
    }

    define dumptype ora-tar-end {
    comment "To start Oracle DB after the backup"
    global
    script "dbora_start"
    }
    define script dbora_start{
    comment "Script to start Oracle DB"
    plugin "dbora_start"
    execute-where CLIENT
    execute-on post-dle-backup
    }

    define script dbora_stop{
    comment "Script to stop Oracle DB"
    plugin "dbora_stop"
    execute-where CLIENT
    execute-on pre-dle-backup
    }



    On DB-SERVER;
    /usr/local/amanda/amanda-2.6.1/libexec/amanda/application
    # ls -al
    total 416
    drwxr-xr-x 2 root system 4096 Nov 17 22:15 .
    drwxr-xr-x 3 root system 4096 Jan 20 2010 ..
    -rwsr-x--- 1 root disk 69224 Jan 20 2010 amgtar
    -rwxr-xr-x 1 amandaba disk 9730 Jan 20 2010 amgtar_perl
    -rwxr-xr-x 1 amandaba disk 6785 Jan 20 2010 amlog-script
    -rwxr-xr-x 1 amandaba disk 18147 Jan 20 2010 amsamba
    -rwsr-x--- 1 root disk 56703 Jan 20 2010 amstar
    -rwxr-xr-x 1 amandaba disk 9003 Jan 20 2010 amzfs-sendrecv
    -rwxr-xr-x 1 amandaba disk 6015 Jan 20 2010 amzfs-snapshot
    -rwxr-xr-- 1 amandaba disk 34 Nov 17 22:14 dbora_start
    -rwxr-xr-- 1 amandaba disk 44 Nov 17 22:15 dbora_stop
    -rwxr-xr-x 1 amandaba disk 5623 Jan 20 2010 script-email

    dbora_start is refering to /etc/dbora start
    dbora_stop is refering to /etc/dbora stop

    [ Backup starts at 00:01 hrs ]
    dbstart.log shows that DB is started at 00:08 hrs (before backup is made)
    dbshut.log shows that DB is shut at 01:06 hrs (after backup is done)


    Can anyone tell me what I am doing wrong here ?
    Last edited by FHogenhout; March 1st, 2011 at 05:36 AM.

  2. #2
    Join Date
    Sep 2010
    Location
    Amsterdam
    Posts
    13

    Default extra info

    Ok, search further end my colleague pointed me that the sendbackup-files in /tmp/amanda showed that the first DLE voor de DB-server, which has the dunptype ora-tar-begion is not started as the first but as the last one and so the DLE with dumptype ora-tar-end is started before teh begin.

    in amanda.conf is set:
    taperalgo largestfit

    I guess this has a lot to do with it.

  3. #3
    Join Date
    Nov 2005
    Location
    Canada
    Posts
    1,047

    Default

    There is no way to order the backup of dle.

    If I understand, you want a script to be executed before all dle and a script executed after all dle are done. You should use pre-host-backup and post-host-backup for that.

    But *-host-backup can only be exetuted on the amanda server, so they must do:
    ssh DB-SERVER /path/to/dbora_stop
    and
    ssh DB-SERVER /path/to/dbora_start

  4. #4
    Join Date
    Sep 2010
    Location
    Amsterdam
    Posts
    13

    Default

    I tried to get it running on the client first so tried pre-host-estimate but this returns;

    planner: ERROR badly formatted response from DB-SERVER
    resulting in no backup at all, although the DB was stopped at the right time ;-)

    I just set up the pre-host-backup for tonight like you suggested, see how that works.
    Will let you know tomorrow

  5. #5
    Join Date
    Nov 2005
    Location
    Canada
    Posts
    1,047

    Default

    What's in sendsize.*.debug file and amandad.*.debug file, it is probably your script that output something to stdout/stderr.

  6. #6
    Join Date
    Sep 2010
    Location
    Amsterdam
    Posts
    13

    Default

    I guess that you mean something like this;

    amandad.*.debug;

    Processing Database instance "cohprd": log file /oracle/product/11.2.0/dbhome_1/shutdown.log
    /oracle 0 SIZE 14339110
    /oracle 1 SIZE 7555130
    Processing Database instance "cohprd": log file /oracle/product/11.2.0/dbhome_1/shutdown.log
    /oracle_cohprd 0 SIZE 10896050
    /oracle_cohprd 1 SIZE 10896050
    Processing Database instance "cohprd": log file /oracle/product/11.2.0/dbhome_1/shutdown.log
    /opt/clp_prd_prt 0 SIZE 1380
    /opt/clp_prd_prt 1 SIZE 600
    Processing Database instance "cohprd": log file /oracle/product/11.2.0/dbhome_1/shutdown.log
    >>>>>
    1299106944.292136: amandad: received ACK pkt:
    <<<<<
    >>>>>
    1299106944.292191: amandad: security_close(handle=20031918, driver=f0f58138 (BSDTCP))
    1299106944.292204: amandad: security_stream_close(20039388)
    1299106944.292301: amandad: pid 950460 finish time Thu Mar 3 00:02:24 2011

    sendsize.*.debug is not showing any odd lines when I compare this with earlier sessions

  7. #7
    Join Date
    Sep 2010
    Location
    Amsterdam
    Posts
    13

    Default

    OK, test failed because of user-error ;
    1st- forgot to change the execute-where form CLIENT to SERVER for the stop-part
    2nd - seems there are 2 application-directories on my amanda-server;
    /usr/libexec/amanda/application
    /usr/local/libexec/amanda/application

    amreport shows;
    driver: FATAL error [exec /usr/libexec/amanda/application/dbora_start: No such file or directory]

    Guess that the "server-application-directory" is; /usr/libexec/amanda/application
    since my scripts were in /usr/local/libexec/amanda/application nothing happened.
    Made the corrections for the next run tonight.
    Last edited by FHogenhout; September 5th, 2011 at 02:36 AM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •