DP Backup failed

[Former Member]

Hello Sap Guru

We are running oracle 11g new system build GRC server.

We are triggering online and archive backup but we getting the following errors

The system is up and running

please advise.

thanks

BR0051I BRBACKUP 7.20 (1)

BR0262I Enter database user name[/password]:

BR0055I Start of database backup: befionwe.anf 2011-03-01 20.07.00

BR0484I BRBACKUP log file: /oracle/SID/sapbackup/befionwe.anf

BR0477I Oracle pfile /oracle/SID/112_64/dbs/initSID.ora created from spfile /oracle/SID/112_64/dbs/spfileSID.ora

BR0613I Database instance SID is shut down

BR0280I BRBACKUP time stamp: 2011-03-01 20.07.00

BR0304I Starting and opening database instance SID ...

BR0278E Command output of '/oracle/SID/112_64/bin/sqlplus /nolog < /oracle/SID/sapbackup/.befionwe.spi':

SQL*Plus: Release 11.2.0.2.0 Production on Tue Mar 1 20:07:00 2011

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

SQL> SQL> Connected to an idle instance.

SQL>

SQL> ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

ORA-01102: cannot mount database in EXCLUSIVE mode

SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

BR0280I BRBACKUP time stamp: 2011-03-01 20.07.07

BR0279E Return code from '/oracle/SID/112_64/bin/sqlplus /nolog < /oracle/SID/sapbackup/.befionwe.spi': 0

BR0302E SQLPLUS call for database instance SID failed

BR0306E Start and open of database instance SID failed

BR0280I BRBACKUP time stamp: 2011-03-01 20.07.07

BR0301E SQL error -1033 at location BrDbConnect-2, SQL statement:

'CONNECT system/********'

ORA-01033: ORACLE initialization or shutdown in progress

BR0310E Connect to database instance SID failed

BR0056I End of database backup: befionwe.anf 2011-03-01 20.07.07

BR0280I BRBACKUP time stamp: 2011-03-01 20.07.07

BR0054I BRBACKUP terminated with errors

