Internal Database Backups Errors. (677 Views)
Reply
Frequent Advisor
BobbyR
Posts: 60
Registered: ‎06-21-2012
Message 1 of 20 (677 Views)

Internal Database Backups Errors.

Hi All,

 

Newbie question again. :-)

 

I am trying to backup DataProtector 7.0 IDB in a Windows Server 2003 R2 environment. I doubt this is the problem, but I had added a Dell Powervault tape changer to our system. I have NO problems with any other backups. I used to backup up the IDB with no errors.

 

I get the following errors:

 

With Encryption:.

  Error Retrieving Encryption Key.

 

Without Encryption ( Because I just want it to work):

  None of the Disk Agents Completed Successfully.

 

I have created a new Media Pool and tried different tape changers. Like I said before no other backups on same system have this problem. I even tried to create the job.

 

Please help.

 

 

 

Honored Contributor
Eblyn Solis
Posts: 1,324
Registered: ‎10-19-2007
Message 2 of 20 (666 Views)

Re: Internal Database Backups Errors.

Hi,

 

With no session running, run this command and post output:

omnidbcheck -extended

 

looks like some corruption in your IDB

 

Regards

Valued Contributor
nikhil_d
Posts: 122
Registered: ‎09-21-2012
Message 3 of 20 (663 Views)

Re: Internal Database Backups Errors.

can you show the full session log instead of just the error? Or at least a couple of lines before and after the error occurs?

Frequent Advisor
BobbyR
Posts: 60
Registered: ‎06-21-2012
Message 4 of 20 (659 Views)

Re: Internal Database Backups Errors.

This is scary.

 

I ran the command: omnidbcheck -extended

 

got

 

Database check is already running!

 

Valued Contributor
nikhil_d
Posts: 122
Registered: ‎09-21-2012
Message 5 of 20 (656 Views)

Re: Internal Database Backups Errors.

not much scary...by default IDB check runs before IDB backup. So that might be the case.....

can you post the session log??

Respected Contributor
drpixel
Posts: 231
Registered: ‎06-11-2010
Message 6 of 20 (653 Views)

Re: Internal Database Backups Errors.

Do you have your IDB backup running while you are doing the omnidbcheck ?

 

Regards,

Christophe
Frequent Advisor
BobbyR
Posts: 60
Registered: ‎06-21-2012
Message 7 of 20 (650 Views)

Re: Internal Database Backups Errors.

here is the session log.

 

Normal] From: BSM@amedapusam832.amed.ds.army.mil "_DP IDB"  Time: 11/9/2012 9:20:39 AM

      Backup session 2012/11/09-67 started.

 

[Normal] From: BMA@amedapusam832.amed.ds.army.mil "HP:Ultrium 4-SCSI_1(2)"  Time: 11/9/2012 9:20:46 AM

      STARTING Media Agent "HP:Ultrium 4-SCSI_1(2)"

 

[Normal] From: BMA@amedapusam832.amed.ds.army.mil "HP:Ultrium 4-SCSI_1(2)"  Time: 11/9/2012 9:20:51 AM

      By: UMA@amedapusam832.amed.ds.army.mil@Changer1:0:6:0

      Loading medium from slot 4 to device Tape4:0:5:1C

 

[Normal] From: DBBDA@amedapusam832.amed.ds.army.mil "[Database]: amedapusam832.amed.ds.army.mil"  Time: 11/9/2012 9:21:44 AM

      STARTING Database HotBackup Disk Agent on amedapusam832.amed.ds.army.mil "[Database]: amedapusam832.amed.ds.army.mil".

 

[Critical] From: BMA@amedapusam832.amed.ds.army.mil "HP:Ultrium 4-SCSI_1(2)"  Time: 11/9/2012 9:21:46 AM

[90:6111]   Error retrieving encryption key.

 

[Normal] From: BMA@amedapusam832.amed.ds.army.mil "HP:Ultrium 4-SCSI_1(2)"  Time: 11/9/2012 9:21:54 AM

      Tape4:0:5:1C

      Medium header verification completed, 0 errors found.

 

[Normal] From: BMA@amedapusam832.amed.ds.army.mil "HP:Ultrium 4-SCSI_1(2)"  Time: 11/9/2012 9:22:13 AM

      By: UMA@amedapusam832.amed.ds.army.mil@Changer1:0:6:0

      Unloading medium to slot 4 from device Tape4:0:5:1C

 

[Normal] From: BMA@amedapusam832.amed.ds.army.mil "HP:Ultrium 4-SCSI_1(2)"  Time: 11/9/2012 9:22:28 AM

      ABORTED Media Agent "HP:Ultrium 4-SCSI_1(2)"

 

