Database not working after backup got failed. [message #585510] |
Mon, 27 May 2013 03:02 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/0c81846af9fd94786836629f797de94d?s=64&d=mm&r=g) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 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 #585528 is a reply to message #585515] |
Mon, 27 May 2013 04:35 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 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 #585537 is a reply to message #585532] |
Mon, 27 May 2013 05:22 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 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 #585541 is a reply to message #585540] |
Mon, 27 May 2013 05:48 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 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!
|
|
|
|