

-- file: prod1_disaster_recovery.txt
-- Features: This text file provides a listing of tablespaces
-- data file names,sizes and user account info.
--
-- Used By: DBA for disaster recovery purposes
--
-- Copyright 2001 by .com Solutions Inc.
--
-- ---------------------- Revision History ---------------
-- Date By Changes
-- 10-6-2001 dsimpson Initial Release
Report produced on: 04-APR-02
Database name: prod1
Database server hostname: blade1
TablespaceFile |
|
|
|
Size (bytes) |
INDX |
|
/u01/prod1/indx01.dbs |
|
52428800 |
RBS |
|
/u01/prod1/rbs01.dbs |
|
20971520 |
REPLICATION |
|
/u01/prod1/replication01.dbf |
|
52428800 |
SYSTEM |
|
/u01/prod1/system01.dbs |
|
314572800 |
TOOLS |
|
/u01/prod1/tools01.dbs |
|
10485760 |
UNDOTBS |
|
/u01/prod1/undo01.dbs |
|
524288000 |
USERS |
|
/u01/prod1/users01.dbs |
|
10485760 |
| |
|
|
|
|
| |
|
|
|
|
| |
Username |
Status |
Tablespace |
Temp |
Created |
ADMIN |
|
OPEN |
USERS |
|
TEMP |
25-NOV-01 |
DBSNMP |
|
OPEN |
SYSTEM |
|
TEMP |
08-MAR-02 |
DSIMPSON |
|
OPEN |
USERS |
|
TEMP |
25-NOV-01 |
HR |
|
OPEN |
SYSTEM |
|
TEMP |
25-NOV-01 |
OE |
|
OPEN |
SYSTEM |
|
TEMP |
25-NOV-01 |
OLAPDBA |
|
OPEN |
SYSTEM |
|
TEMP |
25-NOV-01 |
OLAPSVR |
|
OPEN |
SYSTEM |
|
TEMP |
25-NOV-01 |
OUTLN |
|
OPEN |
SYSTEM |
|
TEMP |
25-NOV-01 |
PM |
|
OPEN |
SYSTEM |
|
TEMP |
25-NOV-01 |
QS |
|
OPEN |
SYSTEM |
|
TEMP |
25-NOV-01 |
QS_ADM |
|
OPEN |
SYSTEM |
|
TEMP |
25-NOV-01 |
QS_CB |
|
OPEN |
SYSTEM |
|
TEMP |
25-NOV-01 |
QS_CBADM |
|
OPEN |
SYSTEM |
|
TEMP |
25-NOV-01 |
QS_CS |
|
OPEN |
SYSTEM |
|
TEMP |
25-NOV-01 |
QS_ES |
|
OPEN |
SYSTEM |
|
TEMP |
25-NOV-01 |
QS_OS |
|
OPEN |
SYSTEM |
|
TEMP |
25-NOV-01 |
QS_WS |
|
OPEN |
SYSTEM |
|
TEMP |
25-NOV-01 |
REPADMIN |
|
OPEN |
REPLICATION |
|
TEMP |
08-MAR-02 |
SH |
|
OPEN |
SYSTEM |
|
TEMP |
25-NOV-01 |
SYS |
|
OPEN |
SYSTEM |
|
TEMP |
25-NOV-01 |
SYSTEM |
|
OPEN |
SYSTEM |
|
TEMP |
25-NOV-01 |
Tablespace |
Status |
Size(Mb) |
Used (Mb) |
Free (Mb) |
INDX |
ONLINE |
50.00 |
0.38 |
49.63 |
RBS |
ONLINE |
20.00 |
0.06 |
19.94 |
REPLICATION |
ONLINE |
50.00 |
1.00 |
49.00 |
SYSTEM |
ONLINE |
300.00 |
139.59 |
160.41 |
TOOLS |
ONLINE |
10.00 |
0.06 |
9.94 |
UNDOTBS |
ONLINE |
500.00 |
17.31 |
482.69 |
USERS |
ONLINE |
10.00 |
0.38 |
9.63 |

