Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database migration from Windows 10g to Linux 11g

j_DBA_souravMar 7 2012 — edited Mar 27 2012
Hello All,

We are having a small database in a windows 2003 server machine. We would be shift this database to another Linux platform. So far My action plan is as follows:-

1. Shutting down instance.

2. copying physical structure of Database

3. alter database backup control file to trace as '....sql';

4. Transfer all the files.

5. In the Linux server creating pfile and creating control file using following commad:-

CREATE CONTROLFILE REUSE DATABASE "DBNAME" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY
LOGFILE GROUP 1 '../REDO01.LOG' SIZE 50M,
GROUP 2 '../REDO02.LOG' SIZE 50M,
GROUP 3 '../REDO03.LOG' SIZE 50M
DATAFILE '../SYSTEM01.DBF',
'../UNDOTBS01.DBF',
'../SYSAUX01.DBF',
'../USERS01.DBF',
'../RMANTBS01.DBF'
CHARACTER SET WE8MSWIN1252
;

6. Opening the database in upgrade mode. I am getting error:


Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/COLDBACKUP_T1RMAN_POC/SYSTEM01.DBF'

Please help

-Reards,
Saha
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 24 2012
Added on Mar 7 2012
12 comments
1,100 views