新特性：CDB/PDB的维护命令：查看cdb的相关文件信息

查看redo log信息：

SQL> col member format a45     

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

    GROUP# MEMBER                                         CON_ID
---------- --------------------------------------------- -------
         2 +DATA1/WHS1/ONLINELOG/group_2.263.1057318081        0
         1 +DATA1/WHS1/ONLINELOG/group_1.262.1057318081        0
         3 +DATA1/WHS1/ONLINELOG/group_3.270.1057318741        0
         4 +DATA1/WHS1/ONLINELOG/group_4.271.1057318743        0

查看控制文件：

SQL> col name format a50
SQL> select name , con_id from v$controlfile;

NAME                                                CON_ID
-------------------------------------------------- -------
+DATA1/WHS1/CONTROLFILE/current.261.1057318079           0

查看数据文件：

SQL> col file_name format a50
SQL> set linesize 150
SQL> col tablespace_name format a20
SQL>  select file_name,tablespace_name,file_id,con_id from cdb_data_files;

FILE_NAME                                          TABLESPACE_NAME         FILE_ID  CON_ID
-------------------------------------------------- -------------------- ---------- -------
+DATA1/WHS1/DATAFILE/system.257.1057317971         SYSTEM                        1       1
+DATA1/WHS1/DATAFILE/sysaux.258.1057318005         SYSAUX                        3       1
+DATA1/WHS1/DATAFILE/undotbs1.259.1057318021       UNDOTBS1                      4       1
+DATA1/WHS1/DATAFILE/users.260.1057318021          USERS                         7       1
+DATA1/WHS1/DATAFILE/undotbs2.269.1057318497       UNDOTBS2                      9       1