The prefix for the default dump file name is awrdat_612_620.
To use this name, press
an alternative.
Enter value for file_name: awr_dump_612_620 --输入dump档名称，注意只要带.dmp后缀
Using the dump file prefix: awr_dump_612_620
|
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| The AWR extract dump file will be located
| in the following directory/file:
| /u01/awr_extr
| awr_dump_612_620.dmp --dump文件名称自动带上了.dmp后缀
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
| *** AWR Extract Started ...
|
| This operation will take a few moments. The
| progress of the AWR extract operation can be
| monitored in the following directory/file:
| /u01/awr_extr
| awr_dump_612_620.log
|
End of AWR Extract
SQL>
6、查看dump文件是否存在
| [oracle@INFA ~]$ cd /u01/awr_extr [oracle@INFA awr_extr]$ ls -l total 12780 -rw-r-----. 1 oracle oinstall 13058048 Aug 3 02:18 awr_dump_612_620.dmp -rw-r--r--. 1 oracle oinstall 25359 Aug 3 02:18 awr_dump_612_620.log |
不仅看到了导出的dmp文件，还看到了导出的log文件，导出成功。
本文作者：黎俊杰（网名：踩点），从事”系统架构、操作系统、存储设备、数据库、中间件、应用程序“六个层面系统性的性能优化工作
欢迎加入 系统性能优化专业群，共同探讨性能优化技术。群号：258187244