Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 824
  • Last Modified:

Oracle & Backup Exec

Oracle 10.2.0.3.0
Backup Exec 12.5

I have two Oracle Database's one will backup fine.   The other which is in "NON Archive Mode" put offline at 22:00 and backed up at 23:00 before coming back online at 06:00

This is giving me the error below.

"Job ended: 12 September 2011 at 23:00:14
Completed status: Failed
Final error: 0xe000100f - Cannot start an Oracle session.
Final error category: Resource Errors

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



0
Bransby-IT
Asked:
Bransby-IT
2 Solutions
 
slightwv (䄆 Netminder) Commented:
My backup-exec experience is pretty old but I cannot remember if it can do a cold backup or not.

It sounds like your setup is trying to perform a hot backup which requires the database it be running and in archive log mode.

Check the backup-exec documentation to see if it can perform a cold backup.
0
 
johnsoneSenior Oracle DBACommented:
If backup-exec cannot do a cold backup...

A cold backup is nothing more than a file system backup.  Shut down the database, back up the directories that contain the database, then bring the database back up.  It sounds like you have the shut down and startup already working.  Just change the backup from an oracle based backup to one that backs up selected directories.

0
 
Bransby-ITAuthor Commented:
Thanks
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now