My first stop would be the DBA, to hear if anything had been any changed on the database in question or if there anything the alert log.
1) What has changed. ( No changes at the DB end, as what they are saying is as it is failing at media manager layer its not a problem at the DB side)
3) If there are any tech notes or VOX posts regarding the issue : Referred article: 000011002 but its not exactly the issue on our environment. I'm unable to find a real document for this error:
"ORA-19506 ORA-27028 ORA-19511 - channel ch00 disabled, job failed on it will be run on another channel."
In the forums which i referred, some it talks about checking the hostname resolution error or some other communication error, or firewall issue, some talks on permission problems on bp.conf and other such files.
It is not taking any of the channels defined in the RMAN script. But the communication is fine between netbackup master and host. (we checked with the bpclntcmd and this is okay)
The root job from Netbackup triggers as per the schedule , but this in turn should trigger the oracle jobs ( application backups) which is not happening.
The dbclient logs are not being generated, so to dig deeper into the issue, we have planned to restart the services on the host.
Kindly help
Instead of just relying on bpclntcmd which only really checks host name resolution, try to run bptestbpcd under <install path>\admincmd. This will actually verify Netbackup's connection over bpcd.
Hi all,
Michael_G_Ander ,Peteror,GeForce123
The only thing i did from my end is creating user_ops and dbclient folders on the host ( oracle user didnt have read/write permissions on this folder) initially.
Later i asked DB team to submit the jobs from RMAN.and this worked.
I'm still confused and unable to understand why didnt it trigger initially. What all are the parameters for allocating channels ?
Also i have seen Oracle jobs failing sometimes, we dont see complete failure, we could see 5 or 6 jobs failed out of 30 jobs, the jobs which had ran before it and after that success. How can I validate if i have a good backup of the databases, because normally it says the job will retry on other channel. How can we confirm that it had retried or the data is complete or corrupt.
Well if the oracle user didn't have read/write permissions originally that could have caused the error. From what you're saying it sounds like that once the permissons were given, you asked the DBA to submit the job from RMAN and it worked successfully. Is that correct?
In order to validate if the backups of the DB's are good or not, if you use OEM (Oracle Enterprise Manager), you could check the DB there and look at the backup reports. It would say if it completed succesfully even if errors/warnings were thrown, or you could look at the RMAN logs
