Oracle

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 …

Enterprise Manager Cloud Control offers a centralized solution that allows you to manage and monitor the entire Oracle infrastructure (Hardware, OS, database, middleware) and other market products, remembering that no …