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>