Show TOC

Showing Encryption Status with BR*ToolsLocate this document in the navigation structure

Context

You can use BR*Tools for Oracle to show information about the database encryption status.

Procedure

Start the procedure using BRGUI or BRTOOLS, or from the command line:

  • BRGUI or BRTOOLS:

    1. Choose Start of the navigation path Instance Management Next navigation step Additional instance functions Next navigation step  Show encryption status End of the navigation path.

      BRGUI or BRTOOLS displays the menu BRSPACE main options for showing database information, where you specify the options with which you call BRSPACE.

    2. Set the required options:

      Menu Entry

      Equivalent BRSPACE Command Option

      BRSPACE profile (profile)

      -p|-profile

      Database user/password (user)

      -u|-user

      Create log file (log)

      -f dbshow -l|-log

      Confirmation mode (confirm)

      -c|-confirm

      Scrolling line count (scroll)

      -s|-scroll

      Message language (language)

      -l|-language

      BRSPACE command line (command)

      This shows you the BRSPACE -f dbshow -c destate command that is to be executed using the current settings.

    3. Choose Continue.

      BRGUI or BRTOOLS prompts you to start BRSPACE.

    4. Choose Continue to start BRSPACE.

  • Command line:

    Enter at least the following command:

    brspace -f dbshow -c destate

    You can enter more parameters if required. For more information, see BRSPACE -f dbshow.

BRSPACE starts and you see a message that includes Start of BRSPACE processing. From now on, BRSPACE writes a detail log if you set the option Create log file (parameter -l|-log).

Note

If you started BRSPACE from the command line without the information class name ( -c|-class) - that is, with brspace -f dbshow - BRSPACE displays the Show database information main menu.

Choose Start of the navigation path Show database instance information Next navigation step Show encryption status End of the navigation path.

BRSPACE displays Status of encryption for database:

List Entry

Meaning

Database encryption wallet (wallet)

Path of the database encryption wallet

Database auto-open wallet (auto_wallet)

Database auto-open wallet

Database wallet status (status)

Status of database wallet

Number of encrypted tables/columns (tab_col)

Number of encrypted tables and columns not in encrypted tablespaces

Number of encrypted tablespaces/tables (tsp_tab)

Number of encrypted tablespaces and tables

Results

If you set the option Create log file (parameter -l|-log), check the results in the BRSPACE logs.

  • The summary log space<DBSID>.log displays the return code.

  • The detail log s<encoded timestamp>.dbw displays the details.

For more information on how to view the logs with BR*Tools, see Showing Profiles and Logs with BR*Tools.