<< Back to previous view

[PSUP-145] ubGuard 2.0.1 Commands Created: 25/Feb/17  Updated: 28/Feb/17

Status: Closed
Project: PUBLIC_SUPPORT
Fix Version/s: None

Type: ubTools - ubGuard Priority: Major
Reporter: ubTools Support Assignee: ubTools Support
Resolution: Answered Votes: 0


 Description   
This document explains ubGuard commands.

 Comments   
Comment by ubTools Support [ 25/Feb/17 04:40 PM ]
COMMANDS:

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; 




[PSUP-142] Change Log: ubGuard 1.1.3 Created: 25/May/15  Updated: 25/May/15

Status: Closed
Project: PUBLIC_SUPPORT
Fix Version/s: ubGuard 1.1.3

Type: ubTools - ubGuard Priority: Minor
Reporter: ubTools Support Assignee: ubTools Support
Resolution: Product Update (Minor) Votes: 0


 Description   
CHANGE LOG:
Since 1.0.3:
--------------------
New features:
1- bin/ubguard.sh (bin/ubguard.bat for Windows) has been added to manage ubGuard.
2- bin/environment.sh (bin/environment.bat for Windows) has been added
   to set environment variables.
3- Windows service has been added.
4- New parameters: 
    ssh.port.client: Defines local(outgoing) SSH port. Value 0 means random port.
    database.instance.alias: Defines ubGuard instance as an alias.
    database.instance.parent.alias: Defines ubGuard parent instance aliases.
5- Renamed parameters:
    ssh.port to ssh.port.server.
6- Removed parameters:
    database.instance.parent.host
    database.instance.parent.instance

1.1.2:
-------------------
New features:
1- database.standby.archivelog.retention.time definition has changed.
   Archivelogs on standby are deleted if they are older than standby
   database time by this parameter. 

Improvements:
1- Database instance alias name is not required to be case sensitive.
2- Numbers of SQLs running on Primary have been reduced.
3- Archivelogs are deleted by RMAN.
4- Unnecessary privileges have been revoked from UBGUARD_ROLE role.

Bugs:
1- While running OS commands, Runtime Exceptions could not be caught.
2- If parameter database.instance.alias is not upper case,
   Oracle directories UBGUARD_ASM_* and UBGUARD_TMP_* are recreated unnecessarily.
3- Wrong file separator used for ASM on Windows.
4- bin/ directory is included in ubGuard.jar unnecessarily.
5- bin/ubguard.sh and bin/environment.sh are in DOS format.

1.1.3:
-------------------
Bug:
1- Unable to catalog archivelogs on Windows.





[PSUP-140] Change Log: ubGuard 1.0.3 Created: 22/Mar/14  Updated: 22/Mar/14

Status: Closed
Project: PUBLIC_SUPPORT
Fix Version/s: ubGuard 1.0.3

Type: ubTools - ubGuard Priority: Major
Reporter: ubTools Support Assignee: ubTools Support
Resolution: Product Update (Major) Votes: 0


 Description   
CHANGE LOG:

Cumulative from the following versions:

 * 1.0.0:
 * -------------------
 * New features:
 * 1- ubGuard is installed in standby severs instead of primary servers.
 * 2- Cascaded standby: A standby gets archivelogs from another standby.
 * 3- The content of conf/setup.properties changed.
 * 4- Applied archivelog can be deleted from standby server with time delay.
 * 5- SSH connect timeout added.
 * 6- Single ubGuard home can bee used for multiple local standby databases.
 * 7- conf/message.properties file added.
 *
 * 1.0.1:
 * -------------------
 * Bug:
 * 1- Archivelogs moved from ASM to primary TMP directory not deleted.
 *
 * 1.0.2:
 * -------------------
 * Bug:
 * 1- Windows not identified.
 *
 *
 * 1.0.3:
 * -------------------
 * Bugs:
 * 1- Unable to get ORACLE_HOME environment variable in Windows.
 * 2- Existing archivelog in standby is retransffered in Windows.





[PSUP-138] Change Log: ubGuard 0.3.2 Created: 30/Sep/13  Updated: 30/Sep/13

Status: Closed
Project: PUBLIC_SUPPORT
Fix Version/s: ubGuard 0.3.2

Type: ubTools - ubGuard Priority: Minor
Reporter: ubTools Support Assignee: ubTools Support
Resolution: Product Update (Minor) Votes: 0


 Description   
CHANGE LOG:

Cumulative from the following versions:

* 0.2.3:
 * -------------------
 * 1- SSH compression has been added.
 *    The parameter: ssh.compression.level
 *    No compression:0, Max compression:9, Default compression:-1(that is 6)
 *
 * 0.3.0:
 * -------------------
 * New Features:
 * 1- Forcing archivelog generation in each archivelog transfer period has been removed.
 *    Use Oracle ARCHIVE_LAG_TARGET initialization parameter instead.
 * 2- The changed messages:
 *    old: ubGuard-1 [<returnCode>]: Unable to acquire lock by DBMS_LOCK.REQUEST().
 *    new: ubGuard-1 [<taskID>,<returnCode>]: Unable to acquire task lock.
 *
 *    old: ubGuard-2 [<returnCode>]: Unable to release lock by DBMS_LOCK.RELEASE().
 *    new: ubGuard-2 [<taskID>,<returnCode>]: Unable to release task lock.
 *
 *    old: ubGuard-5 No UBGUARD_TMP_ARCHIVE directory found in ALL_DIRECTORIES.
 *    new: ubGuard-5 Oracle directory UBGUARD_TMP_ARCHIVE not defined.
 *
 *    old: ubGuard-4 No standby found.
 *    new: ubGuard-4 Standby not defined.
 *
 * 3- The removed messages:
 *    ubGuard-3: <message>
 *    ubGuard-6: Archivelog transfer period not defined.
 *
 * Bugs:
 * 1- Time portion of ERROR_LOG.ERROR_DATE column is lost.
 * 2- If an Oracle RAC thread reopened, it transfers archivelogs which are already in-transmit in another node.
 *
 *
 * 0.3.1d3:
 * -------------------
 * Bug:
 * 1- File name separator on standby windows is not handled correctly.
 *
 * 0.3.1d5:
 * -------------------
 * Bug:
 * 1- Recover SCN of standby database computed wrong after removing forcing archivelog generation
 *    which is introduced in ubGuard 0.3.0.
 *
 * 0.3.1d6:
 * -------------------
 * New features:
 * 1- Setting up mail.transport.user and mail.transport.password parameters are optional.
 *    SMTP authentication is forced only if both parameters are set.
 * 2- Java Mail debug is set to diagnose a problem.
 *
 * 0.3.1d7:
 * -------------------
 * Bug:
 * 1- Recovery start SCN is wrong if datafile is older than controlfile.
 *
 * 0.3.2:
 * -------------------
 * New feature:
 * 1- Unhandled exceptions are written to log/ubGuard.log.
 *
 * Bug:
 * 1- Already deleted archivedlogs are tried to be deleted again.





[PSUP-137] Change Log: ubGuard 0.2.2 Created: 28/Feb/13  Updated: 28/Feb/13

Status: Closed
Project: PUBLIC_SUPPORT
Fix Version/s: ubGuard 0.2.2

Type: ubTools - ubGuard Priority: Major
Reporter: ubTools Support Assignee: ubTools Support
Resolution: Product Update (Major) Votes: 0


 Description   
Change Log:

Initial version.






Generated at Sun Jun 20 03:26:20 UTC 2021 using JIRA Standard Edition, Version: 3.12.3-#302.