Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 How to restore dbf file?
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

bensil
Starting Member

1 Posts

Posted - 04/17/2015 :  17:51:30  Show Profile  Reply with Quote
I have a database named orcl

I backup the data using rman ...

the backup is in this locationn
[oracle@wtu flash_recovery_area]$ cd orcl/
[oracle@wtu orcl]$ ls
control02.ctl
[oracle@wtu orcl]$ cd ..
[oracle@wtu flash_recovery_area]$ cd ORCL/
[oracle@wtu ORCL]$ ls
archivelog autobackup backupset flashback onlinelog
[oracle@wtu ORCL]$ cd backupset/
[oracle@wtu backupset]$ ls
2012_10_17 2012_10_29 2012_12_31
[oracle@wtu backupset]$ cd 2012_12_31/
[oracle@wtu 2012_12_31]$ ls
o1_mf_annnn_TAG20121231T022129_8g2ssc7g_.bkp
o1_mf_annnn_TAG20121231T022442_8g2szbtp_.bkp
o1_mf_nnndf_TAG20121231T022236_8g2svf3z_.bkp

and then I deleted the

[oracle@wtu oradata]$ cd orcl/
[oracle@wtu orcl]$ ls
control01.ctl redo01.log redo03.log system01.dbf undotbs01.dbf
example01.dbf redo02.log sysaux01.dbf temp01.dbf users01.dbf
[oracle@wtu orcl]$ rm -rf *



Then I tried to connect rman to restore and recovery..

Meanwhile i shutdown the database....
SQL> shutdown immediate
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/orcl/control01.ctl'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3


Then I tried to connect rman for restore and recovery..
But is shows the error ....


[oracle@wtu orcl]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 31 02:42:30 2012

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

SQL> exit
[oracle@wtu orcl]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Mon Dec 31 02:42:35 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-06003: ORACLE error from target database:
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/orcl/control01.ctl'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
[oracle@wtu orcl]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 31 02:44:33 2012

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

I shows error



Can you help me to solve...?

tkizer
Almighty SQL Goddess

USA
38200 Posts

Posted - 04/17/2015 :  17:52:20  Show Profile  Visit tkizer's Homepage  Reply with Quote
I would start by asking your question on an Oracle site. SQLTeam.com is for Microsoft SQL Server.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000