Release Notes

3 Migrating an Oracle Database to Dell EMC SC Series Storage | CML1001
Table of contents
Revisions............................................................................................................................................................................. 2
Acknowledgements ............................................................................................................................................................. 2
Executive summary ............................................................................................................................................................. 5
1 Introduction ................................................................................................................................................................... 6
1.1 Audience ............................................................................................................................................................. 6
1.2 Purpose .............................................................................................................................................................. 6
2 SC Series overview ...................................................................................................................................................... 7
3 Storage migration planning and considerations ........................................................................................................... 9
3.1 Understand the environment .............................................................................................................................. 9
3.2 Define storage requirements .............................................................................................................................. 9
3.2.1 Performance ....................................................................................................................................................... 9
3.2.2 Capacity ............................................................................................................................................................ 10
3.3 Configure SC Series volumes for the database ............................................................................................... 10
3.3.1 Database volumes attributes ............................................................................................................................ 10
3.3.2 Protecting Oracle with snapshots and a consistency group ............................................................................. 12
3.3.3 Achieve greater storage efficiency with storage profiles .................................................................................. 12
3.4 Ingest data ........................................................................................................................................................ 14
3.5 Configure Oracle disk groups ........................................................................................................................... 15
3.5.1 Automatic Storage Management (ASM) ........................................................................................................... 15
3.5.2 Linux Logical Volume Manager (LVM) ............................................................................................................. 15
3.5.3 Oracle data files ................................................................................................................................................ 15
3.6 Understanding endian formats ......................................................................................................................... 15
3.6.1 Determine the system endian format................................................................................................................ 16
3.6.2 Determine the database endian format ............................................................................................................ 17
3.7 Selecting and executing the migration methodology ........................................................................................ 18
3.7.1 Oracle ASM ...................................................................................................................................................... 19
3.7.2 Linux LVM ......................................................................................................................................................... 19
3.7.3 Linux utilities ..................................................................................................................................................... 20
3.7.4 Oracle SQL Developer ..................................................................................................................................... 20
3.7.5 Transportable Tablespaces .............................................................................................................................. 20
3.7.6 Oracle export and import facilities .................................................................................................................... 21
3.7.7 RMAN ............................................................................................................................................................... 22