When to use SET DBID in RMAN?

According to oracle documentation:Specify a database's database identifier (DBID) when restoring a control file or server parameter file. Restrictions and Usage Notes for the SET DBID Command You should only run the SET DBID command in the following specialized circumstances: You are not connected to a recovery catalog and want to restore the control file … Continue reading When to use SET DBID in RMAN?

Oracle RMAN Multi-Section Feature

RMAN can optionally break up large files into sections and back up and restore these sections independently. This feature is built into RMAN. You can use it by creating multisection backups, which break up the files generated for the backup set into separate files. This can be done for backup sets and image copies. Each … Continue reading Oracle RMAN Multi-Section Feature

Change “Value” Column Width for “show parameter” in sqlplus

If you tried to increase the width of the "VALUE" column, nothing changed: I found that the NAME & Value columns have special names (for type column , it is normal): column NAME_COL_PLUS_SHOW_PARAM format A20column VALUE_COL_PLUS_SHOW_PARAM format A80 Now, it is fine.

What is the difference between Oracle Client 19c and Oracle Client Home 19c?

When I tried to download and install Oracle client 19c, it was my surprise that there are two different versions. See the following information from the oracle site: So, what is the difference between these two versions?. After some research I found that: LINUX.X64_193000_client.zip is the normal (before 19c) installer-based client software, where you can choose … Continue reading What is the difference between Oracle Client 19c and Oracle Client Home 19c?

TNS-04012: Unable to start Oracle Connection Manager instance.

Background: One advantage of the "Connection Manager" is that it can act as if a proxy server between the database client and the database server, especially when there is a firewall between the client and the server.I installed Oracle Client 19c (only the "Connection Manager" and the "Oracle Net Listener" components): https://www.youtube.com/watch?v=R-tSVkRckfs Then I configured … Continue reading TNS-04012: Unable to start Oracle Connection Manager instance.

Oracle Backup & Recovery Hands-on Practice – Oracle Database 18c VM

Do you want to practice recovering from the following common failures (with a guided step-by-step procedure)?: Recovering from a critical file loss (SYSTEM , UNDO)Recovering from a non-critical file lossRecovering from the loss of the control fileRecovering from the loss of all control filesRecovering from the loss of an inactive redo log fileRecovering from the … Continue reading Oracle Backup & Recovery Hands-on Practice – Oracle Database 18c VM

Schedule RMAN Backup Job in one minute

In this demo, I'm going to schedule a backup job to run daily at a specific time. The backup script provided in this video is for demo only, please don't use it in production without proper testing. https://www.youtube.com/watch?v=sNQXBiOpPUk RegardsAhmed

Oracle Fail Safe 4.2.1 Implementation Plan on Windows 2016 and Oracle 12cR2

Following is the high level plan of Fail Safe 4.2.1 implementation on Windows 2016 and Oracle Database 12cR2 (12.2.0.1). System Administrator Activities: Database Administrator Activities: ThanksAhmed

OPatch error : “Unable to lock Central Inventory”

While applying Patch 31210848 "Microsoft Windows 32-Bit & x86-64 Bundle Patch 12.2.0.1.200714" on database 12.2.0.1on Windows platform I got the following error: Unable to lock Central Inventory. OPatch will attempt to re-lock. Solution: I opened another command window as Administrator, and applied the patch again. This time, it completed successfully without errors: For Windows platform, … Continue reading OPatch error : “Unable to lock Central Inventory”