-- File: |
prod3_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 2002 by .com Solutions
Inc. |
-- |
-- ---------------------- |
Revision History --------------- |
-- Date |
By |
Changes |
|
-- 12-04-2001 |
dsimpson |
Initial Release |
| |
Report produced on: 04-APR-02 |
Database name: prod3 |
Database server hostname: ws134 |
| |
Tablespace |
|
File |
|
Size (bytes) |
|
|
INDX |
|
C:\U01\PROD3\INDX01.DBS |
|
52428800 |
|
QUERY_DATA |
|
C:\U01\PROD3\QUERY_DATA01.DBF |
|
1048576 |
|
RBS |
|
C:\U01\PROD3\RBS01.DBS |
|
20971520 |
|
REPLICATION |
|
C:\U01\PROD3\REPLICATION01.DBF |
|
52428800 |
|
SYSTEM |
|
C:\U01\PROD3\SYSTEM01.DBS |
|
314572800 |
|
TOOLS |
|
C:\U01\PROD3\TOOLS01.DBS |
|
10485760 |
|
UNDOTBS |
|
C:\U01\PROD3\UNDO01.DBS |
|
524288000 |
|
USERS |
|
C:\U01\PROD3\USERS01.DBS |
|
10485760 |
|
USERS2 |
|
C:\U02\PROD3\USERS2.DBF |
|
5242880 |
|
USERS3 |
|
C:\U01\PROD3\USERS3.ORA |
|
5242880 |
|
USERS3 |
|
C:\U01\PROD3\USERS3_02.DBF |
|
1048576 |
|
| |
| |
| |
Username |
|
Status |
Tablespace |
Temp |
Created |
ADMIN |
|
OPEN |
USERS |
TEMP |
27-DEC-01 |
|
|
AURORA$JIS$UTILITY$ |
|
OPEN |
SYSTEM |
TEMP |
26-DEC-01 |
|
|
AURORA$ORB$UNAUTHENTICATED |
|
OPEN |
SYSTEM |
TEMP |
26-DEC-01 |
|
|
DBSNMP |
|
OPEN |
SYSTEM |
TEMP |
07-MAR-02 |
|
|
DSIMPSON |
|
OPEN |
USERS |
TEMP |
27-DEC-01 |
|
|
HR |
|
OPEN |
SYSTEM |
TEMP |
26-DEC-01 |
|
|
MDSYS |
|
OPEN |
SYSTEM |
TEMP |
26-DEC-01 |
|
|
OE |
|
OPEN |
SYSTEM |
TEMP |
26-DEC-01 |
|
|
OLAPDBA |
|
OPEN |
SYSTEM |
TEMP |
26-DEC-01 |
|
|
OLAPSVR |
|
OPEN |
SYSTEM |
TEMP |
26-DEC-01 |
|
|
ORDPLUGINS |
|
OPEN |
SYSTEM |
TEMP |
26-DEC-01 |
|
|
ORDSYS |
|
OPEN |
SYSTEM |
TEMP |
26-DEC-01 |
|
|
OSE$HTTP$ADMIN |
|
OPEN |
SYSTEM |
TEMP |
26-DEC-01 |
|
|
OUTLN |
|
OPEN |
SYSTEM |
TEMP |
26-DEC-01 |
|
|
PM |
|
OPEN |
SYSTEM |
TEMP |
27-DEC-01 |
|
|
QS |
|
OPEN |
SYSTEM |
TEMP |
27-DEC-01 |
|
|
QS_ADM |
|
OPEN |
SYSTEM |
TEMP |
27-DEC-01 |
|
|
QS_CB |
|
OPEN |
SYSTEM |
TEMP |
27-DEC-01 |
|
|
QS_CBADM |
|
OPEN |
SYSTEM |
TEMP |
27-DEC-01 |
|
|
QS_CS |
|
OPEN |
SYSTEM |
TEMP |
27-DEC-01 |
|
|
QS_ES |
|
OPEN |
SYSTEM |
TEMP |
27-DEC-01 |
|
|
QS_OS |
|
OPEN |
SYSTEM |
TEMP |
27-DEC-01 |
|
|
QS_WS |
|
OPEN |
SYSTEM |
TEMP |
27-DEC-01 |
|
|
REPADMIN |
|
OPEN |
REPLICATION |
TEMP |
02-MAR-02 |
|
|
SH |
|
OPEN |
SYSTEM |
TEMP |
27-DEC-01 |
|
|
SYS |
|
OPEN |
SYSTEM |
TEMP |
26-DEC-01 |
|
|
SYSTEM |
|
OPEN |
SYSTEM |
TEMP |
26-DEC-01 |
|
|
| |
| |
| |
