数据库冷迁移(路径不同)

1：创建数据库实例，,创建文件目录，创建密码文件

2：拷贝数据库文件到新

F:\app\Administrator\oradata\purplee>dir /a/bCONTROL01.CTLDRSYS01.DBFEXAMPLE01.DBFINDEX01.DBFINDEX_NEW01.DBFRBS01.DBFREDO01.LOGREDO02.LOGREDO03.LOGSYSAUX01.DBFSYSTEM01.DBFTEMP01.DBFTOOLS01.DBFUNDOTBS01.DBFUSERS01.DBFUSERS_NEW12.DBFUSERS_NEW201.DBF

3：修改参数文件control_file

SQL> show parameter control_fileNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------control_file_record_keep_time        integer     7control_files                        string      F:\APP\ADMINISTRATOR\ORADATA\P                                                 URPLEE\CONTROL01.CTL, F:\APP\A                                                 DMINISTRATOR\RECOVERY_AREA\PUR                                                 PLEE\CONTROL02.CTL

SQL>startup nomount
SQL> alter system set control_files='F:\app\Administrator\oradata\purple\contro01.ctl','F:\app\Administrator\recovery_area\purple\CONTROL02.CTL' scope=spfile;

SQL>shutdown abort

SQL>startup mount

SQL>

alter database rename file 'F:\app\Administrator\oradata\purplee\CONTROL01.CTL' to'F:\app\Administrator\oradata\purple\CONTROL01.CTL';alter database rename file 'F:\app\Administrator\oradata\purplee\DRSYS01.DBF' to'F:\app\Administrator\oradata\purple\DRSYS01.DBF';alter database rename file 'F:\app\Administrator\oradata\purplee\EXAMPLE01.DBF' to'F:\app\Administrator\oradata\purple\EXAMPLE01.DBF';alter database rename file 'F:\app\Administrator\oradata\purplee\INDEX01.DBF' to'F:\app\Administrator\oradata\purple\INDEX01.DBF';alter database rename file 'F:\app\Administrator\oradata\purplee\INDEX_NEW01.DBF' to'F:\app\Administrator\oradata\purple\INDEX_NEW01.DBF';alter database rename file 'F:\app\Administrator\oradata\purplee\RBS01.DBF' to'F:\app\Administrator\oradata\purple\RBS01.DBF';alter database rename file 'F:\app\Administrator\oradata\purplee\REDO01.LOG' to'F:\app\Administrator\oradata\purple\REDO01.LOG';alter database rename file 'F:\app\Administrator\oradata\purplee\REDO02.LOG' to'F:\app\Administrator\oradata\purple\REDO02.LOG';alter database rename file 'F:\app\Administrator\oradata\purplee\REDO03.LOG' to'F:\app\Administrator\oradata\purple\REDO03.LOG';alter database rename file 'F:\app\Administrator\oradata\purplee\SYSAUX01.DBF' to'F:\app\Administrator\oradata\purple\SYSAUX01.DBF';alter database rename file 'F:\app\Administrator\oradata\purplee\SYSTEM01.DBF' to'F:\app\Administrator\oradata\purple\SYSTEM01.DBF';alter database rename file 'F:\app\Administrator\oradata\purplee\TEMP01.DBF' to'F:\app\Administrator\oradata\purple\TEMP01.DBF';alter database rename file 'F:\app\Administrator\oradata\purplee\TOOLS01.DBF' to'F:\app\Administrator\oradata\purple\TOOLS01.DBF';alter database rename file 'F:\app\Administrator\oradata\purplee\UNDOTBS01.DBF' to'F:\app\Administrator\oradata\purple\UNDOTBS01.DBF';alter database rename file 'F:\app\Administrator\oradata\purplee\USERS01.DBF' to'F:\app\Administrator\oradata\purple\USERS01.DBF';alter database rename file 'F:\app\Administrator\oradata\purplee\USERS_NEW12.DBF' to'F:\app\Administrator\oradata\purple\USERS_NEW12.DBF';alter database rename file 'F:\app\Administrator\oradata\purplee\USERS_NEW201.DBF' to'F:\app\Administrator\oradata\purple\USERS_NEW201.DBF';

SQL>alter database open;

SQL> select name from v$datafile;NAME--------------------------------------------------------------------------------F:\APP\ADMINISTRATOR\ORADATA\PURPLE\SYSTEM01.DBFF:\APP\ADMINISTRATOR\ORADATA\PURPLE\SYSAUX01.DBFF:\APP\ADMINISTRATOR\ORADATA\PURPLE\UNDOTBS01.DBFF:\APP\ADMINISTRATOR\ORADATA\PURPLE\USERS01.DBFF:\APP\ADMINISTRATOR\ORADATA\PURPLE\EXAMPLE01.DBFF:\APP\ADMINISTRATOR\ORADATA\PURPLE\DRSYS01.DBFF:\APP\ADMINISTRATOR\ORADATA\PURPLE\INDEX_NEW01.DBFF:\APP\ADMINISTRATOR\ORADATA\PURPLE\INDEX01.DBFF:\APP\ADMINISTRATOR\ORADATA\PURPLE\RBS01.DBFF:\APP\ADMINISTRATOR\ORADATA\PURPLE\TOOLS01.DBFF:\APP\ADMINISTRATOR\ORADATA\PURPLE\USERS_NEW12.DBFF:\APP\ADMINISTRATOR\ORADATA\PURPLE\USERS_NEW201.DBF12 rows selected.