backup of database with Oracle Dataguard

Last post 08-23-2010, 11:00 AM by efg. 1 replies.
Sort Posts: Previous Next
  • backup of database with Oracle Dataguard
    Posted: 08-17-2010, 2:41 AM


    We have a couple off databases running in an Oracle dataguard configuration.

    Our Commvault backup runs on the primary instance (host1), is it possible to automatically switch the backup to the standby database(host2) in case a failover (initiatied from Oracle Dataguard)occurs?



  • Re: backup of database with Oracle Dataguard
    Posted: 08-23-2010, 11:00 AM
    • efg is not online. Last active: 06-03-2020, 10:43 AM efg
    • Top 10 Contributor
    • Joined on 02-02-2010
    • CommVault Tinton Falls NJ
    • Master
    • Points 1,729

    You may want to take a look at the qcommands infrastructure in CommVault.   There is a "qoperation move" command that allows one to move a configured oracle instance from one client to another.  If the standby DB has the same ORACLE_SID and login credentials then this may work for you.   Here is the header from the documentation:



    This command moves an Oracle instance from one client to another.


    qoperation move -sc sourceclient -a iDataAgent -i instance -dc destinationclient [-af argsfile] [-h]


    This command moves an Oracle instance from one or more clients to a single destination client.

    • If the specified instance is found on any of the source clients, then it is deconfigured on the source client and a new instance with the same name appears on the destination client.
    • If the instance is not found on any of the source clients, or, it is found on two or more source clients, then the command fails and returns an appropriate error message. Use the -sc option multiple times for specifying more than one source client from the command line.

    Ensure that the source and destination clients have the same operating system before moving an instance of Oracle. See the qlist client command.

    Upon successful completion, qoperation move displays the message "Move operation successful" in the console. In case of an error, an error code and the error description are displayed in the following format: "move: Error errorcode: errordescription"



    Here is the link to the main secion of qcommands:

    What you might be able to do is call a script when a failover occurs that in turn calls this qcommand to move the instance from server A to server B automatically.



    Ernst F. Graeler
    Senior Engineer III
The content of the forums, threads and posts reflects the thoughts and opinions of each author, and does not represent the thoughts, opinions, plans or strategies of Commvault Systems, Inc. ("Commvault") and Commvault undertakes no obligation to update, correct or modify any statements made in this forum. Any and all third party links, statements, comments, or feedback posted to, or otherwise provided by this forum, thread or post are not affiliated with, nor endorsed by, Commvault.
Commvault, Commvault and logo, the “CV” logo, Commvault Systems, Solving Forward, SIM, Singular Information Management, Simpana, Commvault Galaxy, Unified Data Management, QiNetix, Quick Recovery, QR, CommNet, GridStor, Vault Tracker, InnerVault, QuickSnap, QSnap, Recovery Director, CommServe, CommCell, SnapProtect, ROMS, and CommValue, are trademarks or registered trademarks of Commvault Systems, Inc. All other third party brands, products, service names, trademarks, or registered service marks are the property of and used to identify the products or services of their respective owners. All specifications are subject to change without notice.
Copyright © 2020 Commvault | All Rights Reserved. | Legal | Privacy Policy