No question at this time
DBA Top 10
1 M. Cadot 20800
2 A. Kavsek 14900
3 M. Hidayathullah ... 10800
4 B. Vroman 7900
5 P. Wisse 5300
6 T. Boles 4200
7 J. Schnackenberg 3800
8 K. Van Nieuwenhov... 2100
9 G. Van Cauter 1600
10 A. Hudspith 1500
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48052
Total active users1733
Act. users last 24h10
Act. users last hour0
Registered user hits last week395
Registered user hits last month1204
Go up

Migrating Raw devices to ASMLIB
Next thread: Oracle 11.2.0.4 and memory management
Prev thread: subquery using * instead of specific columns

Message Score Author Date
Dear all , Using rawdevices i configured asm fo...... Jill Salalila Aug 09, 2017, 14:11
Dear, Please check below mos note. How To Se...... Mirza Hidayathullah Baig Aug 10, 2017, 07:46
<b>SQL> startup force; ASM instance started </...... Jill Salalila Aug 12, 2017, 17:33

Follow up by mail Click here


Subject: Migrating Raw devices to ASMLIB
Author: Jill Salalila, Philippines
Date: Aug 09, 2017, 14:11, 68 days ago
Os info: oracle linux 5.5
Oracle info: 10.2.0.5
Message: Dear all ,

Using rawdevices i configured asm for 10g database.
It was up and running fine.

Again i installed asmlib and successfully added new diskgroup using asmlib.

Now how do i migrate existing db from raw device to asmlib. Even RDBMS and +ASM instance went down.

SQL> ALTER SYSTEM SET asm_diskstring = 'ORCL:VOL*' SCOPE=SPFILE;
System altered.

>>

SQL> startup force;
ASM instance started

Total System Global Area 83886080 bytes
Fixed Size 1272120 bytes
Variable Size 57448136 bytes
ASM Cache 25165824 bytes
ORA-15032: not all alterations performed
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "RECO"
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "FRA"
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA"

Please help me to solve this
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Migrating Raw devices to ASMLIB
Author: Mirza Hidayathullah Baig, United Kingdom
Date: Aug 10, 2017, 07:46, 68 days ago
Message: Dear,

Please check below mos note.

How To Setup ASM on Linux Using ASMLIB Disks, Raw Devices, Block Devices or UDEV Devices? (Doc ID 580153.1)

still not sure then check below troubleshooting assistant for more details.

Troubleshooting Assistant: Database Storage (Doc ID 1552419.2)

Regards
Mirza
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Migrating Raw devices to ASMLIB
Author: Jill Salalila, Philippines
Date: Aug 12, 2017, 17:33, 65 days ago
Message: SQL> startup force;
ASM instance started



Total System Global Area 83886080 bytes
Fixed Size 1272120 bytes
Variable Size 57448136 bytes
ASM Cache 25165824 bytes
ORA-15032: not all alterations performed
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "RECO"
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "FRA"
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA"


SQL> show parameter asm_diskgroups;


NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string FRA, RECO, DATA, DG_DATA, DG_FRA

SQL> select name from v$asm_diskgroup;
NAME
------------------------------
DG_DATA
DG_FRA


Is it possible to drop disk group in SQL prompt ?

SQL> drop diskgroup DATA including contents;
drop diskgroup DATA including contents
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15001: diskgroup "DATA" does not exist or is not mounted

Actually RECO , FRA, DATA - disk groups are not exist.
How do i drop those disk groups ?
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here