Migration Non - Asm To Asm

By Unknown -
  1. First Add 4 Hard Disk in VMware.
  2. Start Machine.
  3. Then Go to Disk Management.
  4. Right Click on Unallocated Disk list. Then Click on initialize disk.
  5. Right Click on unallocated disk 1. Then Click on New Partition Then Next. Select option External Partition Button then Next --> Next --> Finish(Note:Repeat Step 5 for all Unallocated HDD).
  6. Unallocated HDD is a free space and color is Green.
  7. Right click on 1st HDD  Then Click on new logical drive Then Next -> Next --> Next 
  8. Click on do not Assign drive letter or Drive path option button Then Next
  9. Click on do not Format this partition option button Then Next ---> Finish.(Note: Repeat Step 5 for all Healthy HDD)
  10. Then free space HDD is healthy and color is Blue.
  11. Close Computer Management Window And Go to Command prompt.
  12. C:\>Documents And Settings\Administrator>Asmtoolg
  13. Asmtoolg Operation Window open.
  14. Click on Add or change label option. And then Next
  15. Then check status or ASM link name.These status is candidate device or ASM link name not set.
  16. Select All these Device Then Next-->Next-->Finish.
  17. Go to Command prompt.
  18. C:\>Documents And Settings\Administrator>DBCA
  19. Database Configuration Assistant Window open. Then Next
  20. Select Create database option button. Then Next -->Next
  21. Enter Global Database Name and SID = ASM
  22. Then Next -->Next
  23. Enter Password for all Accounts.(ADMIN)
  24. Select Automatic Storage Management (ASM).
  25. Then Next
  26. Error Message Show.
  27. Run this command in command prompt and install CSS.
  28. Then Next.
  29. Set ASM SYS Password-(ADMIN).
  30. Then Next.
  31. Click create new ( Create Diskgroup Window Open ).
  32. Enter Disk group Name.
  33. Select Any Redudency
    • High
    • Normal
    • External
  34. Select Disk path and enter Disk group name and Failgroup.
  35. Then OK. Then Next -->Next -->Next.
  36. Click on check box sample schemas.
  37. Then Next -->Next -->Next --> Finish.
  38. Asm Instance Installation Started.
  39. After the installation password window is open.
  40. Click on password management button.Set SCOTT, HR, OE, SH etc. user Password.
  41. Then ok. --->Click on Exit.
  42. After The Installation
  43. Go to Command prompt.
  44. C:\>Documents And Settings\Administrator>Set Oracle_Sid=+ASM
  45. Sqlplus Sys as sysdba
  46. Desc V$asm_disk.
  47. Select failgroup,name,path from V$asm_disk.
  48. Select failgroup,name,path,total_mb,free_mb from V$asm_disk.
  49. Create Normal Disk group and Failgroup(Add 2 Failgroup (2 way Mirroring)
    50.  Create Diskgroup Data Normal Redundancy   
                        Failgroup A Disk '\\.\ORCLDISKHDD10' Name Disk_A_1   
                        Failgroup A Disk '\\.\ORCLDISKHDD20' Name Disk_A_2  
                        Failgroup B Disk '\\.\ORCLDISKHDD30' Name Disk_B_1  
                        Failgroup B Disk '\\.\ORCLDISKHDD40' Name Disk_B_2;
  50. Create High Disk group and Failgroup(Add 3 Failgroup (3 way Mirroring)
    51.  Create Diskgroup Fra High Redundancy  
                        Failgroup X Disk '\\.\ORCLDISKHDD10' Name Disk_X_1  
                        Failgroup X Disk '\\.\ORCLDISKHDD20' Name Disk_X_2  
                        Failgroup Y Disk '\\.\ORCLDISKHDD30' Name Disk_Y_1  
                        Failgroup Y Disk '\\.\ORCLDISKHDD40' Name Disk_Y_2  
                        Failgroup Z Disk '\\.\ORCLDISKHDD50' Name Disk_Z_1  
                        Failgroup Z Disk '\\.\ORCLDISKHDD60' Name Disk_Z_2;

  51. Create External Disk group and Failgroup(Add only 1 Failgroup (No Mirroring)
    52.  Create Diskgroup Ext External Redundancy  
                       Failgroup EX1 Disk '\\.\ORCLDISKHDD10' Name Disk_X_1  
                       Failgroup EX2 Disk '\\.\ORCLDISKHDD20' Name Disk_X_1;
  52. Go to non ASM window.
  53. Show parameter db_create_file_dest.
  54. Set normal diskgroup data to db_create_file_dest.
  55. Alter system set db_create_file_dest='+Data' scope=spfile sid='*';
  56. show parameter Db_recovery_file_dest.
  57. Set High diskgroup Fra to Db_recovery_file_dest.
  58. Alter system set Db_recovery_file_dest='+Fra' scope=spfile sid='*';
  59. show parameter Db_recovery_file_dest_size.
  60. Alter system set Db_recovery_file_dest_size=5g scope=spfile sid='*';
  61. Shut immediate
  62. Startup
  63. Show parameter db_create_file_dest. --> Value= +Data
  64. Show parameter Db_recovery_file_dest -->Value= +Fra
  65. Show parameter Db_recovery_file_dest_size -->Value= 5g
  66. Select failgroup,name,path,total_mb,free_mb from V$asm_disk.
  67. Go to Non ASM window
  68. Shut immediate
  69. Startup Mount
  70. Alter database Archivelog;
  71. Alter Database Open;
  72. Open Rman Session ( Rman target / )
  73. Rman Auto Backup On;
  74. Take Copy Backup
    1.  run  
 {  
 Backup as copy  
 Incremental Level 0  
 database  
 Format '+Data'  
 Tag 'Ora_Asm_Migration'  
 }
  75. Shut Immediate
  76. exit
  77. Host Rman Target /
  78. Startup Nomount
  79. Restore spfile to '+Data/Spfileorcl' from '+Data/orcl/2015_01_14/Nnsnn0_ora_Asm_Migration_00.266.868942521';
  80. Go to C:\Oracle\Product\10.2.0\Db_1\dbs
  81. Drop spfileorcl.ora
  82. Go to C:\Oracle\Product\10.2.0\Db_1\database
  83. Open file initorcl.ora and set path SPFILE='+Data/Spfileorcl'
  84. Shut Immediate
  85. Startup Nomount
  86. Alter system set control_files='+Data' scope=spfile sid='*';
  87. Shut immediate
  88. Startup Nomount
  89. Show parameter Control_files.
  90. Host Rman target /
  91. Restore controlfile from '+Data/Orcl/controlfile/backup.265.868942517'; 
    1. ( Note: // Path Was Brought From The RMAN Backup Which You Have Takes Just Now! )
  92. Alter Database Mount;
  93. Show Parameter Control_file.
  94. Shut Immediate
  95. Startup Nomount
  96. Alter Database Mounr;
  97. Show parameter spfile;
  98. Show parameter control_file;
  99. Go ti Rman Target /
  100. Switch Database to Copy;
  101. Recover Database;
  102. Alter Database open Resetlogs; Or Alter database Open;
  103. Go to Sql Prompt --  Select Name From V$datafile;
  104. Select Member From v$logfile;
  105. Select * From V$log;
  106. Do not Drop current logfile Group;
  107. Alter database drop logfile Group 2 ;
  108. Alter database Add logfile Group 2 '+Data' ;
  109. Alter database drop logfile Group 3 ;
  110. Alter database Add logfile Group 3 '+Data' ;
  111. Alter System switch logfile;
  112. Alter system checkpoint;
  113. Alter database drop logfile Group 1 ;
  114. Alter database Add logfile Group 1 '+Data' ;
  115. Select Member from v$logfile;
  116. Show Parameter Spfile.
  117. Show Parameter Control_file.
  118. Select Name From V$datafile;
  119. Shut Immediate
  120. Startup

Comments

Post a Comment

Popular posts from this blog

Oracle Architecture - Explained In Detailed - Administration I

By -
Image
Figures shown in these notes are from Oracle® Database Concepts 11 g Release 2 Objectives These notes introduce the Oracle server architecture.   The architecture includes physical components, memory components, processes, and logical structures. Primary Architecture Components The figure shown above details the Oracle architecture. Oracle server :   An Oracle server includes an Oracle Instance and an Oracle database .   ·         An Oracle database includes several different types of files:   datafiles, control files, redo log files and archive redo log files.   The Oracle server also accesses parameter files and password files.   ·         This set of files has several purposes.   o    One is to enable system users to process SQL statements.   o    Another is to improve system performance.   o    Still another is to ensure the database can be recovered if there is a software/hardware failure. ·         The database server must manage large amo
Read more

Oracle Database SQL - Practise - Question - Scott Schema Examples

By -
Image
Oracle SQL Practice Questions for Students All Question are Based on Scott Schema Exhibits EMP TABLE Exhibits DEPT TABLE Exhibits SALGRADE TABLE Question 1) Display all the records in emp table? 2) Display all the records in emp table where employee belongs to deptno 10? 3) Display all the records in emp table where employee does not belong to deptno 30? 4) Display total number of records in Emp table? 5) Display emp table with salary descending order? 6) Display first five records in employee table? 7) Display all the records in emp table order by ascending deptno, descending salary? 8) Display all employees those who were joined in year 1981? 9) Display COMM in emp table. Display zero in place of null. 10) Display the records in emp table where MGR in 7698,7566 and sal should be greater then 1500 11) Display all employees where employees hired before 01-JAN-1981 12) Display all employees with
Read more

Step by Step - How to resolve redo log file corruption using ALTER DATABASE CLEAR UNARCHIVED LOGFILE command

By -
Image
Connect to sys using sqlplus in admin command prompt Check whether your database is in archive log mode or not. Run command ARCHIVE LOG LIST. It will show you the following details: It is always preferable to have your database in archive log mode. The reason being if your database is in archive log mode you can recover from all committed changes in the event of an OS or disk failure. This query will display the path of redo log files, their group and their status. It is always recommended to have a minimum of two members in one group. As you can see I have only 1 member in group 6 whose current status is INACTIVE. I intentionally have 1 member to generate a scenario for the sake of this practical. Now go to the specified path where the redo log member of group 6 is located and open it in a notepad. It will show some symbolic data. Delete couple of lines and save it the original location which is the one we got as a result of query. Why did we do the above step i.
Read more