set pagesize 500
set linesize 130
Prompt
Prompt Control Files Location >>>>
col name format a60 heading "Control Files"
select name
from sys.v_$controlfile
/
Prompt
Prompt Redo Log File Locations >>>>
Prompt
col Grp format 9999
col member format a50 heading "Online REDO Logs"
col File# format 9999
col name format a50 heading "Online REDO Logs"
break on Grp
select group#,member
from sys.v_$logfile
/
Prompt Data Files Locations >>>>
col Tspace format a25
col status format a3 heading Sta
col Id format 9999
col Mbyte format 999999999
col name format a50 heading "Database Data Files"
col Reads format 99,999,999
col Writes format 99,999,999
break on report
compute sum label 'Total(MB)' of Mbyte on report
select F.file_id Id,
F.file_name name,
F.bytes/(1024*1024) Mbyte,
decode(F.status,'AVAILABLE','OK',F.status) status,
F.tablespace_name Tspace
from sys.dba_data_files F
order by tablespace_name;
Control Files Location >>>>
Control Files
------------------------------------------------------------
/u03/oradata/rcatp/control01.ctl
/u05/oradata/rcatp/control02.ctl
Redo Log File Locations >>>>
GROUP# Online REDO Logs
---------- --------------------------------------------------
1 /u03/oradata/rcatp/redo01.log
2 /u05/oradata/rcatp/redo02.log
3 /u03/oradata/rcatp/redo03.log
3 /u05/oradata/rcatp/redo03b.log
1 /u05/oradata/rcatp/redo01b.log
2 /u03/oradata/rcatp/redo02b.log
6 rows selected.
Data Files Locations >>>>
ID Database Data Files MBYTE Sta TSPACE
----- -------------------------------------------------- ---------- --- -------------------------
9 /u03/oradata/rcatp/patrol01.dbf 20 OK PATROL
7 /u03/oradata/rcatp/rman10p01.dbf 466 OK RMAN10P
5 /u03/oradata/rcatp/rman11p01.dbf 200 OK RMAN11P
8 /u03/oradata/rcatp/rman9p01.dbf 106 OK RMAN9P
3 /u03/oradata/rcatp/sysaux01.dbf 540 OK SYSAUX
1 /u03/oradata/rcatp/system01.dbf 700 OK SYSTEM
2 /u03/oradata/rcatp/undotbs01.dbf 220 OK UNDOTBS1
4 /u03/oradata/rcatp/users01.dbf 6 OK USERS
----------
sum 2258
8 rows selected.
No comments:
Post a Comment