[oracle@localhost /]$ ./backup.sh
Begin backup databases.....CentOS5.1_gzga
导出前时间: 2008年 09月 25日 星期四 10:15:46 CSTExport: Release 10.2.0.1.0 - Production on Thu Sep 25 10:15:46 2008Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user KSXT
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user KSXT
About to export KSXT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export KSXT's tables via Conventional Path ...
. . exporting table EXAMINE 307 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table EXAMINECONDITION 1053 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table EXAMINEE 6 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table EXAMINEGROUP 109 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table EXAMINEPAPER 5 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table FUNCTION 222 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table GROUPINFO 12 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table HZPYDZB 6763 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table KEY 936 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table PARAMETER 9 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table ROLE 4 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table ROLEDATA 1 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table ROLEFUNCTION 253 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table TMP1 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table TMP2 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table TMP3 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table TMP4 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table TMP5 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table USERLOGIN 3933 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table USERPROFILE 4 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table USERROLE 7 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table USERUNSUCCESSLOG 107 rows exported
EXP-00091: Exporting questionable statistics.
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully with warnings.
Export mission over!
导出后时间: 2008年 09月 25日 星期四 10:16:00 CST
ftp: connect: Connection refused
**********************************************************************
#!/bin/bash
source ~/.bash_profile
echo "Begin backup databases.....CentOS5.1_gzga"
export ORACLE_HOME=/u01/app/oracle/product/10.2.0.1
export ORACLE_SID=gzga
#export NLS_LANG=US7ASCII
rq=`date +%y%m%d`
echo "导出前时间: " `date`
$ORACLE_HOME/bin/exp ksxt/1234 owner=ksxt file=/backup/exp_${rq}.dmp log=/backup/exp_${rq}.log
#$ORACLE_HOME/bin exp ksxt/1234 owner=ksxt file=/backup/exp_'%y%m%d'.dmp log=/backup/explog_'%y%m%d'.log
#cp /backup/*.dmp /root/
rq=`date +%y%m%d_%H`
echo "Export mission over!"
echo "导出后时间: " `date`
ftp -i -v -n 192.168.0.100 <<END请教错误原因,解决方法?
Begin backup databases.....CentOS5.1_gzga
导出前时间: 2008年 09月 25日 星期四 10:15:46 CSTExport: Release 10.2.0.1.0 - Production on Thu Sep 25 10:15:46 2008Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user KSXT
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user KSXT
About to export KSXT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export KSXT's tables via Conventional Path ...
. . exporting table EXAMINE 307 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table EXAMINECONDITION 1053 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table EXAMINEE 6 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table EXAMINEGROUP 109 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table EXAMINEPAPER 5 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table FUNCTION 222 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table GROUPINFO 12 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table HZPYDZB 6763 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table KEY 936 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table PARAMETER 9 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table ROLE 4 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table ROLEDATA 1 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table ROLEFUNCTION 253 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table TMP1 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table TMP2 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table TMP3 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table TMP4 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table TMP5 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table USERLOGIN 3933 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table USERPROFILE 4 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table USERROLE 7 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table USERUNSUCCESSLOG 107 rows exported
EXP-00091: Exporting questionable statistics.
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully with warnings.
Export mission over!
导出后时间: 2008年 09月 25日 星期四 10:16:00 CST
ftp: connect: Connection refused
**********************************************************************
#!/bin/bash
source ~/.bash_profile
echo "Begin backup databases.....CentOS5.1_gzga"
export ORACLE_HOME=/u01/app/oracle/product/10.2.0.1
export ORACLE_SID=gzga
#export NLS_LANG=US7ASCII
rq=`date +%y%m%d`
echo "导出前时间: " `date`
$ORACLE_HOME/bin/exp ksxt/1234 owner=ksxt file=/backup/exp_${rq}.dmp log=/backup/exp_${rq}.log
#$ORACLE_HOME/bin exp ksxt/1234 owner=ksxt file=/backup/exp_'%y%m%d'.dmp log=/backup/explog_'%y%m%d'.log
#cp /backup/*.dmp /root/
rq=`date +%y%m%d_%H`
echo "Export mission over!"
echo "导出后时间: " `date`
ftp -i -v -n 192.168.0.100 <<END请教错误原因,解决方法?
解决方案 »
- 高级SQL优化
- oracle对象怎么学啊
- 请教大家一个关于一对多双向关联的级联保存问题,集合采用<list>类型
- Oracle 数据库 (OLE DB) 不支持关键字: “provider”的问题
- oracle sql语句问题
- SQL语句查询到变化前记录
- 数据库语句和datawindow
- 一个很急的问题(java.sql.SQLException: ORA-00001: 违反唯一约束条件)
- BLOB字段的数据删除时要另外处理吗?(在线)
- oracle启动后自动关闭
- plsql下如何导出生产库里的所有用户/表空间/dblink的创建脚本(oracle)?
- 数据库里建表.有一项是Nullable这一项是什么意思?
http://topic.csdn.net/t/20030710/20/2014176.html再试一下:
在客户端的注册表HKEY_LOCAL_MACHINE->SOFTWARE->ORACLE->HOME0中,如无系统变量NLS_DATE_FORMAT,则“新建”->“字符串”,重命名为“NLS_DATE_FORMAT”,赋值为:“YYYY-MM-DD HH24:MI:SS”。 注册表修改后不必重启,再实施导入。
SQL> select tab1.aa||'_'||tab2.bb||'.'||tab3.cc from (select VALUE$ aa
from sys.props$ where name='NLS_LANGUAGE')tab1,(select VALUE$ bb
from sys.props$ where name='NLS_ISO_CURRENCY')tab2,(select VALUE$ cc
from sys.props$ where name='NLS_CHARACTERSET')tab3;TAB1.AA||'_'||TAB2.BB||'.'||TAB3.CC
--------------------------------------------------------------------------------AMERICAN_AMERICA.ZHS16GBK