Home Database Mysql Tutorial 在虚拟机上添加共享磁盘后节点2的ASM实例无法加载到

在虚拟机上添加共享磁盘后节点2的ASM实例无法加载到

Jun 07, 2016 pm 03:48 PM
asm shared load Example Add to disk node virtual

在节点1用DBCA给ASM增加磁盘图形过程比较容易,新建了两个目录分别是ARCHLOG和BACKUP. 可不能装载节点2上面! [oracle@node2bdump]$ export ORACLE_SID=+ASM2 [oracle@node2bdump]$ asmcmd ASMCMDll commands: -------- cd du find help ls lsct lsdg mkalias

在节点1用DBCA给ASM增加磁盘图形过程比较容易,新建了两个目录分别是ARCHLOG和BACKUP. 可不能装载节点2上面!

[oracle@node2bdump]$ export ORACLE_SID=+ASM2

[oracle@node2bdump]$ asmcmd

ASMCMD>ll

        commands:

        -------- 

        cd

        du

        find

        help

        ls

        lsct

        lsdg

        mkalias

        mkdir

        pwd

        rm

        rmalias

ASMCMD>ls

ARCHLOG/

BACKUP/

DATA/

ASMCMD>cd DATA

ASMCMD>ls

MYRAC/

ASMCMD>cd ..

ASMCMD>cd ARCHLOG

无法进入该目录

启动ASM实例

SQL>startup

ORA-32004:obsolete and/or deprecated parameter(s) specified

ASMinstance started

 

TotalSystem Global Area   92274688 bytes

FixedSize                  1217884 bytes

VariableSize              65890980 bytes

ASMCache                  25165824 bytes

ORA-15032:not all alterations performed

ORA-15003:diskgroup "DATA" already mounted in another lock name space

ORA-15003:diskgroup "BACKUP" already mounted in another lock name space

ORA-15003:diskgroup "ARCHLOG" already mounted in another lock name space

ASM实例已经存在

 

[oracle@node2dbs]$ ps -ef | grep asm_

oracle   26435    1  0 17:05 ?        00:00:00 asm_pmon_+ASM2

oracle   26437    1  0 17:05 ?        00:00:00 asm_diag_+ASM2

oracle   26439    1  0 17:05 ?        00:00:00 asm_psp0_+ASM2

oracle   26459    1  0 17:05 ?        00:00:01 asm_lmon_+ASM2

oracle   26461    1  0 17:05 ?        00:00:00 asm_lmd0_+ASM2

oracle   26463    1  0 17:05 ?        00:00:00 asm_lms0_+ASM2

oracle   26480    1  0 17:05 ?        00:00:00 asm_mman_+ASM2

oracle   26482    1  0 17:05 ?        00:00:00 asm_dbw0_+ASM2

oracle   26484    1  0 17:05 ?        00:00:00 asm_lgwr_+ASM2

oracle   26486    1  0 17:05 ?        00:00:00 asm_ckpt_+ASM2

oracle   26488    1  0 17:05 ?        00:00:00 asm_smon_+ASM2

oracle   26490    1  0 17:05 ?        00:00:00 asm_rbal_+ASM2

oracle   26492    1  0 17:05 ?        00:00:00 asm_gmon_+ASM2

oracle   26564    1  0 17:05 ?        00:00:00 asm_lck0_+ASM2

oracle   32297 24832 0 17:09 pts/1    00:00:00 grep asm_

 

exportORACLE_SID=+ASM2

sqlplus/ as sysdba

SQL>shutdown immediate;

SQL>conn / as sysdba

Connectedto an idle instance.

SQL>startup

ASMinstance started

TotalSystem Global Area   92274688 bytes

FixedSize                  1217884 bytes

VariableSize              65890980 bytes

ASMCache                  25165824 bytes

ORA-15032:not all alterations performed

ORA-15063:ASM discovered an insufficient number of disks for diskgroup

"BACKUP"

ORA-15063:ASM discovered an insufficient number of disks for diskgroup

"ARCHLOG"

 

查看ASM日志

