닫힌 백업 대상 확인 쿼리

1. data file

 

SQL> select name, status from v$datafile;

NAME                                                         STATUS
------------------------------------------------------------ -------
/app/oracle/oradata/testdb/system01.dbf                      SYSTEM
/app/oracle/oradata/testdb/sysaux01.dbf                      ONLINE
/app/oracle/oradata/testdb/undotbs01.dbf                     ONLINE
/app/oracle/oradata/testdb/users01.dbf                       ONLINE
/app/oracle/oradata/testdb/example01.dbf                     ONLINE
/app/oracle/oradata/testdb/test01.dbf                        ONLINE

6 rows selected.

 

 

2. redo log file

 

SQL> select a.group#, a.member, b.bytes/1024/1024 MB, b.archived, b.status
  2  from v$logfile a, v$log b
  3  where a.group#=b.group#
  4  order by 1,2;

    GROUP# MEMBER                                                               MB ARC STATUS
---------- ------------------------------------------------------------ ---------- --- ----------------
         1 /app/oracle/oradata/testdb/redo01_a.log                              50 YES INACTIVE
         1 /app/oracle/oradata/testdb/redo01_b.log                              50 YES INACTIVE
         2 /app/oracle/oradata/testdb/redo02_a.log                              50 NO  CURRENT
         2 /app/oracle/oradata/testdb/redo02_b.log                              50 NO  CURRENT
         3 /app/oracle/oradata/testdb/redo03_a.log                              50 YES INACTIVE
         3 /app/oracle/oradata/testdb/redo03_b.log                              50 YES INACTIVE

6 rows selected.

 

 

3. control file

 

SQL> select name from v$controlfile;

NAME
------------------------------------------------------------
/app/oracle/oradata/testdb/control01.ctl
/app/oracle/oradata/testdb/control02.ctl
/app/oracle/oradata/testdb/control03.ctl