cancel
Showing results for 
Search instead for 
Did you mean: 

RMAN jobs not generating child streams

anishC5
Level 5
Partner Certified

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: Red Hat Enterprise Linux Server release 6.3

output from bphdb on client:

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

 

I can see a line: 01:00:01.522 [1461] <4> bphdb: INF - NB_ORA_SCHED not defined

but schedule is defined in NBU policy.

 

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

thanks, Anish

1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

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 - 
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 

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

RMAN ISSUE 

RMAN backup not trigger 

View solution in original post

6 REPLIES 6

Mouse
Moderator
Moderator
Partner    VIP    Accredited Certified

Hi Anish,

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

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
The script and script output may help.

Michael_G_Ander
Level 6
Certified

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-...

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

The standard questions: Have you checked: 1) What has changed. 2) The manual 3) If there are any tech notes or VOX posts regarding the issue

Andrew_Madsen
Level 6
Partner

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 = <Schedule Name>;

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

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 - 
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 

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

RMAN ISSUE 

RMAN backup not trigger 

anishC5
Level 5
Partner Certified

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.

 

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

 

Regards,

Anish