RAC使用共享存储，使用数据泵导入时，数据文件存放位置查询

SQL> select file_name from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
+DBFILE1/orcl/datafile/users.283.880628015
+DBFILE1/orcl/datafile/undotbs1.282.880628015
+DBFILE1/orcl/datafile/sysaux.281.880628013
+DBFILE1/orcl/datafile/system.280.880628013
+DBFILE1/orcl/datafile/example.288.880628263
+DBFILE1/orcl/datafile/undotbs2.289.880628567
+DBFILE1/orcl/datafile/app_data.dbf
+DBFILE1/orcl/datafile/app_idx.dbf
+DBFILE1/orcl/datafile/statistics_data.dbf
+DBFILE1/orcl/datafile/user_data.dbf
+DBFILE1/orcl/datafile/check_recorddata_2013.dbf

FILE_NAME
--------------------------------------------------------------------------------
+DBFILE1/orcl/datafile/check_recorddata_2014.dbf
+DBFILE1/orcl/datafile/check_recorddata_2015.dbf
+DBFILE1/orcl/datafile/check_recorddata_2016.dbf

14 rows selected.

 

SQL> select * from dba_directories;

OWNER          DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
SYS          SUBDIR
/u01/app/oracle/product/11.2.0/db_1/demo/schema/order_entry//2002/Sep

SYS          SS_OE_XMLDIR
/u01/app/oracle/product/11.2.0/db_1/demo/schema/order_entry/

SYS          LOG_FILE_DIR
/u01/app/oracle/product/11.2.0/db_1/demo/schema/log/

OWNER          DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
SYS          MEDIA_DIR
/u01/app/oracle/product/11.2.0/db_1/demo/schema/product_media/

SYS          DATA_FILE_DIR
/u01/app/oracle/product/11.2.0/db_1/demo/schema/sales_history/

SYS          XMLDIR
/u01/app/oracle/product/11.2.0/db_1/rdbms/xml

OWNER          DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
SYS          ORACLE_OCM_CONFIG_DIR
/u01/app/oracle/product/11.2.0/db_1/ccr/hosts/rac1.localdomain/state

SYS          DATA_PUMP_DIR
/u01/app/oracle/product/11.2.0/db_1/rdbms/log/   ---数据泵文件存放位置

SYS          ORACLE_OCM_CONFIG_DIR2
/u01/app/oracle/product/11.2.0/db_1/ccr/state

9 rows selected.

查看数据库状态：

sql> select inst_id,instance_name,version,archiver,status from gv$instance;

   INST_ID INSTANCE_NAME    VERSION           ARCHIVE STATUS

---------- ---------------- ----------------- ------- ------------

         1 jssdbn1          10.2.0.4.0        STOPPED MOUNTED

         2 jssdbn2          10.2.0.4.0        STOPPED MOUNTED