✎
编程开发网
首页
C语言
C++
面试
Linux
函数
Windows
数据库
下载
搜索
当前位置:
首页
->
基础
->
数据库编程
【使用rman复制数据库10g--clone-1】(四)
2015-01-22 21:38:58
·
作者:
·
浏览:
31
标签:
使用
rman
复制
数据库
10g--clone-1
oged datafile copy datafile copy filename=/u01/oracle/oradata/d10g/example01.dbf recid=4 stamp=863013929 datafile 2 switched to datafile copy input datafile copy recid=1 stamp=863013929 filename=/u01/oracle/oradata/d10g/undotbs01.dbf datafile 3 switched to datafile copy input datafile copy recid=2 stamp=863013929 filename=/u01/oracle/oradata/d10g/sysaux01.dbf datafile 4 switched to datafile copy input datafile copy recid=3 stamp=863013929 filename=/u01/oracle/oradata/d10g/users01.dbf datafile 5 switched to datafile copy input datafile copy recid=4 stamp=863013929 filename=/u01/oracle/oradata/d10g/example01.dbf contents of Memory Script: { Alter clone database open resetlogs; } executing Memory Script database opened Finished Duplicate Db at 07-NOV-14 RMAN> exit Recovery Manager complete. 验证是否clone成功: [oracle@oracle dbs]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Fri Nov 7 14:21:20 2014 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engine and Real Application Testing options SQL> select instance_name from v$instance; INSTANCE_NAME ---------------- d10g
1.密码文件问题
2.网络问题
3.参数问题
4.rman语句 db_file_name_convert 在同一个服务器设置语法有问题
5.注意必须要有备份,远程的话需要copy备份到目标库
首页
上一页
1
2
3
4
下一页
尾页
4
/4/4