I have an issue on 11.2.0.4 database (2 node RAC system) on AIX.  Our system is already around 25T and our full backup size almost 3,7Tb with using compress option.

Our number of datafiles are almost 1054.  We are taking our backup to disk using 16 channel. Total full backup duration is almost 4,5 hours.

Our backup duration became almost 7,8 hours last 3 days. I investigated backup log file and I noticed backup start 16 channels and that 16 channel backupsets job done almost 4:30 hours. After 16 channels backupsets  end,  one new channel opening and it keep taking backupsets by using 1 channel.

Read the rest of this entry »

Advertisements

I have been faced with this problem on R12.1.3 2 node 11.2 RAC database on the AIX system. After closed instance 2, it started to gives ORA-17611: ksfd: file ” cannot be accessed, global open closed errors at alert.log file

After making some search We noticed that this is referring publish bug which will be fixed in12.1 (Future Release). Here is the possible solution for this error:

Read the rest of this entry »

I have 11.2.0.4  2 node RAC system on AIX. Due to do security issue I can not get root password.

As you know, I need to close CRS by using crsctl stop crs commandTo can achieve run this command We need to have a root privileges user or root user’ password.

In this post I will share Which grant you need to can stop CRS instead of the Root user.

Read the rest of this entry »

I have faced with that issue on our 12.1.3 EBS system on AIX system with 2 node 11gR2 RAC databases.

During the full backup operation, I noticed that RMAN log mention below error message at the backup log file.

RMAN-03009: failure of backup command on ORA_DISK_3 channel at 03/29/2012 22:19:19
ORA-19566: exceeded limit of 0 corrupt blocks for file +ORADATA/PROD/datafile/apps_ts_xxcustom_data.308.752148073
RMAN-03009: failure of backup command on ORA_DISK_2 channel at 03/29/2012 21:42:32
ORA-19566: exceeded limit of 0 corrupt blocks for file +ORADATA/PROD/datafile/apps_ts_xxcustom_data.395.741949465
RMAN-03009: failure of backup command on ORA_DISK_8 channel at 03/29/2012 22:18:24
ORA-19566: exceeded limit of 0 corrupt blocks for file +ORADATA/PROD/datafile/apps_ts_xxcustom_data.583.753881375

Read the rest of this entry »

Oracle recommended using 3 control file for your database. We also need to duplicate our Control file due to do security issue.

In this post, I will try to explain how We can duplicate a control file when ASM is involved.

Read the rest of this entry »

You can download Oracle Database 19.3.0 on-prem for Linux now from the usual sources:

Read the rest of this entry »

I face with that error message on our 11.2.0.4 RAC database which is working on AIX Operating System.

I started to get ORA-00245: control file backup operation failed &RMAN-03009: failure of Control File and SPFILE Autobackup command on C1 channel xxx errors. I noticed that this error has appeared after I have been enabled block change tracking to can take Incremental backup on my system.

Read the rest of this entry »

You may hit ORA-01000 maximum open cursors exceeded in your daily life.

So what is a cursor? Why you are hitting this error? In this post let us see inside of this error.

Cursors in Oracle

A cursor is a temporary work area created in the system memory when a SQL statement is executed. It can hold more than one row but can process only one row at a time. A set of rows the cursor holds is called an active set. The cursor might be used for retrieving data on a row-by-row basis like a looping statement.

Read the rest of this entry »

One of Our database size almost 35T and We need to back up this system twice in a day. Because of the backup duration time(We are using 16 channel and full backup time almost 2,5 hours) That’s why We decided to pass the Cumulative Incremental backup strategy for this system.

We take Level 0(full) backup on weekend and We take Level 1 Cumulative Incremental backup during working days.

Read the rest of this entry »

I hit this issue while I was trying to rename table (or index) name on 11.2.0.4 database.

Symptoms is:

I use a simple command as following;

alter table [prev_tablename] rename to [last_tablename]

If We put into schema names to this command, We can deal with ORA-14047 error.

The error raises when I put the schema name in front of the last_tablename.

SQL> alter table hr.[prev_tablename] rename to hr.[last_tablename] >>>  Its give ORA-14047

Solution:

SQL> alter table hr.[prev_tablename] rename to [lasttable_name]

 

Advertisements
Advertisements