How to rename ORACLE_SID and move it to a new server? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

How to rename ORACLE_SID and move it to a new server?

How to rename ORACLE_SID and move it to a new server?# Database - 数据库

w*m2009-08-17 07:08

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

a*o2009-08-17 07:08

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