查看oracle数据库数据文件控制文件日志文件

SQL> select name from v$datafile;数据文件

/u01/app/oracle/oradata/ZZW/system01.dbf
/u01/app/oracle/oradata/ZZW/sysaux01.dbf
/u01/app/oracle/oradata/ZZW/undotbs01.dbf
/u01/app/oracle/oradata/ZZW/pdbseed/system01.dbf
/u01/app/oracle/oradata/ZZW/pdbseed/sysaux01.dbf
/u01/app/oracle/oradata/ZZW/users01.dbf
/u01/app/oracle/oradata/ZZW/pdbseed/undotbs01.dbf
/u01/app/oracle/oradata/ZZW/pdb/system01.dbf
/u01/app/oracle/oradata/ZZW/pdb/sysaux01.dbf
/u01/app/oracle/oradata/ZZW/pdb/undotbs01.dbf
/u01/app/oracle/oradata/ZZW/pdb/users01.dbf

/u01/app/oracle/oradata/ZZW/fgedu01.dbf
/u01/app/oracle/oradata/ZZW/jojo01.dbf

13 rows selected.

SQL> show parameter pfile;

spfile string

SQL> select name from v$controlfile;控制文件

/u01/app/oracle/oradata/ZZW/control01.ctl
/u01/app/oracle/oradata/ZZW/control02.ctl

SQL> show parameter dump_dest;日志文件

NAME TYPE

background_dump_dest string
/u01/app/oracle/product/19.2.0
/db_1/rdbms/log
core_dump_dest string
/u01/app/oracle/diag/rdbms/zzw
/zzw/cdump
user_dump_dest string
/u01/app/oracle/product/19.2.0
/db_1/rdbms/log
SQL> select name from v$datafile;