BRBACKUP /sapmnt/SID/exe/brbackup -t online -d util_file -c -m all -u system/******** returned 3

BR0002I BRARCHIVE 7.20 (1)

BR0262I Enter database user name[/password]:

BR0006I Start of offline redolog processing: aefionwl.cds 2011-03-01 20.07.07

BR0484I BRARCHIVE log file: /oracle/SID/saparch/aefionwl.cds

BR0280I BRARCHIVE time stamp: 2011-03-01 20.07.07

BR0301W SQL error -1033 at location BrDbConnect-2, SQL statement:

'CONNECT system/********'

ORA-01033: ORACLE initialization or shutdown in progress

BR0310W Connect to database instance SID failed

BR0280I BRARCHIVE time stamp: 2011-03-01 20.07.07

BR0301W SQL error -1033 at location BrDbConnect-2, SQL statement:

'CONNECT system/********'

ORA-01033: ORACLE initialization or shutdown in progress

BR0310W Connect to database instance SID failed

BR0280I BRARCHIVE time stamp: 2011-03-01 20.07.07

BR0301E SQL error -1033 at location BrDbConnect-2, SQL statement:

'CONNECT system/********'

ORA-01033: ORACLE initialization or shutdown in progress

BR0310W Connect to database instance SID failed

BR0016I 0 offline redolog files processed, total size 0.000 MB

BR0280I BRARCHIVE time stamp: 2011-03-01 20.07.07

BR0301W SQL error -1033 at location BrDbConnect-2, SQL statement:

'CONNECT system/********'

ORA-01033: ORACLE initialization or shutdown in progress

BR0310W Connect to database instance SID failed

BR0007I End of offline redolog processing: aefionwl.cds 2011-03-01 20.07.07

BR0280I BRARCHIVE time stamp: 2011-03-01 20.07.07

BR0005I BRARCHIVE terminated with errors

BRARCHIVE /sapmnt/SID/exe/brarchive -c -d util_file -cds -u system/******** returned 3

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!

============================================================================

[Former Member · Accepted solution]

Seems process hung at your DB level (Trying to stop DB), Try to restart the DB(As said by above techie) and check.

Restart(DB) can help you in the above situation.

Regards,

Nick Loy

[Former Member · Accepted solution]

did restart but still problem exists

[Former Member · Accepted solution]

The alert logs are here below

Thu Mar 03 18:14:48 2011

ALTER DATABASE MOUNT

Successful mount of redo thread 1, with mount id 1726248664

Database mounted in Exclusive Mode

Lost write protection disabled

Completed: ALTER DATABASE MOUNT

Thu Mar 03 18:14:53 2011

ALTER DATABASE OPEN

LGWR: STARTING ARCH PROCESSES

Thu Mar 03 18:14:54 2011

ARC0 started with pid=18, OS id=1052860

ARC0: Archival started

LGWR: STARTING ARCH PROCESSES COMPLETE

ARC0: STARTING ARCH PROCESSES

Thu Mar 03 18:14:55 2011

ARC1 started with pid=19, OS id=1245434

Thread 1 opened at log sequence 1999

Current log# 3 seq# 1999 mem# 0: /oracle/GRC/origlogA/log_g13m1.dbf

Current log# 3 seq# 1999 mem# 1: /oracle/GRC/mirrlogA/log_g13m2.dbf

Successful open of redo thread 1

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

SMON: enabling cache recovery

Thu Mar 03 18:14:55 2011

ARC2 started with pid=20, OS id=987390

Thu Mar 03 18:14:55 2011

ARC3 started with pid=21, OS id=901286

ARC1: Archival started

ARC2: Archival started

ARC2: Becoming the 'no FAL' ARCH

ARC2: Becoming the 'no SRL' ARCH

ARC1: Becoming the heartbeat ARCH

[999512] Successfully onlined Undo Tablespace 2.

Undo initialization finished serial:0 start:1395201703 end:1395201903 diff:200 (2 seconds)

Verifying file header compatibility for 11g tablespace encryption..

Verifying 11g file header compatibility for tablespace encryption completed

SMON: enabling tx recovery

Database Characterset is UTF8

No Resource Manager plan active

ARC3: Archival started

ARC0: STARTING ARCH PROCESSES COMPLETE

Incremental checkpoint up to RBA [0x7cf.3cfc.0], current log tail at RBA [0x7cf.3d2d.0]

Starting background process QMNC

Thu Mar 03 18:14:58 2011

QMNC started with pid=22, OS id=848052

Completed: ALTER DATABASE OPEN

Thu Mar 03 18:15:02 2011

db_recovery_file_dest_size of 30000 MB is 0.00% used. This is a

user-specified limit on the amount of space that will be used by this

database for recovery-related files, and does not reflect the amount of

space available in the underlying filesystem or ASM diskgroup.

Thu Mar 03 18:17:03 2011

Shutting down instance (immediate)

Shutting down instance: further logons disabled

Stopping background process MMNL

Stopping background process MMON

License high water mark = 18

ALTER DATABASE CLOSE NORMAL

Thu Mar 03 18:17:06 2011

SMON: disabling tx recovery

SMON: disabling cache recovery

Thu Mar 03 18:17:06 2011

Shutting down archive processes

Archiving is disabled

Thu Mar 03 18:17:06 2011

ARCH shutting down

ARC3: Archival stopped

Thu Mar 03 18:17:06 2011

ARCH shutting down

ARC2: Archival stopped

Thu Mar 03 18:17:06 2011

ARCH shutting down

ARC1: Archival stopped

Thu Mar 03 18:17:07 2011

ARCH shutting down

ARC0: Archival stopped

Thread 1 closed at log sequence 1999

Successful close of redo thread 1

Completed: ALTER DATABASE CLOSE NORMAL

ALTER DATABASE DISMOUNT

Completed: ALTER DATABASE DISMOUNT

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Thu Mar 03 18:17:09 2011

Stopping background process VKTM

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Thu Mar 03 18:17:12 2011

Instance shutdown complete

Thu Mar 03 18:17:56 2011

Starting ORACLE instance (normal)

sskgpgetexecname failed to get name

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 3

Autotune of undo retention is turned on.

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options.

Using parameter settings in server-GRCe spfile /oracle/GRC/11202/dbs/spfileGRC.ora

System parameters with non-default values:

processes = 80

sessions = 162

event = "10027"

event = "10028"

event = "10142"

event = "10183"

event = "10191"

event = "38068 level 100"

event = "38085"

event = "38087"

event = "44951 level 1024"

shared_pool_size = 1120M

filesystemio_options = "setall"

firstspare_parameter = 1

control_files = "/oracle/GRC/origlogA/cntrl/cntrlGRC.dbf"

control_files = "/oracle/GRC/origlogB/cntrl/cntrlGRC.dbf"

control_files = "/oracle/GRC/sapdata1/cntrl/cntrlGRC.dbf"

control_file_record_keep_time= 30

db_block_size = 8192

db_cache_size = 1120M

compatible = "11.2.0"

log_archive_dest_1 = "LOCATION=/oracle/GRC/oraarch/GRCarch"

log_archive_format = "%t_%s_%r.dbf"

db_recovery_file_dest = "/oracle/GRC/oraflash"

db_recovery_file_dest_size= 30000M

log_checkpoints_to_alert = TRUE

replication_dependency_tracking= FALSE

undo_tablespace = "PSAPUNDO"

inmemory_undo = FALSE

recyclebin = "off"

remote_os_authent = TRUE

remote_login_passwordfile= "EXCLUSIVE"

parallel_execution_message_size= 16384

tablelookup_prefetch_size= 0

fixcontrol = "4728348:OFF"

fixcontrol = "5099019:ON"

fixcontrol = "5483301:OFF"

fixcontrol = "5705630:ON"

fixcontrol = "6399597:ON"

fixcontrol = "6430500:ON"

fixcontrol = "6440977:ON"

fixcontrol = "6626018:ON"

fixcontrol = "6972291:ON"

fixcontrol = "8937971:ON"

fixcontrol = "9196440:ON"

fixcontrol = "9495669:ON"

audit_file_dest = "/oracle/GRC/saptrace/audit"

db_name = "GRC"

open_cursors = 2000

sortelimination_cost_ratio= 10

btree_bitmap_plans = FALSE

star_transformation_enabled= "true"

parallel_threads_per_cpu = 1

optimizer_index_cost_adj = 20

query_rewrite_enabled = "false"

indexjoin_enabled = FALSE

optimpeek_user_binds = FALSE

pga_aggregate_target = 800M

optimizermjc_enabled = FALSE

diagnostic_dest = "/oracle/GRC/saptrace"

max_dump_file_size = "20000"

Deprecated system parameters with specified values:

remote_os_authent

End of deprecated system parameter listing

Thu Mar 03 18:17:56 2011

PMON started with pid=2, OS id=1040510

Thu Mar 03 18:17:57 2011

PSP0 started with pid=3, OS id=1089696

Thu Mar 03 18:17:58 2011

VKTM started with pid=4, OS id=1159336 at elevated priority

VKTM running at (10)millisec precision with DBRM quantum (100)ms

Thu Mar 03 18:17:58 2011

GEN0 started with pid=5, OS id=594118

Thu Mar 03 18:17:58 2011

DIAG started with pid=6, OS id=475200

Thu Mar 03 18:17:58 2011

DBRM started with pid=7, OS id=929888

Thu Mar 03 18:17:58 2011

DIA0 started with pid=8, OS id=569450

Thu Mar 03 18:17:58 2011

MMAN started with pid=9, OS id=942284

Thu Mar 03 18:17:58 2011

DBW0 started with pid=10, OS id=532678

Thu Mar 03 18:17:59 2011

LGWR started with pid=11, OS id=1228980

Thu Mar 03 18:17:59 2011

CKPT started with pid=12, OS id=876766

Thu Mar 03 18:17:59 2011

SMON started with pid=13, OS id=254122

Thu Mar 03 18:17:59 2011

RECO started with pid=14, OS id=1093710

Thu Mar 03 18:17:59 2011

MMON started with pid=15, OS id=589874

Thu Mar 03 18:17:59 2011

MMNL started with pid=16, OS id=848090

ORACLE_BASE from environment = /oracle

Thu Mar 03 18:17:59 2011

ALTER DATABASE MOUNT

Successful mount of redo thread 1, with mount id 1726187415

Database mounted in Exclusive Mode

Lost write protection disabled

Completed: ALTER DATABASE MOUNT

Thu Mar 03 18:18:04 2011

ALTER DATABASE OPEN

LGWR: STARTING ARCH PROCESSES

Thu Mar 03 18:18:05 2011

ARC0 started with pid=18, OS id=462868

ARC0: Archival started

LGWR: STARTING ARCH PROCESSES COMPLETE

ARC0: STARTING ARCH PROCESSES

Thu Mar 03 18:18:06 2011

ARC1 started with pid=19, OS id=1212568

Thread 1 opened at log sequence 1999

Current log# 3 seq# 1999 mem# 0: /oracle/GRC/origlogA/log_g13m1.dbf

Current log# 3 seq# 1999 mem# 1: /oracle/GRC/mirrlogA/log_g13m2.dbf

Successful open of redo thread 1

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

SMON: enabling cache recovery

Thu Mar 03 18:18:06 2011

ARC2 started with pid=20, OS id=901292

Thu Mar 03 18:18:06 2011

ARC3 started with pid=21, OS id=987164

ARC1: Archival started

ARC2: Archival started

ARC3: Archival started

ARC0: STARTING ARCH PROCESSES COMPLETE

ARC0: Becoming the 'no FAL' ARCH

ARC0: Becoming the 'no SRL' ARCH

ARC2: Becoming the heartbeat ARCH

[1122420] Successfully onlined Undo Tablespace 2.

Undo initialization finished serial:0 start:1395393032 end:1395393426 diff:394 (3 seconds)

Verifying file header compatibility for 11g tablespace encryption..

Verifying 11g file header compatibility for tablespace encryption completed

SMON: enabling tx recovery

Database Characterset is UTF8

No Resource Manager plan active

Incremental checkpoint up to RBA [0x7cf.3f8d.0], current log tail at RBA [0x7cf.3fbc.0]

Starting background process QMNC

Thu Mar 03 18:18:09 2011

QMNC started with pid=22, OS id=1052864

Completed: ALTER DATABASE OPEN

Thu Mar 03 18:18:15 2011

db_recovery_file_dest_size of 30000 MB is 0.00% used. This is a

user-specified limit on the amount of space that will be used by this

database for recovery-related files, and does not reflect the amount of

space available in the underlying filesystem or ASM diskgroup.

Thu Mar 03 18:19:00 2011

Starting background process SMCO

Thu Mar 03 18:19:00 2011

SMCO started with pid=41, OS id=1200262

Thu Mar 03 18:22:48 2011

Beginning log switch checkpoint up to RBA [0x7d0.2.10], SCN: 12990298

Thread 1 advanced to log sequence 2000 (LGWR switch)

Current log# 4 seq# 2000 mem# 0: /oracle/GRC/origlogB/log_g14m1.dbf

Current log# 4 seq# 2000 mem# 1: /oracle/GRC/mirrlogB/log_g14m2.dbf

Thu Mar 03 18:22:49 2011

Archived Log entry 1395 added for thread 1 sequence 1999 ID 0x66b93316 dest 1:

Thu Mar 03 18:27:50 2011

Completed checkpoint up to RBA [0x7d0.2.10], SCN: 12990298

Thu Mar 03 18:48:10 2011

Incremental checkpoint up to RBA [0x7d0.2760.0], current log tail at RBA [0x7d0.27a4.0]

Thu Mar 03 19:18:11 2011

Incremental checkpoint up to RBA [0x7d0.34bf.0], current log tail at RBA [0x7d0.36cb.0]

Thu Mar 03 19:48:12 2011

Incremental checkpoint up to RBA [0x7d0.52d8.0], current log tail at RBA [0x7d0.5317.0]

Thu Mar 03 20:18:14 2011

Incremental checkpoint up to RBA [0x7d0.5f13.0], current log tail at RBA [0x7d0.5f4e.0]

sadca101:oraGRC 13>

[former_member182313 · Accepted solution]

Check your environment variable: ORACLE_SID. Is that GRC or SID? It should be set to GRC. This env var and other variables are set in the file .dbenv_<host_name>.csh or .dbenv_<host_name>.sh file depending on which shell OraSID user is defualting to.

Secondly check if spfileGRC.ora or initGRC.ora exists in $ORACLE_HOME/dbs dir.

Your brtools - probably because the environment is wrong- is accessing initSID.ora file.

Also make sure the files .dbenv* for both c shell and Bourne shell are consistent. The database may be up because it was started in non-default shell of ora<sid> user whereas brtools uses default shell which doesn't probably point to Oracle SID GRC.

Bala

[Former Member · Accepted solution]

its GRC

as per checking database are open, init and spfile files exists

SQL> select open_mode from v$database;

OPEN_MODE

-

---

READ WRITE

SQL> select status, database_status from v$instance;

STATUS DATABASE_STATUS

-

---

-

---

OPEN ACTIVE

[former_member182313 · Accepted solution]

Your environment is pointing to SID called SID. BRTOOLS is trying to connect to SID not GRC.

[Former Member · Accepted solution]

Hello

SYSTEM user has the SYSDBA authorization, also tried creating another user and reintegrated again in DP but still error persists

also tried the step-by-step starting up database but there are no error found

SQL> startup nomount;

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area 2405273600 bytes

Fixed Size 2221896 bytes

Variable Size 1207961784 bytes

Database Buffers 1174405120 bytes

Redo Buffers 20684800 bytes

SQL> alter database mount;

Database altered.

SQL> alter database open;

Database altered.

SQL> exit

As per checking ORA-32004 is related to the parameter remote_os_authent set as per recommendation in sapnote 1431798.

Also tried to recreated spfile still error persists

yes the oracle is pointing to GRC not to SID "sorry for typo error of SID instead of GRC"

[volker_borowski2 · Accepted solution]

HI,

what about this ?

BR0051I BRBACKUP 7.20 (1)

I think the current patchlevel of brtools 7.20 is 10 or 12 ! Update and apply the corresponding sapdba_role.sql.

There is a section in the Upgrade guide, that states to create a symlink in $ORACLE_HOME/lib for brtools.

Did you do that ?

Volker

[Former Member · Accepted solution]

do you think the following parameters at initGRC.sap has impact on the backup run?

backup_type = offline

backup_dev_type = tape --> do you think we should change it to util_file?

our backup command from DP is issuing this command line

brarchive -c -d util_file -cds -u system/******** returned 3

[former_member266290 · Accepted solution]

>

> backup_type = offline

> backup_dev_type = tape --> do you think we should change it to util_file?

>

For using DP for backup, the backup_dev_type should have value util_file.

Regards

[former_member266290 · Accepted solution]

Hi

1) First remove the entry of this system form DP database as follows:

On the DP server go to directory

C:\Program Files\OmniBack\Config\Server\Integ\Config\SAP

rename following files for your SAP system to something else like

hostname.domain.com%_OB2_GLOBAL to  ... hostname.domain.com%_OB2_GLOBAL.old

and

hostname.domain.com%SID  to  ...  hostname.domain.com%SID.old

and After that

Configure the database template from the DP client which will create new entries in DP server.

Hope this will solve your problem..let us know about it.

regards

Vijay

[Former Member · Accepted solution]

Hello All,

we are able to change and add some parameters and environment in GRC system. but error still persists.

we add the following environment:

env | grep OB2

OB2BARHOSTNAME=GRCCA101.corp.net

OB2HOSTNAME=GRCCA101.corp.net

OB2APPNAME=GRC

set the following parameters:

backup_dev_type = util_file

backup_type = online_cons

and also tried removing old integration files pointing to other <SID> under .......\Config\Server\Integ\Config\SAP of cell manager and reintegrate it again.

test backup trigger from data protector is still having error seen below:

BR0613I Database instance GRC is shut down <<< error from DP

but when we trigger archive and online backup locally in the server with same command the errors is different and the error is only resulting to the missing redologs that we recently moved to other temp direcoty

oracle_sid GRC

oracle_home /oracle/GRC/11202

oracle_profile /oracle/GRC/11202/dbs/initGRC.ora

sapdata_home /oracle/GRC

sap_profile /oracle/GRC/11202/dbs/initGRC.sap

backup_dev_type util_file

archive_dupl_del only

system_info oraGRC/oraGRC grcca101 AIX 3 5 00C8EA2E4C00

oracle_info GRC 11.2.0.2.0 8192 2075 13851481 grcca101 UTF8 UTF8 1723374358

sap_info 702 SAPSR3 GRC TEMPLICENSE R3_ORA INITIAL

make_info rs6000_64 OCI_102 Mar 6 2010

command_line brarchive -c -d util_file -cds -u

BR0017W Offline redolog file '/oracle/GRC/oraarch/GRCarch1_1910_742006742.dbf' not found

BR0017W Offline redolog file '/oracle/GRC/oraarch/GRCarch1_1911_742006742.dbf' not found

BR0017W Offline redolog file '/oracle/GRC/oraarch/GRCarch1_1912_742006742.dbf' not found

BR0017W Offline redolog file '/oracle/GRC/oraarch/GRCarch1_1913_742006742.dbf' not found

BR0017W Offline redolog file '/oracle/GRC/oraarch/GRCarch1_1914_742006742.dbf' not found

anything which having problem?

Thanks!

mike

Edited by: Mcphoenix on Mar 11, 2011 4:47 AM

Edited by: Mcphoenix on Mar 11, 2011 4:51 AM

[former_member266290 · Accepted solution]

>

>

> test backup trigger from data protector is still having error seen below:

>

> BR0613I Database instance GRC is shut down <<< error from DP

>

Please most more messages for failed backup from the DP, it must showing ORA errors.

> but when we trigger archive and online backup locally in the server with same command the errors is different and the error is only resulting to the missing redologs that we recently moved to other temp direcoty

>

>

> BR0017W Offline redolog file '/oracle/GRC/oraarch/GRCarch1_1910_742006742.dbf' not found

> BR0017W Offline redolog file '/oracle/GRC/oraarch/GRCarch1_1911_742006742.dbf' not found

> BR0017W Offline redolog file '/oracle/GRC/oraarch/GRCarch1_1912_742006742.dbf' not found

> BR0017W Offline redolog file '/oracle/GRC/oraarch/GRCarch1_1913_742006742.dbf' not found

> BR0017W Offline redolog file '/oracle/GRC/oraarch/GRCarch1_1914_742006742.dbf' not found

>

Since you have moved redolog files to some another location, its showing warning for those files in your local backup.

I would suggest you restart ( stop SAP, database and reboot ) the whole server.

Regards

Edited by: VijayIngle on Mar 11, 2011 1:54 PM

[Former Member · Accepted solution]

Hello guys,

thanks for all help. our issue has been resolved. issue basically with DataProtector.

the resolution was removing all related integrated file, backup specification in the cell manager and reintegrating the DataProtector to SAP again.

On the first reintegration wont work because there are still integrated files exists.

Thanks for all the help

[Former Member]

Have you checked the Recommended Oracle Parameter note?(Check installation guide for Note no OR search SMP).

compare all the parameters defined in your instance and correct them.

Regards,

Nick Loy

[Former Member]

Yes, all needed parameters has been set-up and review and it fine.

I have question in mind, because this system was reuse for GRC but still has the same hostname (new SAP system and oracle installation) but the DP client was not reinstalled. What we only did is push the patch for the client for data protector. Do you think we should reinstall the DP client instead of using the old client that has been use to the old SAP system.? also the logs from backup is not registering to the DB12 logs but exists in OS level /oracle/GRC/sapbackup and /saparch? any idea?

Thanks!

[former_member266290]

Hi

Please check the privileges SYSTEM user in Oracle.

Make sure that SYSTEM user has the sysdba privilege.

If SYSTEM user has sysdba privilege and still your facing the error,

then create one user in oracle and grant sysdba privilege to this new user.

And while configuring DP for integration with SAP system use this new user.

Let us know, whether this has solved your problem or not.

Regards

Vijay

[Former Member]

Hi,

it looks like your environment is not quite correct..

SQL> SQL> Connected to an idle instance.
SQL> 
SQL> ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
ORA-01102: cannot mount database in EXCLUSIVE mode

But the database is open....

check your environment..

Mark

[Former Member]

Did application and database restart, check alert log nothing seems an issue registered in the alert log

the database are open.

no issue encountered during system restart too but when we trigger backup again from DP issue still persist.

Please advise

[sunny_pahuja2]

Hi,

It looks like some wrong _Fix* parameters are set in your system. First try to stop the database manually. If it does not stop then check alert log file and also paste here.

Thanks

Sunny