Unable to backup Oracle 11g Database

Created: 02 Jan 2012 | 10 comments

0 0 Votes

Hi,

I have Oracle 11g Installed on Windows 2008 (64bit) in the Hyper-V VM

I have Backup Exec 2010 R3 installed in the same Host server where hyper- is there with the Oracle VM.

I have given the authentication in the Server list authentication of the domain and the authentication in the "Database Access" with the same user name password.

I have given the instance authentication without "Recovery Catalog" authentication.

The backup is failling with the unexpexted error.

some time its is giving the there is no agent installed.

Is there any compatability issue oe required some SP/Hotfix

Please, help

Discussion Filed Under:

Backup and Recovery, Backup Exec - 2010, Backup Exec, Agents, Backing Up, Compatibility, Error messages

Login or register to post comments
Comments RSS Feed

Comments

Jan

2012

0 Votes 0

AmolZeroCool

In the job log you will find

In the job log you will find an RMAN log, could you post the error message from that log.

Regards
Amol
__________________________________________________________________________________________
If this response answers your query, please mark it as a solution

Jan

2012

0 Votes 0

RahulG

The Oracle Agent will not

The Oracle Agent will not work with 32bit versions of Oracle installed on a 64bit system, Make sure you have 64bit of oracle installed

If this response answers your concern, please mark it as a "solution"

Jan

2012

0 Votes 0

mrinal.sarkar6200

Here is the RMAN log...

Hi,

Here is teh log:-

Recovery Manager: Release 11.2.0.2.0 - Production on Mon Jan 2 12:52:38 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

 
 # -----------------------------------------------------------------
 # RMAN command section
 # -----------------------------------------------------------------
 
 RUN {
 ALLOCATE CHANNEL ch0
     TYPE 'SBT_TAPE';
 SEND 'BSA_SERVICE_HOST=192.168.0.91,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={4DE7B132-9707-42D3-A0AC-DFFEACBCC0E7},NBBSA_DB_DEVICE_NAME=Oracle-Win::\\Oracle-SRV.BKP.com\turfview';
 BACKUP
     INCREMENTAL LEVEL=0
     FORMAT 'BE_U'
     DATABASE FORCE PLUS ARCHIVELOG FORCE;
 BACKUP CURRENT CONTROLFILE 
     FORMAT 'BE_U';
 
 RELEASE CHANNEL ch0;
 }
 
connected to target database: TURFVIEW (DBID=546603987)

using target database control file instead of recovery catalog
allocated channel: ch0
channel ch0: SID=41 device type=SBT_TAPE
channel ch0: Symantec/BackupExec/1.1.0

sent command to channel: ch0


Starting backup at 02-JAN-12
current log archived
channel ch0: starting archived log backup set
channel ch0: specifying archived log(s) in backup set
input archived log thread=1 sequence=51 RECID=1 STAMP=771221277
input archived log thread=1 sequence=52 RECID=2 STAMP=771221451
input archived log thread=1 sequence=53 RECID=3 STAMP=771221632
input archived log thread=1 sequence=54 RECID=4 STAMP=771221704
input archived log thread=1 sequence=55 RECID=5 STAMP=771221758
input archived log thread=1 sequence=56 RECID=6 STAMP=771221952
input archived log thread=1 sequence=57 RECID=7 STAMP=771222142
input archived log thread=1 sequence=58 RECID=8 STAMP=771222859
input archived log thread=1 sequence=59 RECID=9 STAMP=771223170
input archived log thread=1 sequence=60 RECID=10 STAMP=771223284
input archived log thread=1 sequence=61 RECID=11 STAMP=771223410
input archived log thread=1 sequence=62 RECID=12 STAMP=771223587
input archived log thread=1 sequence=63 RECID=13 STAMP=771224075
input archived log thread=1 sequence=64 RECID=14 STAMP=771224220
input archived log thread=1 sequence=65 RECID=15 STAMP=771224290
input archived log thread=1 sequence=66 RECID=16 STAMP=771224667
input archived log thread=1 sequence=67 RECID=17 STAMP=771224855
input archived log thread=1 sequence=68 RECID=18 STAMP=771225011
input archived log thread=1 sequence=69 RECID=19 STAMP=771225061
input archived log thread=1 sequence=70 RECID=20 STAMP=771225601
input archived log thread=1 sequence=71 RECID=21 STAMP=771225817
input archived log thread=1 sequence=72 RECID=22 STAMP=771226031
input archived log thread=1 sequence=73 RECID=23 STAMP=771226296
input archived log thread=1 sequence=74 RECID=24 STAMP=771226542
input archived log thread=1 sequence=75 RECID=25 STAMP=771226822
input archived log thread=1 sequence=76 RECID=26 STAMP=771226957
input archived log thread=1 sequence=77 RECID=27 STAMP=771459969
input archived log thread=1 sequence=78 RECID=28 STAMP=771460130
input archived log thread=1 sequence=79 RECID=29 STAMP=771460347
input archived log thread=1 sequence=80 RECID=30 STAMP=771460902
input archived log thread=1 sequence=81 RECID=31 STAMP=771510990
input archived log thread=1 sequence=82 RECID=32 STAMP=771511229
input archived log thread=1 sequence=83 RECID=33 STAMP=771511960
channel ch0: starting piece 1 at 02-JAN-12

