TutorialDBA - Support | Training | Consultant

Oracle Database 10g Release 1 introduced Automatic Storage Management (ASM), a new framework for managing Oracle database files. ASM provides a foundation for highly efficient storage management with direct I/O, redundancy, striping and load balancing. Files stored on ASM are evenly distributed across disks in a disk group and mirrored according to the policies defined in the disk group. Since ASM provides an easy and highly efficient way to manage storage, it is the recommended file system for storing database files for RAC as well as single instance databases. The following types of database files can be stored in ASM diskgroups: Control files Datafiles, temporary datafiles, and datafile copies SPFILEs Online redo logs, archive logs, and Flashback logs RMAN backups Disaster recovery configurations Change tracking bitmaps Data Pump dumpsets To take advantage of ASM with an existing database using non-ASM storage, all or part of the database needs to be migrated into AS...

 In this tutorial i will explained step by step  Migration from non asm oracle database to asm oracle database  Simple Steps of database migration From  Non ASM  to ASM:: SET THE control_files and db_create_file_dest backup the database and archivelog with controlfile using rman utility SET THE control_files and db_create_file_dest to relevent asm disk shutdown the database startup the nomount mode and Restore the control file mount the database Backup Database Into Asm Disk Group Switch All Data Files To The New Asm Diskgroup Location recover the database open the database using resetlogs STEP 1. SET THE control_files and db_create_file_dest PARAMETER BEFORE BACKUP IF NOT SET  IN NON ASM DATABASE AND ALSO ENABLE ARCHIVELOG MODE SQL> alter system set control_files='/home/oracle/kfc/oradata/control/control01.ctl' scope=spfile; alter system set db_create_file_dest='/home/oracle/kfc/oradata/data/' scope=spfile; --The ALTER DATAB...

 In this tutorial  we  explained step by step  Migration from ASM oracle database to NON ASM oracle database  Simple Steps of database migration From ASM to Non ASM: backup the database and archivelog with controlfile using rman utility SET THE control_files and db_create_file_dest shutdown the database startup the nomount mode and Restore the control file mount the database create the directory for datafile Backup Database Into FILE SYSTEM Switch All Disk Datafile To The New File System Location recover the database open the database using resetlogs --check the asm disk state SQL> select name, path, mode_status, state, disk_number from v$asm_disk; NAME PATH MODE_ST STATE DISK_NUMBER -------------------- ------------------------------ ------- -------- ----------- ORCL:DISK1 ONLINE NORMAL 4 ORCL:DISK2 ON...