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

ความคิดเห็น • 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)😊😊😊

  • @krishnaarekar1278
    @krishnaarekar1278 3 ปีที่แล้ว +1

    Thanks a ton sir for this video

    • @Mallik034
      @Mallik034  3 ปีที่แล้ว

      Most welcome

  • @ritasarma6591
    @ritasarma6591 2 ปีที่แล้ว

    Excellent!

  • @BHARARHROYAL
    @BHARARHROYAL 3 ปีที่แล้ว +1

    Good session sir

  • @praveenganesh3782
    @praveenganesh3782 2 ปีที่แล้ว

    Thank you 😊

  • @prabagarna801
    @prabagarna801 3 ปีที่แล้ว +1

    Pls upload more videos on performance tuning.

    • @Mallik034
      @Mallik034  3 ปีที่แล้ว

      Sure Prabagarn, more to come in upcoming days

  • @lucian1094
    @lucian1094 3 ปีที่แล้ว +1

    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 ปีที่แล้ว +1

      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.

  • @sahaniarunitm
    @sahaniarunitm 3 ปีที่แล้ว

    very nice