Devices acquired: 1
Data streams used: 1

Remember, Kowledge & Wisdom always makes a person success.

Mrinal Sarkar

Howrah, India

Jan

2012

0 Votes 0

AmolZeroCool

I guess you missed copying

I guess you missed copying the error message, its located at the bottom of the RMAN log.

Regards
Amol
__________________________________________________________________________________________
If this response answers your query, please mark it as a solution

Jan

2012

0 Votes 0

mrinal.sarkar6200

The complete Logs

Hi,

Here is teh complete logs;-

Job server: BKPSRV
Job name: Oracle-2
Job started: Monday, January 02, 2012 at 12:52:25 PM
Job type: Backup
Job Log: BEX_BKPSRV_00119.xml

Drive and media mount requested: 1/2/2012 12:52:25 PM

No appendable media could be mounted.
Switching to overwrite operation on scratch media.

Device and Media Information
Drive and media information from media mount: 1/2/2012 12:52:25 PM Drive Name: Oracle-Data Media Label: B2D000007 Media GUID: {15c033d9-91bf-44bc-86ec-7ebe3a184faf} Overwrite Protected Until: 1/30/2012 12:52:25 PM Appendable Until: 1/8/2012 12:52:25 PM Targeted Media Set Name: Keep Data for 4 Weeks All Media Used B2D000007

Device and Media Information

Drive and media information from media mount: 1/2/2012 12:52:25 PM
Drive Name: Oracle-Data
Media Label: B2D000007
Media GUID: {15c033d9-91bf-44bc-86ec-7ebe3a184faf}
Overwrite Protected Until: 1/30/2012 12:52:25 PM
Appendable Until: 1/8/2012 12:52:25 PM
Targeted Media Set Name: Keep Data for 4 Weeks


All Media Used
 B2D000007

Job Operation - Backup

Backup Options

Media operation - Append to media, overwrite if no appendable media is available.

Compression Type: Hardware [if available, otherwise none]

Encryption Type: None

WARNING: The option 'Verify after backup completes' was not selected.

Performing a verify operation to make sure that media can be read after the backup has completed is recommended.

Server - Oracle-SRV.BKP.com

Set Information - Oracle-Win::\\Oracle-SRV.BKP.com\turfview

V-79-57344-3844

- The media server was unable to connect to the Remote Agent on machine Oracle-SRV.BKP.com. Remote Agent not detected on Oracle-SRV.BKP.com.

V-79-57344-33861

- The media operation was terminated by the user.

RMAN Output

