Procedure documentationShowing Data Files with BR*Tools

 

You can use BR*Tools for Oracle to show information about data files.

Procedure

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

    • BRGUI or BRTOOLS:

      1. Choose Start of the navigation path Space management Next navigation step Additional space functions Next navigation step Show data files 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

        Database tablespace (tablespace)

        -f dbshow -s|-tablespace

        Database file (file)

        -f dbshow -f|-file

        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 dfinfo 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 dfinfo

      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 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 space information Next navigation step Show data files End of the navigation path.

    End of the note.

  2. If you have already entered the data file name, continue with step 4.

    BRSPACE displays the List of database files:

    List Entry

    Meaning

    Pos.

    List sequence number

    Tablespace

    Tablespace name for the data file

    Status

    Data file status: online, offline, system or recover

    Type

    Data file type: file system, raw device, or ASM file

    File

    Data file name

    Id.

    Data file ID

    Size[KB]

    Data file size

    Device

    Disk device ID

    Back.

    Backup status

    AuExt.

    Whether data file has autoextend set

    MaxSize[KB]

    Maximum size of the data file

    IncrSize[KB]

    Data file increment size

  3. To see more information, select one or more data files.

    Example Example

    These examples apply only to input in character mode.

    To select the first three entries in the list, enter 1-3.

    To select the first and third entries, enter 1,3.

    To select the first three entries and the fifth, enter 1-3,5.

    To select all entries, enter 0.

    End of the example.

    BRSPACE displays Information about data file:

    List Entry

    Meaning

    Data file_id (Id)

    Data file ID

    Data file status (status)

    Data file status: online, offline, system or recover

    Tablespace name

    (tablespace)

    Tablespace name for the data file

    Backup status (backup)

    Backup status

    Data file type (type)

    Data file type: file system, raw device, or ASM file

    Disk device Id (device)

    Disk device ID

    Data file size in KB (size)

    Data file size

    File autoextend mode

    (autoextend)

    Whether data file has autoextend set

    Maximum file size in KB

    (maxsize)

    Maximum size of the data file

    File increment size in KB

    (incrsize)

    Data file increment size

    Allocated disk space in KB (space)

    Disk space allocated to the data file

    Data file creation time (crtime)

    Creation time stamp of the data file

    Data file creation SCN (crscn)

    Creation system change number (SCN) of the data file

  4. If you specified multiple data files, choose Continue to scroll through.

Result

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.