error with fullonline_backup (ORA-01031: insufficient privileges)

[Former Member]

Hi experts,

we are facing problem during sap fullonline + redolog backup. while wholeonline+redolog backup working fine.

please see the detail.

........................................................................................................................................

BR0280I BRBACKUP time stamp: 2011-12-22 16.06.40

BR0063I 35 of 35 files processed - 117460.273 of 117460.273 MB done

BR0204I Percentage done: 100.00%, estimated end time: 16:06

BR0001I **************************************************

BR0280I BRBACKUP time stamp: 2011-12-22 16.06.40

BR0317I 'Alter tablespace SYSTEM end backup' successful

BR0280I BRBACKUP time stamp: 2011-12-22 16.06.42

BR0530I Cataloging backups of all database files...

BR0278E Command output of 'SHELL=/bin/sh /oracle/R3P/102_64/bin/rman nocatalog':

Recovery Manager: Release 10.2.0.4.0 - Production on Thu Dec 22 16:06:42 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

RMAN>

RMAN> connect target *
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-01031: insufficient privileges

RMAN> **end-of-file**

RMAN>

host command complete

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37>

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of catalog command at 12/22/2011 16:06:42

RMAN-06171: not connected to target database

RMAN>

Recovery Manager complete.

BR0280I BRBACKUP time stamp: 2011-12-22 16.06.42

BR0279E Return code from 'SHELL=/bin/sh /oracle/R3P/102_64/bin/rman nocatalog': 1

BR0536E RMAN call for database instance R3P failed

BR0280I BRBACKUP time stamp: 2011-12-22 16.06.42

BR0532E Cataloging backups of all database files failed

BR0056I End of database backup: behmnbjo.fnt 2011-12-22 16.06.42

BR0280I BRBACKUP time stamp: 2011-12-22 16.06.42

BR0054I BRBACKUP terminated with errors

......................

Regards

Imran Khan

[nicholas_chang]

Hi,

i dont think is due to authorization issue. There's a different between "FULL" and "WHOLE" database online backup.

Full database backup : Will backup all the databasee files (Inclusing datafiles, online redolog files and the control files) and do the catalog. So that we can use this as the referance backup and we can do the incremental backup.

Whole database backup : Will backup all the databasee files (Inclusing datafiles, online redolog files and the control files). We can't use this for the incremental backup.

As you see from the log, full database online backup is calling RMAN. FYI, backup your system with "Whole" is equally good unless you want to to use incremental backup.

Thanks,

Nicholas Chang

Edited by: Nicholas Chang on Dec 23, 2011 12:03 AM

[Former Member]

Hi,

then how we resolve this issue.

Regards

Khan

[former_member188883]

Hi,

It seems that the Operating System user is not able to login to your target database as sysdba. To confirm this you can try to login to target database using "sqlplus /" on your command OS command prompt

either add the OS user in the dba group, so that it can login to the target database using rman target=/ nocatalog

or use rman target=sys/passwd nocatalog (.. give the username and the password of a sysdba user)

Also check the output of

RMAN> crosscheck archivelog all;

Hope this is useful.

Regards,

Deepak Kori

[Former Member]

Hi,

The system is trying to logon with OPS$ mechanish. So, check the previous thread

Best regards,

Orkun Gedik