Oracle 11g R2 database supports cascade standby database structure. If you are using RAC on primary side, your database version has to be least 11.2.0.2 to support cascade standby structure. You can use to reduce the load on your primary database with using cascade standby database structure. Primary database redo is written to the standby…
Category: Administration
Oracle 12c R2 Downloadable Now
You can download Oracle 12c R2 database now. Only Linux x64 and Solaris Operation Systems supported for now. You can download with below link; http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html Also you can find new features about of Oracle 12c R2 with below links; https://docs.oracle.com/database/122/ https://blogs.oracle.com/sql/entry/12_things_developers_will_love
Oracle 11g Oracle Checkpoint Not Complete, Cannot Allocate New Log Warning
Error: Checkpoint not complete, Cannot Allocate New Log Warning Thread 1 cannot allocate new log, sequence 125487 Checkpoint not complete Solution: Checkpoint not complete messages are generated due to the logs are switching so fast that the checkpoint associated with the log switch isn’t complete. You should increase redo log file size and amount to…
Keep Table in Buffer Pool Oracle 11g
Oracle provides a feature to keep objects in the Buffer pool. This feature allows you to keep the frequently accessed table in memory itself which will provide the faster access of the table. The object will be kept under the KEEP pool and the purpose of the keep pool is to accommodate / cache the…
Create Dblink From Oracle to PostgreSQL Database
Since fetching data from PostgreSQL database to Oracle database, you can create database link between two database systems. For that you can apply below operations. Test Systems PostgreSQL DB IP : 192.168.10.10 OS : Centos 7 x64 Service : postgresql.service Oracle DB IP : 192.168.10.20 OS : OEL 6 x64 PostgreSQL Side psql# create user…
Oracle 12c : RMAN New Features and Enhancements
1. Fine Grained Recovery With Oracle Database 12c, you can use a simple RECOVER TABLE command to perform a point-in-time recovery of a table/partition without having to go through a manual point-in-time recovery process. This command automatically performs the following steps: creation of the auxiliary instance, table recovery, exporting of the object, and importing it…
Oracle 11g Data Guard Failover With Python Script
I wrote a python script to perform failover steps and to take product database IP addresses when product database is down. If you dont use data guard broker or other application for failover operations, you can use this script for failover. My scenario is that I have Oracle 11gR2 2 nodes RAC product database and…
Move Datafiles Of Tablespaces With RMAN Set Newname in Oracle 11g
You can move datafiles of tablespaces. Scenarios can be asm to file system or file system to file system or file system to file system or asm to asm. Below operations show how to move datafiles. You have to take a backup and database has to be archivelog mode before this operations because of that…
Auto Increment Primary Key With Trigger in Oracle 11g
You can provide auto increment primary with trigger by appling below operations. Create Table SQL> CREATE TABLE TESTUSER.TBL_TEST (id number primary key, name varchar2(100)); Create Sequence SQL> CREATE SEQUENCE TESTUSER.SEQ_TEST_ID START WITH 1 MAXVALUE 999999999 MINVALUE 1 CYCLE NOCACHE NOORDER; Create Trigger For Auto Increment SQL> CREATE OR REPLACE TRIGGER TESTUSER.TRG_AUTO_INC_TEST_ID before insert on TESTUSER.TBL_TEST…
How to Migrate Controlfile From File System to ASM Disk in Oracle 11g
You can migrate controlfile from file system to asm disk. You have to stop database and you can do that. Stop Database SQL> shutdown immediate; SQL> startup nomount; Migrate Controlfile RMAN> restore controlfile to ‘+DATA’ from ‘/tmp/controlfile_currentlocation.ctl’; RMAN> restore controlfile to ‘+FRA’ from ‘/tmp/controlfile_currentlocation.ctl’;