Solved

Oracle & Backup Exec

Posted on 2011-09-13
3
791 Views
Last Modified: 2013-12-19
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
Comment
Question by:Bransby-IT
3 Comments
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 200 total points
ID: 36528911
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
 
LVL 34

Accepted Solution

by:
johnsone earned 300 total points
ID: 36529498
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
 
LVL 3

Author Closing Comment

by:Bransby-IT
ID: 36947737
Thanks
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now