RMAN recovery catalog registration errors RMAN-03009 ORA-01403

In a new Oracle 12cR2 database, i was attempting to register it with the Recovery Catalog:

RMAN> register database;

starting full resync of recovery catalog

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of register command at 06/24/2019 06:56:42

RMAN-03014: implicit resync of recovery catalog failed

RMAN-03009: failure of full resync command on default channel at 06/24/2019 06:56:42

ORA-01403: no data found

In order to solve this problem I needed to re-create the control file:

SQL> alter database backup controlfile to trace as ‘/orcl/backup/CTL_DEF.txt’;

SQL> exit;

 

// A text file with control file definition is created, I will only use the NORESETLOG section and create a sql based file as shown below (this is template):

vi create_controlfile.sql

CREATE CONTROLFILE REUSE DATABASE “DBT11” NORESETLOGSĀ  ARCHIVELOG

MAXLOGFILES 25

MAXLOGMEMBERS 5

MAXDATAFILES 850

MAXINSTANCES 1

MAXLOGHISTORY 18697

LOGFILE

GROUP 1 (

‘/opt/DBT11/t11LOGA1.log’,

‘/opt/DBT11/t11LOGA2.log’

) SIZE 256M BLOCKSIZE 512,

GROUP 2 (

‘/opt/DBT11/t11LOGB1.log’,

‘/opt/DBT11/t11LOGB2.log’

) SIZE 256M BLOCKSIZE 512,

GROUP 3 (

‘/opt/DBT11/t11LOGC1.log’,

‘/opt/DBT11/t11LOGC2.log’

) SIZE 256M BLOCKSIZE 512

— STANDBY LOGFILE

DATAFILE

‘/data1/DBT11/SYSTEM.ORA’,

‘/data2/DBT11/SYSAUX.ORA’,

‘/data2/DBT11/UNDO010.ORA’,

‘/data3/DBT11/USERD010.ORA’,

‘/data3/DBT11/AMS_TS.DBF’,

‘/data3/DBT11/SSDPROD_TS.DBF’,

‘/data3/DBT11/USERS02.DBF’

CHARACTER SET WE8MSWIN1252

;

 

SQL> STARTUP NOMOUNT

SQL> @create_controlfile.sql

SQL> alter database open;

 

// re-create the temp tablespace as follows:

SQL> ALTER TABLESPACE TEMP ADD TEMPFILE ‘/data1/DBT11/TEMP01.DBF’

SIZE 6557M REUSE AUTOEXTEND ON ;

 

Now try registering the database again:

rman target /

RMAN> connect catalog catalog01/XXXXXX@catalogdb

RMAN> register database;

 

 

 

 

 

 

 

 

 

 

 

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s