Database Reference
In-Depth Information
Moving the database into ASM
If the decision has been made to consolidate databases in ASM, then it is a good idea to consider such move at time
of the migration. Migrating a database from a file system into ASM is quite straight-forward since Oracle 11g. In
summary you create an image copy of the database in ASM, and then switch to the database copy. This is very similar
to the recovery strategy where a full copy of the database is stored in the Fast Recovery Area which can be the target of
a (RMAN) switchover operation.
Before you are going to move the database into ASM you should first keep a log of where the files are located on
the file system. Files eligible for a move into ASM are:
•
Data files
•
Temp files
•
Control files
•
Server parameter file
Some other file types such as certain Data Pump files can also be created in ASM, but many users keep those
on a file system. If you are also moving an existing Flash Recovery Area into ASM then you need to drop all restore
points and disable flashback database before doing so. This may have implications on existing back-out strategies
for other changes, so better ensure there are no conflicts! Begin by checking your data and temp files. The below
database has very few data and temp files but please be aware that the number of physical files in a database
only extends the duration of the copy operation, otherwise a small database is moved into ASM using the same
techniques as a large one.
SQL> select name from v$datafile union all
2 select name from v$tempfile union all
3 select value from v$parameter2
4 where name in ('control_files','spfile') union all
5 select member from v$logfile
6 /
NAME
--------------------------------------------------------------------------------
/u01/oradata/CDB2/system01.dbf
/u01/oradata/CDB2/sysaux01.dbf
/u01/oradata/CDB2/undotbs01.dbf
/u01/oradata/CDB2/pdbseed/system01.dbf
/u01/oradata/CDB2/users01.dbf
/u01/oradata/CDB2/pdbseed/sysaux01.dbf
/u01/oradata/CDB2/MASTER/system01.dbf
/u01/oradata/CDB2/MASTER/sysaux01.dbf
/u01/oradata/CDB2/MASTER/MASTER_users01.dbf
/u01/oradata/CDB2/temp01.dbf
/u01/oradata/CDB2/pdbseed/pdbseed_temp01.dbf
/u01/oradata/CDB2/MASTER/temp01.dbf
/u01/app/oracle/product/12.1.0.1/dbhome_1/dbs/spfileCDB2.ora
/u01/oradata/CDB2/control01.ctl
/u01/fra/CDB2/control02.ctl
/u01/oradata/CDB2/redo03.log
Search WWH ::
Custom Search