Showing Data Files with BR*Tools
Use
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:
i. Choose Space management ® Additional space functions ® Show data files.
BRGUI or BRTOOLS displays the menu BRSPACE main options for showing database information, where you specify the options with which you call BRSPACE.
ii. Set the required options:
Menu Entry |
Equivalent BRSPACE Command Option |
BRSPACE profile (profile) |
|
Database user/password (user) |
|
Database tablespace (tablespace) |
|
Database file (file) |
iii. Choose Continue.
BRGUI or BRTOOLS displays a further menu, Additional BRSPACE options for showing database information, where you specify the additional options with which you call BRSPACE.
Menu Entry |
Equivalent BRSPACE Command Option |
Create log file (log) |
|
Confirmation mode (confirm) |
|
Scrolling line count (scroll) |
|
Message language (language) |
|
BRSPACE command line (command) |
This shows you the BRSPACE –f dbshow -c dfinfo command that is to be executed using the current settings. |
iv. Choose Continue
BRGUI or BRTOOLS prompts you to start BRSPACE.
v. 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).
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 Show database space information ® Show data files.
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: raw device or file system |
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.
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.
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: raw device or file system |
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 |
4. If you specified multiple data files, choose Continue to scroll through.
Results
If you set the option Create log file (parameter –l|-log), check the results in the BRSPACE logs.
· The summary log space<DBSID>.logdisplays 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 Logs and Profiles with BR*Tools