Tail-100 /opt/oracle/database/admin/+ASM/bdump/alert_+ASM2.log

SQL>ALTER DISKGROUP ALL MOUNT

TueSep 25 17:52:30 2012

NOTE:cache registered group DATA number=1 incarn=0x28a105da

NOTE:cache registered group ARCHLOG number=2 incarn=0x25e105d8

NOTE:cache registered group BACKUP number=3 incarn=0x262105d9

TueSep 25 17:52:30 2012

LoadedASM Library - Generic Linux, version 2.0.4(KABI_V2) library for asmlib interface

TueSep 25 17:52:30 2012

NOTE:Hbeat: instance not first (grp 1)

ERROR: no PST quorum in group 2:required 1, found 0

Tue Sep 25 17:52:30 2012

NOTE: cache dismounting group2/0x25E105D8 (ARCHLOG)

NOTE: dbwr not being msg'd to dismount

ERROR: diskgroup ARCHLOG was not mounted

TueSep 25 17:52:30 2012

ERROR:no PST quorum in group 3: required 1, found 0

TueSep 25 17:52:30 2012

NOTE:cache dismounting group 3/0x262105D9 (BACKUP)

NOTE:dbwr not being msg'd to dismount

ERROR:diskgroup BACKUP was not mounted

NOTE:cache opening disk 0 of grp 1: VOL1 label:VOL1

NOTE:F1X0 found on disk 0 fcn 0.0

NOTE:cache opening disk 1 of grp 1: VOL2 label:VOL2

NOTE:cache mounting (not first) group 1/0x28A105DA(DATA)

TueSep 25 17:52:31 2012

kjbdomattsend to node 0

TueSep 25 17:52:31 2012

NOTE:attached to recovery domain 1

TueSep 25 17:52:32 2012

NOTE:opening chunk 1 at fcn 0.7142 ABA

NOTE:seq=42 blk=940

TueSep 25 17:52:32 2012

NOTE:cache mounting group 1/0x28A105DA(DATA) succeeded

SUCCESS:diskgroup DATA was mounted

TueSep 25 17:52:34 2012

NOTE:recovering COD for group 1/0x28a105da(DATA)

SUCCESS:completed COD recovery for group 1/0x28a105da(DATA)

 

关闭虚拟机 修改VMX文件增加

scsi1.sharedBus = "VIRTUAL"


Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to share wallpaperengine with friends How to share wallpaperengine with friends Mar 18, 2024 pm 10:00 PM

Users can share the wallpapers they obtain with friends when using WallpaperEngine. Many users do not know how to share WallpaperEngine with friends. They can save their favorite wallpapers locally and then share them with friends through social software. How to share wallpaperengine with friends Answer: Save it locally and share it with friends. 1. It is recommended that you save your favorite wallpapers locally and then share them with friends through social software. 2. You can also upload it to the computer through a folder, and then click Share using the creative workshop function on the computer. 3. Use Wallpaperengine on the computer, open the options bar of the creative workshop and find

How to share screen on WeChat Enterprise How to share screen on WeChat Enterprise Feb 28, 2024 pm 12:43 PM

More and more enterprises choose to use exclusive enterprise WeChat, which not only facilitates communication between enterprises and customers and partners, but also greatly improves work efficiency. Enterprise WeChat has rich functions, among which the screen sharing function is very popular. During the meeting, by sharing the screen, participants can display content more intuitively and collaborate more efficiently. So how to share your screen efficiently in WeChat Enterprise? For users who don’t know yet, this tutorial guide will give you a detailed introduction. I hope it can help you! How to share screen on WeChat Enterprise? 1. In the blue area on the left side of the main interface of Enterprise WeChat, you can see a list of functions. We find the "Conference" icon. After clicking to enter, three conference modes will appear.

Convert VirtualBox fixed disk to dynamic disk and vice versa Convert VirtualBox fixed disk to dynamic disk and vice versa Mar 25, 2024 am 09:36 AM

