 Database not working after backup got failed. [message #585510] |
Mon, 27 May 2013 03:02  |
 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
