Databases are suffering from "Checkpoint not complete" in alertlog

V$log listing all the groups are in  ACTIVE and CURRENT status and alert log listing checkpoint not complete

Setting the parameter archive_lag_target   from 180sec to 900 sec resolved the issue, 

Check the impact of setting archive_lag_target in your environment

datafilecopy header validation failure for file +DATA due to file move from file system to ASM via sqlplus

datafilecopy header validation failure for file +DATA

This issue happens due to file move from file system to ASM via sqlplus

The renaming of the datafiles was done via SQL Plus and NOT via RMAN with SWITCH command

Error message looks like "datafilecopy header validation failure for file +DATA"

Solution :

During  RMAN COPY command to move datafiles to a new location (ASM or otherwise), do NOT rename the file via SQLPlus but use the RMAN SWITCH command instead (SWITCH DATAFILE ALL).

Check the alertlog for the message

alter database rename file '/u01user01.dbf  to  '+DATA’;

If SQLPlus has already been used to rename the files the rman metadata can be corrected as follows:

1. Check name of the current datafiles:

RMAN>report schema;

2. Confirm the name of the datafile copies (this will show the SAME list of datafiles):

RMAN>list copy of database;

3. Remove the datafilecopy entries from the rman repository (this will NOT remove the physical
files but simply update the rman repository):

RMAN>change datafilecopy uncatalog;

You can get value from the list copy of database output - do this for every datafile
that is 'duplicated' in the list copy output.

4. Confirm that the copies have been removed:

RMAN>list copy of database;

oracle11g password setting

Viewing Password Settings:

These new settings can be seen by running the below query.

SELECT profile, resource_name, limit
FROM dba_profiles
WHERE profile='DEFAULT';

Resource Name
Oracle Database 11g

Failed_login_attempts 10
Password_grace_time 7 (days)
Password_life_time 180
Password_lock_time 1 (days)
Password_reuse_max Unlimited
Password_reuse_time Unlimited

To size undo tablespace properly

To properly size the UNDO tablespace, it is suggested that you actually observe the workload through the system. After a good workload has been given to the system, you can use the following code to ask Oracle to determine the proper sizing for an UNDO tablespace.
SQL> SET SERVEROUTPUT on
SQL> DECLARE
utbsiz_in_MB NUMBER;
BEGIN
utbsiz_in_MB := DBMS_UNDO_ADV.RBU_MIGRATION;
dbms_output.put_line('undo size : '||utbsiz_in_MB||'MB');
end;
/
undo size : 2800MB
PL/SQL procedure successfully completed.
Run this package during peak hours ie when the load is more in this case it is suggested that we need to set undo tbs to 2800M

RMAN-03009: ORA-00230: operation disallowed: snapshot control file enqueue unavailable

RMAN-03009: failure of Control File and SPFILE Autobackup command on dev_0 channel at 03/23/2007 01:35:21
ORA-00230: operation disallowed: snapshot control file enqueue unavailable


RMAN-03009: failure of Control File and SPFILE Autobackup command on dev_0 channel at 03/23/2007 01:35:21
ORA-00230: operation disallowed: snapshot control file enqueue unavailable
This is due to some job is doing the same activity ie duplicate job running against the db

There may be another job is holding the controlfile ie there may be chances of backup running by another job on same DB just check
Is there another rman backup running and backing up the control file at the same time?

specification does not match any archive log in the recovery catalog

In rman log message

RMAN> connect target *
2> crosscheck archivelog all;
3> list archivelog until time 'sysdate-3';
4> delete noprompt archivelog until time 'sysdate-3';
5>
specification does not match any archive log in the recovery catalog

This can be ignored

It is simply saying that there are no archive logs earlier than 3 days found for deletion

Cross check : on archive dest you will not have archivelogs older than 3 days

ASM cannot be used until Oracle CSS service is started on AIX

Environment : oracle10gR2 on AIX5.3

Problem : When i run the script localconfig add from command prompt on $ORACLE_HOME/bin path as root user to configure and start CSS
# id
uid=0(root) gid=0(root)
#./$ORACLE_HOME/bin/localconfig add

Solution: Install the below Apar’s
xlC.aix50.rte:7.0.0.4
xlC.rte:7.0.0.1
rsct.basic.rte
rsct.compat.clients.rte
rsct.basic.rte
rsct.compat.clients.rte
and run again same command or
#./$ORACLE_HOME/bin/localconfig reset

Note: TO configure ASM Cluser Synchronization Service(CSS) must be configured and started.