When creating a virtual machine, you will be asked to select a disk type, you can select fixed disk or dynamic disk. What if you choose fixed disks and later realize you need dynamic disks, or vice versa? Good! You can convert one to the other. In this post, we will see how to convert VirtualBox fixed disk to dynamic disk and vice versa. A dynamic disk is a virtual hard disk that initially has a small size and grows in size as you store data in the virtual machine. Dynamic disks are very efficient at saving storage space because they only take up as much host storage space as needed. However, as disk capacity expands, your computer's performance may be slightly affected. Fixed disks and dynamic disks are commonly used in virtual machines

How to add a TV to Mijia How to add a TV to Mijia Mar 25, 2024 pm 05:00 PM

Many users are increasingly favoring the electronic ecosystem of Xiaomi smart home interconnection in modern life. After connecting to the Mijia APP, you can easily control the connected devices with your mobile phone. However, many users still don’t know how to add Mijia to their homes. app, then this tutorial guide will bring you the specific connection methods and steps, hoping to help everyone in need. 1. After downloading Mijia APP, create or log in to Xiaomi account. 2. Adding method: After the new device is powered on, bring the phone close to the device and turn on the Xiaomi TV. Under normal circumstances, a connection prompt will pop up. Select "OK" to enter the device connection process. If no prompt pops up, you can also add the device manually. The method is: after entering the smart home APP, click the 1st button on the lower left

Windows 11 Folder Sharing Guide: Easily Share Your Files and Data Windows 11 Folder Sharing Guide: Easily Share Your Files and Data Mar 13, 2024 am 11:49 AM

In daily life and work, we often need to share files and folders between different devices. Windows 11 system provides convenient built-in folder sharing functions, allowing us to easily and safely share the content we need with others within the same network while protecting the privacy of personal files. This feature makes file sharing simple and efficient without worrying about leaking private information. Through the folder sharing function of Windows 11 system, we can cooperate, communicate and collaborate more conveniently, improving work efficiency and life convenience. In order to successfully configure a shared folder, we first need to meet the following conditions: All devices (participating in sharing) are connected to the same network. Enable Network Discovery and configure sharing. Know the target device

Stremio subtitles not working; error loading subtitles Stremio subtitles not working; error loading subtitles Feb 24, 2024 am 09:50 AM

Subtitles not working on Stremio on your Windows PC? Some Stremio users reported that subtitles were not displayed in the videos. Many users reported encountering an error message that said "Error loading subtitles." Here is the full error message that appears with this error: An error occurred while loading subtitles Failed to load subtitles: This could be a problem with the plugin you are using or your network. As the error message says, it could be your internet connection that is causing the error. So please check your network connection and make sure your internet is working properly. Apart from this, there could be other reasons behind this error, including conflicting subtitles add-on, unsupported subtitles for specific video content, and outdated Stremio app. like

How to increase disk size in VirtualBox [Guide] How to increase disk size in VirtualBox [Guide] Mar 17, 2024 am 10:10 AM

We often encounter situations where the predefined disk size has no room for more data? If you need more virtual machine hard disk space at a later stage, you must expand the virtual hard disk and partitions. In this post, we will see how to increase disk size in VirtualBox. Increasing the disk size in VirtualBox It is important to note that you may want to back up your virtual hard disk files before performing these operations, as there is always the possibility of something going wrong. It is always a good practice to have backups. However, the process usually works fine, just make sure to shut down your machine before continuing. There are two ways to increase disk size in VirtualBox. Expand VirtualBox disk size using GUI using CL

Shared printer cannot connect to printer Shared printer cannot connect to printer Feb 22, 2024 pm 01:09 PM

With the development of the digital era, shared printers have become an indispensable part of the modern office environment. However, sometimes we may encounter the problem that the shared printer cannot be connected to the printer, which will not only affect work efficiency, but also cause a series of troubles. This article aims to explore the reasons and solutions for why a shared printer cannot connect to the printer. There are many reasons why a shared printer cannot connect to the printer, the most common of which is network issues. If the network connection between the shared printer and the printer is unstable or interrupted, normal operation will not be possible.

See all articles