Home » RDBMS Server » Backup & Recovery » Database not working after backup got failed. (Oracle 10.2.0.1, Windows XP32, Primavera P6 8.2)
icon8.gif  Database not working after backup got failed. [message #585510] Mon, 27 May 2013 03:02 Go to next message
shaheemm
Messages: 10
Registered: May 2013
Junior Member
Hi,

In order to migrate oracle xe to sql server 2008, I have tried to backup the current Database, while backup I have got the below error and it got failed. After when I open primavera, database is not connection. Oracle UK support is trying to restore but I have back up of 16th April and 2nd may only. The error happened on 21st may. So without backup how do I get the database back to work.... it was working perfect. All my company latest project updated are made on the days between 2nd and 21st may. So how do I recover those data.. please help me...

Backup up log:

Recovery Manager: Release 10.2.0.1.0 - Production on Tue May 21 09:58:19 2013

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:781M/1527M, Ph+PgF:2982M/4425M, VA:2002M/2047M
Starting with debugging turned off

connected to target database: XE (DBID=2684498378, not open)

RMAN> set echo on;
2> shutdown immediate;
3> startup mount;
4> configure controlfile autobackup format for device type disk clear;
5> configure retention policy to redundancy 2;
6> configure controlfile autobackup on;
7> sql "create pfile=''C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\SPFILE2INIT.ORA'' from spfile";
8> backup as backupset device type disk database;
9> configure controlfile autobackup off;
10> alter database open;
11> delete noprompt obsolete;
12>
echo set on

using target database control file instead of recovery catalog
database dismounted
Oracle instance shut down

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area 805306368 bytes

Fixed Size 1289996 bytes
Variable Size 243269876 bytes
Database Buffers 557842432 bytes
Redo Buffers 2904064 bytes

RMAN configuration parameters are successfully reset to default value

old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters are successfully stored

old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored

sql statement: create pfile=''C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\SPFILE2INIT.ORA'' from spfile

Starting backup at 21-MAY-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=35 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00006 name=C:\ORACLEXE\ORADATA\XE\INDX.DBF
input datafile fno=00005 name=C:\ORACLEXE\ORADATA\XE\EXPDB.DBF
input datafile fno=00003 name=C:\ORACLEXE\ORADATA\XE\SYSAUX.DBF
input datafile fno=00002 name=C:\ORACLEXE\ORADATA\XE\UNDO.DBF
input datafile fno=00001 name=C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF
input datafile fno=00007 name=C:\ORACLEXE\ORADATA\XE\EXPBLOBS.DBF
input datafile fno=00004 name=C:\ORACLEXE\ORADATA\XE\USERS.DBF
channel ORA_DISK_1: starting piece 1 at 21-MAY-13
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/21/2013 10:07:05
RMAN-10035: exception raised in RPC:
ORA-19583: conversation terminated due to error
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 10737418240 limit
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 1080
RMAN-10031: RPC Error: ORA-19583 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE

Recovery Manager complete.

[Updated on: Mon, 27 May 2013 03:03]

Report message to a moderator

Re: Database not working after backup got failed. [message #585513 is a reply to message #585510] Mon, 27 May 2013 03:13 Go to previous messageGo to next message
John Watson
Messages: 4409
Registered: January 2010
Location: Global Village
Senior Member
Your backup is failing because your Flash Recovery Area is full. I do not know how 10.2XE would react to this, but certainly an 11.x database will not open in this circumstance. However, I am astonished that what you call "Oracle UK support" has advised you to perform a restore, because that is absolutely wrong. In fact, I did not not think that Oracle would ever provide support for XE on a de-supported release.
You need to clear space within the Flash Recovery Area. Probably the safest course of action would be, from an RMAN prompt, to run this:

backup archivelog all format 'c:\somewhere\safe\%U' delete all input;

Re: Database not working after backup got failed. [message #585515 is a reply to message #585513] Mon, 27 May 2013 03:23 Go to previous messageGo to next message
shaheemm
Messages: 10
Registered: May 2013
Junior Member
C:\oraclexe folder there but safe folder I couldn't find it. I have logged a call with Oracle and their UK support is working on the same. But its been a week now. he suggest me to restore 2nd of may but that is not the solution right?.

Could you please help me where I can find this safe folder... I have done a search for all log in the oraclexe folder... but yet I didn't find.
Re: Database not working after backup got failed. [message #585528 is a reply to message #585515] Mon, 27 May 2013 04:35 Go to previous messageGo to next message
John Watson
Messages: 4409
Registered: January 2010
Location: Global Village
Senior Member
There is something very odd here. You keep talking about Oracle UK Support. But I do not believe Oracle will give you ANY support for 10g XE edition. Furthermore, you appear to be in the UAE, so why would UK support be involved? I would have expected support, if any, to be from the Bucharest response centre.

In any case, I have already told you what to do. If you do not understand my suggestion, I think perhaps you had better bring in some outside support. A decent consultant would fix this in under an hour (though you might have to face a minimum charge - for example, I think my boss insists on two hours for me.)
Re: Database not working after backup got failed. [message #585529 is a reply to message #585528] Mon, 27 May 2013 04:38 Go to previous messageGo to next message
John Watson
Messages: 4409
Registered: January 2010
Location: Global Village
Senior Member
One more thing - it is quite possible (considering the size of your Flash REcovery Area) that your 2 May backup can be recovered up the current date, in which case you will not lose any data. If anyone says that you will lose data, question his skills.
Re: Database not working after backup got failed. [message #585532 is a reply to message #585529] Mon, 27 May 2013 05:04 Go to previous messageGo to next message
shaheemm
Messages: 10
Registered: May 2013
Junior Member
John,
When I logged a service at Oracle Dubai the support guy called me and he is from UK. anyways let him work on it.
Here, if I restore 2 may backup the data until 2 may will be there but regarding the data from 2 may to 21 may wont be there right.

Also here its really hard to find oracle consultant to fix the same. so that is the reason I have reached this forum.

Anyways thanks dear for your support.
Re: Database not working after backup got failed. [message #585537 is a reply to message #585532] Mon, 27 May 2013 05:22 Go to previous messageGo to next message
John Watson
Messages: 4409
Registered: January 2010
Location: Global Village
Senior Member
This forum isn't meant for sales, but if you want a consultant, this person could sort you out no problem
http://skillbuilders.com/our-instructors/john-watson.cfm
there is a contact address on the website. I'm surprised you couldn't find anyone locally.

However, I must repeat: there is no reason to lose any data. I do not think your database is damaged in any way. THe information you have posted shows no problem that cannot be easily fixed. And even if the database were damaged, you have a backup and (probably) all the redo needed to recover it.
Re: Database not working after backup got failed. [message #585539 is a reply to message #585537] Mon, 27 May 2013 05:30 Go to previous messageGo to next message
shaheemm
Messages: 10
Registered: May 2013
Junior Member
Thanks John. The link is redirected to you I guess. Any ways I will use the contact from the website link you have provided.
Re: Database not working after backup got failed. [message #585540 is a reply to message #585539] Mon, 27 May 2013 05:43 Go to previous messageGo to next message
shaheemm
Messages: 10
Registered: May 2013
Junior Member
John,
Oracle UK updated the SR and asked me to do some steps:



Hello Shaheem -

I had restored yr EXPDP.dbf...etc within XE.rar, and following steps need assistance.
1. Shutdown yr database.
-- Goto C:\OracleXE\OraData folder, rename the XE folder to be XE_BACKUP_5_27
-- Goto C:\oraclexe\app\oracle, rename the flashrecovery folder to be flash_recovery_BACKUP_5_27

2. Then goto link: ftp://xxxxx

3. And then extract all of them.
-- Put extracted XE folder files into C:\OracleXE\OraData
-- Put extracted flash_recovery folder files into C:\oraclexe\app\oracle

4. Then goto cmd, type sqlplus / as sysdba, and startup mount;

Check if could startup your database, will wait for your update.

Re: Database not working after backup got failed. [message #585541 is a reply to message #585540] Mon, 27 May 2013 05:48 Go to previous messageGo to next message
John Watson
Messages: 4409
Registered: January 2010
Location: Global Village
Senior Member
Er... I think it is a huge mistake. I see no reason to restore anything: indeed, a restore may well mean that you lose data.

You might want to ask if they believe that you will be able to recover up to today, with zero data loss. I believe that you can.

Up to you. You get what you pay for!


Re: Database not working after backup got failed. [message #585542 is a reply to message #585541] Mon, 27 May 2013 05:50 Go to previous message
shaheemm
Messages: 10
Registered: May 2013
Junior Member
Any how I have copied all th oraclexe folder to my d drive like a backup of the current state.
Let me try this... if failed as you said I'll contact the link you have provided.
Previous Topic: ORA-01115: IO error reading block from file 11 (block # 118736)
Next Topic: RMAN Backup failed.
Goto Forum:
  


Current Time: Thu Jul 31 09:44:52 CDT 2014

Total time taken to generate the page: 0.23301 seconds