RMAN jobs not generating child streams

Question

Hi All,

i have been going through a lot of forums but not have been able to pin point the issue.

Our Master server: NB appliance 5230

Client:&nbsp;Red Hat Enterprise Linux Server release 6.3

output from bphdb on client:

01:00:01.522 [1461] &lt;4&gt; bphdb: INF - setenv NB_ORA_POLICY=client-svr01-RMAN-Inc
	01:00:01.522 [1461] &lt;4&gt; bphdb: INF - setenv NB_ORA_CLIENT=client-svr01
	01:00:01.522 [1461] &lt;4&gt; bphdb: INF - setenv NB_ORA_MODE=B
	01:00:01.522 [1461] &lt;4&gt; bphdb: INF - NB_ORA_POLICY=client-svr01-RMAN-Inc
	01:00:01.522 [1461] &lt;4&gt; bphdb: INF - NB_ORA_SCHED not defined.
	01:00:01.522 [1461] &lt;4&gt; bphdb: INF - NB_ORA_PC_SCHED=Differential-Inc
	01:00:01.522 [1461] &lt;4&gt; bphdb: INF - NB_ORA_SERV=Master-svr01.wiley.com
	01:00:01.522 [1461] &lt;4&gt; bphdb: INF - NB_ORA_PC_BTYPE not set
	01:00:01.522 [1461] &lt;4&gt; bphdb: INF - setenv NB_ORA_FULL=0
	01:00:01.522 [1461] &lt;4&gt; bphdb: INF - setenv NB_ORA_INCR=1
	01:00:01.522 [1461] &lt;4&gt; bphdb: INF - setenv NB_ORA_CINC=0
	01:00:01.522 [1461] &lt;4&gt; bphdb: INF - setenv NB_ORA_SCHEDULED=1
	01:00:01.522 [1461] &lt;4&gt; bphdb: INF - setenv NB_ORA_PARENT_JOBID=38634
	01:00:01.522 [1461] &lt;4&gt; bphdb: INF - BACKUP START 1461
	01:00:01.523 [1461] &lt;4&gt; bphdb: INF - CONTINUE BACKUP message received

&nbsp;

I can see a line:&nbsp;01:00:01.522 [1461] &lt;4&gt; bphdb: INF - NB_ORA_SCHED not defined

but schedule is defined in NBU policy.

&nbsp;

please can you advise which other logs can help identify the issue and where are we going wrong please?

thanks, Anish

marianne · Accepted Answer

The only way to know what is going wrong is to have a look at the script and the script output.

There have been similar issues on this forum with different reasons causing this -&nbsp;
	from issue with RMAN Catalog to problem where the command was too long and had to be moved into a separate cmdfile.

Some previous posts:

RMAN Backup happening without generating child streams&nbsp;

RMAN Backup completed without generating child stream or sometime failing with error code 6&nbsp;

RMAN ISSUE&nbsp;

RMAN backup not trigger&nbsp;

mouse · Answer

Hi Anish,

Please make sure you have both Automatic and Application schedule, check this detailed guide&nbsp;http://http://www.symantec.com/docs/TECH27133

marianne · Answer

The script and script output may help.

michael_g_ander · Answer

The bphdb and dbclient (permission 777) log folders can often help indicate the issue.

These two posts might help you:

https://www-secure.symantec.com/connect/forums/general-database-backup-error-troubleshooting

https://www-secure.symantec.com/connect/forums/general-connectivity-troubleshooting-status-23242558-often-6

As the client is a Linux machine, have your tried to stop the firewall ?&nbsp; service stop iptables, if I remember correctly.

andrew_madsen · Answer

You need to set the RMAN environment variable as well setenv NB_ORA_SCHED. Just because it is defined in the policy the RMAN script will not know which schedule to use until you define it. If you had only one schedule you would have been fine. In your script add the setenv NB_ORA_SCHED = &lt;Schedule Name&gt;;

anishc5 · Answer

Hello All,

We finally managed to resolve this issue.

While going though the script, i noticed that the oracle home was being pointed to a directory that did not exist and DBA also confirmed that cron on the server was not having permission to run the oracle script.

Once the permission adn directory issue was sorted ,the backups started fine.

&nbsp;

I would like to thank all of you for guiding me.. thanks a ton to all of you.

&nbsp;

Regards,

Anish

Forum Discussion

RMAN jobs not generating child streams

6 Replies

Related Content

RMAN Backup happening without generating child streams

Oracle RMAN backup completing succesfully with No KB & no child streams

RMAN Backup completed without generating child stream or sometime failing with error code 6

SQL backup exits status 1 - all child streams successful

3350 Access S3 keys generation error

Recent Discussions

command: bperror

MS-SharePoint policy restore error (2804) .

How to restore a backup

How to configure RBAC

10 years old netbackup appliance database service down, ssl certification out date