Database Reference
In-Depth Information
/u01/oradata/CDB2/redo02.log
/u01/oradata/CDB2/redo01.log
18 rows selected.
The database CDB2 which is about to be migrated has block change tracking enabled as well as flashback
database using a Fast Recovery Area in /u01/fra . Both of these must be disabled prior to the migration into ASM,
and any restore points must be dropped. Before dropping these please ensure with the change approval board that
these are not a life insurance for another change! During the next steps backups will be taken, creating image copies
of the database's components in ASM. The disk groups to be used are RECO for the Fast Recovery Area and DATA for
anything else. Begin by taking a backup of the database using RMAN.
RMAN> backup as copy incremental level 0 database
2> format '+DATA' tag 'CDB2_pre_migration';
Starting backup at 15.08.2013 17:53
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=10 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/oradata/CDB2/system01.dbf
output file name=+DATA/CDB2/DATAFILE/system.288.823542809 tag=CDB2_PRE_MIGRATION
RECID=3 STAMP=823542819
[...]
input datafile file number=00010 name=/u01/oradata/CDB2/MASTER/MASTER_users01.dbf
output file name=+DATA/CDB2/E4002A8CC0102B3AE0436638A8C0D53A/DATAFILE/users.282.823542887
tag=CDB2_PRE_MIGRATION RECID=11 STAMP=823542888
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 15.08.2013 17:54
Starting Control File and SPFILE Autobackup at 15.08.2013 17:54
piece handle=/u01/fra/CDB2/autobackup/2013_08_15/o1_mf_s_823542889_90t1yso5_.bkp
comment=NONE
Finished Control File and SPFILE Autobackup at 15.08.2013 17:54
RMAN> alter system switch logfile
Statement processed
The process will copy all the files as image copies into the disk group specified and switches the archive log. So far
so good! There are still components outside ASM which need to be moved as well, including the server parameter file
(you can't have a parameter file in ASM), the control files as well as the online redo logs. The server parameter file can
be backed up manually if you have not requested an automatic backup.
At this point the Oracle documentation recommends turning flashback off and drop all restore points if you
are moving the Fast Recovery Area into ASM as well which you probably should do. Furthermore the Block Change
Tracking feature must now be turned off if it was enabled as per the docs. With the initial preparations completed you
need to perform a clean shutdown of the database. In most cases “shutdown transactional” or “shutdown immediate”
 
Search WWH ::




Custom Search