The following is the ORA-00237 error message, you can learn the cause and solution of the Oralce error.


ORA-00237 snapshot operation disallowed: controlfile newly created

Cause: An attempt to invoke cfileMakeAndUseSnapshot with a currently mounted control file that was newly created with CREATE CONTROLFILE was made.

Solution: Mount a current control file and retry the operation.

Case:

After recreating the controlfile, a backup was taking immediately after.

The backup failed as follows:

RMAN> backup current controlfile;

allocated channel: ORA_DISK_1 
channel ORA_DISK_1: sid=160 devtype=DISK 
channel ORA_DISK_1: starting full datafile backupset 
channel ORA_DISK_1: specifying datafile(s) in backupset 
RMAN-00571: =========================================================== 
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== 
RMAN-00571: =========================================================== 
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/05/2007 11:12: 
45 
ORA-00237: snapshot operation disallowed: controlfile newly created

 

CAUSE
In most cases the reason for re-creating the controlfile is to perform point time recovery.

When a controlfile is initially created, while still in MOUNT MODE, it is not the current control. There is no real information in the controlfile at this time that ties back in to the database.

The steps taken in this case to produce the ORA-237:

1. The database was started in MOUNT mode
2. The controlfile was recreated.
3. backup current controlfile was issued
The database was never recovered or opened. At this time the controlfile has no relationship to the database.

SOLUTION
The following should occur:

1. The database was started in MOUNT mode
2. Recreate the controlfile
3. Either OPEN the database or RECOVER the database (This makes the new controlfile current)
4. Now you make backup the controlfile.