Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error while restore control file

927578May 13 2013 — edited May 13 2013
Hi,
SQL> startup
ORACLE instance started.

Total System Global Area  289406976 bytes
Fixed Size                  1248576 bytes
Variable Size             130024128 bytes
Database Buffers          150994944 bytes
Redo Buffers                7139328 bytes
ORA-00205: error in identifying control file, check alert log for more info


SQL> shutdown immediate
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> startup pfile='C:\oracle\init.ora';
ORACLE instance started.

Total System Global Area  289406976 bytes
Fixed Size                  1248576 bytes
Variable Size              92275392 bytes
Database Buffers          188743680 bytes
Redo Buffers                7139328 bytes
Database mounted.
Database opened.
rman
C:\Documents and Settings\Siva Saravana Kumar>rman

Recovery Manager: Release 10.2.0.1.0 - Production on Mon May 13 17:29:40 2013

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

RMAN> connect target sys@mani

target database Password:
connected to target database: MANI (DBID=946337126)

RMAN> restore controlfile from autobackup;

Starting restore at 13-MAY-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=141 devtype=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/13/2013 17:30:05
RMAN-06496: must use the TO clause when the database is mounted or open

RMAN>
i don't understand why am getting this error ? i used pfile for startup database .. Pls Help
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 10 2013
Added on May 13 2013
10 comments
2,261 views