Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Saturday, May 25, 2019

dbaascli Utility:

dbaascli utility is to perform a variety of life-cycle and administration operations.

Using the dbaascli utility,we can perform:

  • Change the password of a database user.
  • Start and stop a database.
  • Start and stop the Oracle Net listener
  • Check the status of the Oracle Data Guard configuration.
  • Perform switchover and failover in an Oracle Data Guard configuration.
  • Patch the database deployment.
  • Perform database recovery.
  • Rotate the master encryption key.

Command:

# dbaascli subcommand subcommand-options

Subcommand        Subcommand Options
database                  bounce – shuts down and then restarts the database instance.
                                changepassword – changes the password of the specified user.
                                start– starts the database instance and opens the database.
                                status – displays the open mode of the database and additional information about                                               the database deployment.
                                stop – shuts down the database instance.
--------------------------------------------------------------------------------------------------------------------------
dataguard                 failover – performs a manual failover.
                                 reinstate – reinstates a failed primary database.
                                 status – checks the status of the configuration.
                                 switchover – performs a switchover operation.
--------------------------------------------------------------------------------------------------------------------------
dbpatchm               apply – applies the patch.
                              clonedb – applies a patch to a test deployment.
                              list_patches – displays a list of available patches.
                              list_tools – checks whether any cloud tooling updates are available.
                              prereq – checks the prerequisites of a patch.
                              rollback – rolls back the last deployment patch.
                              switchback – restores database software to a prior state.
                              toolsinst – downloads and applies the patch containing the cloud tooling update.
--------------------------------------------------------------------------------------------------------------------------
dv                        off – disables Oracle Database Vault.
                            on– enables Oracle Database Vault.
--------------------------------------------------------------------------------------------------------------------------
gg                       setup – configures the database as a valid replication database.
                           status – indicates whether the database has been configured as a valid replication                                               database.
--------------------------------------------------------------------------------------------------------------------------
listener                bounce – stops and restarts the listener.
                            start – starts the listener.
                            status – displays the status of the listener, including a summary of listener                                                           configuration settings, listening protocol addresses, and a summary of                                                   services registered with the listener.
                            stop – stops the listener.
--------------------------------------------------------------------------------------------------------------------------
netsec                  config – configures network encryption and network integrity.
                            config encryption– configures network encryption.
                           config integrity – configures network integrity.
                           status – displays network encryption and network integrity configuration                                                             information.
--------------------------------------------------------------------------------------------------------------------------
orec                   duplicate – updates the standby database in a Data Guard configuration.
                          keep list – lists the available long-term backups.
                          keep tag – restores a specific long-term backup and performs recovery.
                         latest – restores the most recent backup and performs complete recovery.
                         list – lists the available normal backups.
                         pitr – restores a specific normal backup and performs recovery.
                         scn – restores the most recent backup and performs recovery through the specified                                        SCN.
--------------------------------------------------------------------------------------------------------------------------
patch                 db apply – applies the database patch.
                          db cleanup – removes temporary files created during database patching operations.
                          db list – displays a list of available database patches.
                          db prereq – checks whether any database updates are available.
                          db switchback – rolls back the last database patch.
                          os apply – applies the OS patch.
                          os list – displays a list of available OS patches.
                          tools apply – downloads and applies the patch containing the cloud tooling update.
                          tools auto disable – disables automatic cloud tooling updates.
                          tools auto enable – enables automatic cloud tooling updates.
                          tools auto execute – downloads and applies the patch containing the latest cloud                                                                     tooling update.
                          tools auto status – checks whether automatic cloud tooling updates are enabled or                                                              disabled.
                          tools list – checks whether any cloud tooling updates are available.
--------------------------------------------------------------------------------------------------------------------------
tde                     rotate masterkey – changes (rotates) the master encryption key.
                          status – displays information about the software keystore, including the type and                                                status.



No comments:

Post a Comment