Oracle Database-Backup Oracle for DMP type data

Liu Bei, for his later brain is not bright when you can find a place to flip.

The first part of the export of Oracle data

1. Database address and account password:

Database address: 10.10.10.132
Account Password: oracle/oracle

2. Log in using Xshell:

Enter address and user name

3. View the current DB instance name and installation address path

[[Email protected] abs_dmp]$ env |grep ORACLE--View current DB instance
ORACLE_SID=ORCL--by Oracle_sid=orcl ', the current DB instance is ' ORCL '
Oracle_base=/home/oracle/app
Oracle_home=/home/oracle/app/oracle/product/11.2.0/dbhome_1

4. Log in to the database using the Sqlplus command to view the character set

[[email protected] abs_dmp]$ sqlplus/as SYSDBA--Log in to the database using the Sqlplus command to view the character set
Sql*plus:release 11.2.0.3.0 Production on Thu Mar 31 05:45:29 2016
Copyright (c) 1982, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production
With the partitioning, OLAP, Data Mining and Real application testing options
Sql> Select Userenv (' language ') from dual; --View the character set encoding in the data

USERENV (' LANGUAGE ')
----------------------------------------------------
American_china. Zhs16gbk

Sql> Exit--Exit the SQL command line

--------------------------------Split symbol----------------------------------------------------------considerations start

In particular, it is important to note that without viewing the database character set, the problem of exporting garbled characters can be reported as a warning:

Exp-00091:exporting questionable statistics.
. . Exporting table Visual_theme_set 2 rows exported
Exp-00091:exporting questionable statistics.
Exp-00091:exporting questionable statistics.
. . Exporting table Web_analytics_config 0 rows exported
Exp-00091:exporting questionable statistics.
Exp-00091:exporting questionable statistics.
. . Exporting table Web_analytics_type 4 rows exported
Exp-00091:exporting questionable statistics.
Exp-00091:exporting questionable statistics.
Exp-00091:exporting questionable statistics.
. . Exporting table Web_app_source rows exported
Exp-00091:exporting questionable statistics.
Exp-00091:exporting questionable statistics.
. . Exporting table Web_app_source_permission 402 rows Exported
Exp-00091:exporting questionable statistics.
Exp-00091:exporting questionable statistics.
. . Exporting table Web_page 0 rows exported

--------------------------------Split symbol----------------------------------------------------------considerations End

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production
With the partitioning, OLAP, Data Mining and Real application testing options

[Email protected] abs_dmp]$ echo $NLS _lang--see if the value of the environment variable "Nls_lang" is American_america. Al32utf8 "
[Email protected] abs_dmp]$ export Nls_lang=american_america. Al32utf8--Modify the value of the environment variable "Nls_lang" to "American_america. Al32utf8 "
[[email protected] abs_dmp]$ echo $NLS _lang--see if the modified environment variable is successful
American_america. Al32utf8

--Export Data command
[[email protected] abs_dmp] $exp username/[email protected]_sid file=test.dmp log=./test.log--Export data
Imp username/[email protected]_sid file=test.dmp log=./test.log--Import data

Second, switch DB instance to export Oracle database

Oracle Database-Backup Oracle for DMP type data