We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
3 days, 7 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
backup and restore
Posted on 2012-12-31
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_TAG20121231T02
o1_mf_annnn_TAG20121231T02
o1_mf_nnndf_TAG20121231T02
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/o
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/o
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...?
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_TAG20121231T02
o1_mf_annnn_TAG20121231T02
o1_mf_nnndf_TAG20121231T02
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/o
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/o
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...?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
6-
4
11 Comments
Active today
I would suggest looking at the documentation. This should be a helpful link:
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmadvre.htm#i1006453
This link takes you to disaster recovery, which is more or less the scenario that you are trying to test. The reason that you are getting an error is that you have deleted the control file and that needs to be restored first.
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmadvre.htm#i1006453
This link takes you to disaster recovery, which is more or less the scenario that you are trying to test. The reason that you are getting an error is that you have deleted the control file and that needs to be restored first.
do a "shutdown abort"
then do a "startup nomount"
you then need to restore the controlfile from the backup;
then you can restore the database
cheersH
then do a "startup nomount"
you then need to restore the controlfile from the backup;
then you can restore the database
cheersH
[oracle@wtu backupset]$ cd 2012_12_31/
[oracle@wtu 2012_12_31]$ ls
o1_mf_annnn_TAG20121231T02
o1_mf_annnn_TAG20121231T02
o1_mf_nnndf_TAG20121231T02
[oracle@wtu 2012_12_31]$ pwd
/u01/app/oracle/flash_reco
[oracle@wtu 2012_12_31]$
there are three backup pieces in the above folder...
when we give
restore controlfile from ' ' which one I will give for controlfile
which one I will give for spfile.
which one for redo log
[oracle@wtu 2012_12_31]$ ls
o1_mf_annnn_TAG20121231T02
o1_mf_annnn_TAG20121231T02
o1_mf_nnndf_TAG20121231T02
[oracle@wtu 2012_12_31]$ pwd
/u01/app/oracle/flash_reco
[oracle@wtu 2012_12_31]$
there are three backup pieces in the above folder...
when we give
restore controlfile from ' ' which one I will give for controlfile
which one I will give for spfile.
which one for redo log
which script did you use to backup the database with - did you specify that you wanted to back up the controlfile - what is in the autobackup folder ?
try:
rman target=/
restore controlfile from autobackup
try:
rman target=/
restore controlfile from autobackup
I did until this
what is next step..
SQL> startup
ORACLE instance started.
Total System Global Area 1707446272 bytes
Fixed Size 1336988 bytes
Variable Size 1124075876 bytes
Database Buffers 570425344 bytes
Redo Buffers 11608064 bytes
ORA-00205: error in identifying control file, check alert log for more info
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@wtu ~]$ rman target=/
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Jan 4 02:20:08 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (not mounted)
RMAN> restore controlfile from autobackup;
Starting restore at 04-JAN-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=18 device type=DISK
recovery area destination: /u01/app/oracle/flash_reco
database name (or database unique name) used for search: ORCL
channel ORA_DISK_1: AUTOBACKUP /u01/app/oracle/flash_reco
AUTOBACKUP search with format "%F" not attempted because DBID was not set
channel ORA_DISK_1: restoring control file from AUTOBACKUP /u01/app/oracle/flash_reco
channel ORA_DISK_1: control file restore from AUTOBACKUP complete
output file name=/u01/app/oracle/orada
output file name=/u01/app/oracle/flash
Finished restore at 04-JAN-13
RMAN> startup force mount
Oracle instance started
database mounted
Total System Global Area 1707446272 bytes
Fixed Size 1336988 bytes
Variable Size 1124075876 bytes
Database Buffers 570425344 bytes
Redo Buffers 11608064 bytes
what is next step..
SQL> startup
ORACLE instance started.
Total System Global Area 1707446272 bytes
Fixed Size 1336988 bytes
Variable Size 1124075876 bytes
Database Buffers 570425344 bytes
Redo Buffers 11608064 bytes
ORA-00205: error in identifying control file, check alert log for more info
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@wtu ~]$ rman target=/
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Jan 4 02:20:08 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (not mounted)
RMAN> restore controlfile from autobackup;
Starting restore at 04-JAN-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=18 device type=DISK
recovery area destination: /u01/app/oracle/flash_reco
database name (or database unique name) used for search: ORCL
channel ORA_DISK_1: AUTOBACKUP /u01/app/oracle/flash_reco
AUTOBACKUP search with format "%F" not attempted because DBID was not set
channel ORA_DISK_1: restoring control file from AUTOBACKUP /u01/app/oracle/flash_reco
channel ORA_DISK_1: control file restore from AUTOBACKUP complete
output file name=/u01/app/oracle/orada
output file name=/u01/app/oracle/flash
Finished restore at 04-JAN-13
RMAN> startup force mount
Oracle instance started
database mounted
Total System Global Area 1707446272 bytes
Fixed Size 1336988 bytes
Variable Size 1124075876 bytes
Database Buffers 570425344 bytes
Redo Buffers 11608064 bytes
ok - thats restored your controlfie which is great;
all you need to do now is to restore the database;
in rman issue: "restore database"
after that issue "recover database"
thats should do it!
all you need to do now is to restore the database;
in rman issue: "restore database"
after that issue "recover database"
thats should do it!
rememeber if your controlfile was the last thing you backed up after the database your fine - however if its the first thing you backed up you will need to register your backup pieces in rman using:
CATALOG BACKUPPIECE '/2012_12_31//o1_mf_annnn_
do this for each piece
CATALOG BACKUPPIECE '/2012_12_31//o1_mf_annnn_
do this for each piece
After that this is the problem..
Recovery Manager complete.
[oracle@wtu ~]$ export ORACLE_SID=orcl
[oracle@wtu ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sun Jan 6 21:12:42 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> startup nomount
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@wtu ~]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Sun Jan 6 21:12:54 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1321380463, not open)
RMAN> startup up force mount;
RMAN-00571: ==========================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ==========================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "up": expecting one of: "dba, force, mount, newline, nomount, pfile, ;"
RMAN-01007: at line 1 column 9 file: standard input
RMAN> startup force mount;
Oracle instance started
database mounted
Total System Global Area 1707446272 bytes
Fixed Size 1336988 bytes
Variable Size 1124075876 bytes
Database Buffers 570425344 bytes
Redo Buffers 11608064 bytes
RMAN> CATALOG BACKUPPIECE '/u01/app/oracle/flash_rec
using target database control file instead of recovery catalog
cataloged backup piece
backup piece handle=/u01/app/oracle/fla
RMAN> CATALOG BACKUPPIECE '/u01/app/oracle/flash_rec
cataloged backup piece
backup piece handle=/u01/app/oracle/fla
RMAN> CATALOG BACKUPPIECE '/u01/app/oracle/flash_rec
cataloged backup piece
backup piece handle=/u01/app/oracle/fla
RMAN> restore database;
Starting restore at 06-JAN-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=18 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/or
channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/or
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/or
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/or
channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/or
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_reco
channel ORA_DISK_1: piece handle=/u01/app/oracle/fla
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:36
Finished restore at 06-JAN-13
RMAN> recover database;
Starting recover at 06-JAN-13
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 59 is already on disk as file /home/oracle/Desktop/stby/
archived log file name=/home/oracle/Desktop/
unable to find archived log
archived log thread=1 sequence=60
RMAN-00571: ==========================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ==========================
RMAN-03002: failure of recover command at 01/06/2013 21:24:44
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 60 and starting SCN of 1667468
RMAN>
Recovery Manager complete.
[oracle@wtu ~]$ export ORACLE_SID=orcl
[oracle@wtu ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sun Jan 6 21:12:42 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> startup nomount
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@wtu ~]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Sun Jan 6 21:12:54 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1321380463, not open)
RMAN> startup up force mount;
RMAN-00571: ==========================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ==========================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "up": expecting one of: "dba, force, mount, newline, nomount, pfile, ;"
RMAN-01007: at line 1 column 9 file: standard input
RMAN> startup force mount;
Oracle instance started
database mounted
Total System Global Area 1707446272 bytes
Fixed Size 1336988 bytes
Variable Size 1124075876 bytes
Database Buffers 570425344 bytes
Redo Buffers 11608064 bytes
RMAN> CATALOG BACKUPPIECE '/u01/app/oracle/flash_rec
using target database control file instead of recovery catalog
cataloged backup piece
backup piece handle=/u01/app/oracle/fla
RMAN> CATALOG BACKUPPIECE '/u01/app/oracle/flash_rec
cataloged backup piece
backup piece handle=/u01/app/oracle/fla
RMAN> CATALOG BACKUPPIECE '/u01/app/oracle/flash_rec
cataloged backup piece
backup piece handle=/u01/app/oracle/fla
RMAN> restore database;
Starting restore at 06-JAN-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=18 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/or
channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/or
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/or
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/or
channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/or
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_reco
channel ORA_DISK_1: piece handle=/u01/app/oracle/fla
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:36
Finished restore at 06-JAN-13
RMAN> recover database;
Starting recover at 06-JAN-13
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 59 is already on disk as file /home/oracle/Desktop/stby/
archived log file name=/home/oracle/Desktop/
unable to find archived log
archived log thread=1 sequence=60
RMAN-00571: ==========================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ==========================
RMAN-03002: failure of recover command at 01/06/2013 21:24:44
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 60 and starting SCN of 1667468
RMAN>
Featured Post
Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Background
In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This post first appeared at Oracleinaction (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself).
I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows syntax for various backup options while discussing how the different basic backup types work. It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses
Course of the Month3 days, 7 hours left to enroll
Earn Certification
Certified Information Systems Auditor (CISA)
$99.00$89.10
691 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.