[Critical] From: BSM@amedapusam832.amed.ds.army.mil "_DP IDB"  Time: 11/9/2012 9:22:29 AM

      None of the Disk Agents completed successfully.

      Session has failed.

 

Frequent Advisor
BobbyR
Posts: 60
Registered: ‎06-21-2012
Message 8 of 20 (644 Views)

Re: Internal Database Backups Errors.

No, nothing was running.
Respected Contributor
drpixel
Posts: 231
Registered: ‎06-11-2010
Message 9 of 20 (638 Views)

Re: Internal Database Backups Errors.

 

Just have a look in the c:\program files\omniback\tmp (or c:\programdata\omniback\tmp) for the existence of a dbcheck.lck file.

If it exists :

omnisv -stop

remove the .lck file

omnisv -start

 

run omnidbcheck as asked.

Regards,

Christophe
Valued Contributor
nikhil_d
Posts: 122
Registered: ‎09-21-2012
Message 10 of 20 (637 Views)

Re: Internal Database Backups Errors.

my best guess is you are trying to append the IDB backup to an encrypted tape, and the key is nissing.

Please check if the key exists by omnikeytool -list

 

And try the backup with a fresh tape, if it succeeds then proceed further.

Frequent Advisor
BobbyR
Posts: 60
Registered: ‎06-21-2012
Message 11 of 20 (629 Views)

Re: Internal Database Backups Errors.

Ok I removed the lock, its actually .LK.

 

Ran Omnitrig -extended

 

Looks like still runnig ?

 

Check Level                Mode                  Status

Core                            -core

 

How long does it take?

 

I have created a new pool, and reformated tapes also. Should I try new tape?

Respected Contributor
drpixel
Posts: 231
Registered: ‎06-11-2010
Message 12 of 20 (623 Views)

Re: Internal Database Backups Errors.

"Ran Omnitrig -extended"  ... you mean omnidbcheck -extended  ...

 

The running time is dependant of how big is you IDB.

 

Let it run.

 

Yes you should try the new tape  ... but do not perform the backup to the new tape before the end of the omnidbcheck.

 

Regards,

Christophe
Frequent Advisor
BobbyR
Posts: 60
Registered: ‎06-21-2012
Message 13 of 20 (620 Views)

Re: Internal Database Backups Errors.

Sorry,

 

I ment omnidbcheck -extended.

 

So no backups till done? any Idea how ling it takes?

Respected Contributor
drpixel
Posts: 231
Registered: ‎06-11-2010
Message 14 of 20 (618 Views)

Re: Internal Database Backups Errors.

How big is you IDB ?

Regards,

Christophe
Valued Contributor
nikhil_d
Posts: 122
Registered: ‎09-21-2012
Message 15 of 20 (610 Views)

Re: Internal Database Backups Errors.

well, you could perform an IDB backup without the check.

there is an option in IDB backup to disable the check, you could try that if you want the backup desperately.

 

The duration depends on lot of factors like size of your IDB, CM platform/configuration etc. I've seen an average of 2 hours per 50 GB of IDB on a G4 HP-UX (11.31). May be you get more on Windows.

Frequent Advisor
BobbyR
Posts: 60
Registered: ‎06-21-2012
Message 16 of 20 (604 Views)

Re: Internal Database Backups Errors.

I have a feeling our DB is more than 50 Gig, We run alot of SAP backups. I did not know it would take that long.

Is there a way to stop  the  omnicheck -extended check.  Please say yes :-(

 

 

Respected Contributor
drpixel
Posts: 231
Registered: ‎06-11-2010
Message 17 of 20 (600 Views)

Re: Internal Database Backups Errors.

Press CTRL+C ...

 

Regards,

Christophe
Frequent Advisor
BobbyR
Posts: 60
Registered: ‎06-21-2012
Message 18 of 20 (596 Views)

Re: Internal Database Backups Errors.

Thanks,

 

Sorry for being a newbie....

Spoiler
 

 

Frequent Advisor
BobbyR
Posts: 60
Registered: ‎06-21-2012
Message 19 of 20 (584 Views)

Re: Internal Database Backups Errors.

 

It looks like the IDB backup is working now. After I deleted the .LK file. One more stupid question.

We run backups around the clock, hence why I was nervous doing the DB check, is it safe to to the DB backup while other backups are running?

 

Thanks

Respected Contributor
drpixel
Posts: 231
Registered: ‎06-11-2010
Message 20 of 20 (582 Views)

Re: Internal Database Backups Errors.

[ Edited ]

I would advice you to perfom the IDB backup with no backups running ...But I sometime back it up while other backups are running ... (when I don't have the choice). Of course in case of IDB  restore you won't have the most current information. And you won't be able to restore "quickly" the backups that were running.

 

All restore tests were OK

 

The IDB backup was OK with the new tape ?

Did you retry the old one ?

 

Regards,

Christophe
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.