restore the control file from different machine

This note is maily tell you how to restore the controlfile from different machine..


//construct a failure case of losing controlfile

[oracle@hundsun trade]$ ls -lrt
total 3118452
-rw-r–r– 1 oracle dba        930 Apr 13 06:46 init_trade.ora
-rw-r—– 1 oracle dba  524296192 Apr 16 22:00 temp01.dbf
-rw-r—– 1 oracle dba    5251072 May  7 21:07 users01.dbf
-rw-r—– 1 oracle dba 2147491840 May  7 21:07 TRADE.dbf
-rw-r—– 1 oracle dba   52429312 May  7 21:07 redo03.log
-rw-r—– 1 oracle dba   52429312 May  7 21:07 redo02.log
-rw-r—– 1 oracle dba  335552512 May  7 21:18 system01.dbf
-rw-r—– 1 oracle dba  241180672 May  7 21:20 sysaux01.dbf
-rw-r—– 1 oracle dba  277880832 May  7 21:20 undotbs01.dbf
-rw-r—– 1 oracle dba   52429312 May  7 21:20 redo01.log
-rw-r—– 1 oracle dba    7061504 May  7 21:20 control03.ctl
-rw-r—– 1 oracle dba    7061504 May  7 21:20 control02.ctl
-rw-r—– 1 oracle dba    7061504 May  7 21:20 control01.ctl
[oracle@hundsun trade]$ rm -rf control01.ctl
[oracle@hundsun trade]$ rm -rf control02.ctl
[oracle@hundsun trade]$ rm -rf control03.ctl


[oracle@hundsun trade]$ ls -lrt
total 3097728
-rw-r–r– 1 oracle dba        930 Apr 13 06:46 init_trade.ora
-rw-r—– 1 oracle dba  524296192 Apr 16 22:00 temp01.dbf
-rw-r—– 1 oracle dba    5251072 May  7 21:07 users01.dbf
-rw-r—– 1 oracle dba 2147491840 May  7 21:07 TRADE.dbf
-rw-r—– 1 oracle dba   52429312 May  7 21:07 redo03.log
-rw-r—– 1 oracle dba   52429312 May  7 21:07 redo02.log
-rw-r—– 1 oracle dba  335552512 May  7 21:18 system01.dbf
-rw-r—– 1 oracle dba  241180672 May  7 21:20 sysaux01.dbf
-rw-r—– 1 oracle dba  277880832 May  7 21:20 undotbs01.dbf
-rw-r—– 1 oracle dba   52429312 May  7 21:20 redo01.log
 

 

Continue reading “restore the control file from different machine”