Oracle RMAN incremental backup doesnt finishing (NMDA1.6)

I think at the time of NW 7.6 NMDA 1.6 didn't exist yet... of course, you know very well you are running ancient versions by current standards.  Anyway, try couple of things - try backup without compression and see if that makes any difference.  I never used level backup with RMAN as it is pain to restore so I am not aware of anything specific that would explain why level backup hangs, but you should check alert log on Oracle side and also via SQL check status of RMAN jobs to see on what procedure is waiting.  This could be very well Oracle issue too.

thanks a lot we try your suggestions

Dear Experts,

Thanks for your suggestions! We have tried it but the problem still exist. On the other hand our Oracle support (database expert) says that RMAN log is just fine and it reports that the backup was successful, but the NetWorker job keeps running.
It seems to me that the NetWorker jobs don't realize that the RMAN script is finished and returned with success.
Pal suggested us to uninstall the old NetWorker (client side) and NMDA and install the latest... we've made the changes but the problem does still occur.

Client side versions:

lgtonmda-8.2.1-1

lgtoclnt-8.2.1-1

Any other suggestions are highly appreciated!

Thanks in advance!

Best regards,

Jozsef

Can you post your RMAN script (skip connect string)?

Here's the full backup config from the client's Apps & Modules tab:

(I only changed the DB_INSTANCE name to DBNAME_STD because of security reasons.)

BACKUP_LOG_OPT:"Back up all logs"; BKUP_DB:"true"; BKUP_FORMAT:"%d_%U"; BKUP_LEVEL:"1"; BKUP_TYPE:"CUMULATIVE"; CAT_INSTANCE:"OMS"; CAT_USER:"rman"; DB_INSTANCE:"DBNAME_STD"; DB_USER:"RMANUSER"; DELETE_LOGS:"true"; DELETE_LOGS_ON_TIMESTAMP:"false"; INCLUDEARCH:"true"; INCLUDECF:"true"; NUM_CHANNELS:"32"; ORACLE_DELETE_EXPIRED_BACKUPS:"false"; ORACLE_FRA_DISK_BACKUPS:"false"; ORACLE_HOME:"/u01/app/oracle/product/11.2.0.3/dbhome_1"; TNS_ADMIN:"/u01/app/oracle/product/11.2.0.3/dbhome_1/network/admin"; name:"RMAN"; type:"NSR Oracle RMAN";

RMAN_SCRIPT:"RUN {

ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH2 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH3 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH4 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH5 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH6 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH7 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH8 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH9 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH10 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH11 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH12 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH13 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH14 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH15 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH16 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH17 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH18 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH19 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH20 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH21 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH22 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH23 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH24 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH25 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH26 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH27 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH28 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH29 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH30 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH31 TYPE 'SBT_TAPE'\;

ALLOCATE CHANNEL CH32 TYPE 'SBT_TAPE'\;

BACKUP

INCREMENTAL  LEVEL 1  CUMULATIVE

FORMAT '%d_%U'

DATABASE

INCLUDE CURRENT CONTROLFILE

PLUS ARCHIVELOG DELETE INPUT

\;

RELEASE CHANNEL CH1\;

RELEASE CHANNEL CH2\;

RELEASE CHANNEL CH3\;

RELEASE CHANNEL CH4\;

RELEASE CHANNEL CH5\;

RELEASE CHANNEL CH6\;

RELEASE CHANNEL CH7\;

RELEASE CHANNEL CH8\;

RELEASE CHANNEL CH9\;

RELEASE CHANNEL CH10\;

RELEASE CHANNEL CH11\;

RELEASE CHANNEL CH12\;

RELEASE CHANNEL CH13\;

RELEASE CHANNEL CH14\;

RELEASE CHANNEL CH15\;

RELEASE CHANNEL CH16\;

RELEASE CHANNEL CH17\;

RELEASE CHANNEL CH18\;

RELEASE CHANNEL CH19\;

RELEASE CHANNEL CH20\;

RELEASE CHANNEL CH21\;

RELEASE CHANNEL CH22\;

RELEASE CHANNEL CH23\;

RELEASE CHANNEL CH24\;

RELEASE CHANNEL CH25\;

RELEASE CHANNEL CH26\;

RELEASE CHANNEL CH27\;

RELEASE CHANNEL CH28\;

RELEASE CHANNEL CH29\;

RELEASE CHANNEL CH30\;

RELEASE CHANNEL CH31\;

RELEASE CHANNEL CH32\;

}"; RMAN_SCRIPT_TEMPLATE:"true"; name:"RMAN Script"; type:"NSR Oracle RMAN Script";

NLS_LANG:"AMERICAN_AMERICA.EE8ISO8859P2"; name:"nsrnmo"; type:"NSR Oracle nsrnmo";

ARCHIVE_LOG_ONLY_FLOW:"false"; ORACLE_DISK_BACKUP_FLOW:"false"; SNAPSHOT_BACKUP_LOGS:"false"; SNAPSHOT_BACKUP_ONLY:"true"; name:"Oracle Internal Options"; type:"NSR Oracle Internal Options";

Kind Regards,

Jozsef

Try to decrease number of channels and see if that makes any difference.  Also, try to test it by running RMAN script from client.

Our database expert has run incremental backup from RMAN and it was totally fine. We've tested it with 8 CHs, with 16 CHs and with 32 CHs as well without any problem.

The problem only appears if we use the NetWorker and in that case the RMAN log says that everything is okay, only the NetWorker thinks that something went wrong. We have a valid incremental backup if we ask the RMAN but the NetWorker job somehow do not want to accept it and just runs onwards...

The way you use it looks like wizard make thing.  Instead, try more classical way (which does not include application information field).  Also, you use 7.6 on client which is not supported and I don't think that version was around when NMDA 1.6 was released - so you need to fix that as well to get compatibility right.

Hi,,,

Can you please answer the following questions:

1. When you run RMAN full backup; what backup level you use level full or incremental level 0?

If you run level full; then you need to change it to level 0; because level full can’t be used as a base for inc backup.

2. What is the duration of full / incremental level 0 backup?

3. Is “BCT”, Block Change Tracking, enabled in your oracle DB?

If the BCT is not enabled; and for the full backup you use incremental level 0, then incremental level 1 backup duration will be almost the same as “incremental level 0” because RMAN will read the entire DB files like the full backup, but it will write less amount of data to the backup volume & you might feel like the backup is not progressing for long time.

Regards,