ubGuard executable is <UBGUARD_HOME>/bin/ubguard.sh (ubguard.bat for Windows).

Prerequisite for all commands:

• Regarding Oracle listeners must be running.

Setup:

Prerequisites:

• <UBGUARD_HOME>conf/setup.properties must be filled.
• Primary databases must be opened.
• Standby databases must be in MOUNT state.

CMD> ubguard.sh setup

Start:

Prerequisites:

• Primary database must be opened.
• Standby database must be in MOUNT state.

CMD> ubguard.sh start <ubguard_alias>

Stop:

CMD> ubguard.sh stop <ubguard_alias>

Status:

CMD> ubguard.sh status <ubguard_alias>

Failover:

Prerequisites:

• Standby database must be in MOUNT state.

CMD> ubguard.sh failover to <ubguard_alias> [FORCE]

Default Failover:

It is a failover without FORCE option. It gets all missing archivelogs from primary server, applies archivelogs to standby database and activates standby database as primary database. It causes less data loss, but longer failover time.

The alternative manual method by RMAN on standby:

CMD> ubguard.sh stop  <ubguard_alias>
--> Copy all missing archivelogs from primary server to standby server
CMD> SET ORACLE_SID=<SID>
CMD> rman target /
RMAN> SHUTDOWN IMMEDIATE;
RMAN> STARTUP MOUNT;
RMAN> RECOVER DATABASE;
RMAN> SQL 'ALTER DATABASE ACTIVATE STANDBY DATABASE';
RMAN> ALTER DATABASE OPEN;
RMAN> EXIT; 

Forced Failover:

It is a failover with FORCE option. It doesn't get archivelogs from primary server and it doen't apply archivelogs to standby database. It just activates standby database as primary database. It causes more data loss, but less failover time.

The alternative manual method by RMAN on standby:

CMD> ubguard.sh stop  <ubguard_alias>
CMD> SET ORACLE_SID=<SID>
CMD> rman target /
RMAN> SHUTDOWN IMMEDIATE;
RMAN> STARTUP MOUNT;
RMAN> SQL 'ALTER DATABASE ACTIVATE STANDBY DATABASE';
RMAN> ALTER DATABASE OPEN;
RMAN> EXIT;