![OCP TECHNOLOGY](/img/default-banner.jpg)
- 220
- 1 870 327
OCP TECHNOLOGY
India
Приєднався 24 січ 2014
OCP TECHNOLOGY
providing free Tutorials on ORACLE RDBMS software including ORACLE RAC (Real Application Cluster), ASM (Automatic Storage Management), Oracle DATAGUARD, SQL, PL/SQL
in Hindi & English Language so that everybody learns & understands quickly.
For business inquiries: support@ocptechnology.com
providing free Tutorials on ORACLE RDBMS software including ORACLE RAC (Real Application Cluster), ASM (Automatic Storage Management), Oracle DATAGUARD, SQL, PL/SQL
in Hindi & English Language so that everybody learns & understands quickly.
For business inquiries: support@ocptechnology.com
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
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 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
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.
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?
@@melikeertunc6093 chang the date format in excel simple
Tq nice explanation
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?
You can calculate the required FRA size as per daily archives generation dear
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
Have you seen the complete video?
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.
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
Thank you so much for sharing on how to create a mount in a Linux server...
Welcome dear
Thank you sir it is very helpful
Welcome dear
Very informative straight to the point that's why I always prefer to watch your videos
Thank you dear
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
Hi, Where you stuck?
super explanation
Thanks dear
Super explanations DG steps
Thank you dear
Anyone is there who will help me in solve the oracle issue
What issue are you facing?
Thanks sir it helpful
thanks it was helpful
Thanks dear
Sir I wished to know if at source I have 18.0.0, and at destination 19c. So then how do I perform datapump
Simple bro just take export from 18c and import in 19c
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
Thank you bro
Hi sir, if 'alter database commit to switchover to primary' is the command for failover then what is the command for switchover?
Same command bro
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?
Yes, you should create backup
@@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?
Wonderfull video, is it work windows as well??
Thank you dear
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.
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?
Register the Database service with the listener then try
Mail id to contact you
Hi sripal ji pls send me your contact number
You are genius
Thank you dear
Thank you very much, very helpfull
Your welcome bro
Could you please make video on how to enable TLS 1.3 on Oracle 23c Linux or RHEL? Not getting any resource. Thanks
Thank You Sir!!!!
Your welcome
many thanks for your efforts to share this informative video with us😃
Thanks for watching #ocptechnology
Great job dear..
Thank you dear
Super ji
Thank you 🙏
Good content 👌 bro😊
Make a video 📹 optimizer statistics bro
Ok coming soon
No clarity voice bro
Thanks for watching bro. In next video I'll try to record with good quality audio
@@ocptechnology OK 👍 tq bro
Very good my friend , I just following you, I’m from Brazil
Thank you dear
Good understanding of the concept.🎉
Thank you
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.
Thanks for watching, you can try but on UAT, I never try this
@@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?
Very crisp and "To The Point" explaination..!! another helpful video from you..!!
Thank you chaitanya
Thanks dear
Your welcome
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?)
It will be kind of PDB, but not actually pdb
It wont work if i try to peroform the datapump activity from 10g to 19c ... highly appreciated if any buddy can support
can you a video on rman restore please? especially from recovery catalog. Thanks
is that same for 19c RAC env
A little bit different, please read the readme file carefully
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
There are two different instances
How to connect with you
support@ocptechnology.com our official mail
More description needed
Ok, can you share what you want to know?
Nice video sir... please do video on RMAN DUPLICATE on ASM ?
Thanks sadan, i'll upload soon