Recovery Manager: Release 11.2.0.2.0 - Production on Mon Jan 2 12:52:38 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

 
 # -----------------------------------------------------------------
 # RMAN command section
 # -----------------------------------------------------------------
 
 RUN {
 ALLOCATE CHANNEL ch0
     TYPE 'SBT_TAPE';
 SEND 'BSA_SERVICE_HOST=192.168.0.91,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={4DE7B132-9707-42D3-A0AC-DFFEACBCC0E7},NBBSA_DB_DEVICE_NAME=Oracle-Win::\\Oracle-SRV.BKP.com\turfview';
 BACKUP
     INCREMENTAL LEVEL=0
     FORMAT 'BE_U'
     DATABASE FORCE PLUS ARCHIVELOG FORCE;
 BACKUP CURRENT CONTROLFILE 
     FORMAT 'BE_U';
 
 RELEASE CHANNEL ch0;
 }
 
connected to target database: TURFVIEW (DBID=546603987)

using target database control file instead of recovery catalog
allocated channel: ch0
channel ch0: SID=41 device type=SBT_TAPE
channel ch0: Symantec/BackupExec/1.1.0

sent command to channel: ch0


Starting backup at 02-JAN-12
current log archived
channel ch0: starting archived log backup set
channel ch0: specifying archived log(s) in backup set
input archived log thread=1 sequence=51 RECID=1 STAMP=771221277
input archived log thread=1 sequence=52 RECID=2 STAMP=771221451
input archived log thread=1 sequence=53 RECID=3 STAMP=771221632
input archived log thread=1 sequence=54 RECID=4 STAMP=771221704
input archived log thread=1 sequence=55 RECID=5 STAMP=771221758
input archived log thread=1 sequence=56 RECID=6 STAMP=771221952
input archived log thread=1 sequence=57 RECID=7 STAMP=771222142
input archived log thread=1 sequence=58 RECID=8 STAMP=771222859
input archived log thread=1 sequence=59 RECID=9 STAMP=771223170
input archived log thread=1 sequence=60 RECID=10 STAMP=771223284
input archived log thread=1 sequence=61 RECID=11 STAMP=771223410
input archived log thread=1 sequence=62 RECID=12 STAMP=771223587
input archived log thread=1 sequence=63 RECID=13 STAMP=771224075
input archived log thread=1 sequence=64 RECID=14 STAMP=771224220
input archived log thread=1 sequence=65 RECID=15 STAMP=771224290
input archived log thread=1 sequence=66 RECID=16 STAMP=771224667
input archived log thread=1 sequence=67 RECID=17 STAMP=771224855
input archived log thread=1 sequence=68 RECID=18 STAMP=771225011
input archived log thread=1 sequence=69 RECID=19 STAMP=771225061
input archived log thread=1 sequence=70 RECID=20 STAMP=771225601
input archived log thread=1 sequence=71 RECID=21 STAMP=771225817
input archived log thread=1 sequence=72 RECID=22 STAMP=771226031
input archived log thread=1 sequence=73 RECID=23 STAMP=771226296
input archived log thread=1 sequence=74 RECID=24 STAMP=771226542
input archived log thread=1 sequence=75 RECID=25 STAMP=771226822
input archived log thread=1 sequence=76 RECID=26 STAMP=771226957
input archived log thread=1 sequence=77 RECID=27 STAMP=771459969
input archived log thread=1 sequence=78 RECID=28 STAMP=771460130
input archived log thread=1 sequence=79 RECID=29 STAMP=771460347
input archived log thread=1 sequence=80 RECID=30 STAMP=771460902
input archived log thread=1 sequence=81 RECID=31 STAMP=771510990
input archived log thread=1 sequence=82 RECID=32 STAMP=771511229
input archived log thread=1 sequence=83 RECID=33 STAMP=771511960
channel ch0: starting piece 1 at 02-JAN-12

Devices acquired: 1 Data streams used: 1

Job Completion Status
Job ended: Monday, January 02, 2012 at 12:53:37 PM Completed status: Failed Final error: 0xe000846b - The resource could not be backed up because an error occurred while connecting to the Backup Exec for Windows Servers Remote Agent. Make sure that the correct version of the Remote Agent is installed and running on the target computer. If the server or resource no longer exists, remove it from the selection list. Edit the selection list properties, click the View Selection Details tab, and then remove the resource. Final error category: Resource Errors For additional information regarding this error refer to link V-79-57344-33899

