RMAN-20201: datafile not found in the recovery catalog

[Former Member]

Hi Guys,

Here we are using BRbackup to take backup, also came to know brbackup is using RMAN script to perform backup.

But we got the following error in the backup  log to our production DB as follows.

allocated channel: dsk
channel dsk: SID=102 device type=DISK

executing command: SET NOCFAU

executing command: SET MAX CORRUPT
released channel: dsk
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of set command at 07/31/2014 03:01:13
RMAN-20201: datafile not found in the recovery catalog
RMAN-06010: error while looking up datafile: 43.

coz, datafile was added newly so it may not synchronized with catalog db, or may moved/purged Datafile as well.

But for to synchronize, require catalog DB info, so where shall I find the RMAN scripts which used brbackup, also the brbackup was scheduled

by our system engineers, is there any parameter file is there for the above info ??????

Guide me for the above.

Thanks in Advance,

Sivakumar KS.

[former_member188883]

Hi Sivakumar,

brbackup can use RMAN utility by specifying the parameters in initSID.sap.

Look out of parameter tape_cmd_copy = rman

What is your brtools version ?

Regards,

Deepak Kori

[Former Member]

Thanks for you support. our BRversion is 7.20.33,

But I require to know RMAN script statement used while executing backup.Hope those scripts will be kept in some files,

Coz if we need to synchrnoze manually, then need to know what catalog DB it is using as I mentioned  in my post, we are getting "datafile not found in catalog" error, so either should know  RMAN script statement executions or catalog DB information through any parameter or files etc ???

Hope my query is clear , could you pls. guide me.

Best Regards,

Sivakumar KS.

[former_member188883]

Hi Sivakumar,

RMAN is a native Oracle utility for database administration. Brtools can trigger these native commands when proper parameters are set in initSID.sap file.

could you share entries under init<SID>.sap

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

I does backup scripting using RMAN for oracle, But now the Databases are SAP owned DB,

Here for backup they are using BRBACKUP. moreover initSID.sap ENTRIES for RMAN as follows

backup_type = online
backup_dev_type = util_file
backup_root_dir = /oracle/NBI/sapbackup
stage_root_dir = /oracle/NBI/sapbackup
compress_dir = /oracle/NBI/sapreorg
archive_function = save_delete
archive_copy_dir = /oracle/NBI/redorepository
archive_stage_dir = /oracle/NBI/sapbackup
disk_copy_cmd = copy
stage_copy_cmd = rcp
pipe_copy_cmd = rsh
cpio_flags = -ovB
cpio_in_flags = -iuvB
cpio_disk_flags = -pdcu
rman_maxcorrupt = (43:25)
tape_size = 100G
exec_parallel = 0
volume_archive = (NBIA01, NBIA02, NBIA03, NBIA04, NBIA05,
                  NBIA06, NBIA07, NBIA08, NBIA09, NBIA10,
                  NBIA11, NBIA12, NBIA13, NBIA14, NBIA15,
                  NBIA16, NBIA17, NBIA18, NBIA19, NBIA20,
                  NBIA21, NBIA22, NBIA23, NBIA24, NBIA25,
                  NBIA26, NBIA27, NBIA28, NBIA29, NBIA30)

volume_backup = (NBIB01, NBIB02, NBIB03, NBIB04, NBIB05,
                 NBIB06, NBIB07, NBIB08, NBIB09, NBIB10,
                 NBIB11, NBIB12, NBIB13, NBIB14, NBIB15,
                 NBIB16, NBIB17, NBIB18, NBIB19, NBIB20,
                 NBIB21, NBIB22, NBIB23, NBIB24, NBIB25,
                 NBIB26, NBIB27, NBIB28, NBIB29, NBIB30)

tape_use_count = 100
util_par_file = initNBI.utl
stats_change_threshold = 20

inside initNBI.utl
profile_name = NBI_uk1gcnsd01001.corpnet2.com

Here also no catalogue DB info mentioned also Hope brbackup runs remotely to the individual DB for take backup ?????

But our backup failure error is

RMAN-03002: failure of set command at 07/31/2014 03:01:13

RMAN-20201: datafile not found in the recovery catalog

RMAN-06010: error while looking up datafile: 43.

above error obviously shows that RMAN is using catalog DB as a repository.

now, revert with guidance.

/Siva....

[former_member188883]

Hi Sivakumar,

I do not see any RMAN specific parameters being set under initSID.sap file.

I seems that you are triggering RMAN backup directly rather than through brtools.

Please confirm the same.

In such a case use RMAN commands to catalog db and proceed.

Regards,

Deepak Kori

[Former Member]

Deepak,

Thanks for your support. Brbackup is using RMAN only, which is why got error "Datafile not found in re-synch catalog".

will find out some other way.

Siva..