郑州到范县物流加盟:[转载]ORACLE 9i下exp和imp备份实例
来源:百度文库 编辑:九乡新闻网 时间:2024/07/14 00:34:30
1 在主服务器上执行exp备份数据库
exp [email=system/oracle@orcl]system/oracle@orcl[/email] file=SC_200811101220.dmp owner=subcentrex full=y buffer=1024000
exp [email=system/oracel@orcl]system/oracel@orcl[/email] file=BS_200811101220.dmp owner=billing full=y buffer=1024000
[oracle@localhost oracle]$ exp file=SC_200811101220.dmp owner=subcentrex full=y buffer=1024000
[oracle@localhost oracle]$ exp file=BS_200811101220.dmp owner=billing full=y buffer=1024000
2 在备份服务器上新建数据库
2.1 删除用户
sql>drop user subcentrex cascade;
sql>drop user billing cascade;
2.2 删除空间,释放资源
sql>drop tablespace subcentrex including contents and datafiles;
sql>drop tablespace billing including contents and datafiles;
2.3 创建新用户
create tablespace subcentrex datafile '/usr/local/opt/oracle/oradata/subcentrex.dbf' size 1200m autoextend on next 100m maxsize 8192m segment space management auto;
sql>create tablespace billing datafile '/usr/local/opt/oracle/oradata/billing.dbf' size 1700m autoextend on next 100m maxsize 8192m segment space management auto;
2.4创建新的表空间和新用户
sql> create user subcentrex identified by admin default tablespace subcentrex temporary tablespace temp;
sql> create user billing identified by admin default tablespace billing temporary tablespace temp;
3 进入备用服务器的oracle目录,ftp把主服务器上的备份数据ge到备用服务器oracle目录下
4 imp数据库
imp [email=system/oracle@orcl]system/oracle@orcl[/email] fromuser=subcentrex touser=subcentrex file=SC_200811101220.dmp ignore=y
imp [email=system/oracle@orcl]system/oracle@orcl[/email] fromuser=billing touser=billing file=BS_200811101220.dmp ignore=y
转自:http://www.itpub.net/thread-1084601-1-1.html
exp [email=system/oracle@orcl]system/oracle@orcl[/email] file=SC_200811101220.dmp owner=subcentrex full=y buffer=1024000
exp [email=system/oracel@orcl]system/oracel@orcl[/email] file=BS_200811101220.dmp owner=billing full=y buffer=1024000
[oracle@localhost oracle]$ exp file=SC_200811101220.dmp owner=subcentrex full=y buffer=1024000
[oracle@localhost oracle]$ exp file=BS_200811101220.dmp owner=billing full=y buffer=1024000
2 在备份服务器上新建数据库
2.1 删除用户
sql>drop user subcentrex cascade;
sql>drop user billing cascade;
2.2 删除空间,释放资源
sql>drop tablespace subcentrex including contents and datafiles;
sql>drop tablespace billing including contents and datafiles;
2.3 创建新用户
create tablespace subcentrex datafile '/usr/local/opt/oracle/oradata/subcentrex.dbf' size 1200m autoextend on next 100m maxsize 8192m segment space management auto;
sql>create tablespace billing datafile '/usr/local/opt/oracle/oradata/billing.dbf' size 1700m autoextend on next 100m maxsize 8192m segment space management auto;
2.4创建新的表空间和新用户
sql> create user subcentrex identified by admin default tablespace subcentrex temporary tablespace temp;
sql> create user billing identified by admin default tablespace billing temporary tablespace temp;
3 进入备用服务器的oracle目录,ftp把主服务器上的备份数据ge到备用服务器oracle目录下
4 imp数据库
imp [email=system/oracle@orcl]system/oracle@orcl[/email] fromuser=subcentrex touser=subcentrex file=SC_200811101220.dmp ignore=y
imp [email=system/oracle@orcl]system/oracle@orcl[/email] fromuser=billing touser=billing file=BS_200811101220.dmp ignore=y
转自:http://www.itpub.net/thread-1084601-1-1.html
[转载]ORACLE 9i下exp和imp备份实例
Oracle数据库备份命令Exp/Imp-华军资讯
oracle的imp和exp的一些用法
Oracle 9i的备份和恢复机制
Oracle exp/imp导出导入工具的使用 - xxlinux.com
Imp exp使用全解.
[转载]ORACLE数据库备份方法
oracle 9i 和oracle 10g 和oracle 11g有什么区别
DevX.Me ? Oracle EXP
oracle跨版本导出EXP
Oracle 9i的数据类型
Oracle 9i的数据类型
DOS下备份和恢复
Oracle导入程序Imp的使用详解
手工创建oracle 9i数据库
Oracle 9i 各服务的作用
Oracle 9i初始化参数文件
oracle下?创建用户和grant命令
oracle 9i内存配置为动态分配的步骤
oracle不同版本间数据的导入导出/oracle IMP 命令详解
linux下oracle的自动启动和停止2
win7x64下成功安装ORACLE客户端和PLSQLDEV!
关于RAC和MSCS并存的问题? - Oracle专题深入讨论 - ITPUB论坛 - I...
对oracle实例的内存(SGA和PGA)进行调整,优化数据库性能