No question at this time
DBA Top 10
1 M. Cadot 11200
2 A. Kavsek 6000
2 B. Vroman 6000
4 P. Wisse 3400
5 J. Schnackenberg 3200
6 J. PĂ©ran 2000
7 T. Boles 600
8 Z. Hudec 400
8 G. Lambregts 400
8 N. Havard 400
8 F. Pachot 400
8 D. Dave 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48559
Total active users1398
Act. users last 24h3
Act. users last hour0
Registered user hits last week55
Registered user hits last month810
Go up

Accidentally remove diskgroup
Next thread: Your opinion regarding the autoupgrade new feature
Prev thread: lots of processes

Message Score Author Date
Hi, Can anyone help? I accidentally remove the ...... Ferdie Palero Jul 03, 2020, 08:57
Hi Ferdie, well, if you deleted the diskgroup u...... Jan Schnackenberg Jul 03, 2020, 12:13
Hi Sir Jan, If I restore using RMAN, do I need ...... Ferdie Palero Jul 03, 2020, 13:32
Hi Ferdie, yes. Diskgroups are no different tha...... Jan Schnackenberg Jul 03, 2020, 14:27
Hi Sir Jan, Do I need to create on both Node1 a...... Ferdie Palero Jul 03, 2020, 14:34
Honestly? If you have this little knowledge about ...... Score: 700 PtsScore: 700 PtsScore: 700 PtsScore: 700 PtsScore: 700 Pts Jan Schnackenberg Jul 03, 2020, 16:58
Hi Jan, ' Got it! thank you very much for the he...... Ferdie Palero Jul 04, 2020, 00:41

Follow up by mail Click here


Subject: Accidentally remove diskgroup
Author: Ferdie Palero, Philippines
Date: Jul 03, 2020, 08:57, 144 days ago
Os info: Lunix RedHat
Oracle info: Oracle 11
Message: Hi,

Can anyone help? I accidentally remove the diskgroup from the server using asmcmd. I am thinking to return it back, it is possible to restore using rman?

the diskgroup remove was;
OCR/
DATA/
UATDB/
etc.

Please advice.

Thank you in Advance,
FSPalero
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Accidentally remove diskgroup
Author: Jan Schnackenberg, Germany
Date: Jul 03, 2020, 12:13, 144 days ago
Message: Hi Ferdie,

well, if you deleted the diskgroup using asmcmd, it's gone.

While the actual datablocks on the LUNs might still be available, all the metadata, telling ASM which files exist and which allocation units they are using, is gone.

You'll have to restore from backup after manually rebuilding the diskgroup.

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

Subject: Re: Accidentally remove diskgroup
Author: Ferdie Palero, Philippines
Date: Jul 03, 2020, 13:32, 144 days ago
Message: Hi Sir Jan,

If I restore using RMAN, do I need to create first the diskgroup /REDO, /DATA, OCRVRD, FRA in asmcmd?

Thank you.

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

Subject: Re: Accidentally remove diskgroup
Author: Jan Schnackenberg, Germany
Date: Jul 03, 2020, 14:27, 144 days ago
Message: Hi Ferdie,

yes. Diskgroups are no different than partitions with filesystems.

in a way you just deleted the partition-table of your hard disk. You now have to recreate your filesystems (diskgroups) so Oracle can store it's files there.

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

Subject: Re: Accidentally remove diskgroup
Author: Ferdie Palero, Philippines
Date: Jul 03, 2020, 14:34, 144 days ago
Message: Hi Sir Jan,

Do I need to create on both Node1 and Node2?

Thank you in advance.

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

Subject: Re: Accidentally remove diskgroup
Author: Jan Schnackenberg, Germany
Date: Jul 03, 2020, 16:58, 144 days ago
Score:   Score: 700 PtsScore: 700 PtsScore: 700 PtsScore: 700 PtsScore: 700 Pts
Message: Honestly? If you have this little knowledge about RAC, is this really something you should do by yourself?

I'm all for learning on the job, but...

No, ASM-LUNs are shared between both nodes. Once you create an ASM diskgroup on one node, it will exist on both nodes.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Accidentally remove diskgroup
Author: Ferdie Palero, Philippines
Date: Jul 04, 2020, 00:41, 143 days ago
Message: Hi Jan,
'
Got it! thank you very much for the help appreciate.

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