sde for Oracle的物理迁移

测试环境:
ArcSDE9.3
Database:10.2.0.4
OS: window xp sp2

原数据库名称为test，网络服务名为test,位于esri-liufeng机器上，需要将数据库迁移到psdserver机器上
原理：
利用Recovery Manger对原数据库进行物理备份，将备份完后的备份文件利用操作系统工具cp到psdserver上，然后在techserver上新建立一个Oracle实例，利用启动的Oracle的实例，将数据库恢复到psdserver机器上。
规划：
恢复后的数据库是放在”e:/oraclebackup”目录中。

步骤:

1. 备份数据库
登陆到rman提示符状态下，rman target system/dbtest，同时记录下数据库的DBID=1958199029
输入:
Run
{
Configure controlfile autobackup on;
Configure controlfile autobackup format for device type disk to ‘e:/dest/controlfile%F.bak’;
Allocate channel ch1 type disk;
Allocate channel ch2 type disk
Backup database format ‘e:/dest/bkdatabase%u.bak’;
Release channel ch1;
Release channel ch2;
}



备份的文件位于e:/dest目录下面，分别是BKDATABASE1AJRDFBT.BAK，CONTROLFILEC-1958199029-20080924-01.BAK，BKDATABASE19JRDFBS.BAK。
2．将备份文件cp到psdserver上，考在e:/OracleBackup下。
3．在techserver上创建PFILE文件，位置位于d:/oraclebackup/inittest.ora
该文件中的内容如下
*.audit_file_dest='E:/oraclebackup/test/adump'
*.background_dump_dest='E:/oraclebackup/test/bdump'
*.compatible='10.2.0.2.0'
*.control_files='E:/OracleBackup/CONTROL01.CTL','E:/OracleBackup/CONTROL02.ctl'
*.core_dump_dest='E:/oraclebackup/test/cdump'
*.cursor_sharing='EXACT'
*.db_block_size=8192
*.db_domain='com.cn'
*.db_file_multiblock_read_count=16
*.db_name='test'
*.dispatchers='(service=xdb)(protocol=tcp)'
*.job_queue_processes=10
*.max_shared_servers=0
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=300
*.pga_aggregate_target=96468992
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_max_size=524288000
*.sga_target=419430400
*.shared_servers=0
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='D:/oraclebackup/test/udump'


4. 利用oradim命令创建一个实例(服务)
Oradim –NEW –SID test

5.启动实例，连接到idle实例上。
Set ORACLE_SID=test
Sqlplus sys as sysdba

6.利用刚刚创建的’e:/oraclebackup/inittest.ora文件启动到实际实例
Startup pfile=’e:/oraclebackup/inittest.ora’ nomount;

7.启动另一个控制台，运行
Set ORACLE_SID=test
Rman target/

8.设置DBID
Set dbid=1958199029

9.恢复控制文件。
运行restore controlfile from ‘e:/oraclebackup/CONTROLFILEC-1958199029-20080924-01.BAK

10．加载控制文件，将数据库启动到mount状态。
Alter database mount;

11．运行catalog start with ‘e:/oraclebackup’,将备份信息记录到控制文件中。

11.运行以下的命令，恢复数据库文件到e:/oraclebackup中
Run
{
Set newname for datafile 1 to ‘e:/oraclebackup/system01.dbf’;
Set newname for datafile 2 to ‘e:/oraclebackup/undotbs01.dbf’;
Set newname for datafile 3 to ‘e:/oraclebackup/.dbf’;
Set newname for datafile 4 to ‘e:/oraclebackup/users01.dbf’;
Set newname for datafile 5 to ‘e:/oraclebackup/example01.dbf’;
Set newname for datafile 6 to ‘e:/oraclebackup/sde.dbf’;
Set newname for datafile 7 to ‘e:/oraclebackup/lob.dbf’;
Set newname for datafile 8 to ‘e:/oraclebackup/test.dbf’;
Set newnanme for datafile 9 to ‘e:/oraclebackup/lf.dbf’;
Restore database;
Switch datafile all;
Recover database ;
}
Alter database open resetlogs;

文章来源：http://blog.csdn.net/liufeng1980423/article/details/6076815