After that, the database and instance names on the linux Server are changed from uppercase ORCL to lowercase orcl, and all the parameter files and password files are modified to decompress the cold backup.
After that, the database and instance names on the linux Server are changed from uppercase ORCL to lowercase orcl, and all the parameter files and password files are modified to decompress the cold backup.
Install a Windows 2008 Server 64 and Oracle, and then migrate the database to the Linux environment
Windows Server 2008-192.168.182.128 Oracle 11.2.0.3.0 ORACLE_SID = orcl
Oracle Enterprise Linux 5.8-192.168.182.131 Oracle 11.2.0.1.0 ORACLE_SID = ORCL
The process is the same as migrating a 10g Database to 11g. When modifying the control file script, you must modify the path and database name.
1 check information from PROD
On 128-windows oracle Server
Sqlplus/as sysdba
SYS @ orcl> select dbid from v $ database;
DBID
----------
1371889729
SYS @ orcl> create pfile = 'C: \ initorcl. ora 'from spfile;
File created.
SYS @ PROD1> alter database backup controlfile to trace;
Database altered.
SYS @ PROD1> show parameter user_dump
NAME TYPE VALUE
-----------------------------------------------------------------------------
User_dump_dest string C: \ oracle \ diag \ rdbms \ orcl
\ Trace
Cd C: \ oracle \ diag \ rdbms \ orcl \ trace
Copy the trc file to c: \ dbclone \ control.txt
And edit it:
From:
STARTUP NOMOUNT
Create controlfile reuse database "ORCL" RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
# MAXLOGHISTORY 292
LOGFILE
GROUP 1'/u01/app/oracle/oradata/ORCL/redo01.log' SIZE 50 m blocksize 512,
GROUP 2'/u01/app/oracle/oradata/ORCL/REDO02.LOG 'SIZE 50 m blocksize 512,
GROUP 3 '/u01/app/oracle/oradata/ORCL/redo03.log' SIZE 50 m blocksize 512
-- STANDBY LOGFILE
DATAFILE
'/U01/app/oracle/oradata/ORCL/system01.dbf ',
'/U01/app/oracle/oradata/ORCL/sysaux01.dbf ',
'/U01/app/oracle/oradata/ORCL/undotbs01.dbf ',
'/U01/app/oracle/oradata/ORCL/users01.dbf ',
'/U01/app/oracle/oradata/ORCL/example01.dbf'
Character set AL32UTF8
;
To:
STARTUP NOMOUNT
Create controlfile set database "ORCL" RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
# MAXLOGHISTORY 292
LOGFILE
GROUP 1'/u01/app/oracle/oradata/ORCL/redo01.log' SIZE 50 m blocksize 512,
GROUP 2'/u01/app/oracle/oradata/ORCL/REDO02.LOG 'SIZE 50 m blocksize 512,
GROUP 3 '/u01/app/oracle/oradata/ORCL/redo03.log' SIZE 50 m blocksize 512
-- STANDBY LOGFILE
DATAFILE
'/U01/app/oracle/oradata/ORCL/system01.dbf ',
'/U01/app/oracle/oradata/ORCL/sysaux01.dbf ',
'/U01/app/oracle/oradata/ORCL/undotbs01.dbf ',
'/U01/app/oracle/oradata/ORCL/users01.dbf ',
'/U01/app/oracle/oradata/ORCL/example01.dbf'
Character set AL32UTF8
;
2.2 cold backup tar-128 orcl
SYS @ orcl> select name from v $ dbfile;
NAME
--------------------------------------------------------------------------------
C: \ ORACLE \ ORADATA \ ORCL \ USERS01.DBF
C: \ ORACLE \ ORADATA \ ORCL \ UNDOTBS01.DBF
C: \ ORACLE \ ORADATA \ ORCL \ SYSAUX01.DBF
C: \ ORACLE \ ORADATA \ ORCL \ SYSTEM01.DBF
C: \ ORACLE \ ORADATA \ ORCL \ EXAMPLE01.DBF