Successfully migrated an oracle database from filesystem to ASM. More or less it was easy…<\/p>\n
shutdown immediate
\nstartup mount
\nalter database archivelog;
\nstartup;<\/p>\n
[oracle@scada ~]$ rman target=\/<\/p>\n
Recovery Manager: Release 11.2.0.3.0 – Production on Mon Jun 3 19:35:59 2013<\/p>\n
Copyright (c) 1982, 2011, Oracle and\/or its affiliates. All rights reserved.<\/p>\n
connected to target database: DB (DBID=1578985198)<\/p>\n
RMAN> backup as copy incremental level 0 database format ‘+DATA’ tag ‘ORA_ASM_MIGRATION’;<\/p>\n
RMAN> restore spfile to ‘+DATA\/DB\/spfiledb.ora’;
\nRMAN> shutdown immediate<\/p>\n
mv $ORACLE_HOME\/dbs\/spfileDB.ora $ORACLE_HOME\/dbs\/spfileDB.ora.bak
\necho “SPFILE=’+DATA\/DB\/spfiledb.ora’ > $ORACLE_HOME\/dbs\/initDB.ora<\/p>\n
SQL> STARTUP FORCE NOMOUNT;
\nSQL> ALTER SYSTEM SET DB_CREATE_FILE_DEST=’+DATA’ SID=’*’;<\/p>\n
if ( FRA is used ) {
\nSQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=100G SID=’*’;
\nSQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+FRA’ SID=’*’;
\n}<\/p>\n
SQL> ALTER SYSTEM SET CONTROL_FILES=’+DATA’,’+DATA’ SCOPE=SPFILE SID=’*’;
\nSQL> SHUTDOWN IMMEDIATE<\/p>\n
RMAN> STARTUP FORCE NOMOUNT;
\nRMAN> RESTORE CONTROLFILE FROM ‘\/data\/oradata\/DB\/control01.ctl’;
\nRMAN> SWITCH DATABASE TO COPY;
\nRMAN> RECOVER DATABASE;<\/p>\n
SQL> alter database add logfile thread 1 size 100M;
\nSQL> alter database add logfile thread 1 size 100M;
\nSQL> alter database add logfile thread 1 size 100M;
\nSQL> select * from v$log;
\nSQL> select * from v$logfile;
\nSQL> alter database drop logfile group <nr>
\nSQL> alter database drop logfile member ‘\/u01\/oradata\/DB\/onlinelog\/o1_mf_2_8tssrbd8_.log’;
\nSQL> ..
\nSQL> alter system switch logfile;
\nSQL> alter system checkpoint global;
\nSQL> alter tablespace temp add tempfile size 2G;
\nSQL> alter tablespace temp drop tempfile ‘\/u00\/oradata\/DB\/temp01.dbf’;<\/p>\n","protected":false},"excerpt":{"rendered":"
Successfully migrated an oracle database from filesystem to ASM. More or less it was easy… shutdown immediate startup mount alter database archivelog; startup; [oracle@scada ~]$ rman target=\/ Recovery Manager: Release 11.2.0.3.0 – Production on Mon Jun 3 19:35:59 2013 Copyright (c) 1982, 2011, Oracle and\/or its affiliates. All rights reserved. connected to target database: DB … Continue reading Oracle database ASM migration….<\/span>