SQL> @?/rdbms/admin/awrload;
~~~~~~~~~~
AWR LOAD
~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~ This script will load the AWR data from a dump file. The ~
~ script will prompt users for the following information: ~
~ (1) name of directory object ~
~ (2) name of dump file ~
~ (3) staging schema name to load AWR data into ~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Specify the Directory Name
~~~~~~~~~~~~~~~~~~~~~~~~~~
Directory Name Directory Path
------------------------------ -------------------------------------------------
A /data/161025awr_bak
B /data/161028new_awr
DATA_PUMP_DIR /home/oracle/app/oracle/admin/jt/dpdump/
ORACLE_OCM_CONFIG_DIR /home/oracle/app/oracle/product/11.2.0/dbhome_1/c
cr/hosts/localhost.localdomain/state
ORACLE_OCM_CONFIG_DIR2 /home/oracle/app/oracle/product/11.2.0/dbhome_1/c
cr/state
XMLDIR /home/oracle/app/oracle/product/11.2.0/dbhome_1/r
dbms/xml
Directory Name Directory Path
------------------------------ -------------------------------------------------
Choose a Directory Name from the list above (case-sensitive).---->>>>>
Enter value for directory_name: a
Using the dump directory: a
declare
*
ERROR at line 1:
ORA-20103: directory name 'a' is invalid
ORA-06512: at line 17
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@localhost 161025awr_bak]$
awrload中的directory name是区分大小写的
最新推荐文章于 2021-04-02 23:32:20 发布