oracle backup filesの在り処

control,
data,
redo log file
の3つが同期しなくてはならない。

場所は以下

SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
/opt/oracle/app/oradata/orcl/control01.ctl
/opt/oracle/app/flash_recovery_area/orcl/control02.ctl

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/opt/oracle/app/oradata/orcl/system01.dbf
/opt/oracle/app/oradata/orcl/sysaux01.dbf
/opt/oracle/app/oradata/orcl/undotbs01.dbf
/opt/oracle/app/oradata/orcl/users01.dbf

SQL> desc v$logfile;
 名前                                    NULL?    型
 ----------------------------------------- -------- ----------------------------
 GROUP# 					    NUMBER
 STATUS 					    VARCHAR2(7)
 TYPE						    VARCHAR2(7)
 MEMBER 					    VARCHAR2(513)
 IS_RECOVERY_DEST_FILE				    VARCHAR2(3)

SQL> select group#,member from v$logfile;

    GROUP#
----------
MEMBER
--------------------------------------------------------------------------------
	 1
/opt/oracle/app/oradata/orcl/redo01.log

	 2
/opt/oracle/app/oradata/orcl/redo02.log

	 3
/opt/oracle/app/oradata/orcl/redo03.log


SQL>