Database Startup and Shutdown Sequence in Standalone and RAC - What are database startup phases?
ฝัง
- เผยแพร่เมื่อ 21 ส.ค. 2024
- 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
TH-cam: / mallik034
Fakebook: / mallik034
Blog: mallik034.blog...
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg
Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848
Email: malluramadurg@gmail.com
LinkedIn: / mallik034
TH-cam: / mallik034
Fakebook: / mallik034
Blog: mallik034.blog...
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg
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)😊😊😊
Thanks a ton sir for this video
Most welcome
Excellent!
Good session sir
Thanks
Thank you 😊
Pls upload more videos on performance tuning.
Sure Prabagarn, more to come in upcoming days
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;
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.
very nice
Thanks