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.
| 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/ |
 |
|
|
|
|
|
How to restore dbf file?