Database migration from Windows 10g to Linux 11g
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