Тёмный

Database Startup and Shutdown Sequence in Standalone and RAC - What are database startup phases? 

Mallik034
Подписаться 21 тыс.
Просмотров 9 тыс.
50% 1

Database Startup and Shutdown Sequence in Standalone and RAC - What are database startup phases?
SQL-Plus Utility
SQL] startup --- Open Mode
SQL] startup nomount
SQL] alter database mount;
SQL] alter database open; or
SQL] startup
srvctl Utility
$ srvctl start database -d orcl -o nomount
$ srvctl start database -d orcl -o mount
$ srvctl start database -d orcl -o open
$ srvctl start database -d orcl
SQL-Plus Utility
SQL] shutdown transactional;
SQL] shutdown immediate; or
SQL] shutdown;
SQL] shutdown abort;
srvctl Utility
$ srvctl stop database -d orcl -o transactional
$ srvctl stop database -d orcl -o immediate
$ srvctl stop database -d orcl -o abort
$ srvctl stop database -d orcl
Startup and shutdown databases using OEM irrespective if standalone and RAC database
#sqlplus #srvctl #standalone #Startup #Shutdown #Database #Exadata #RAC #ASM #Oracle
Please do follow me and support me on,
LinkedIn: / mallik034
RU-vid: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg
Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848
Email: malluramadurg@gmail.com
LinkedIn: / mallik034
RU-vid: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg

Наука

Опубликовано:

 

6 дек 2020

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 13   
@saikumarraju8963
@saikumarraju8963 Год назад
Hi sir , i am seeing your videos from just 1 week really it is very helpfull for me.thank you soooo much sir. (From Andhrapradesh)😊😊😊
@ritasarma6591
@ritasarma6591 2 года назад
Excellent!
@praveenganesh3782
@praveenganesh3782 2 года назад
Thank you 😊
@krishnaarekar1278
@krishnaarekar1278 3 года назад
Thanks a ton sir for this video
@Mallik034
@Mallik034 3 года назад
Most welcome
@sahaniarunitm
@sahaniarunitm 3 года назад
very nice
@Mallik034
@Mallik034 3 года назад
Thanks
@BHARARHROYAL
@BHARARHROYAL 3 года назад
Good session sir
@Mallik034
@Mallik034 3 года назад
Thanks
@prabagarna801
@prabagarna801 3 года назад
Pls upload more videos on performance tuning.
@Mallik034
@Mallik034 3 года назад
Sure Prabagarn, more to come in upcoming days
@lucian1094
@lucian1094 3 года назад
Very nice video, ty! I have a setup with 19c RAC (2 nodes), 1cdb, 1 pdb. When I start the virtual machines I check crsctl stat (2 X Instance Shutdown,STABLE), next step is -- srvctl start database -d database_name, after this step, cdb is in open mode and the pdb is in mount mode. I expected that pdb to be in open mode also. Is it any srvctl command to open pdb (both instances)? Now I open pdb using "alter pluggable database pdb_name start instances=ALL;
@Mallik034
@Mallik034 3 года назад
by default your PDBs will goes to mount mode, You have to set defaut option as open mode for you PDBs so that the moment you open you CDB all your PDBs also get open.
Далее
Crossing the Most Dangerous Crosswalk
00:24
Просмотров 11 млн
RAC Database Spfile Or Pfile
12:11
Просмотров 766
SRVCTL and CRSCTL in Oracle RAC
50:19
Просмотров 22 тыс.
Красиво, но телефон жаль
0:32
Просмотров 1,5 млн
Prices & Poco M4 Pro 5G
1:00
Просмотров 271 тыс.