Redian新闻
>
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
相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。