PRECHECKS -> 1 Minimum version of the database that can be directly upgraded to Oracle 19c Source Target 11.2.0.4 19c 12.1.0.2 19c 12.2.0.1 19c 18.1 19c 2 Changes in 19c need to be discussed with Application Teams There are lot of changes in 19c like – utl_file_dir, streams, oracle multimedia are de-supported, do check with…
Category: oracle dba
How to Take Incremental Backup and Roll Forward Standby Database in Oracle
How often you see archive missing from production which is not shipped to Standby database ? Rare right? But you will come across this situation once for sure when due to re-org you were forced to delete archives / due to network disconnection archive didn’t got shipped properly and due to automation job archive got…
How to convert Physical Standby database to Snapshot Standby
From oracle 11g we have one more feature enabled to help ourselves. “Snapshot Standby”. This way you can open a physical database in read write mode and revert back to physical standby. So what Option was available for 10g database ? We will discuss it in another blog. Lets start with how to convert Physical…
How to Resize Online Redo Logs in Oracle
There is no command to resize online redo logs in oracle as of now. So to achieve our goal of “How to Resize Online redo logs in oracle” we will do Drop and create online redo logs groups. Sorry to confuse you with title. It’s How to Re-create Online Redo Logs in Oracle. As promised…
How to Recreate Standby Redo logs on Standby Database
Hello, Today we were increasing the size of redo logs. And since we had standby redologs as well. So we had to resize the standby redo logs too. I will create a detailed blog post on how to resize redo log groups. Before that, let me tell you what happened today. For now lets talk…
How to Install Oracle 12c Release 2 on Redhat Linux
Hello Reader :), Welcome back to my Blog . In this post, we will learn how to install Oracle 12c on Redhat Linux Server. We will learn how to Install oracle 12c Release 2 on redhat linux in 3 different ways which will come handy to you when you are installing it at client site….
How to Install Linux on Oracle Virtual Box
If you are searching for How to Install Linux on Windows System without disturbing windows system or How to Install linux System on Oracle Virtual Box. Then you are at right place. AS promised in earlier post where we explained how to install Linux on VMWARE. If you haven’t gone through the post there here…
How to Install Linux (Any Flavors) on VMWARE
Hello Readers, Welcome to my blog – oracledbworld, Today we are going to concentrate on how to Install Linux on VMWARE. To be honest, VMWARE is add-on for a student like us, who are willing to learn, understand, do R&D. VMWARE is not a freeware, hence you will have a restriction for using trail version….