Home » RDBMS Server » Backup & Recovery » Backup problem in Oracle XE
icon5.gif  Backup problem in Oracle XE [message #200667] Tue, 31 October 2006 18:00 Go to next message
hcavila
Messages: 2
Registered: October 2006
Junior Member
Hi all,

I have a problem trying to perform a database backup; I receive the following error message:

Backup of the database failed.
Unknown log mode : SP2-0640:.
Log file is at SP2-0640:.

And nothing happend after that. I make a search in google, lycos, yahoo, etc. but there is nothing related to this error.

I´m using Oracle XE, running on Microsoft XP professional SP2.

Please help me.

Thank you.

Report message to a moderator

Re: Backup problem in Oracle XE [message #201043 is a reply to message #200667] Thu, 02 November 2006 06:11 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
Can You provide more info.
like
how can you take backup.
1. rman
2. user managed bkp.
or something else.

check ur alertsid.log file there any error. encountered.

ur database is archive log mode. or no archivelog mode.

HOPE THIS HELPS.
MOhammad Taj.

Report message to a moderator

Re: Backup problem in Oracle XE [message #201377 is a reply to message #201043] Fri, 03 November 2006 17:52 Go to previous messageGo to next message
hcavila
Messages: 2
Registered: October 2006
Junior Member
Hello Mohammad,

I'm using the procedure provided by oracle (user managed backup) by selecting start->programs->Oracle 10g XE->Backup database.

I already checked the alert log file but there is no error message in it.

My database is in archive log mode.

Thank you for your help.

Heraldo.

Report message to a moderator

Re: Backup problem in Oracle XE [message #245487 is a reply to message #200667] Sun, 17 June 2007 19:00 Go to previous messageGo to next message
elrobalo
Messages: 4
Registered: June 2007
Junior Member
I am having the same issue. help.

Report message to a moderator

Re: Backup problem in Oracle XE [message #245499 is a reply to message #200667] Sun, 17 June 2007 22:40 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
Run,

Select log_mode from v$database;

And see your current log mode. If you are running in noarchive mode you cant perform online backup.

Report message to a moderator

Re: Backup problem in Oracle XE [message #245506 is a reply to message #200667] Sun, 17 June 2007 23:35 Go to previous messageGo to next message
elrobalo
Messages: 4
Registered: June 2007
Junior Member
I have the archivelog mode running.
the oracle client was install on this server
I have removed the client

in the css.log
[ OCRUTL][6928]u_set_com_error: parameter was NULL
[ OCRUTL][6928]u_set_ocr_error: parameter was NULL
[ OCROSD][6928]utgdv:1:could not open registy key SOFTWARE\Oracle\ocr os err the system could not find the enviroment option that was entered.

Report message to a moderator

Re: Backup problem in Oracle XE [message #245530 is a reply to message #200667] Mon, 18 June 2007 00:53 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
I think environmental variable missing. Reinstall of oracle may solve the problem.

Report message to a moderator

Re: Backup problem in Oracle XE [message #245689 is a reply to message #245530] Mon, 18 June 2007 09:05 Go to previous messageGo to next message
elrobalo
Messages: 4
Registered: June 2007
Junior Member
If I have data in the system and can not do a backup. An ideas on a work around?

Report message to a moderator

Re: Backup problem in Oracle XE [message #245706 is a reply to message #245530] Mon, 18 June 2007 10:24 Go to previous messageGo to next message
elrobalo
Messages: 4
Registered: June 2007
Junior Member
the application log shows

The description for Event ID ( 34 ) in Source ( Oracle.xe ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: ACTION : 'CONNECT' DATABASE USER: 'sys' PRIVILEGE : SYSDBA CLIENT USER: WCI\rex CLIENT TERMINAL: SHEFFILE STATUS: 0 .

Report message to a moderator

icon12.gif  Re: Backup problem in Oracle XE [message #249673 is a reply to message #200667] Thu, 05 July 2007 09:23 Go to previous messageGo to next message
karlis
Messages: 1
Registered: July 2007
Junior Member
You must run backup with user with which you have installed OracleXE!
Or should be memeber of ORA_DBA group (About this I'm not sure)

Report message to a moderator

Re: Backup problem in Oracle XE [message #301488 is a reply to message #245689] Wed, 20 February 2008 18:13 Go to previous messageGo to next message
Jimbo1
Messages: 1
Registered: February 2008
Junior Member
Hi there,

I had the same error message when I tried to run the Oracle 10g XE Edition's backup from the Windows Start Menu, i.e.

==================== ERROR =============================
Backup of the database failed.
Unknown log mode : SP2-0640:.
Log file is at SP2-0640:.
==================== ERROR =============================

It turned out I got this because I'd not started up the database. Ensure your XE database has been started up before you run the backup from the Windows Start Menu. Embarassed

Cheers.

James

Report message to a moderator

Re: Backup problem in Oracle XE [message #302507 is a reply to message #301488] Tue, 26 February 2008 00:07 Go to previous messageGo to next message
we.charm
Messages: 1
Registered: February 2008
Location: India
Junior Member
Start oracle server using Windows- Start -> Program files -> Oracle 10g -> Start database.

Even if services are started.

Report message to a moderator

Re: Backup problem in Oracle XE [message #315766 is a reply to message #249673] Tue, 22 April 2008 13:37 Go to previous message
gogator19
Messages: 1
Registered: April 2008
Junior Member
Good information.

Rather than log out of my user account and back in as the administrator account used to instal Oracle XE I did the following:

Opened Start -> Programs -> Oracle Database 10g Express Edition and then right clicked Backup Database. Select Properties from the context menu. In the Backup Database Properties dialog box under Shortcut tab prepend the target with "runas /user:<login> " without the quotes where <login> is the Windows user that installed Oracle.

Now when you click Backup Database you will get a prompt for the password for <login> and the database will backup normally.

Report message to a moderator

Previous Topic: DATABASE ARCHITECTURE FOR APPLICATION
Next Topic: PARALLEL in Import/Export pump
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 17:45:23 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.