--*************************************************************************************************** RAT1 migration TO asm --*************************************************************************************************** SYS@RAT1 SQL>select * from v$block_change_tracking; STATUS ---------- FILENAME -------------------------------------------------------------------------------- BYTES ---------- ENABLED /u03/ARBPRDDB/oradata/RAT1_block_change.dbf 158401024 SYS@RAT1 SQL> SYS@STGTDB1 SQL>alter database disable block change tracking; Database altered. SYS@STGTDB1 SQL>alter database enable block change tracking USING FILE '+PROD_FRA/RAT1_block_change.dbf'; Database altered. SYS@STGTDB1 SQL> SYS@RAT1 SQL>show parameter recovery; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string db_recovery_file_dest_size big integer 0 recovery_parallelism integer 4 SYS@RAT1 SQL> SYS@STGTDB1 SQL> SYS@RAT1 SQL>set linesize 200 SYS@RAT1 SQL>col FILE_NAME format a80 SYS@RAT1 SQL>col TABLESPACE_NAME format a80 SYS@RAT1 SQL>select FILE_ID,FILE_NAME,TABLESPACE_NAME from dba_temp_files; FILE_ID FILE_NAME TABLESPACE_NAME ---------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- 2 /u03/ARBPRDDB/oradata/temp_backend_01.dbf TEMP_BACKEND SYS@RAT1 SQL> SYS@STGRAT1 SQL>select NAME,STATUS,BLOCK_SIZE,FILE_SIZE_BLKS from v$controlfile; NNAME STATUS BLOCK_SIZE FILE_SIZE_BLKS -------------------------------------------------------------------------------- ------- ---------- -------------- /u02/ARBPRDDB/oradata/arbi_ctl01.ctl 8192 4234 /u03/ARBPRDDB/oradata/arbi_ctl02.ctl 8192 4234 /u04/ARBPRDDB/oradata/arbi_ctl03.ctl 8192 4234 SYS@STGRAT1 SQL>select GROUP#,MEMBER from v$logfile SYS@RAT1 SQL>col member format a80 SYS@RAT1 SQL>/ GROUP# MEMBER ---------- -------------------------------------------------------------------------------- 1 /u06/ARBPRDDB/oradata/redo_01.log 1 /u05/ARBPRDDB/oradata/redo_01.log 2 /u06/ARBPRDDB/oradata/redo_02.log 2 /u05/ARBPRDDB/oradata/redo_02.log 3 /u06/ARBPRDDB/oradata/redo_03.log 3 /u05/ARBPRDDB/oradata/redo_03.log 4 /u06/ARBPRDDB/oradata/redo_04.log 4 /u05/ARBPRDDB/oradata/redo_04.log 5 /u06/ARBPRDDB/oradata/redo_05.log 5 /u05/ARBPRDDB/oradata/redo_05.log 6 /u06/ARBPRDDB/oradata/redo_06.log 6 /u05/ARBPRDDB/oradata/redo_06.log 12 rows selected. SYS@RAT1 SQL> Starting Control File and SPFILE Autobackup at 07-APR-11 piece handle=/u01/ARBPRDDB/app/oracle/product/1020/dbs/cfauRAT1_c-4264422613-20110407-00.f comment=NONE 1.Create the ASM instance in ASM_HOME /mnt/u01/ARBPRDDB/app/oracle/product/11.2.0/grid. 2.Create ASM Disk groups (RAT1_DATA, RAT1_FRA) 3.Change ORACLE_HOME and SID to STGTDB1 4.Run the following command $rman target / catalog rman/rman@rman RMAN>RUN { allocate channel d10 type disk; allocate channel d11 type disk; allocate channel d12 type disk; allocate channel d13 type disk; allocate channel d14 type disk; BACKUP AS COPY INCREMENTAL LEVEL 0 DATABASE FORMAT '+RAT1_DATA' TAG 'ORA_ASM_MIGRATION_RAT1-20110520'; } RMAN>sql'alter system archive log current'; exit. $sqlplus / as sysdba SYS@STGRAT1 SQL>create spfile='+RAT1_DATA/spfileSTGRAT1.ora' from pfile='/u01/ARBPRDDB/app/oracle/product/11.2.0/dbhome_1/dbs/initSTGRAT1.ora'; **** Stop all application pointing to STGRAT1 create table admn.testasm(lastupdated date); insert into admn.testasm values(sysdate); SYS@STGRAT1 SQL>select to_char(sysdate,'mon-dd-yyyy hh:mi:ss') from dual; TO_CHAR(SYSDATE,'MON -------------------- apr-07-2011 09:00:26 SYS@STGRAT1 SQL>/ TO_CHAR(SYSDATE,'MON -------------------- apr-07-2011 09:00:31 SYS@STGRAT1 SQL>commit; Commit complete. SYS@STGRAT1 SQL>select * from admn.testasm; LASTUPDAT --------- 07-APR-11 07-APR-11 07-APR-11 07-APR-11 07-APR-11 07-APR-11 07-APR-11 07-APR-11 07-APR-11 07-APR-11 10 rows selected. SYS@STGRAT1 SQL>select count(*) from admn.testasm; COUNT(*) ---------- 10 SYS@STGRAT1 SQL>alter system set DB_RECOVERY_FILE_DEST_SIZE=350G SID='RAT1'; System altered. SYS@STGRAT1 SQL>alter system set DB_RECOVERY_FILE_DEST='+RAT1_FRA' SID='RAT1'; System altered. RMAN>backup incremental level 1 for recover of copy with tag 'ORA_ASM_MIGRATION_RAT1-20110520' database format '/u07/ARBPRDDB/%d_bk_%s_%p_%t' ; RMAN>recover copy of database with tag 'ORA_ASM_MIGRATION_RAT1-20110520'; channel ORA_DISK_1: reading from backup piece /u07/ARBPRDDB/RAT1_bk_65348_1_751778219 channel ORA_DISK_1: piece handle=/u07/ARBPRDDB/RAT1_bk_65348_1_751778219 tag=ORA_ASM_MIGRATION_RAT1-20110520 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:26 Finished recover at 22-MAY-11 Starting Control File and SPFILE Autobackup at 22-MAY-11 piece handle=/u01/ARBPRDDB/app/oracle/product/11.2.0/dbhome_1/dbs/cfauTDB1_c-3569405059-20110522-03.f comment=NONE Finished Control File and SPFILE Autobackup at 22-MAY-11 run { BACKUP AS BACKUPSET SPFILE; RESTORE SPFILE TO "+RAT1_DATA/spfile"; } create spfile='+RAT1_DATA/spfileRAT1.ora' from pfile='/u01/ARBPRDDB/app/oracle/product/11.2.0/dbhome_1/dbs/initRAT1.ora'; RMAN> SHUTDOWN IMMEDIATE; database closed database dismounted Oracle instance shut down RMAN> STARTUP MOUNT; connected to target database (not started) Oracle instance started database mounted Total System Global Area 5344731136 bytes Fixed Size 2216200 bytes Variable Size 4244639480 bytes Database Buffers 1073741824 bytes Redo Buffers 24133632 bytes RMAN> BACKUP AS COPY CURRENT CONTROLFILE FORMAT '/u01/ARBPRDDB/oradba/pre-ASM-controfileSTGRAT120110522.ctl'; Starting backup at 22-MAY-11 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=932 device type=DISK channel ORA_DISK_1: starting datafile copy copying current control file output file name=/u01/ARBPRDDB/oradba/pre-ASM-controfileSTGRAT120110522.ctl tag=TAG20110522T033631 RECID=1570 STAMP=751779392 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01 Finished backup at 22-MAY-11 Starting Control File and SPFILE Autobackup at 22-MAY-11 piece handle=/u01/ARBPRDDB/app/oracle/product/11.2.0/dbhome_1/dbs/cfauTDB1_c-3569405059-20110522-04.f comment=NONE Finished Control File and SPFILE Autobackup at 22-MAY-11 RMAN> SHUTDOWN IMMEDIATE; database dismounted Oracle instance shut down RMAN> exit Recovery Manager complete. you have mail in /usr/spool/mail/oracle va-iperf01:STGRAT1:/u01/ARBPRDDB/app/oracle/product/11.2.0/dbhome_1/dbs> va-iperf01:STGRAT1:/u01/ARBPRDDB/app/oracle/product/11.2.0/dbhome_1/dbs>ls pfile*.ora pfilerat1.ora va-iperf01:STGRAT1:/u01/ARBPRDDB/app/oracle/product/11.2.0/dbhome_1/dbs>cat pfile*.ora spfile='+RAT1_DATA/spfileRAT1.ora' va-iperf01:STGRAT1:/u01/ARBPRDDB/app/oracle/product/11.2.0/dbhome_1/dbs> va-iperf01:STGRAT1:/u01/ARBPRDDB/app/oracle/product/11.2.0/dbhome_1/dbs>sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 7 21:24:48 2011 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SYS@STGRAT1 SQL> SYS@STGRAT1 SQL>startup nomount PFILE='/u01/ARBPRDDB/app/oracle/product/11.2.0/dbhome_1/dbs/pfilerat1.ora'; ORACLE instance started. Total System Global Area 5344731136 bytes Fixed Size 2216200 bytes Variable Size 4244639480 bytes Database Buffers 1073741824 bytes Redo Buffers 24133632 bytes SYS@STGRAT1 SQL> SYS@STGRAT1 SQL>alter system set control_files='+RAT1_DATA/arbi_ctl01.ctl','+RAT1_DATA/arbi_ctl02.ctl' scope=spfile sid='*'; System altered. SYS@STGRAT1 SQL>alter system set DB_RECOVERY_FILE_DEST_SIZE=400G SID='RAT1'; System altered. SYS@STGRAT1 SQL>alter system set DB_RECOVERY_FILE_DEST='+PROD_FRA' SID='RAT1'; System altered. alter system set log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST'; SYS@STGRAT1 SQL>shutdown immediate; ORA-01507: database not mounted ORACLE instance shut down. SYS@STGRAT1 SQL> SYS@STGRAT1 SQL>startup nomount PFILE='/u01/ARBPRDDB/app/oracle/product/11.2.0/dbhome_1/dbs/pfilerat1.ora'; ORACLE instance started. Total System Global Area 5344731136 bytes Fixed Size 2216200 bytes Variable Size 4244639480 bytes Database Buffers 1073741824 bytes Redo Buffers 24133632 bytes SYS@STGRAT1 SQL>exit va-iperf01:STGRAT1:/u01/ARBPRDDB/app/oracle/product/11.2.0/dbhome_1/dbs>rman target / catalog rman/rman@rman Recovery Manager: Release 11.2.0.1.0 - Production on Thu Apr 7 21:37:53 2011 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: STGRAT1 (not mounted) connected to recovery catalog database RMAN> RMAN> restore controlfile from '/u01/ARBPRDDB/app/oracle/product/11.2.0/dbhome_1/dbs/cfauTDB1_c-3569405059-20110522-04.f'; Starting restore at 07-APR-11 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=2330 device type=DISK channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:04 output file name=+RAT1_DATA/arbi_ctl01.ctl output file name=+RAT1_FRA/arbi_ctl02.ctl Finished restore at 07-APR-11 RMAN> alter database mount; database mounted released channel: ORA_DISK_1 RMAN> switch database to copy; ...................... ......................... datafile 188 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/tts_tsanteracdr_index.340.747857033" datafile 192 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/ts_ucx_data.408.747861363" datafile 198 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/ts_ucx_index.410.747861367" datafile 201 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/report_ts.399.747861307" datafile 333 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/sysaux.379.747860875" datafile 349 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/ts_archiver_data.395.747861255" datafile 350 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/ts_archiver_index.385.747861115" datafile 351 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/tts_tcdr_index.341.747857341" datafile 352 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/tts_tsanteracdr_index.342.747857517" datafile 353 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/tts_tcdr_index.343.747857593" datafile 354 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/tts_tsanteracdr_index.344.747857687" datafile 355 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/tts_tcdr_index.345.747857725" datafile 356 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/ts_scpcdr_data.406.747861361" datafile 357 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/ts_scpcdr_idx.384.747861061" RMAN> recover database; Starting recover at 07-APR-11 using channel ORA_DISK_1 starting media recovery archived log for thread 1 with sequence 20 is already on disk as file /u05/ARBPRDDB/oradata/redo_02.log archived log file name=/u05/ARBPRDDB/oradata/redo_02.log thread=1 sequence=20 media recovery complete, elapsed time: 00:00:01 Finished recover at 07-APR-11 run { set newname for tempfile 1 to '+RAT1_DATA'; set newname for tempfile 2 to '+RAT1_DATA'; switch tempfile all; } executing command: SET NEWNAME executing command: SET NEWNAME renamed tempfile 2 to +RAT1_DATA in control file SYS@STGRAT1 SQL>alter database open resetlogs; Database altered. SYS@STGRAT1 SQL>select * from admn.testasm; LASTUPDAT --------- 07-APR-11 07-APR-11 07-APR-11 07-APR-11 07-APR-11 07-APR-11 07-APR-11 07-APR-11 07-APR-11 07-APR-11 10 rows selected. SYS@STGRAT1 SQL> ALTER DATABASE ADD LOGFILE ('+RAT1_DATA/log1a.log', '+RAT1_DATA/log1b.log') SIZE 719M; ALTER DATABASE ADD LOGFILE ('+RAT1_DATA/log2a.log', '+RAT1_DATA/log2b.log') SIZE 719M; ALTER DATABASE ADD LOGFILE ('+RAT1_DATA/log3a.log', '+RAT1_DATA/log3b.log') SIZE 719M; ALTER DATABASE ADD LOGFILE ('+RAT1_DATA/log4a.log', '+RAT1_DATA/log4b.log') SIZE 719M; ALTER DATABASE ADD LOGFILE ('+RAT1_DATA/log5a.log', '+RAT1_DATA/log5b.log') SIZE 719M; ALTER DATABASE ADD LOGFILE ('+RAT1_DATA/log6a.log', '+RAT1_DATA/log6b.log') SIZE 719M; SYS@STGRAT1 SQL>alter system switch logfile; System altered. SYS@STGRAT1 SQL>/ System altered. SYS@STGRAT1 SQL>/ System altered. SYS@STGRAT1 SQL>/ System altered. SYS@STGRAT1 SQL>/ System altered. SYS@STGRAT1 SQL>/ System altered. SYS@STGRAT1 SQL>/ System altered. SYS@STGRAT1 SQL> ALTER DATABASE DROP LOGFILE GROUP 1; ALTER DATABASE DROP LOGFILE GROUP 2; ALTER DATABASE DROP LOGFILE GROUP 3; ALTER DATABASE DROP LOGFILE GROUP 4; ALTER DATABASE DROP LOGFILE GROUP 5; ALTER DATABASE DROP LOGFILE GROUP 6; SYS@STGRAT1 SQL>select GROUP#,STATUS,MEMBER from V$LOGFILE order by GROUP#; GROUP# STATUS MEMBER ---------- ------- -------------------------------------------------------------------------------- 7 /u06/ARBPRDDB/oradata/STGRAT1_srl0.f 8 /u06/ARBPRDDB/oradata/STGRAT1_srl1.f 9 /u06/ARBPRDDB/oradata/STGRAT1_srl2.f 10 /u06/ARBPRDDB/oradata/STGRAT1_srl3.f 11 /u06/ARBPRDDB/oradata/STGRAT1_srl4.f 12 /u06/ARBPRDDB/oradata/STGRAT1_srl5.f 13 /u06/ARBPRDDB/oradata/STGRAT1_srl6.f 14 +RAT1_DATA/log1a.log 14 +RAT1_FRA/log1b.log 15 +RAT1_DATA/log2a.log 15 +RAT1_FRA/log2b.log GROUP# STATUS MEMBER ---------- ------- -------------------------------------------------------------------------------- 16 +RAT1_DATA/log3a.log 16 +RAT1_FRA/log3b.log 17 +RAT1_DATA/log4a.log 17 +RAT1_FRA/log4b.log 18 +RAT1_DATA/log5a.log 18 +RAT1_FRA/log5b.log 19 +RAT1_DATA/log6a.log 19 +RAT1_FRA/log6b.log 19 rows selected. SYS@STGRAT1 SQL> SYS@STGRAT1 SQL>select group#,ARCHIVED,STATUS from v$standby_log; GROUP# ARC STATUS ---------- --- ---------- 7 YES UNASSIGNED 8 YES UNASSIGNED 9 YES UNASSIGNED 10 YES UNASSIGNED 11 YES UNASSIGNED 12 YES UNASSIGNED 13 YES UNASSIGNED 7 rows selected. alter database drop standby logfile group 7; alter database drop standby logfile group 8; alter database drop standby logfile group 9; alter database drop standby logfile group 10; alter database drop standby logfile group 11; alter database drop standby logfile group 13; SYS@STGRAT1 SQL>alter database drop standby logfile group 7; alter database drop standby logfile group 8; alter database drop standby logfile group 9; alter database drop standby logfile group 10; alter database drop standby logfile group 11; alter database drop standby logfile group 12; alter database drop standby logfile group 13; Database altered. SYS@STGRAT1 SQL> SYS@STGRAT1 SQL>select GROUP#,STATUS,MEMBER from V$LOGFILE order by GROUP#; GROUP# STATUS MEMBER ---------- ------- -------------------------------------------------------------------------------- 14 +RAT1_DATA/log1a.log 14 +RAT1_FRA/log1b.log 15 +RAT1_DATA/log2a.log 15 +RAT1_FRA/log2b.log 16 +RAT1_DATA/log3a.log 16 +RAT1_FRA/log3b.log 17 +RAT1_DATA/log4a.log 17 +RAT1_FRA/log4b.log 18 +RAT1_DATA/log5a.log 18 +RAT1_FRA/log5b.log 19 +RAT1_DATA/log6a.log GROUP# STATUS MEMBER ---------- ------- -------------------------------------------------------------------------------- 19 +RAT1_FRA/log6b.log 12 rows selected. Database altered. SYS@STGRAT1 SQL> Database altered. SYS@STGRAT1 SQL> Database altered. SYS@STGRAT1 SQL> Database altered. SYS@STGRAT1 SQL> Database altered. SYS@STGRAT1 SQL> SYS@STGRAT1 SQL> SYS@STGRAT1 SQL> SYS@STGRAT1 SQL> SYS@STGRAT1 SQL> SYS@STGRAT1 SQL> ************************************************************************************************** ************************************************************************************************** ************************************************************************************************** ************************************************************************************************** alter database enable block change tracking USING FILE '+RPTDB_FRA/RPTDB_block_change.dbf'; SQL> select NAME,STATUS,BLOCK_SIZE,FILE_SIZE_BLKS from v$controlfile; NAME STATUS BLOCK_SIZE FILE_SIZE_BLKS ---------------------------------------------------------------- ------- ---------- -------------- /u02/RPTDB/oradata/control01.ctl 16384 782 /u03/RPTDB/oradata/control02.ctl 16384 782 /u04/RPTDB/oradata/control03.ctl 16384 782 SQL> select GROUP#,MEMBER from v$logfile; GROUP# MEMBER ---------- ---------------------------------------------------------------- 5 /u05/RPTDB/oradata/log5a.log 5 /u06/RPTDB/oradata/log5b.log 4 /u05/RPTDB/oradata/log4a.log 4 /u06/RPTDB/oradata/log4b.log 3 /u05/RPTDB/oradata/log3a.log 3 /u06/RPTDB/oradata/log3b.log 2 /u05/RPTDB/oradata/log2a.log 2 /u06/RPTDB/oradata/log2b.log 1 /u05/RPTDB/oradata/log1a.log 1 /u06/RPTDB/oradata/log1b.log 10 rows selected. SQL> select FILE_NAME from dba_temp_files; FILE_NAME -------------------------------------------------------------------------------- /u03/RPTDB/oradata/temp02.dbf /u03/RPTDB/oradata/temp01.dbf SQL> $rman target / catalog rman/rman@rman RMAN>RUN { allocate channel d1 type disk; allocate channel d2 type disk; allocate channel d3 type disk; allocate channel d4 type disk; BACKUP AS COPY INCREMENTAL LEVEL 0 DATABASE FORMAT '+RPTDB_DATA' TAG 'ORA_ASM_MIGRATION_RPTDB0429'; } SQL> create spfile='+RPTDB_DATA/spfileSTGRPTDB.ora' from pfile='/u01/app/oracle/product/10gR2/dbs/initRPTDB.ora'; File created. SQL> create spfile='+RPTDB_DATA/spfileRPTDB.ora' from pfile='/u01/app/oracle/product/10gR2/dbs/initRPTDB.ora'; File created. SQL> create table admn.testasm(lastupdated date); Table created. SQL> insert into admn.testasm values(sysdate); 1 row created. SQL> / 1 row created. SQL> / 1 row created. SQL> / 1 row created. SQL> / 1 row created. SQL> / 1 row created. SQL> commit; Commit complete. SQL> select * from admn.testasm; LASTUPDAT --------- 25-APR-11 25-APR-11 25-APR-11 25-APR-11 19-APR-11 19-APR-11 19-APR-11 19-APR-11 19-APR-11 19-APR-11 10 rows selected. SQL> RMAN>sql'alter system archive log current'; exit. SQL> quit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options va-idb01:RPTDB:/u01/home/oracle $rman target / catalog rman/rman@rman Recovery Manager: Release 10.2.0.4.0 - Production on Tue Apr 19 21:34:35 2011 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: RPTDB (DBID=4032003294) connected to recovery catalog database RMAN> backup incremental level 1 for recover of copy with tag 'ORA_ASM_MIGRATION_RPTDB0429' format '/backup/RPTDB/level1_%d_bk_%s_%p_%t' database ; Starting backup at 19-APR-11 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=1062 devtype=DISK channel ORA_DISK_1: starting incremental level 1 datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset input datafile fno=00006 name=/u07/RPTDB/oradata/ts_cdr_view_dat_02.dbf input datafile fno=00019 name=/u07/RPTDB/oradata/ts_cdr_view_idx_03.dbf input datafile fno=00044 name=/u09/RPTDB/oradata/ts_scpcdragg_data09.dbf input datafile fno=00022 name=/u10/RPTDB/oradata/ts_voipdm_data01.dbf input datafile fno=00031 name=/u10/RPTDB/oradata/ts_voipdm_data02.dbf input datafile fno=00035 name=/u09/RPTDB/oradata/ts_scpcdragg_data06.dbf input datafile fno=00037 name=/u09/RPTDB/oradata/ts_scpcdragg_data07.dbf input datafile fno=00042 name=/u09/RPTDB/oradata/ts_scpcdragg_idx_10.dbf input datafile fno=00049 name=/u09/RPTDB/oradata/ts_scpcdragg_data10.dbf input datafile fno=00054 name=/u09/RPTDB/oradata/ts_scpcdragg_dat12.dbf input datafile fno=00056 name=/u09/RPTDB/oradata/ts_scpcdragg_dat13.dbf input datafile fno=00061 name=/u09/RPTDB/oradata/ts_scpcdragg_idx_18.dbf input datafile fno=00026 name=/u09/RPTDB/oradata/ts_scpcdragg_idx_04.dbf input datafile fno=00050 name=/u09/RPTDB/oradata/ts_scpcdragg_idx_14.dbf input datafile fno=00007 name=/u07/RPTDB/oradata/ts_cdr_view_idx_01.dbf input datafile fno=00014 name=/u12/RPTDB/oradata/ts_scpcdr_dat01.dbf input datafile fno=00025 name=/u09/RPTDB/oradata/ts_scpcdragg_idx_03.dbf input datafile fno=00033 name=/u09/RPTDB/oradata/ts_scpcdragg_idx_06.dbf input datafile fno=00039 name=/u09/RPTDB/oradata/ts_scpcdragg_idx_09.dbf input datafile fno=00048 name=/u09/RPTDB/oradata/ts_scpcdragg_idx_13.dbf input datafile fno=00021 name=/u09/RPTDB/oradata/ts_scpcdragg_idx_02.dbf input datafile fno=00051 name=/u09/RPTDB/oradata/ts_scpcdragg_idx_15.dbf input datafile fno=00085 name=/u07/RPTDB/oradata/ts_voipdm_data04.dbf input datafile fno=00068 name=/u09/RPTDB/oradata/ts_scpcdragg_dat16.dbf input datafile fno=00078 name=/u07/RPTDB/oradata/ts_scpcdragg_dat24.dbf input datafile fno=00046 name=/u10/RPTDB/oradata/ts_voipdm_data03.dbf input datafile fno=00079 name=/u07/RPTDB/oradata/ts_scpcdragg_dat23.dbf input datafile fno=00083 name=/u07/RPTDB/oradata/ts_scpcdragg_idx_28.dbf input datafile fno=00074 name=/u09/RPTDB/oradata/ts_scpcdragg_idx_21.dbf input datafile fno=00053 name=/u07/RPTDB/oradata/undotbs1-02.dbf input datafile fno=00090 name=/u07/RPTDB/oradata/ts_cdr_view_dat_05.dbf input datafile fno=00091 name=/u07/RPTDB/oradata/ts_cdr_view_dat_06.dbf input datafile fno=00064 name=/u04/RPTDB/oradata/undotbs1-03.dbf input datafile fno=00081 name=/u07/RPTDB/oradata/ts_scpcdragg_dat21.dbf input datafile fno=00084 name=/u07/RPTDB/oradata/ts_scpcdragg_idx_27.dbf input datafile fno=00015 name=/u12/RPTDB/oradata/ts_scpcdr_idx_01.dbf input datafile fno=00076 name=/u09/RPTDB/oradata/ts_scpcdragg_idx_24.dbf input datafile fno=00017 name=/u11/RPTDB/oradata/ts_nolog_idx_01.dbf input datafile fno=00003 name=/u03/RPTDB/oradata/sysaux01.dbf input datafile fno=00028 name=/u09/RPTDB/oradata/ts_summ_data01.dbf input datafile fno=00089 name=/u07/RPTDB/oradata/ts_scpcdragg_idx_30.dbf input datafile fno=00093 name=/u12/RPTDB/oradata/ts_scpcdr_dat02.dbf input datafile fno=00004 name=/u08/RPTDB/oradata/users01.dbf input datafile fno=00012 name=/u09/RPTDB/oradata/ts_utils_data01.dbf input datafile fno=00058 name=/u09/RPTDB/oradata/ts_utils_data02.dbf input datafile fno=00087 name=/u07/RPTDB/oradata/ts_summ_data03.dbf channel ORA_DISK_1: starting piece 1 at 19-APR-11 RMAN>recover copy of database with tag 'ORA_ASM_MIGRATION_RPTDB0429'; run { BACKUP AS BACKUPSET SPFILE; RESTORE SPFILE TO '+RPTDB_DATA/SPFILE.ora'; } Starting backup at 25-APR-11 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current SPFILE in backup set channel ORA_DISK_1: starting piece 1 at 25-APR-11 channel ORA_DISK_1: finished piece 1 at 25-APR-11 piece handle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/2kmam145_1_1 tag=TAG20110425T160837 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 25-APR-11 Starting Control File and SPFILE Autobackup at 25-APR-11 piece handle=/backup/RPTDB/cfauRPTDB_c-4032003294-20110425-02.f comment=NONE Finished Control File and SPFILE Autobackup at 25-APR-11 Starting restore at 25-APR-11 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: restoring SPFILE output file name=+RPTDB_DATA/spfile channel ORA_DISK_1: reading from backup piece /backup/RPTDB/cfauRPTDB_c-4032003294-20110425-02.f channel ORA_DISK_1: piece handle=/backup/RPTDB/cfauRPTDB_c-4032003294-20110425-02.f tag=TAG20110425T160840 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 Finished restore at 25-APR-11 RMAN> RMAN> SHUTDOWN IMMEDIATE; database closed database dismounted Oracle instance shut down RMAN> STARTUP MOUNT; connected to target database (not started) Oracle instance started database mounted Total System Global Area 5344731136 bytes Fixed Size 2216200 bytes Variable Size 4244639480 bytes Database Buffers 1073741824 bytes Redo Buffers 24133632 bytes RMAN> RMAN> BACKUP AS COPY CURRENT CONTROLFILE FORMAT '/backup/RPTDB/pre-ASM-controfile.ctl'; Starting backup at 25-APR-11 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=1302 device type=DISK channel ORA_DISK_1: starting datafile copy copying current control file output file name=/backup/RPTDB/pre-ASM-controfile.ctl tag=TAG20110425T161540 RECID=566 STAMP=749405741 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01 Finished backup at 25-APR-11 Starting Control File and SPFILE Autobackup at 25-APR-11 piece handle=/backup/RPTDB/cfauRPTDB_c-4032003294-20110425-03.f comment=NONE Finished Control File and SPFILE Autobackup at 25-APR-11 RMAN> RMAN> SHUTDOWN IMMEDIATE; database dismounted Oracle instance shut down RMAN> exit Recovery Manager complete. va-idb01:RPTDB:/u01/home/oracle $cd $ORACLE_HOME/dbs va-idb01:RPTDB:/u01/app/oracle/product/11.2.0/dbhome_1/dbs $ls pfile*.ora pfilerptdb.ora va-idb01:RPTDB:/u01/app/oracle/product/11.2.0/dbhome_1/dbs $cat pfilerptdb.ora spfile='+RPTDB_DATA/spfileRPTDB.ora' va-idb01:RPTDB:/u01/app/oracle/product/11.2.0/dbhome_1/dbs $sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 25 16:17:03 2011 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount pfile='/u01/app/oracle/product/11.2.0/dbhome_1/dbs/pfilerptdb.ora'; ORACLE instance started. Total System Global Area 5745586176 bytes Fixed Size 2217160 bytes Variable Size 1308625720 bytes Database Buffers 4429185024 bytes Redo Buffers 5558272 bytes SQL> SYS@STGRAT1 SQL>alter system set control_files='+RPTDB_DATA/rptdb_ctl01.ctl','+RPTDB_FRA/rptdb_ctl02.ctl' scope=spfile sid='*'; System altered. SYS@STGRAT1 SQL>alter system set DB_RECOVERY_FILE_DEST_SIZE=100G SID='RPTDB'; System altered. SYS@STGRAT1 SQL>alter system set DB_RECOVERY_FILE_DEST='+RPTDB_FRA' SID='RPTDB'; System altered. SYS@STGRAT1 SQL>shutdown immediate; ORA-01507: database not mounted ORACLE instance shut down. SYS@STGRAT1 SQL> SYS@STGRAT1 SQL>startup nomount PFILE='/u01/ARBPRDDB/app/oracle/product/11.2.0/dbhome_1/dbs/pfilerat1.ora'; ORACLE instance started. Total System Global Area 5344731136 bytes Fixed Size 2216200 bytes Variable Size 4244639480 bytes Database Buffers 1073741824 bytes Redo Buffers 24133632 bytes SYS@STGRAT1 SQL>exit va-iperf01:STGRAT1:/u01/ARBPRDDB/app/oracle/product/11.2.0/dbhome_1/dbs>rman target / catalog rman/rman@rman Recovery Manager: Release 11.2.0.1.0 - Production on Thu Apr 7 21:37:53 2011 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: STGRAT1 (not mounted) connected to recovery catalog database RMAN> RMAN> restore controlfile from '/backup/RPTDB/cfauRPTDB_c-4032003294-20110425-03.f'; Starting restore at 07-APR-11 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=2330 device type=DISK channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:04 output file name=+RAT1_DATA/arbi_ctl01.ctl output file name=+RAT1_FRA/arbi_ctl02.ctl Finished restore at 07-APR-11 RMAN> alter database mount; database mounted released channel: ORA_DISK_1 RMAN> switch database to copy; ...................... ......................... datafile 188 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/tts_tsanteracdr_index.340.747857033" datafile 192 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/ts_ucx_data.408.747861363" datafile 198 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/ts_ucx_index.410.747861367" datafile 201 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/report_ts.399.747861307" datafile 333 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/sysaux.379.747860875" datafile 349 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/ts_archiver_data.395.747861255" datafile 350 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/ts_archiver_index.385.747861115" datafile 351 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/tts_tcdr_index.341.747857341" datafile 352 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/tts_tsanteracdr_index.342.747857517" datafile 353 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/tts_tcdr_index.343.747857593" datafile 354 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/tts_tsanteracdr_index.344.747857687" datafile 355 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/tts_tcdr_index.345.747857725" datafile 356 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/ts_scpcdr_data.406.747861361" datafile 357 switched to datafile copy "+RAT1_DATA/stgrat1a/datafile/ts_scpcdr_idx.384.747861061" RMAN> recover database; Starting recover at 07-APR-11 using channel ORA_DISK_1 starting media recovery archived log for thread 1 with sequence 20 is already on disk as file /u05/ARBPRDDB/oradata/redo_02.log archived log file name=/u05/ARBPRDDB/oradata/redo_02.log thread=1 sequence=20 media recovery complete, elapsed time: 00:00:01 Finished recover at 07-APR-11 RMAN> run { set newname for tempfile 1 to '+RPTDB_DATA'; set newname for tempfile 2 to '+RPTDB_DATA'; switch tempfile all; } executing command: SET NEWNAME executing command: SET NEWNAME renamed tempfile 2 to +RPTDB_DATA in control file SYS@STGRAT1 SQL>alter database open resetlogs; Database altered. SYS@STGRAT1 SQL>select * from admn.testasm; LASTUPDAT --------- 07-APR-11 07-APR-11 07-APR-11 07-APR-11 07-APR-11 07-APR-11 07-APR-11 07-APR-11 07-APR-11 07-APR-11 10 rows selected. SQL> select GROUP#,MEMBER from v$logfile; SQL> select GROUP#,MEMBERS,STATUS from v$log; GROUP# MEMBERS STATUS ---------- ---------- ---------------- 1 2 ACTIVE 2 2 CURRENT 3 2 INACTIVE 4 2 INACTIVE 5 2 ACTIVE SQL> SYS@STGRAT1 SQL> ALTER DATABASE ADD LOGFILE ('+RPTDB_DATA/rptdblog1a.log', '+RPTDB_FRA/rptdblog1b.log') SIZE 719M; ALTER DATABASE ADD LOGFILE ('+RPTDB_DATA/rptdblog2a.log', '+RPTDB_FRA/rptdblog2b.log') SIZE 719M; ALTER DATABASE ADD LOGFILE ('+RPTDB_DATA/rptdblog3a.log', '+RPTDB_FRA/rptdblog3b.log') SIZE 719M; ALTER DATABASE ADD LOGFILE ('+RPTDB_DATA/rptdblog4a.log', '+RPTDB_FRA/rptdblog4b.log') SIZE 719M; ALTER DATABASE ADD LOGFILE ('+RPTDB_DATA/rptdblog5a.log', '+RPTDB_FRA/rptdblog5b.log') SIZE 719M; ALTER DATABASE ADD LOGFILE ('+RPTDB_DATA/rptdblog6a.log', '+RPTDB_FRA/rptdblog6b.log') SIZE 719M; SYS@STGRAT1 SQL>alter system switch logfile; System altered. SYS@STGRAT1 SQL>/ System altered. SYS@STGRAT1 SQL>/ System altered. SYS@STGRAT1 SQL>/ System altered. SYS@STGRAT1 SQL>/ System altered. SYS@STGRAT1 SQL>/ System altered. SYS@STGRAT1 SQL>/ System altered. SYS@STGRAT1 SQL> ALTER DATABASE DROP LOGFILE GROUP 1; ALTER DATABASE DROP LOGFILE GROUP 2; ALTER DATABASE DROP LOGFILE GROUP 3; ALTER DATABASE DROP LOGFILE GROUP 4; ALTER DATABASE DROP LOGFILE GROUP 5; ALTER DATABASE DROP LOGFILE GROUP 6; SYS@STGRAT1 SQL>select GROUP#,STATUS,MEMBER from V$LOGFILE order by GROUP#; GROUP# STATUS MEMBER ---------- ------- -------------------------------------------------------------------------------- 7 /u06/ARBPRDDB/oradata/STGRAT1_srl0.f 8 /u06/ARBPRDDB/oradata/STGRAT1_srl1.f 9 /u06/ARBPRDDB/oradata/STGRAT1_srl2.f 10 /u06/ARBPRDDB/oradata/STGRAT1_srl3.f 11 /u06/ARBPRDDB/oradata/STGRAT1_srl4.f 12 /u06/ARBPRDDB/oradata/STGRAT1_srl5.f 13 /u06/ARBPRDDB/oradata/STGRAT1_srl6.f 14 +RAT1_DATA/log1a.log 14 +RAT1_FRA/log1b.log 15 +RAT1_DATA/log2a.log 15 +RAT1_FRA/log2b.log GROUP# STATUS MEMBER ---------- ------- -------------------------------------------------------------------------------- 16 +RAT1_DATA/log3a.log 16 +RAT1_FRA/log3b.log 17 +RAT1_DATA/log4a.log 17 +RAT1_FRA/log4b.log 18 +RAT1_DATA/log5a.log 18 +RAT1_FRA/log5b.log 19 +RAT1_DATA/log6a.log 19 +RAT1_FRA/log6b.log 19 rows selected. SYS@STGRAT1 SQL> SYS@STGRAT1 SQL>select group#,ARCHIVED,STATUS from v$standby_log; GROUP# ARC STATUS ---------- --- ---------- 7 YES UNASSIGNED 8 YES UNASSIGNED 9 YES UNASSIGNED 10 YES UNASSIGNED 11 YES UNASSIGNED 12 YES UNASSIGNED 13 YES UNASSIGNED 7 rows selected. alter database drop standby logfile group 7; alter database drop standby logfile group 8; alter database drop standby logfile group 9; alter database drop standby logfile group 10; alter database drop standby logfile group 11; alter database drop standby logfile group 13; SYS@STGRAT1 SQL>alter database drop standby logfile group 7; alter database drop standby logfile group 8; alter database drop standby logfile group 9; alter database drop standby logfile group 10; alter database drop standby logfile group 11; alter database drop standby logfile group 12; alter database drop standby logfile group 13; Database altered. SYS@STGRAT1 SQL> SYS@STGRAT1 SQL>select GROUP#,STATUS,MEMBER from V$LOGFILE order by GROUP#; GROUP# STATUS MEMBER ---------- ------- -------------------------------------------------------------------------------- 14 +RAT1_DATA/log1a.log 14 +RAT1_FRA/log1b.log 15 +RAT1_DATA/log2a.log 15 +RAT1_FRA/log2b.log 16 +RAT1_DATA/log3a.log 16 +RAT1_FRA/log3b.log 17 +RAT1_DATA/log4a.log 17 +RAT1_FRA/log4b.log 18 +RAT1_DATA/log5a.log 18 +RAT1_FRA/log5b.log 19 +RAT1_DATA/log6a.log GROUP# STATUS MEMBER ---------- ------- -------------------------------------------------------------------------------- 19 +RAT1_FRA/log6b.log 12 rows selected. Database altered. SYS@STGRAT1 SQL> Database altered. SYS@STGRAT1 SQL> Database altered. SYS@STGRAT1 SQL> Database altered. SYS@STGRAT1 SQL> Database altered. SYS@STGRAT1 SQL> SYS@STGRAT1 SQL> SYS@STGRAT1 SQL> SYS@STGRAT1 SQL> SYS@STGRAT1 SQL> SYS@STGRAT1 SQL>