Unlock Oracle

Ulock oracle after note shutdown during backup

 

xhost:/dev/diskgroup # ll
total 0
lrwxrwxrwx 1 root root 54 2015-12-14 14:50 dg_data -> /dev/disk/by-id/scsi-360022a11000e1c4c21965a9300000006
lrwxrwxrwx 1 root root 54 2015-12-14 14:50 dg_index -> /dev/disk/by-id/scsi-360022a11000e1c4c2196629300000007
lrwxrwxrwx 1 root root 8 2015-12-14 14:50 dg_ora -> /dev/sdb

xhost:/dev/diskgroup # su – grid

grid@xhost:~> crsctl stat res -t
——————————————————————————–
NAME TARGET STATE SERVER STATE_DETAILS
——————————————————————————–
Local Resources
——————————————————————————–
ora.DG_DATA.dg
ONLINE ONLINE xhost
ora.DG_INDEX.dg
OFFLINE OFFLINE xhost
ora.DG_ORA.dg
OFFLINE OFFLINE xhost
ora.LISTENER.lsnr
ONLINE ONLINE xhost
ora.asm
ONLINE ONLINE xhost Started
ora.ons
OFFLINE OFFLINE xhost
——————————————————————————–
Cluster Resources
——————————————————————————–

grid@xhost:~> crsctl start resource ora.DG_ORA.dg
CRS-2672: Attempting to start ‚ora.DG_ORA.dg‘ on ‚xhost‘
CRS-2676: Start of ‚ora.DG_ORA.dg‘ on ‚xhost‘ succeeded
grid@xhost:~> crsctl start resource ora.DG_INDEX.dg
CRS-2672: Attempting to start ‚ora.DG_INDEX.dg‘ on ‚xhost‘
CRS-2676: Start of ‚ora.DG_INDEX.dg‘ on ‚xhost‘ succeeded
grid@xhost:~> crs_stat -t
Name Type Target State Host
————————————————————
ora.DG_DATA.dg ora….up.type ONLINE ONLINE xhost
ora….NDEX.dg ora….up.type ONLINE ONLINE xhost
ora.DG_ORA.dg ora….up.type ONLINE ONLINE xhost
ora….ER.lsnr ora….er.type ONLINE ONLINE xhost
ora.asm ora.asm.type ONLINE ONLINE xhost
ora.cssd ora.cssd.type ONLINE ONLINE xhost
ora.diskmon ora….on.type OFFLINE OFFLINE
ora.evmd ora.evm.type ONLINE ONLINE xhost
ora.ons ora.ons.type OFFLINE OFFLINE
grid@xhost:~> exit

oracle@xhost:~> sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 20 10:12:58 2016

Copyright (c) 1982, 2011, Oracle. All rights reserved.

SQL> connect /as sysdba

SQL> startup
ORACLE instance started.

Total System Global Area 6413680640 bytes
Fixed Size 2240344 bytes
Variable Size 1778385064 bytes
Database Buffers 4613734400 bytes
Redo Buffers 19320832 bytes
Database mounted.
Database opened.
SQL> exit

Jan D.
Jan D.

"The only real security that a man will have in this world is a reserve of knowledge, experience, and ability."

Articles: 669

Leave a Reply

Vaše e-mailová adresa nebude zveřejněna. Vyžadované informace jsou označeny *