Delphix Products

Expand all | Collapse all

Best way to start a VDB automatically in noarchivelog ?

Jump to Best Answer
  • 1.  Best way to start a VDB automatically in noarchivelog ?

    Posted 11-27-2014 04:38:00 PM
    What is the best way ?Should I use clone hook. ?
    What do you suggest in the script ? restart the VDB in mount mode and execute alter database noarchivelog ?

    Thanks
    Marie



  • 2.  RE: Best way to start a VDB automatically in noarchivelog ?
    Best Answer

    Posted 11-28-2014 04:51:00 AM
    Hi Marie,

    Correct the Configure Clone Hook will run for both a provision and refresh of a VDB when wanting to switch to noarchivelog.

    There are two types of operations for a hook, shell script or expect script. We would use shell script, which is the default.

    More information  can be found here in our documentation: http://docs.delphix.com/display/DOCS41/_hook+operations

    Utilizing the Configure Clone hook when provisioning, we would press the Green Plus sign at the top right of the UI window. Verify that it's operation is Run shell script, the default and then just paste something like the following where indicated:

    echo “Running Config clone script to switch to noarchivelog” > /tmp/logme.out

    sqlplus / as sysdba <<EOF
    startup force mount ;
    alter database noarchivelog ;
    alter database open ;
    exit ;
    EOF

    exit 0

    You can also flip the VDB card over for an existing VDB and select the hooks tab on the top right and add a configure clone hook. Therefore the next time this VDB is refreshed that hook will run.

    I hope this helps.

    Cheers,
    Dave G.



  • 3.  RE: Best way to start a VDB automatically in noarchivelog ?

    Posted 11-28-2014 07:25:00 AM
    Yes, it helps a lot.
    Thanks,

    Marie