How to restore dbf file? - SQL Server Forums

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

All Forums

General SQL Server Forums

Data Corruption Issues

How to restore dbf file?

Author

Topic

bensil
Starting Member

1 Post

Posted - 2015-04-17 : 17:51:30

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

38200 Posts

Posted - 2015-04-17 : 17:52:20

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/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources