Recovery Failure in Oracle enterprise manager
739765Jun 2 2010 — edited Jun 2 2010Hi ,
When i tried to recover the whole database by selecting "Recover to the current time or a previous point-in-time" in Perform recovery area.
It came up with the error message as shown below.
ERROR :::::
startup mount
shutdown immediate
shutdown immediate
SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 1 14:45:44 2010
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> SQL> Connected.
SQL> SQL> SQL> Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning option
startup mount
SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 1 14:46:45 2010
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> SQL> Connected to an idle instance.
SQL> SQL> ORACLE instance started.
Total System Global Area 2137886720 bytes
Fixed Size 2215064 bytes
Variable Size 1677722472 bytes
Database Buffers 452984832 bytes
Redo Buffers 4964352 bytes
Database mounted.
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning option
Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 1 14:46:50 2010
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN>
connected to target database: SPPADEV (DBID=1558297262, not open)
using target database control file instead of recovery catalog
RMAN>
echo set on
RMAN> run {
2> restore database until time "to_date('2010-05-20 20:00:00', 'YYYY-MM-DD HH24:MI:SS')";
3> recover database until time "to_date('2010-05-20 20:00:00', 'YYYY-MM-DD HH24:MI:SS')";
4> }
Starting restore at 01-JUN-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=452 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=3 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=32 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=62 device type=DISK
creating datafile file number=1 name=/u02/oradata/SPPADEV/system01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/01/2010 14:46:52
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/u02/oradata/SPPADEV/system01.dbf'
RMAN> exit;
Recovery Manager complete.
Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 1 14:46:52 2010
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN>
connected to target database: SPPADEV (DBID=1558297262, not open)
using target database control file instead of recovery catalog
RMAN>
echo set on
RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 06/01/2010 14:46:53
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
RMAN> exit;
Recovery Manager complete.
Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 1 14:46:53 2010
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN>
connected to target database: SPPADEV (DBID=1558297262, not open)
using target database control file instead of recovery catalog
RMAN>
echo set on
RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 06/01/2010 14:46:53
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
RMAN> exit;
Recovery Manager complete.
;;;;
It will be very much grateful if some one can help me with this issue.
Thanks,
Hary