Job Completion Status

Job ended: Monday, January 02, 2012 at 12:53:37 PM
Completed status: Failed
Final error: 0xe000846b - The resource could not be backed up because an error occurred while connecting to the Backup Exec for Windows Servers Remote Agent. 
Make sure that the correct version of the Remote Agent is installed and running on the target computer.  If the server or resource no longer exists, remove it from the selection list. Edit the selection list properties, click the View Selection Details tab, and then remove the resource.
Final error category: Resource Errors

For additional information regarding this error refer to link V-79-57344-33899

Errors
Click an error below to locate it in the job log Backup- Oracle-Win::\\Oracle-SRV.BKP.com\turfview Remote Agent not detected on Oracle-SRV.BKP.com. V-79-57344-33861 - The media operation was terminated by the user.

Errors

Click an error below to locate it in the job log

Backup- Oracle-Win::\\Oracle-SRV.BKP.com\turfview
Remote Agent not detected on Oracle-SRV.BKP.com.

V-79-57344-33861 - The media operation was terminated by the user.

Exceptions
Click an exception below to locate it in the job log Backup- Oracle-Win::\\Oracle-SRV.BKP.com\turfview V-79-57344-3844 - The media server was unable to connect to the Remote Agent on machine Oracle-SRV.BKP.com.

Exceptions

Click an exception below to locate it in the job log

Backup- Oracle-Win::\\Oracle-SRV.BKP.com\turfview
V-79-57344-3844 - The media server was unable to connect to the Remote Agent on machine Oracle-SRV.BKP.com.

Remember, Kowledge & Wisdom always makes a person success.

Mrinal Sarkar

Howrah, India

Jan

2012

1 Vote +1

RahulG

Are you running 32 bit

Are you running 32 bit version of oracle on 64bit system ? If yes then it will not work .

Make sure the remote agent service is started , try backing up some other set of files from the server and see if they gets backedup fine .Also check the event log on the oracle server

If this response answers your concern, please mark it as a "solution"

Jan

2012

0 Votes 0

mrinal.sarkar6200

No its is 64bit...

Hi,

The Oracle 11g version is a 64bit one .

AND I have tried to take some files from C drive of the Oracle Server and found successful.

Thanks.

Remember, Kowledge & Wisdom always makes a person success.

Mrinal Sarkar

Howrah, India

Jan

2012

0 Votes 0

RahulG

Does the remote agent service

Does the remote agent service stops when you run the oracle backup ?

If this response answers your concern, please mark it as a "solution"

Jan

2012

0 Votes 0

mrinal.sarkar6200

No...

Hi,

No the service is working fine..

I have used the "win" application in the Oracle script folder.

But the there is error

The media server was unable to connect to the Remote Agent on machine Oracle-SRV.BKP.com.
Remote Agent not detected on Oracle-SRV.BKP.com.
Devices acquired: 1
Data streams used: 1

Location:-

Thanks.

Remember, Kowledge & Wisdom always makes a person success.

Mrinal Sarkar

Howrah, India

Jan

2012

2 Votes +2

mrinal.sarkar6200

Almost done ....

Hi,

I have changed in some place for connection and authenticatin fromm and in Oracle server nad Media server.

Added media IP address in the publish option in the Backup utility Agent in the Oracle server.

Used IP address of the media server (instead of Media server name) in the Oracle TAB for Media address.

And

STOPPED THE FIREWALL IN BOTH THE SERVER, MEDIA SERVER AND ORACLE SERVER.

Violia its working......

Its was a connectivity issue....

As I have checked the RMAN logs where it was showing that media server have started the database but it was unable to send the backup to the media serever.

Now I need to find that which port was blocking this backup from the Oracle serer to the Symantec Backup Exec 2010 R3 Media server.

Thanks.

Remember, Kowledge & Wisdom always makes a person success.

Mrinal Sarkar

Howrah, India

Unable to backup Oracle 11g Database

Comments

Would you like to reply?

Links

Technical Support

Symantec.com

Store

Community Stats