logo
Redian新闻
>未名空间
>Database - 数据库
>
How to rename ORACLE_SID and move it to a new server?
avatar
How to rename ORACLE_SID and move it to a new server?# Database - 数据库
w*m
1 楼
suppose I have a oracle instance A in server Aserver,
I want to move to to server Bserver with a new instance name B.
any suggestions?
rename it first, then move? Any technical details are appreciated.
Thanks
avatar
a*o
2 楼
what's your oracle version? 9i/10g/11g?
Use RMAN's duplicate database command,
Here is an example,
http://www.mcs.csueastbay.edu/support/oracle/doc/10.2/backup.102/b14191/rcmdupdb005.htm#i1009381
Example 13-3 Duplicating When Datafiles Use Inconsistent Paths
CONNECT TARGET /;
CONNECT CATALOG rman/[email protected];
CONNECT AUXILIARY SYS/[email protected];
# note that a RUN command is necessary because you can only execute SET
NEWNAME
# within a RUN command
RUN
{
# The DUPLICATE command uses an automatic s
相关阅读
选课求助新手想考oracle的DBA 认证，给点建议吧MySQL creator: version 5.1 released with "fatal bugs"(ZZ)what could be the problemrecommand a good forum of berkeleyDB?一个很平常的问题SQL SERVER 面试题, find the objectsHELP: where to get recovery_model_desc in sql server 2000?What's the difference between mysql4 and mysql5?请教制作网站shopping cart 的高手啊oracle的表名如何用变量代替请教一个有关 MSSQL 2005 Replication 的问题有人准备SQL Server 2008的考试吗？吐血了how to display a variableAvoid cursors in SQL Server with these methods to loop over records by Matthew Schroeder(转)请教如何将teradata的数据导入oracle?面试回来发考题1求教一个数据库面试题，多对多关系表设计 (转载)how to extract large number of rows from sql server?
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章，不代表同意其说法或描述，仅为提供更多信息，也不构成任何建议。文章信息的合法性及真实性由其作者负责，与Redian.news及其运营公司无关。欢迎投稿，如发现稿件侵权，或作者不愿在本网发表文章，请版权拥有者通知本网处理。