Database Guy
Database Guy
  • Видео 138
  • Просмотров 532 204
Oracle Database Recover from Old Control File Error ORA-01207
Oracle Database Recover from Old Control File Error
Error Received while Startup
ORA-01122: database file 1 failed verification check
ORA-01207: file is more recent than control file - old control file
Просмотров: 135

Видео

Oracle Database System File Needs Media Recovery (Missing Archive Logs)
Просмотров 20114 дней назад
Oracle Database System File Needs Media Recovery (Missing Archive Logs)
Oracle Database System File Needs Media Recovery (All Archive Logs Present)
Просмотров 17014 дней назад
Oracle Database System File Needs Media Recovery (All Archive Logs Present)
How to connect to DB2 Database
Просмотров 1,4 тыс.4 месяца назад
How to connect to DB2 Database
SQL Server Point in Time Restore
Просмотров 1424 месяца назад
Restore SQL Server Database to specific point in time.
Install MySQL on Windows
Просмотров 1264 месяца назад
Install MySQL on Windows
Install MySQL on LINUX
Просмотров 904 месяца назад
Install MySQL on LINUX
Oracle ASM Create New Disk Group
Просмотров 8314 месяца назад
Oracle ASM Create New Disk Group
Oracle OEM 13.5 On Windows Manage Data Guard
Просмотров 1824 месяца назад
Oracle OEM 13.5 On Windows Manage Data Guard
Oracle OEM 13.5 on Windows Add Target
Просмотров 5315 месяцев назад
Oracle OEM 13.5 on Windows Add Target
Oracle OEM 13.5 Installation on Windows Setup
Просмотров 1,6 тыс.5 месяцев назад
Timeline 00:00 Overview 03:15 Install Visual C Redistributable 06:40 Download Oracle 19c Database home & OEM 13.5 10:10 Pre-requisites for Oracle 19c Database Home 15:40 Set Environment Variables 17:40 Install Oracle 19c Database Home 19:27 Create Listener 21:30 Create Database for OEM Repository 26:48 Listener Static Registration 28:15 Database Configuration for OEM 30:00 Install OEM 42:20 Log...
Oracle 19c Data Guard on Windows Broker Setup
Просмотров 3055 месяцев назад
Link to Script www.dropbox.com/scl/fi/g18i0tnglf3z5qr3lo80o/Oracle-19c-Data-Guard-Broker-Setup-on-Windows.sql?rlkey=ahjc0fe0o725g2e194y1prg9v&dl=0
Oracle 19c Data Guard Configure Client/App Failover
Просмотров 5275 месяцев назад
Script Used www.dropbox.com/scl/fi/ph93ixpyhh8mz72vebn51/Oracle-19c-Data-Guard-Client-Failover.sql?rlkey=ky48lnh9v5rpxaeblcly7vhwj&dl=0
Oracle 19c Data Guard on Windows Step By Step Setup
Просмотров 1,8 тыс.5 месяцев назад
00:00 Introduction 12:00 Setup Environmental Variables 17:00 Create Listener 21:30 Create Primary Database 28:00 Setup DB Parameters on Primary 35:08 Setup Connectivity (listener.ora and tnsnames.ora) 41:30 Duplicate Database as Standby 50:00 Verify Data Guard Configuration 52:00 Perform Some Transactions 55:00 (Optional) Switch over 1:02:00 (Optional) Switch back 1:06:10 Conclusion Script Loca...
Oracle FULL vs INCREMENTAL LEVEL Backup
Просмотров 3946 месяцев назад
Oracle FULL vs INCREMENTAL LEVEL Backup
Oracle Backup Misconception No Archivelog Mode & Incremental Backup
Просмотров 2716 месяцев назад
Oracle Backup Misconception No Archivelog Mode & Incremental Backup
SQL Backup & Restore (Restore .bak file)
Просмотров 1356 месяцев назад
SQL Backup & Restore (Restore .bak file)
Oracle RAC Administration Basic Commands
Просмотров 2,8 тыс.6 месяцев назад
Oracle RAC Administration Basic Commands
Oracle RAC Concepts & Theory - Prepare for Interview
Просмотров 6 тыс.6 месяцев назад
Oracle RAC Concepts & Theory - Prepare for Interview
How to connect to Oracle RAC Database
Просмотров 5646 месяцев назад
How to connect to Oracle RAC Database
Oracle Database How to connect - Listener Configuration in Detail
Просмотров 7266 месяцев назад
Oracle Database How to connect - Listener Configuration in Detail
Oracle Database How to connect - Listener & TNSNAMES
Просмотров 1,1 тыс.6 месяцев назад
Oracle Database How to connect - Listener & TNSNAMES
Oracle Database How to connect - Basic Troubleshooting
Просмотров 6047 месяцев назад
Oracle Database How to connect - Basic Troubleshooting
Oracle RMAN Restore Database Like a Champion
Просмотров 4637 месяцев назад
Oracle RMAN Restore Database Like a Champion
How to take Oracle Database Backup Learn under 30 mins
Просмотров 4577 месяцев назад
How to take Oracle Database Backup Learn under 30 mins
Learn Oracle Data Pump In Detail - Logical Backup
Просмотров 1,2 тыс.7 месяцев назад
Learn Oracle Data Pump In Detail - Logical Backup
Learn Oracle Data Pump in 10 Mins - Logical Backup
Просмотров 4757 месяцев назад
Learn Oracle Data Pump in 10 Mins - Logical Backup
Oracle Restore Database on Windows Different Server on a Different Location
Просмотров 8297 месяцев назад
Oracle Restore Database on Windows Different Server on a Different Location
Oracle Restore Database on Windows Different Server
Просмотров 3247 месяцев назад
Oracle Restore Database on Windows Different Server
Oracle Restore Database on Windows on Same Server
Просмотров 2807 месяцев назад
Oracle Restore Database on Windows on Same Server

Комментарии

  • @wildanusman
    @wildanusman 17 часов назад

    Many thanks

  • @wildanusman
    @wildanusman 17 часов назад

    Normally if we execute lsnrctl status the status is READY. But yours was UNKNOWN. What was or were the reason(s) of that and how to solve that?

  • @wildanusman
    @wildanusman 18 часов назад

    Many thanks for this video. It's very crispy and clear..... 👍👍👍👍

  • @suzannesellers7383
    @suzannesellers7383 День назад

    Excellent, but is the prereqcheck built in? We used to run that before the instance install

    • @DB2_Oracle
      @DB2_Oracle День назад

      No, its not built in. Excellent point. Do not know how I missed it.

  • @dhanakumar3423
    @dhanakumar3423 День назад

    Thank you so much

  • @InsEtu-z5p
    @InsEtu-z5p 2 дня назад

    Can these steps be followed to perform an upgrade on Windows Server ?

    • @DB2_Oracle
      @DB2_Oracle 2 дня назад

      On windows just use DBUA to upgrade Oracle Database. Its part of installation.

  • @swacosta
    @swacosta 5 дней назад

    Very helpful! Thank you very much for creating these videos on OEM on Windows

    • @DB2_Oracle
      @DB2_Oracle 4 дня назад

      Thank you for the comment. Hope the video was useful.

  • @swacosta
    @swacosta 5 дней назад

    There are so many Oracle videos for Linux. It's so nice to see a well-done video that focuses on Windows. Thank You!

    • @DB2_Oracle
      @DB2_Oracle 4 дня назад

      Thank you for the nice comment. I hope you liked the content.

  • @vedashwi
    @vedashwi 5 дней назад

    thank u so much

  • @thetradesecrets2221
    @thetradesecrets2221 5 дней назад

    If ocr is not present , then how come your ASM came up?

    • @DB2_Oracle
      @DB2_Oracle 4 дня назад

      By starting in exclusive mode.

  • @Klick-s2r
    @Klick-s2r 6 дней назад

    Thanks a lot. Excellent presentation!

  • @PankajJaiswal11
    @PankajJaiswal11 6 дней назад

    Please share the document you have shown in the video

  • @pawansonole9127
    @pawansonole9127 7 дней назад

    Sir can you share same steps for mac os

    • @DB2_Oracle
      @DB2_Oracle 7 дней назад

      I am a windows pc user and donot have mac os pc

  • @PatrickBlack-v9i
    @PatrickBlack-v9i 9 дней назад

    Williams Shirley Miller John Lopez Michelle

  • @LiaqatAli-tn9np
    @LiaqatAli-tn9np 9 дней назад

    Awesome Video

  • @winnithrebello
    @winnithrebello 10 дней назад

    very well explained

  • @abdulrehmanbutt
    @abdulrehmanbutt 11 дней назад

    Very good and informative video I have configured OEM using this video. Thanks

  • @LiaqatAli-tn9np
    @LiaqatAli-tn9np 11 дней назад

    Great Video Sir ❤ very informative

  • @ulugbektaylakov7203
    @ulugbektaylakov7203 13 дней назад

    I am getting this error. Windows Server 2002. Can you help? ORA-28759: could not open file

  • @pedrokarandeniya162
    @pedrokarandeniya162 13 дней назад

  • @shadatshaikh8468
    @shadatshaikh8468 14 дней назад

    Hi, Can anyone tell me "Why we do restore a incremental backup first?"

    • @DB2_Oracle
      @DB2_Oracle 14 дней назад

      To create the full objects

  • @user-rv5hk3ho9m
    @user-rv5hk3ho9m 16 дней назад

    Thanks !!!

  • @user-lm4wb6st2q
    @user-lm4wb6st2q 18 дней назад

    Sir can you tell me how to find host named of ip address

    • @DB2_Oracle
      @DB2_Oracle 17 дней назад

      Dont understand the question? What exactly you want?

  • @gravewassify
    @gravewassify 21 день назад

    Very helpful. need a tutorial on Data guard with RAC DB on windows

  • @gravewassify
    @gravewassify 21 день назад

    Can we add Data Guard on an RAC? if Yes, could you make a tutorial for 21c RAC - Data Guard

    • @DB2_Oracle
      @DB2_Oracle 16 дней назад

      Yes, you can add dataguard on RAC. However for that, I will have to setup 4 nodes or machines, 2 Nodes on Primary RAC - Primary Data Guard Database 2 Nodes on Secondary RAC - Secondary Data Guard Database My Laptop is not so powerful to host 4 machines, I can only host 3 max. So with my current laptop configuration, I cannot do this setup

  • @gravewassify
    @gravewassify 21 день назад

    Hi, excellent series. Good Job. Can you share this Text File in description. shall be obliged

  • @devatichetty4323
    @devatichetty4323 24 дня назад

    Thanks for the clearest explanation of certificates and ACLs. Very useful.

  • @suriyam5359
    @suriyam5359 26 дней назад

    Hi bro i have a doubt on creating the environment so can u please add that part of having the two like from the beginning it will be very useful bro can u do that!???

    • @DB2_Oracle
      @DB2_Oracle 16 дней назад

      There are many videos where I have installed Oracle Database. You can refer any of those. That will help you to do initial setup. Best one is below link. ruclips.net/video/0NXo27TmTdg/видео.html

  • @DonDBA
    @DonDBA 26 дней назад

    Hi, can we add any IP on the listener? or you created it before setting up the AG?

    • @DB2_Oracle
      @DB2_Oracle 26 дней назад

      We can add any IP for the listener as long as it is in the same subnet. I did not create any IP before.

  • @UltraNewbieTech
    @UltraNewbieTech 28 дней назад

    thanks for detail video

  • @user-he7qw5es3u
    @user-he7qw5es3u 28 дней назад

    Thank you so much

  • @user-he7qw5es3u
    @user-he7qw5es3u 28 дней назад

    Thanks

  • @syedhassnain5204
    @syedhassnain5204 Месяц назад

    Thanks for the amazing video and cleared all my doubts. If possible can you share pdf ? Or your Dropbox link? Please

  • @bethavasavi4085
    @bethavasavi4085 Месяц назад

    Can you please share this document

  • @suzannesellers7383
    @suzannesellers7383 Месяц назад

    Excellent teaching!

  • @habibk9538
    @habibk9538 Месяц назад

    Awesome session !!!

  • @narayanvj1709
    @narayanvj1709 Месяц назад

    can you share this document?

  • @billalhossain3410
    @billalhossain3410 Месяц назад

    Your tutorial very helpful thank you very much..!!

  • @narayanvj1709
    @narayanvj1709 Месяц назад

    can you please share the document pls?

  • @daxelai
    @daxelai Месяц назад

    How to create wallet for pluggable database or we can create wallet for root database and use in pluggable database

  • @amitmoorthy
    @amitmoorthy Месяц назад

    I have only c drive can i extract there

  • @jaskiratrattu9060
    @jaskiratrattu9060 Месяц назад

    Bro my change adapter settings not opening…

  • @wysemanacc84
    @wysemanacc84 Месяц назад

    Great job and straight to the point.

  • @noopmercyyt2373
    @noopmercyyt2373 Месяц назад

    Hi. I wanted to know that to install Enterprise manager agent on windows. Do we have to do these things first then install Agent or directly we can do that? Please answer me

  • @sunilchunduri
    @sunilchunduri Месяц назад

    👍 Thank you

  • @gotchihaeyo1825
    @gotchihaeyo1825 Месяц назад

    Shut Abort Startup Mount Rman) restore Datafile 5 ; Rman) recover Datafile 5 ; SQL) Alter database open ; Would this work as well with the Datafile 5 online? Thank you !!

    • @DB2_Oracle
      @DB2_Oracle Месяц назад

      This will work. As you have put the database in MOUNT mode However if you want to restore datafile while database is online, you need to mark that datafile offline Use alter tablespace command before restore

  • @beboalhag
    @beboalhag Месяц назад

    sir from where can i download grid in video (unzip -qq oracle_DB_19cR300_Grid_LIN64_Home.ZIP -d /dbi/oracle/V19Grid) can you give me the link thank you

    • @DB2_Oracle
      @DB2_Oracle Месяц назад

      From the Oracle Website www.oracle.com/in/database/technologies/oracle19c-linux-downloads.html

  • @sajimenon4888
    @sajimenon4888 Месяц назад

    Very informative video. Keep up the great work!

  • @shaikshameer9783
    @shaikshameer9783 2 месяца назад

    Thank you

  • @up1679
    @up1679 2 месяца назад

    But brother clustering is for load balancing also thn how it is in active passive

    • @DB2_Oracle
      @DB2_Oracle 2 месяца назад

      Oracle RAC can be configured as ACTIVE-ACTIVE or ACTIVE-PASSIVE based on your choice.