현재 사용중인 database를 구성하고 있는 파일의 정보를 본다.

SQL> select name from v$datafile
UNION
select member from v$logfile
UNION
select name from v$controlfile
UNION
select value from v$parameter where name in ('log_archive_dest',
'log_archive_duplex_dest');

SVRMGR> select name from v$datafile
2> UNION
3> select member from v$logfile
4> UNION
5> select name from v$controlfile
6> UNION
7> select value from v$parameter where name in ('log_archive_dest','log_archive_duplex_dest');
NAME
----------------------------------------------------------------------
/home/oracle/oradata/RUSH/control01.ctl
/home/oracle/oradata/RUSH/control02.ctl
/home/oracle/oradata/RUSH/control03.ctl
/home/oracle/oradata/RUSH/drsys01.dbf
/home/oracle/oradata/RUSH/indx01.dbf
/home/oracle/oradata/RUSH/rbs01.dbf
/home/oracle/oradata/RUSH/redo01.log
/home/oracle/oradata/RUSH/redo02.log
/home/oracle/oradata/RUSH/redo03.log
/home/oracle/oradata/RUSH/system01.dbf
/home/oracle/oradata/RUSH/temp01.dbf
/home/oracle/oradata/RUSH/tools01.dbf
/home/oracle/oradata/RUSH/users01.dbf
/home/oradata/data01.dbf

15 rows selected.
SVRMGR>

ctl 은 control file
dbf 는 data file
log 는 redo log file