Sun Oracleworld
204 FOLLOWERS
Expert Database Consultancy & Solutions. All the post in this blog is my own opinion and all the steps are tested in test environment. Kindly review and test it before implementing in production. This Blog is intend to share & gain the knowledge of Oracle Technologies.
Sun Oracleworld
5y ago
How to Migrate Database from One Diskgroup to Another Diskgroup Step by Step 1 Prechecks collect the database file path name of the files in ASM diskgroupsSet your ORACLE_SID to the Database instance name. Get spfile location SQL> show parameter spfile Get database file locationsSQL> select name from v$controlfile union select name from v$datafile union select name from v$tempfile union select member from v$logfile union select filename from v$block_change_tracking Crosscheck asm diskgroup redundancy and available space in diskgroupSQL> select state,name,type, total_mb, fre ..read more