RMAN backup failed after issuing “alter database open resetlogs” command

By PhDs, (© Copyright reserved), April 15, 2007 at 10:46 am · Category: Oracle DBA

(No Ratings Yet)

Loading ...

You did a restore and recovey, and then open database using this command:

Alter database open resetlogs;

Now you want to do a full backup but failed with the following error message:

RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS RMAN-00571: =============================================== RMAN-03002: failure of crosscheck command at 04/15/2007 10:59:36 RMAN-12010: automatic channel allocation initialization failed RMAN-06004: ORACLE error from recovery catalog database: RMAN-20003: target database incarnation not found in recovery catalog

What you should do is to recreate RMAN catalog schema and catalog.

1, create RMAN catalog schema.

sqlplus /nolog connect sys/xxx@rman as sysdba

create tablespace rmancatalog datafile 'C:\Oracle\oradata\Rman\rmancatalog.dbf' size 50m;

create user rmanager identified by xxx temporary tablespace temp default tablespace rmancatalog quota unlimited on rmancatalog;

grant recovery_catalog_owner, connect, resource to rmanager;

exit;

2, Recreate catalog

dos>rman catalog rmansiit/xxx@rman target sys/xxx@crm

RMAN> create catalog tablespace rmancatalog;

recovery catalog created

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

#run once
RUN {
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1;
configure channel device type disk format = “L:\Rman_backup\%d_%u_%s_%p” MAXPIECESIZE 15000m;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘L:\Rman_backup\%d_%F.ctl’;
configure maxsetsize to 15000m;
}