![Salman Lab](/img/default-banner.jpg)
- 26
- 19 113
Salman Lab
Bahrain
เข้าร่วมเมื่อ 17 ก.พ. 2012
Salman Lab channel is my personal lab where I do to learn all IT products , I am expert in Oracle Database and Redhat Linux certified administrators a long with wide IT technologies , here if you follow me you will get a chance to watch and learn
Downgrading Oracle Database to an Earlier Release , 19c to 12.2
Downgrading Oracle Database to an Earlier Release , 19c to 12.2 using Scripts dbdowngrade to Downgrade Non-CDB Oracle Database
มุมมอง: 75
วีดีโอ
Oracle M5 Cross Endian Platform Migration
มุมมอง 1292 หลายเดือนก่อน
Oracle M5 Cross Endian Platform Migration using Full Transportable Data Pump Export/Import and RMAN Incremental Backup show you in performing a cross platform (Big Endian to small Endian, vice versa, or same platform) oracle 19c and above
How to apply Oracle Data Pump Patches 19c
มุมมอง 1042 หลายเดือนก่อน
How to apply the Oracle Data Pump Recommended Proactive Patches For 19c DB
Oracle Dataguard Failover
มุมมอง 842 หลายเดือนก่อน
Oracle dataguard 19c failover where the primary database become unavailable .
Migrate from 12c to 19c using v4 script - Transportable Tablespaces
มุมมอง 1642 หลายเดือนก่อน
using V4 Cross Platform Transportable Tablespaces (XTTS) with RMAN incremental backups to migrate data between systems that have different endian formats
Who is Salman Lab
มุมมอง 46ปีที่แล้ว
Here is a brief about me .. Thank you for watching my channel www.linkedin.com/in/salmancs9/ salmanitexpert.blogspot.com/
Oracle Rolling Upgrade using DBMS_ROLLING 12 to 19c
มุมมอง 644ปีที่แล้ว
Oracle step by step upgrade from 12c to 19c using DBMS_ROLLING , this is rolling upgrade ( zero downtime ) , but need active data guard license .
Oracle Patching Data Guard Standby-First steps
มุมมอง 1.3Kปีที่แล้ว
step by step patching oracle database in data guard configured with DG broker in place .
Oracle upgrade OPatch utility
มุมมอง 1.3Kปีที่แล้ว
Step by step upgrading OPatch utility in oracle all version are same steps. This utility is used to patch the Oracle DB
Oracle switchover using Data Guard broker(dgmgrl)
มุมมอง 1.2Kปีที่แล้ว
step by step oracle 12c data guard switchover dgmgrl
Oracle Data Guard Switchover using SQL
มุมมอง 92ปีที่แล้ว
oracle 12c do a switchover with basic explanation
Oracle Creating a Physical Standby Database
มุมมอง 821ปีที่แล้ว
step by step Oracle 12 or 19c , manually create a physical standby database in maximum performance mode using asynchronous redo transport and real-time apply, the default Oracle Data Guard configuration
Oracle Managed File OMF
มุมมอง 370ปีที่แล้ว
How enable and use Oracle Managed File OMF in oracle 19c , simple example and basic information
Oracle 19c Migrate and upgrade using data pump
มุมมอง 4.6Kปีที่แล้ว
Oracle 19c Migrate and upgrade using data pump
Oracle 19c Using DBCA to create and configure Database
มุมมอง 705ปีที่แล้ว
Oracle 19c Using DBCA to create and configure Database
Oracle Migration and Upgrade from 12c to 19c using RMAN Incremental Backups
มุมมอง 2Kปีที่แล้ว
Oracle Migration and Upgrade from 12c to 19c using RMAN Incremental Backups
How to Enable archive log mode on Oracle DB
มุมมอง 65ปีที่แล้ว
How to Enable archive log mode on Oracle DB
Install Oracle DB12.2c On Oracle Linux 8
มุมมอง 700ปีที่แล้ว
Install Oracle DB12.2c On Oracle Linux 8
Hi, maybe lame question but is there a application outage during the switchover? Thanks
@@majojepan9 Hi, Yes, DB sessions will be disconnected, however, if application can reconnect automatically to the new db without letting users feeling this you may consider it as no disconnecting. Mainly I consider it as interruption.
Please share the command which u had in notepad. It will be useful
@@swethaswetha8966 I will do this in future lab, thanks
Thank you for this. Been struggling with the installation. Will this method work on Redhat 9?
@@kunihiramuchwa actually it's works put you have to patch for certain level during the installation and perform the prechek I will do one video for this soon
Very good explanation.
can you show how to do it using oracle data guard broker? in oracle 21.3.0, I face this error: DGMGRL> failover to orap; ORA-16600: not connected to target standby database 1. My tns's are correct. 2. I am connected to the secondary database and trying to do failover.
Assalamu-alaykum brother, Nice explanation. Would like to check with you. Is the user creation mandatory before import ?? Let's say user belongs to the tablespace that i am migrating currently.
Hi, Create any users in the destination database that owned objects within the tablespace being transported before importing the Metadata.
@salmanlab87 The default user table size is 1 GB. But the user size is around 1 TB. The tablespace contains all the data of the user which is 1 TB. In this case the user tablespace requires 1 TB or 1 GB should be enough?
@@zubairwali222 size will be the tablespace size that you configured to move
When taking l1 backup, for source database, is it required to have L0 backup file in the src_backups destination
@@zubairwali222 file will be created on this path and then you have to move it to the destination path to apply it
Good Job Salman , way to go brother
Thanks Samer
Hello sir, After performing switchover, how users will connect to primary database. Do we need to provide any information to them.
Thats depends on connection type If it is tnsnames you may change it or configure it to cover both If network nat or dns in the middle you may change there
@@salmanlab87 thank you very much
Hi, On doing switchover in 19c , it completes successfully but if I do show configuration afterwards , it gives the same apply lag error which you got. In your case it got resolved in some time, but in my case it doesn't go away automatically , it persists. Please suggest what could be the issue.
Hi Check the logs for the details, seems that missing configuration on the standby . Start with connecting from standby server to the main server db and reverse.
I am facing error in configuration error [DBT-50000] Unable to check for available memory how to solve this error
Share the full details pls Where this error appeared ..etc
Excellent presentation! I shall upgrade a test 12.2.0 instance along with its standby to Oracle 19.22 now.
thank you so much .
Very helpful video 😊
Can you share your installation file/document?
I always refer to oracle official documents
You missed to run "select * from dba_registry_sqlpatch;" in database at the end to check the status of patching in database.
That is true. You may run this to verify the data patching
Unable to find a match: libnsl2-devel? Any solution plz?
Ensure that os repository is configured with right version. If you got error while installing it please share it .
@@salmanlab87 I use Centos 8.
Excellent work your doing.. please keep posting videos and sharing your knowledge with us... Thanks ❤
Excellent work your doing.. please keep posting videos and sharing your knowledge with us... Thanks ❤
Thank you so much
Thank you
Did you try this ever with switch over to allow zero downtime? I came across to see the same. Thanks by the way for putting the time here.
As you know patching is two steps. Binary patching and data patching. With DG you will do only Binary patching,thus, switchover will not leads to zero downtime. Only rac is rolling patching with interruption actually while stop one node
Hey bro will you help me to create a oracle account I don't have credit card
Yes I will.
nice video ! thanks
Welcome!