cancel
Showing results for 
Search instead for 
Did you mean: 

RMON ISSUE ON ORACLE

Tajammul_Ahmed
Regular Advisor

RMON ISSUE ON ORACLE

Hi,

We are using Oracle 9i Standard edition on HP-UNIX, as a backend to support HP Openview (Network Management software).

Also we are taking online backup for this database, We are using HP Openview Data Protector to take online backup, ( Our Backup server is on windows platform and Database is on UNIX).

We had configured successfully oracle online database to be back up, which was working fine from last 3 to 4 months, suddenly it’s not taking the backup ( online database backup fails), I did some level of troubleshooting but couldn’t find the Issues, then I escalated the same to HP, they say's its oracle problem.

Problem : Unable to take Online backup.

HP Solution: according to them it’s RMON problem, I’m not the oracle DBA so I don’t know how to verify RMON settings.

Also I’m unable to login as sysdba.

Here is the detail

Actual situation when backup was working fine.
#su oracle
#Sqlplus / nolog
Sql> connect /as sysdba.
Connected.

Present Situation
#su oracle
SQL> connect /as sysdba
ERROR:
ORA-01031: insufficient privileges

If I use below method it’s working fine.
SQL> connect oracle/oracle as sysdba;
Connected.
SQL>
I know this is some operating system user issue with oracle user, but I don’t know how to solve this.

Summary : I think we have to work on RMON, OS user and Oracle user.

If you need further Info please let me know I’ll provide you.

Your kind help will be highly appreciated to solve this Issue.

Thanks and best regards
Mohammed Tajammul Ahmed.
9 REPLIES
Murat SULUHAN
Honored Contributor

Re: RMON ISSUE ON ORACLE

Hi Mohammed

Could you submit more information for example logs about "online database backup fails"

Best Regards
Murat
Murat Suluhan
Tajammul_Ahmed
Regular Advisor

Re: RMON ISSUE ON ORACLE

Hi,

Here is rmon script
ate channel 'dev_0' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=openview,OB2BARLIST=ORACLE_DAILY_BACKUP)';
allocate channel 'dev_1' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=openview,OB2BARLIST=ORACLE_DAILY_BACKUP)';
allocate channel 'dev_2' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=openview,OB2BARLIST=ORACLE_DAILY_BACKUP)';
allocate channel 'dev_3' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=openview,OB2BARLIST=ORACLE_DAILY_BACKUP)';
backup incremental level
format 'ORACLE_DAILY_BACKUP.dbf'
database;
sql 'alter system archive log current';
backup
format 'ORACLE_DAILY_BACKUP.dbf'
archivelog all;
backup
format 'ORACLE_DAILY_BACKUP.dbf'
current controlfile;

Debug Logs...

Tajammul_Ahmed
Regular Advisor

Re: RMON ISSUE ON ORACLE

Error When backup start..

[Normal] From: BSM@tshpdp.tawasulservices.com "ORACLE_DAILY_BACKUP" Time: 11/21/2007 10:03:15 AM
OB2BAR application on "tshpov1.tawasulservices.com" successfully started.

ob2rman.exe started with arguments:
-backup -full

Recovery Manager: Release 9.2.0.6.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN>
connected to target database: OPENVIEW (DBID=2595768771)
using target database controlfile instead of recovery catalog

RMAN>
RMAN> run {
2> allocate channel 'dev_0' type 'sbt_tape'
3> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=openview,OB2BARLIST=ORACLE_DAILY_BACKUP,OB2BARHOSTNAME=tshpov1.tawasulservices.com)';
4> allocate channel 'dev_1' type 'sbt_tape'
5> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=openview,OB2BARLIST=ORACLE_DAILY_BACKUP,OB2BARHOSTNAME=tshpov1.tawasulservices.com)';
6> allocate channel 'dev_2' type 'sbt_tape'
7> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=openview,OB2BARLIST=ORACLE_DAILY_BACKUP,OB2BARHOSTNAME=tshpov1.tawasulservices.com)';
8> allocate channel 'dev_3' type 'sbt_tape'
9> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=openview,OB2BARLIST=ORACLE_DAILY_BACKUP,OB2BARHOSTNAME=tshpov1.tawasulservices.com)';
10> backup incremental level 0
11> format 'ORACLE_DAILY_BACKUP.dbf'
12> database;
13> sql 'alter system archive log current';
14> backup
15> format 'ORACLE_DAILY_BACKUP.dbf'
16> archivelog all;
17> backup
18> format 'ORACLE_DAILY_BACKUP.dbf'
19> current controlfile;
20> }
allocated channel: dev_0
channel dev_0: sid=54 devtype=SBT_TAPE
channel dev_0: Data Protector A.05.50/330

released channel: dev_0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of allocate command at 11/21/2007 09:58:51
RMAN-06181: multiple channels require Enterprise Edition

RMAN> **end-of-file**

RMAN>

Recovery Manager complete.
[Major] From: ob2rman.exe@tshpov1 "openview" Time: 11/21/07 09:58:52
Backup of Oracle database finished with error.
1. Check Data Protector errors and follow
Data Protector troubleshooting procedure.
2. Check Oracle RMAN errors.

If the Data Protector error is reported please
check the following files:
a) /var/opt/omni/log/oracle8.log on tshpov1
b) /sbtio.log on tshpov1
c) /var/opt/omni/log/debug.log on tshpov1

Note that Oracle RMAN errors are not reported in the above files.

[Normal] From: ob2rman.exe@tshpov1 "openview" Time: 11/21/07 09:58:52
RMAN script saved in /var/opt/omni/tmp/RMAN_ORACLE_DAILY_BACKUP_input.rman file.

