- 110
- 284 246
Hemant K Chitale
Singapore
Registrace 23. 07. 2011
Video Posts. Currently primarily about Oracle SQL, On-Premises Database, Cloud ADB and SQL Server On-Premises (Please view them in HD format-- using the Settings button to select Auto 720p or 1080p -- if possible)
RAC OCR and OLR
Oracle Grid/ClusterWare OCR (Cluster Registry) and OLR (Local Registry) commands.
ocrcheck : Lists the locations of the OCR and checks for corruption (run as root to check for logical corruption as well)
ocrconfig -add DG Name (e.g. ocrconfig -add +DATA) : Adds a new copy of the OCR in the stated ASM DG
ocrconfig -delete DG Name : Deletes a copy of the OCR from the ASM DG
cat /etc/oracle/olr.loc : Shows the location of the OLR
ocrcheck -local : Checks the OLR
ocrconfig -showbackup : Shows the default location of OCR backups
ocrconfig -manualbackup : Create a manual backup of the OCR
(use asmcmd to copy the backup out from ASM to Filesystem)
ocrconfig -local -showbackuploc : Shows the location of OLR backups
ocrconfig -local -manualbackup : Create a manual backup of the OLR
ocrconfig -local -export : Create an Export backup of the OLR
ocrcheck : Lists the locations of the OCR and checks for corruption (run as root to check for logical corruption as well)
ocrconfig -add DG Name (e.g. ocrconfig -add +DATA) : Adds a new copy of the OCR in the stated ASM DG
ocrconfig -delete DG Name : Deletes a copy of the OCR from the ASM DG
cat /etc/oracle/olr.loc : Shows the location of the OLR
ocrcheck -local : Checks the OLR
ocrconfig -showbackup : Shows the default location of OCR backups
ocrconfig -manualbackup : Create a manual backup of the OCR
(use asmcmd to copy the backup out from ASM to Filesystem)
ocrconfig -local -showbackuploc : Shows the location of OLR backups
ocrconfig -local -manualbackup : Create a manual backup of the OLR
ocrconfig -local -export : Create an Export backup of the OLR
zhlédnutí: 69
Video
RAC DataGuard Protection Mode HD
zhlédnutí 127Před měsícem
Oracle offers 3 DG protection modes. "Maximum Performance" is the default to reduce overhead at the Primary but *does not guarantee zero data loss*. My preference is "Maximum Availability". The "Maximum Protection" mode offers the highest level of protection in that if the Standby goes down or is inaccessible, the Primary also goes down. For more information see the Oracle Documentation at docs...
RAC DataGuard Single Instance HD
zhlédnutí 210Před 2 měsíci
Monitoring a DataGuard (single instance) for a 2-node RAC Cluster
RAC Client Side Failover HD
zhlédnutí 176Před 3 měsíci
Configuring Client Side Load Balancing and Failover using the TNSNAMES.ORA file See "Client-Side Load Balancing" in the 19c Documentation at docs.oracle.com/en/database/oracle/oracle-database/19/racad/workload-management-with-dynamic-database-services.html#GUID-10F7892A-92DD-482C-8D68-AE80CE956010
RAC HostNames SCAN and IPs HD
zhlédnutí 103Před 3 měsíci
Understanding Host Names, SCAN and IP addresses in an Oracle RAC Cluster
RAC RedoLog Switch and Archival HD
zhlédnutí 78Před 4 měsíci
RedoLog Switch and Archival behaviour in RAC. Each Database Instance (on each node of the Cluster) has it's own Redo Thread. When the Instances are active, they do execute switching and archival of RedoLogs. This video also demonstrates that Oracle attempts to keep the Redo Thread as close to each other (in terms of SCNs (Change#, not Sequence#) even if an Instance is idle and not generating it...
RAC Running ORACHK HD
zhlédnutí 140Před 4 měsíci
ORACHK is part of the Oracle Autonomous Health Framework. See Oracle Support document "Autonomous Health Framework (AHF) - Including TFA and ORAchk/EXAchk (Doc ID 2550798.1)" and the AHF documentation at docs.oracle.com/en/engineered-systems/health-diagnostics/autonomous-health-framework/ On using ORACHK as an Upgrade Readiness Assessment tool, see Oracle Support document "ORAchk Upgrade Readin...
RAC Monitoring from SQL Developer HD
zhlédnutí 113Před 5 měsíci
Real Time monitoring of an Oracle RAC Database Cluster from SQL Developer. Without having to wait to generate ASH or AWR Reports.
RAC Global Cache Single Block Transfers HD
zhlédnutí 46Před 5 měsíci
Building on the previous demo where I had multiple blocks updated on node2 and then queried on node1, I show the impact with a single block containing 2 rows of which only 1 row is updated. The 21c documentation on Wait Events is at docs.oracle.com/en/database/oracle/oracle-database/21/refrn/descriptions-of-wait-events.html#GUID-2FDDFAA4-24D0-4B80-A157-A907AF5C68E2 while the 19c documentation i...
RAC Global Cache Transfers HD
zhlédnutí 159Před 5 měsíci
A quick demonstration of Global Cache Transfer Waits in RAC. When blocks are modified by one instance but are being requested (even just for reads) by the other instance, the requesting instance may spend time waiting for the transfer of the blocks over the (high-speed) interconnect. My demonstration environment may not be very fast but it does highlight the fact that when you scale to tens or ...
RAC Instance Recovery and Auto Restart HD
zhlédnutí 71Před 5 měsíci
When a Database Instance in a RAC Cluster dies abnormally, any other surviving Instance in the Cluster executes Instance Recovery. Here Instance 2 on node2 died abnormally and Instance 1 executed Recovery (applied Rollforward and Rollback using the Redo Logs of Thread 2 [Instance 2] ). Furtheremore, ClusterWare on the node detects the failure of the Instance (the Instance is one of many resourc...
RAC Instance Recovery and Auto Restart
zhlédnutí 64Před 5 měsíci
When a Database Instance in a RAC Cluster dies abnormally, any other surviving Instance in the Cluster executes Instance Recovery. Here Instance 2 on node2 died abnormally and Instance 1 executed Recovery (applied Rollforward and Rollback using the Redo Logs of Thread 2 [Instance 2] ). Furtheremore, ClusterWare on the node detects the failure of the Instance (the Instance is one of many resourc...
RAC Instance Recovery
zhlédnutí 176Před 5 měsíci
Here I demonstrate Instance Recovery of a database instance on a failed node being executed by the surviving node of the RAC Cluster Failover of the session that was connected to the SCAN IP of the failed node has been demonstrated in the previous video titled "RAC Client Query Session and Query Failover" at czcams.com/video/1cfEGNRDWeI/video.htmlsi=phLN_9kDhUGWwHTm
RAC Client Query Session and Query Failover
zhlédnutí 218Před 6 měsíci
When a client connects to a RAC Instance via a SCAN listener : If the node (Linux in this case) goes down abnormally, Grid Infrastructure does a failover of the SCAN IP address to any of the surviving nodes. In this demo, I have two connections to two different SCAN IPs, one on node1 and the other on node2 (i.e. two different Linux DB Servers running RAC). When node2 goes down abruptly, the use...
ADG DML Redirection and Locking and Timeouts
zhlédnutí 115Před rokem
When using DML Redirection in Active DataGuard, you can run into Locking issues for Transactions in the same as would happen if both sessions were in the same database instance. An added complication is "distributed_lock_timeout" because DML Redirection uses a Database Link For my previous videos see "Open Standby Database for Querying" : czcams.com/video/eb2CrAbEo_M/video.html and "ADG DML Red...
Add and Drop Pluggable Database (PDB) in DataGuard
zhlédnutí 693Před rokem
Add and Drop Pluggable Database (PDB) in DataGuard
Oracle Instance Viewer in SQL Developer
zhlédnutí 928Před 2 lety
Oracle Instance Viewer in SQL Developer
SQL Server Migration Assistant for Oracle
zhlédnutí 16KPřed 2 lety
SQL Server Migration Assistant for Oracle
Load Flat or CSV File to Oracle Using SQL Developer
zhlédnutí 10KPřed 2 lety
Load Flat or CSV File to Oracle Using SQL Developer
Performance Hub for On-Premises Database
zhlédnutí 159Před 3 lety
Performance Hub for On-Premises Database
thank you bro 🥰
As always excellent blog Sir , i really like your way of explanation , in future can you please upload videos for RMAN restore and recovery scenarios like restoring backup based on SCN/time from old backup and validate before restoring
The scripts are in a ZIP file linked in the blog post at hemantoracledba.blogspot.com/2024/05/video-on-monitoring-single-instance.html
Thank you
your video make us understand very well . sir can you make a full course video on oracle 19C from the beginning please sir
No, unfortunately, I do not currently have enough time to create a full course.
Hi hemant i want to contact you.. Are you providing any online trainings??
No, I do not provide any online training.
What connection string(JDBC) application team needs to modify so that the application can reconnect automatically(retry logic)? Is the scan name in the connecting string enough?
Check the documentation (this for 19c which is the supported production release) : docs.oracle.com/en/database/oracle/oracle-database/19/racad/workload-management-with-dynamic-database-services.html#GUID-EE246927-2883-44EC-80F6-A3FCB019624E
thanks for sharing , volume is little low
Yes, unfortunately, the Microphone didn't capture my voice well. You could configure automatic Closed Caption (the "CC" icon) when playing in CZcams.
Very Low voice
Yes, unfortunately, the Microphone didn't capture my voice well. You could configure automatic Closed Caption (the "CC" icon) when playing in CZcams.
Does Migration assistant can only be installed in SQL Server machine
Well, it has to be on a Windows Server. If you are thinking of an installation connecting to multiple SQL Server instances, you would be able to define a connection to each instance.
This video is helpful. We need additional assistance with importing the 'new-211123.bak' backup file, which contains an encrypted database. Please provide guidance on how to perform this import on a new Oracle machine.
When was pfile used.
The STARTUP NOMOUNT required a PFILE. If an SPFILE doesn't exist, Oracle uses the PFILE corresponding to the ORACLE_SID. I prefer to keep a backup PFILE in case the SPFILE gets corrupted.
Thankyou so much
I can do migration process by SSMA manually, but i need to do periodically ( as scheduled job ) any idea ?
I am not aware of an in-built scheduler. However you could consider extracting the scripts, adding any DROP or DELETE statements as required, and scheduling them through a job scheduler (VisualCron and PowerShell) or BMC.
thank you sir
Great Job
Hemant thanks for helping the community with this video
I think you're a great great teacher.
Is there a way to schedule this SSMA process ?
Any solution did you get do as schedule job ?
I'd suggest extracting the generated scripts, adding DROP and DELETE statements and scheduling through an external Scheduler (VisualCron and PowerShell) or BMC
I'd suggest extracting the generated scripts, adding DROP and DELETE statements and scheduling through an external Scheduler (VisualCron and PowerShell) or BMC
This is SQL serer or SQL Dba
This is Oracle. Not SQL Server
What is the protection mode of the standby database ?
Maximum Performance.
Thank you. It is usefull
Glad it was helpful!
you did not rant "convert schema" .. may be because you manually created the object in sql server db ?
The DDLs were generated by the Migration Assistant . So I didn't have to "convert schema" (not sure what you mean by "convert schema")
Thank you for proper explanation... I have 1 questions, can you guide on oracle sequence migration?
I'd suggest configuring the column as Identity Column so that SQL Server generates the values.
Hi, can you do a video showing some error with the Oracle number datatype conversion? By default SQL server will set as float[53]. How can we change to numeric? I try that in project settings. But the SSMA doesn't allow me to migrate successfully.
You could ALTER TABLE MODIFY the column in Oracle to set the correct Precision and Scale before you run the Migration Assistant. OR You could modify the generated SQL Server DDL statements.
Sir I am not able to use the command to open script file can I get any another way
Which "script file" do you mean ? login.sql is automatically executed by sqlplus.
Hi , Thanks for the video, its helping me with migration. I have a query what is Equivalent of Oracles sys_context ('USERENV', 'Client_Identifier') in SQL Server. I am getting errors w.r.t same after schema conversion..
I'm sorry, I don't know an equivalent. The DBA can query sys.dm_exec_connections to identify connections but if your requirement is for a non-DBA session to identify client_identifier you might try working with this view
Very nice video bro. Here I want to mention that video is not clear but it's understandable. Can you please help if my table contains 125 column and having row 10 lacks then which set parameters can I use to format results in CSV which looks proper in terminal
Two options : sqlcl with the /* csv */ hint . OR sqplus with "set markup csv on". See this recent video czcams.com/video/Mgf2wHtx0DQ/video.html
Thanks
Welcome
Hey can u share me the link for OVA format file pls?
Standard Prebuilt Virtual Box VMs by Oracle are available for download at www.oracle.com/downloads/developer-vm/community-downloads.html Also, other enthusiasts and developers make theirs available via github e.g. Dr Tim Hall's builds at github.com/oraclebase with instructions from oracle-base.com/index
Do do jagah likhne ka kya matlab aise aap kahaa kya command use kar rahenho dikhta nahi Aur video jyada fast h
Thank you for your advice.
There is no clarity screen bayya
Use the "settings" button to view it in 720p or 1080p HD.
this video is so helpful
Thank you
Thank you so much..... for this detailed video... it's really helpful to me✌
You are welcome.
set pages 0 linesize 32767 trimspool on trim on long 1000000 longchunksize 10000000 spool DBMS_PERF_REPORT.html select dbms_perf.report_perfhub(is_realtime=>1,type=>'active') from dual; -- is_realtime 1 and active shows the report for the last 1hour -- for more options see the documentation on DBMS_PERF spool off -- then edit the html file to remove the first line and the spool off command if necessary
Bonjour, Hemant K Chitale. surprisingly excellent video. thank. :)
Thank you
Unable to see the commands what u r executing.
Slow down the video, pause it and watch it ?
Hii sir Attached script also
You'll have to view the commands from the video. There are a very large number of RMAN posts on my blog at hemantoracledba.blogspot.com where you can view the command/scripts in text format
Excellent explanation sir. Please keep it up :)
Thank you
Hi Hemant, Thanks for your videos. I tried to run an incremental 1 cumulative backup after level 0(level 0 is successful with all datafiles backed up) but it throws a warning below "no parent backup or copy of datafile 1 found" & took full backup. Can you please help.
Run these RMAN commands "LIST BACKUP" or "LIST BACKUP OF DATAFILE 1" and also "CROSSCHECK BACKUP" or "CROSSCHECK BACKUP OF DATAFILE 1" to see RMAN is aware of a datafile 1 backup. Also, confirm that your level 0 backup was done with "INCREMENTAL LEVEL 0" in the RMAN command.
Hi, Thanks for your prompt response .. I tried your commands and it says available only..I ran the command as Backup incremental level 0 database for full backup
I tried in another env and it works.. I believe the issue is due to i have done reset reincarnation lately.. i believe this might b a reason for the behavior.. it says no parent file only for system datafile, not other files.. any guess??
@@sribalaje Yes, a RESETLOGS creates a different incarnation. So the level-0 backup of the previous incarnation isn't the base of the current level-1 backup.
Thanks but in my case i done reincarnation two days back but i started level 0 yesterday and level 1 today.. still got issues
you have explained Latches pretty well
Thank you
Thanks
You are welcome
well done sir
Thank you
how can i know my script filename while saving format changes ????
The script file name has nothing to do with presentation formats.
Thank you very much helped me alot
You are welcome
That's why CZcams is my first choice than google search!!! Thanks for solution.....
Thank you
Thank you very much.
You are welcome
Very helpful, thank you!
I am glad that it was helpful
Very informative.
I am glad that it was helpful
You're the best! Thank you! It was so hard to find a video that explained this.
Glad it helped!