DanBrother的部落格

Convert Controlfile to OMF:

# Current controlfile is none-OMF
sqlplus / as sysdba
sho parameter control_files

NAME           VALUE
-------------- --------------------------------------------------------
control_files  +DATA1/testdb/controlfile/control.ctl

Edit $ORACLE_HOME/dbs/inittestdb.ora
>>
control_files=('+DATA1','+DATA1','+DATA1')

sqlplus / as sysdba
shut immediate;
startup nomount pfile=$ORACLE_HOME/dbs/inittestdb.ora

RMAN> restore controlfile from '+DATA1/testdb/controlfile/control.ctl';

Starting restore at 05-AUG-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=3 device type=DISK

channel ORA_DISK_1: copied control file copy
output file name=+DATA1/testdb/controlfile/current.263.758384647
output file name=+DATA1/testdb/controlfile/current.264.758384649
output file name=+DATA1/testdb/controlfile/current.265.758384649
Finished restore at 05-AUG-11

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> alter database open;

database opened