[Normal] From: BSM@tshpdp.tawasulservices.com "ORACLE_DAILY_BACKUP" Time: 11/21/2007 10:04:02 AM
OB2BAR application on "tshpov1.tawasulservices.com" disconnected.

[Critical] From: BSM@tshpdp.tawasulservices.com "ORACLE_DAILY_BACKUP" Time: 11/21/2007 10:04:02 AM
None of the Disk Agents completed successfully.
Session has failed.

[Normal] From: BSM@tshpdp.tawasulservices.com "ORACLE_DAILY_BACKUP" Time: 11/21/2007 10:04:02 AM

Backup Statistics:

Session Queuing Time (hours) 0.00
----------------------------------------
Completed Disk Agents ........ 0
Failed Disk Agents ........... 0
Aborted Disk Agents .......... 0
----------------------------------------
Disk Agents Total ........... 0
========================================
Completed Media Agents ....... 0
Failed Media Agents .......... 0
Aborted Media Agents ......... 0
----------------------------------------
Media Agents Total .......... 0
========================================
Mbytes Total ................. 0 MB
Used Media Total ............. 0
Disk Agent Errors Total ...... 0


============================================================================
Session failed!
============================================================================

Also find the Debug logs, please let me know if you need further info to solve this issue.

Thanks and best regards
Mohammed Tajammul Ahmed.
Murat SULUHAN
Honored Contributor

Re: RMON ISSUE ON ORACLE

Hi Mohammed

Error message says everything, you cannot use parallelism with Standart Edition,

RMAN-03002: failure of allocate command at 11/21/2007 09:58:51
RMAN-06181: multiple channels require Enterprise Edition

RMAN> **end-of-file**


Oracle Reference

RMAN-06181 multiple channels require Enterprise Edition

Cause: Attempt to allocate more than one channel in a job.

Action: Remove all except one ALLOCATE CHANNEL command.


http://download.oracle.com/docs/cd/B10500_01/server.920/a96525/rmanus.htm

Apply the action and try again

Best Regards
Murat


Murat Suluhan
Yogeeraj_1
Honored Contributor

Re: RMON ISSUE ON ORACLE

hi,

I think the problem is related to the fact that you are running the Standard Edition of Oracle and trying to run RMAN with options for Enterprise Edition.

When checking the above extract, i can see:
"RMAN-06181: multiple channels require Enterprise Edition "


Try to modify your script so that it uses only one channel and see if it works!

revert!

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Tajammul_Ahmed
Regular Advisor

Re: RMON ISSUE ON ORACLE

Dear All,

Thanks a lot for your reply, unfortunately I'm not the oracle DBA so I don't know how to apply

"Remove all except one ALLOCATE CHANNEL command"

Even I don't know how to modify the script.

I need your help to modify the script or send me the procedure.

Thank.
Murat SULUHAN
Honored Contributor

Re: RMON ISSUE ON ORACLE

Hi

your rman script as follows

RMAN>
RMAN> run {
2> allocate channel 'dev_0' type 'sbt_tape'
3> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=openview,OB2BARLIST=ORACLE_DAI
LY_BACKUP,OB2BARHOSTNAME=tshpov1.tawasulservices.com)';
4> allocate channel 'dev_1' type 'sbt_tape'
5> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=openview,OB2BARLIST=ORACLE_DAI
LY_BACKUP,OB2BARHOSTNAME=tshpov1.tawasulservices.com)';
6> allocate channel 'dev_2' type 'sbt_tape'
7> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=openview,OB2BARLIST=ORACLE_DAI
LY_BACKUP,OB2BARHOSTNAME=tshpov1.tawasulservices.com)';
8> allocate channel 'dev_3' type 'sbt_tape'
9> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=openview,OB2BARLIST=ORACLE_DAI
LY_BACKUP,OB2BARHOSTNAME=tshpov1.tawasulservices.com)';
10> backup incremental level 0
11> format 'ORACLE_DAILY_BACKUP.dbf'
12> database;
13> sql 'alter system archive log current';
14> backup
15> format 'ORACLE_DAILY_BACKUP.dbf'
16> archivelog all;
17> backup
18> format 'ORACLE_DAILY_BACKUP.dbf'
19> current controlfile;
20> }


it must be like below, open your script in DP GUI and then delete allocate channel lines from rman script except first one.

RMAN>
RMAN> run {
allocate channel 'dev_0' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=openview,OB2BARLIST=ORACLE_DAI
LY_BACKUP,OB2BARHOSTNAME=tshpov1.tawasulservices.com)';
backup incremental level 0
format 'ORACLE_DAILY_BACKUP.dbf'
database;
sql 'alter system archive log current';
backup
format 'ORACLE_DAILY_BACKUP.dbf'
archivelog all;
backup
format 'ORACLE_DAILY_BACKUP.dbf'
current controlfile;
}
Save the script and backup session, then try again


Best Regards
Murat

Murat Suluhan
Yogeeraj_1
Honored Contributor

Re: RMON ISSUE ON ORACLE

hi,

Please do not forget to backup any scripts before making the changes.

Also verify if the performance you are getting is acceptable to your DBA. Otherwise you will have to review your stategies.


Good luck!

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Tajammul_Ahmed
Regular Advisor

Re: RMON ISSUE ON ORACLE

Dear All,

Thanks a lot for your help, after changing to channel 1 its working fine, and I had assiged 10 points for each answer.

ones again thanks a lot for your help.

Thanks and best regards
Mohammed Tajammul Ahmed.