RMAN
duplicate command is a very useful automated way to create a copy/clone of a
database rather than manually creating a clone of a database. Duplicate
database can be created on the same server were source database is running or
on a different server. Duplicate database can be created using RMAN backup of source database,
Oracle Installation guides, Linux Administration tips for DBAs, Performance Tuning tips, Disaster Recovery, RMAN, Dataguard and ORA errors solutions.
No contents from my website can be published anywhere else without my permission. Test every solution before implementing in the production environment.
Tuesday, June 30, 2015
Friday, June 26, 2015
Heartbeat failed to connect to standby. Error is 16009
On one of my 11.2.0.4 dataguard
setup on Windows 64 bit, following errors were being reported every minute, in
alert log file of standby database.
PING[ARC2]: Heartbeat failed to
connect to standby 'proddb'. Error is 16009.
Thu Jun 25 07:01:10 2015 |
Wednesday, June 17, 2015
ORA-29701: unable to connect to Cluster Synchronization Service
On 11.2.0.3 single server grid infrastructure on Windows 2008, I faced ORA-29701 error while starting ASM instance.
C:\>sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jun 17 12:44:08 2015 |
Sunday, June 14, 2015
Killing a process using orakill.exe on Windows
If you kill an oracle session using ALTER SYSTEM KILL SESSION command, status of this session in v$session view is set to “KILLED”, and after some time you no longer see this session. Sometimes it may happen that status of this session
remains “KILLED” for a very long time and resources taken by this session are
still not released. I have observed this especially in
Thursday, June 11, 2015
DDL Logging in Oracle
Starting Oracle 12c, DDL (Data Definition Language) command are logged in a log file which is located under <diag_location>/rdbms/<db_unique_name>/<sid>/log. In my case, it is located under c:\app\oracle\diag\rdbms\db12c\db12c\log directory, and log file name is ddl_<db_name>.log. XML version of this DDL log file is stored under
Subscribe to:
Posts (Atom)
Popular Posts - All Times
-
Finding space usage of tablespaces and database is what many DBAs want to find. In this article I will explain how to find out space usage ...
-
If you want to know how we upgrade an 11g database to 12c using DBUA, click here . For upgrading 12.1.0.1 to 12.1.0.2 using DBUA, ...
-
This error means that you are trying to perform some operation in the database which requires encryption wallet to be open, but wallet is ...
-
By default AWR snapshot interval is set to 60 minutes and retention of snapshots is set to 8 days. For better and precise investigation of...
-
SWAP space recommendation from Oracle corp. for Oracle 11g Release 2 If RAM is between 1 GB and 2 GB, SAWP should be 1.5 times the s...
-
This article explains how to install a 2 nodes Oracle 12cR1 Real Application Cluster (RAC) on Oracle Linux 7. I did this installation on O...
-
In this post I will be demonstrating the steps to upgrade Oracle Grid Infrastructure (GI) 11g (11.2.0.4) to Grid Infrastructure 12c (12.1....
-
ORA-01653: unable to extend table <SCHEMA_NAME>.<SEGMENT_NAME> by 8192 in tablespace <TABLESPACE_NAME> This error is q...
-
It is quite common to see the error ORA-01624 while dropping a redo log group. The full error text is similar to “log <log_group#> n...
-
Error PRCR-1065 and CRS-2529 can be returned while stopping the ASM using srvctl command on Grid Infrastructure 11.2 and above as can be s...
