troubleshooting Question

backup and restore

Avatar of walkerdba
walkerdba asked on
Oracle Database
11 Comments1 Solution887 ViewsLast Modified:
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...?
ASKER CERTIFIED SOLUTION
hraja77

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 11 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros