OCP TECHNOLOGY
OCP TECHNOLOGY
  • 220
  • 1 870 327
How to schedule RMAN backup using crontab
In this video, we are going to learn how to schedule RMAN backup using crontab in a Linux environment and you get the answer of the below questions:
How do I schedule a RMAN backup?
How to schedule backup using crontab?
How to estimate RMAN backup time?
What is the RMAN daily backup script?
#crontab #oraclebackup #backupscheduler
Join Our Official Telegram Channel
👉t.me/ocptechnology
Chat with me on:
👉Join WhatsApp Group: whatsapp.com/channel/0029VaS09Y64NViipTPpxt1q
👉Join Telegram Group: t.me/+GyzG3cZgs3I4NWI1
MY Gadgets:
👉Mic amzn.to/3lYLBW8
👉Laptop amzn.to/3ndktCa
👉Mouse amzn.to/3jn58Ok
Chat with me on:
👉Oracle Interview application play.google.com/store/apps/de...
👉Facebook page ocptechnology
👉Instagram ocptechnology
👉Website ocptechnology.com/
👉Twitter ocptechnology
Переглядів: 500

Відео

How to install Oracle 23c on Linux
Переглядів 2 тис.6 місяців тому
In this video, we learn how to install Oracle 23c on the Linux platform and create a database in Oracle 23c step by step. Join Our Official Telegram Channel 👉t.me/ocptechnology Chat with me on: 👉Join WhatsApp Group: whatsapp.com/channel/0029VaS09Y64NViipTPpxt1q 👉Join Telegram Group: t.me/ GyzG3cZgs3I4NWI1 23c Document: ocptechnology.com/oracle-23c-installation-on-linux/ MY Gadgets: 👉Mic amzn.to...
How to apply Oracle Patch in windows #patch #oracle #oracledba
Переглядів 7 тис.Рік тому
In this video we are going to learn how to apply oracle patch on windows platform. Join Our Official Telegram Channel 👉t.me/ocptechnology Chat with me on: 👉Join WhatsApp Group: whatsapp.com/channel/0029VaS09Y64NViipTPpxt1q 👉Join Telegram Group: t.me/ GyzG3cZgs3I4NWI1 MY Gadgets: 👉Mic amzn.to/3lYLBW8 👉Laptop amzn.to/3ndktCa 👉Mouse amzn.to/3jn58Ok Chat with me on: 👉Oracle Interview application pl...
How to upgrade Oracle 11 2 0 4 to 19 3 using RMAN backup #upgrade #oracledatabasetutorial #oracle
Переглядів 2,3 тис.Рік тому
How to upgrade Oracle 11 2 0 4 to 19 3 using RMAN backup #upgrade #oracledatabasetutorial #oracledatabasetutorial #upgradeoracle11gto19cusingrman 00:00 Introduction 00:18 Create a User for testing 00:40 Check Database Registry 00:51 Create RMAN Backup 00:14 Create pfile from spfile 01:28 Action on 19c Machine 01:41 Edit the Pfile 02:06 Start Database with 19c environment till nomount using pfil...
Manual Reinstate old Primary Using Flashback #dataguard #reinstate
Переглядів 317Рік тому
Manual Reinstate old Primary Using Flashback #dataguard #reinstate Document Link: ocptechnology.com/manual-reinstate-old-primary-using-flashback/ Join Our Official Telegram Channel 👉t.me/ocptechnology Chat with me on: 👉Join WhatsApp Group: whatsapp.com/channel/0029VaS09Y64NViipTPpxt1q 👉Join Telegram Group: t.me/ GyzG3cZgs3I4NWI1 MY Gadgets: 👉Mic amzn.to/3lYLBW8 👉Laptop amzn.to/3ndktCa 👉Mouse am...
Reinstate the old Primary as a Standby after Failover with broker #dataguard
Переглядів 1,3 тис.Рік тому
How to Reinstate the old Primary as a Standby after Failover with DG Broker #reinstate #failover #dataguard #oracledatabasetutorial #oracledba How to switchover and switch back 👉ua-cam.com/video/gAlH8JWdTN0/v-deo.html How to configure 19c Data Guard broker 👉ua-cam.com/video/48PLHdSSzP8/v-deo.html How to configure Oracle 19c Dataguard with PDB 👉ua-cam.com/video/zOTwvN4xqrQ/v-deo.html Join Our Of...
How to switchover and switch back using DG broker #dataguard
Переглядів 833Рік тому
#Oracle19c switchover and switch back using DG broker complete guide. #switchover #dgbroker #dataguardbroker #dataguard #oracledatabase #oracledatabasetutorial #oracledba 00:00 introduction 00:30 check Archive Gap 00:45 connect DG broker 00:08 Check Primary is ready for switchover 02:00 switchover 04:51 switchover back Document Link: 👉ocptechnology.com/switchover-with-broker/ Join Our Official ...
How to configure 19c Data Guard broker
Переглядів 2 тис.Рік тому
Oracle 19c Data Guard Broker Configuration steps by steps #dataguard #19cdataguardbroker #brokerconfiguration #oraclebroker Join Our Official Telegram Channel 👉t.me/ocptechnology Chat with me on: 👉Join WhatsApp Group: whatsapp.com/channel/0029VaS09Y64NViipTPpxt1q 👉Join Telegram Group: t.me/ GyzG3cZgs3I4NWI1 19c Data Guard Play List: 👉ua-cam.com/video/zOTwvN4xqrQ/v-deo.html Oracle Architecture P...
How to configure Oracle 19c Dataguard with PDB
Переглядів 4,1 тис.Рік тому
Oracle 19c Dataguard congratulations step by step #dataguard #oracle19c #oracledatabase #oracledatabasetutorial #oracledba Document Link: ocptechnology.com/oracle-19c-dataguard-setup-with-pdb/ 19c Installation: 👉ua-cam.com/video/pvE14ON4R8Q/v-deo.html Create PDB 19c: 👉ua-cam.com/video/ONWD0YmzQt0/v-deo.html Join Our Official Telegram Channel 👉t.me/ocptechnology Chat with me on: 👉Join WhatsApp G...
How to upgrade 19.3 to 19.16 Applying patch | Oracle PATCHING steps
Переглядів 12 тис.Рік тому
In this video, we will learn how to upgrade oracle 19.3 to 19.16 by applying a patch. #19.3to19.16 #patching #oraclepatching #databasepatching #oracledatabase #oracledatabasetutorial Join Our Official Telegram Channel 👉t.me/ocptechnology Chat with me on: 👉Join WhatsApp Group: whatsapp.com/channel/0029VaS09Y64NViipTPpxt1q 👉Join Telegram Group: t.me/ GyzG3cZgs3I4NWI1 MY Gadgets: 👉Mic amzn.to/3lYL...
update statement process in Oracle Database architecture
Переглядів 1,9 тис.Рік тому
update statement process in Oracle Database architecture
How select statement works in oracle SGA
Переглядів 1,7 тис.Рік тому
How select statement works in oracle SGA
Oracle Database Architecture Part 3 | Oracle SGA and Background Processes
Переглядів 1,6 тис.Рік тому
Oracle Database Architecture Part 3 | Oracle SGA and Background Processes
Oracle Database Architecture Part 2 | UGA PGA SHARED POOL
Переглядів 1,8 тис.Рік тому
Oracle Database Architecture Part 2 | UGA PGA SHARED POOL
ORACLE DATABASE ARCHITECTURE PART-1 | MEMORY STRUCTURES (SGA)
Переглядів 2,7 тис.Рік тому
ORACLE DATABASE ARCHITECTURE PART-1 | MEMORY STRUCTURES (SGA)
How to Install Oracle Linux 9 in Virtual Box | Full Setup of Linux 9
Переглядів 4,6 тис.Рік тому
How to Install Oracle Linux 9 in Virtual Box | Full Setup of Linux 9
RMAN Backup Type | Difference Between Differential and Cumulative Backup
Переглядів 1,2 тис.Рік тому
RMAN Backup Type | Difference Between Differential and Cumulative Backup
How to Install Java in windows 11 #javainstallation #java #installjava
Переглядів 549Рік тому
How to Install Java in windows 11 #javainstallation #java #installjava
How to Migrate Non CDB Database into PDB Database
Переглядів 3,2 тис.Рік тому
How to Migrate Non CDB Database into PDB Database
How to UPGRADE ORACLE 12c to 19c using RMAN Backup
Переглядів 6 тис.Рік тому
How to UPGRADE ORACLE 12c to 19c using RMAN Backup
How to upgrade Oracle 11G to 19C using Auto Upgrade
Переглядів 4,4 тис.Рік тому
How to upgrade Oracle 11G to 19C using Auto Upgrade
How to install windows server 2022
Переглядів 2642 роки тому
How to install windows server 2022
How to upgrade oracle database 11g to 19c on Linux step by step
Переглядів 8 тис.2 роки тому
How to upgrade oracle database 11g to 19c on Linux step by step
Data Pump Export Import Over the Network using network_link
Переглядів 3,2 тис.2 роки тому
Data Pump Export Import Over the Network using network_link
Oracle Database Export Backup Automation with shell scripting
Переглядів 3,6 тис.2 роки тому
Oracle Database Export Backup Automation with shell scripting
How to automate Oracle RMAN Backup with shell script - Cron Jobs
Переглядів 4,9 тис.2 роки тому
How to automate Oracle RMAN Backup with shell script - Cron Jobs
How to Check Oracle Dump file is corrupted or not
Переглядів 1,6 тис.2 роки тому
How to Check Oracle Dump file is corrupted or not
How to implement Oracle TDE | transparent data encryption | Oracle wallet
Переглядів 2,2 тис.2 роки тому
How to implement Oracle TDE | transparent data encryption | Oracle wallet
How to install statspack step by step | Generate spreport | Uninstall statspack
Переглядів 1 тис.2 роки тому
How to install statspack step by step | Generate spreport | Uninstall statspack
How to install Oracle Instant Client | Oracle 21c Client Installation on windows complete guide
Переглядів 33 тис.2 роки тому
How to install Oracle Instant Client | Oracle 21c Client Installation on windows complete guide

КОМЕНТАРІ

  • @coding_guru
    @coding_guru День тому

    Every statement will go into the Parsing process into diff stages like Syntex check, symatic check and shared pool check. After the shared pool check only it will go Hard parse and Soft parse.

  • @melikeertunc6093
    @melikeertunc6093 10 днів тому

    hi! Thanks for the video ! After installing Oracle Client, my date format was corrupted. I am getting "not a valid month" error in my SQL query in Excel. How can I change the date format of ocmt?

    • @ocptechnology
      @ocptechnology 10 днів тому

      @@melikeertunc6093 chang the date format in excel simple

  • @kindurudineshreddy-jr8uo
    @kindurudineshreddy-jr8uo 17 днів тому

    Tq nice explanation

  • @isvic007
    @isvic007 17 днів тому

    My database is 50tb, archive generation is 20tb per day. If I have to bring back my primary after a week, what would be the flashback space requirement?

    • @ocptechnology
      @ocptechnology 13 днів тому

      You can calculate the required FRA size as per daily archives generation dear

  • @rowlandjones3872
    @rowlandjones3872 18 днів тому

    Hi i didnt see you or hear you mention that the preupgrade.jar file needs to be downloaded?? Or its not important for these steps

  • @mylittleguggu4786
    @mylittleguggu4786 18 днів тому

    Hi Bro, I have doubt, i have EBS 12.2 with 19c (CDB, PDB) database. I need to make this primary & standby. I have new standby server. In standby server do we need to copy Primary database Oracle_Home? and how they create CDB & PDB in Secondary Server? Please explain me.

    • @ocptechnology
      @ocptechnology 18 днів тому

      Hi, First install the same version of oracle database on standby server then take rman backup on primary db once it's completed then restore it on standby but before restoration set Datagurd parameters on primary db, check Datagurd video on our channel

  • @armenhagobian
    @armenhagobian Місяць тому

    Thank you so much for sharing on how to create a mount in a Linux server...

  • @shreyashpatil7648
    @shreyashpatil7648 Місяць тому

    Thank you sir it is very helpful

  • @shreyashpatil7648
    @shreyashpatil7648 Місяць тому

    Very informative straight to the point that's why I always prefer to watch your videos

  • @Shazrash
    @Shazrash Місяць тому

    Hello everyone who can help me in oracle dba bcz i m stuck here please help me who is doing work as a oracle dba

  • @awkhanabdul1313
    @awkhanabdul1313 Місяць тому

    super explanation

  • @awkhanabdul1313
    @awkhanabdul1313 Місяць тому

    Super explanations DG steps

  • @Shazrash
    @Shazrash Місяць тому

    Anyone is there who will help me in solve the oracle issue

  • @shreyashpatil7648
    @shreyashpatil7648 Місяць тому

    Thanks sir it helpful

  • @user-yr1vz2po9y
    @user-yr1vz2po9y Місяць тому

    thanks it was helpful

  • @imtiazmahmood1757
    @imtiazmahmood1757 Місяць тому

    Sir I wished to know if at source I have 18.0.0, and at destination 19c. So then how do I perform datapump

    • @ocptechnology
      @ocptechnology 18 днів тому

      Simple bro just take export from 18c and import in 19c

  • @iamsonu123
    @iamsonu123 Місяць тому

    Sir aap hindi me bhi pdha diya karo....aap ka pdhaya hua ache se samjah me aata h. or app (LEARNOMATE TECHNOLOGY) se acha padhate ho...all videos Awesome sir

  • @balajichandramohan5117
    @balajichandramohan5117 Місяць тому

    Hi sir, if 'alter database commit to switchover to primary' is the command for failover then what is the command for switchover?

  • @viniciusrw
    @viniciusrw 2 місяці тому

    Hello, I tried just following your steps, but when I run $ORACLE_HOME/perl/bin/perl catctl.pl catupgrd.sql, received : ERROR at line 13: ORA-00942: table or view does not exist SQL> SELECT TO_NUMBER('NONUPGRADED_TABLEDATA') FROM SYS.V$INSTANCE 2 ; SELECT TO_NUMBER('NONUPGRADED_TABLEDATA') FROM SYS.V$INSTANCE * ERROR at line 1: ORA-01722: invalid number In my original database I did not run any pre-upgrade script, should I run it before performing the backup to correct these errors?

    • @ocptechnology
      @ocptechnology 2 місяці тому

      Yes, you should create backup

    • @viniciusrw
      @viniciusrw 2 місяці тому

      @@ocptechnology Hello, I'm a bit of a detail oriented person, so I should run the scripts on the source base and then proceed with the backup to restore on the destination base, right?

  • @muhammadjabirsalman8128
    @muhammadjabirsalman8128 2 місяці тому

    Wonderfull video, is it work windows as well??

  • @Yuka2003n
    @Yuka2003n 2 місяці тому

    One more thing about the connection. I modified the tnsnames.ora file by adding the service FREEPDB1 (listener.ora about FREEPDB1 was also added the difference from yours is that when started, bother services, FREE and FREEPDB1 are UNKNOWN instead of READY). When login sys as sysdba@FREEPDB1, I had the ORA-01017 error.

  • @Yuka2003n
    @Yuka2003n 2 місяці тому

    I have the Listener start problem. There is no error messages. However, when started, yours are "READY" whereas mine is "UNKNOWN". Do you know what is the problem of causing that?

    • @ocptechnology
      @ocptechnology 2 місяці тому

      Register the Database service with the listener then try

  • @rahithreddy4704
    @rahithreddy4704 2 місяці тому

    Mail id to contact you

  • @rahithreddy4704
    @rahithreddy4704 2 місяці тому

    Hi sripal ji pls send me your contact number

  • @user-vh2ym6ff9w
    @user-vh2ym6ff9w 2 місяці тому

    You are genius

  • @yosephfahed9897
    @yosephfahed9897 2 місяці тому

    Thank you very much, very helpfull

  • @supreethgr2586
    @supreethgr2586 2 місяці тому

    Could you please make video on how to enable TLS 1.3 on Oracle 23c Linux or RHEL? Not getting any resource. Thanks

  • @nihlanijam5145
    @nihlanijam5145 2 місяці тому

    Thank You Sir!!!!

  • @robertdeutschmann578
    @robertdeutschmann578 3 місяці тому

    many thanks for your efforts to share this informative video with us😃

    • @ocptechnology
      @ocptechnology 3 місяці тому

      Thanks for watching #ocptechnology

  • @kknirala1
    @kknirala1 3 місяці тому

    Great job dear..

  • @jeevananthamvaradhan2596
    @jeevananthamvaradhan2596 3 місяці тому

    Super ji

  • @Venkatesh-Venky
    @Venkatesh-Venky 3 місяці тому

    Good content 👌 bro😊

  • @Venkatesh-Venky
    @Venkatesh-Venky 3 місяці тому

    Make a video 📹 optimizer statistics bro

  • @Venkatesh-Venky
    @Venkatesh-Venky 3 місяці тому

    No clarity voice bro

    • @ocptechnology
      @ocptechnology 3 місяці тому

      Thanks for watching bro. In next video I'll try to record with good quality audio

    • @Venkatesh-Venky
      @Venkatesh-Venky 3 місяці тому

      ​@@ocptechnology OK 👍 tq bro

  • @fernandomartinsdasilva3164
    @fernandomartinsdasilva3164 3 місяці тому

    Very good my friend , I just following you, I’m from Brazil

  • @Super3tube
    @Super3tube 3 місяці тому

    Good understanding of the concept.🎉

  • @SiegbertMashika
    @SiegbertMashika 3 місяці тому

    Good day Shripal, Thank you for this helpful video2, I wanted to ask. what if my CDB is on a different server does that mean i have to copy the database files in one location on the CDB , in order to specify the locations in COPY FILE_NAME_CONVERT parameters? In my case i do have the NON CDB datafiles in different locations as well.

    • @ocptechnology
      @ocptechnology 3 місяці тому

      Thanks for watching, you can try but on UAT, I never try this

    • @vickynagpal6574
      @vickynagpal6574 13 днів тому

      @@ocptechnology Thank you. I have the same scenario wherein My non cdb is on anther box and new CDB (PDB) is on another. Should we take the cold backup after creating the xml to new server and then convert?

  • @chaitanyalotwala8796
    @chaitanyalotwala8796 3 місяці тому

    Very crisp and "To The Point" explaination..!! another helpful video from you..!!

  • @colorsoflife-811
    @colorsoflife-811 4 місяці тому

    Thanks dear

  • @lifesaint
    @lifesaint 4 місяці тому

    I understand Oracle has CDB, if we add another database in 11g, will it be CDB or PDB (I know 11g does not support PDB, but can't be two CDB, right?)

    • @ocptechnology
      @ocptechnology 4 місяці тому

      It will be kind of PDB, but not actually pdb

  • @gajanandn
    @gajanandn 4 місяці тому

    It wont work if i try to peroform the datapump activity from 10g to 19c ... highly appreciated if any buddy can support

  • @nicholusnatweta2942
    @nicholusnatweta2942 4 місяці тому

    can you a video on rman restore please? especially from recovery catalog. Thanks

  • @samtheoyou
    @samtheoyou 4 місяці тому

    is that same for 19c RAC env

    • @ocptechnology
      @ocptechnology 4 місяці тому

      A little bit different, please read the readme file carefully

  • @moldovanmoldovan7593
    @moldovanmoldovan7593 4 місяці тому

    Namaste, Shripal. I still do not get it, are you using two DISTINCT Oracle database instances (but with same major/minor version) or you somehow do convert Non-CDB to CDB using same Oracle instance? thanks

    • @ocptechnology
      @ocptechnology 4 місяці тому

      There are two different instances

  • @guruprasadmahajan605
    @guruprasadmahajan605 4 місяці тому

    How to connect with you

    • @ocptechnology
      @ocptechnology 4 місяці тому

      support@ocptechnology.com our official mail

  • @user-zr1ce3oj7b
    @user-zr1ce3oj7b 4 місяці тому

    More description needed

    • @ocptechnology
      @ocptechnology 4 місяці тому

      Ok, can you share what you want to know?

  • @sadanb4876
    @sadanb4876 4 місяці тому

    Nice video sir... please do video on RMAN DUPLICATE on ASM ?