SOLUTION Please perform the following steps on the physical standby database to resolve the issue. – Please cancel the managed recovery by – Set standby_file_management=manual If the physical standby database…
1. Mục đích – Giúp DBA chủ động quản trị, không bị động trong các trường hợp ban đêm, ngày nghỉ, đi du lịch. Công cụ tự động add datafile…
Hi, today we are going to create script which automatically kill inactive sessions in oracle database. Here i’m going to kill 15 minutes old inactive sessions. Related Keywords: oracle inactive sessions…
How to automate Oracle RMAN Backup with shell script In a real environment, you obviously won’t manually trigger all of the Oracle database backups. An automated mechanism is required to…
The primary database is operating in MAXIMUM PROTECTIONor MAXIMUM AVAILABILITY mode, and the standby database doesnot contain any viable standby redo logfiles.ORA-16086: Redo data cannot be written to the standby…
In the following post we’ll go through every possible scenario where we loose REDO, one by one. REDO is the most crucial part when we talk about recovery and contains…
In this article we will learn How to create a new Physical Standby using Backup Set and also DUPLICATE in RMAN, this is a fast way to create Physical Standby…
Download Software Download the Oracle software from OTN or MOS depending on your support status. Unpack Files Unzip the files. You should now have a single directory called “database” containing…
ORACLE DBA – ACTIVITY CHECKLIST on DAILY/WEEKLY/MONTHLY/NIGHTLY Aim: This activity checklist is for Oracle DBA to perform the complete health check report of production databases on Daily/Weekly/Monthly basis as per…
How to Install the Oracle Enterprise Manager Cloud Control (OEM) 13.5c on Oracle Linux Check the OS Hostname: In case if you have not install the Software & Oracle database…