Solved

RMAN Recovery

Posted on 2011-02-20
11
920 Views
Last Modified: 2012-05-11
I am trying to do a test recovery on my Dev database server. I got this error: RMAN-06025: no backup of log thread 1 seq 1108 lowscn 61380386 found to restore. How do I solve this problem? The log is not there and I have no other backup file to use.

The reason for this test recovery is because I am planning to do a duplicate database from Dev to Prod server but it also fails due to it cannot find the same log.


RMAN> recover database;

Starting recover at 21-FEB-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=212 devtype=DISK

starting media recovery

archive log thread 1 sequence 1109 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01109_0738606773.001
archive log thread 1 sequence 1110 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01110_0738606773.001
archive log thread 1 sequence 1111 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01111_0738606773.001
archive log thread 1 sequence 1112 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01112_0738606773.001
archive log thread 1 sequence 1113 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01113_0738606773.001
archive log thread 1 sequence 1114 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01114_0738606773.001
archive log thread 1 sequence 1115 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01115_0738606773.001
archive log thread 1 sequence 1116 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01116_0738606773.001
archive log thread 1 sequence 1117 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01117_0738606773.001
archive log thread 1 sequence 1118 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01118_0738606773.001
archive log thread 1 sequence 1119 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01119_0738606773.001
archive log thread 1 sequence 1120 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01120_0738606773.001
archive log thread 1 sequence 1121 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01121_0738606773.001
archive log thread 1 sequence 1122 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01122_0738606773.001
archive log thread 1 sequence 1123 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01123_0738606773.001
archive log thread 1 sequence 1124 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01124_0738606773.001
archive log thread 1 sequence 1125 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01125_0738606773.001
archive log thread 1 sequence 1126 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01126_0738606773.001
archive log thread 1 sequence 1127 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01127_0738606773.001
archive log thread 1 sequence 1128 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01128_0738606773.001
archive log thread 1 sequence 1129 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01129_0738606773.001
archive log thread 1 sequence 1130 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01130_0738606773.001
archive log thread 1 sequence 1131 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01131_0738606773.001
archive log thread 1 sequence 1132 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01132_0738606773.001
archive log thread 1 sequence 1133 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01133_0738606773.001
archive log thread 1 sequence 1134 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01134_0738606773.001
archive log thread 1 sequence 1135 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01135_0738606773.001
archive log thread 1 sequence 1136 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01136_0738606773.001
archive log thread 1 sequence 1137 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01137_0738606773.001
archive log thread 1 sequence 1138 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01138_0738606773.001
archive log thread 1 sequence 1139 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\DB_2\RDBMS\AR
C01139_0738606773.001
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/21/2011 11:38:17
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 1108 lowscn 61380386 found to restore

0
Comment
Question by:OP_Zaharin
[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
  • 5
11 Comments
 
LVL 7

Expert Comment

by:MrNed
ID: 34940394
Did that log ever exist? Did you turn on archiving before or after that log?

Check:
select * from v$log_history
select * from v$archived_log
0
 
LVL 23

Author Comment

by:OP_Zaharin
ID: 34940595
hi Mr.Ned,
archiving is turn on before that log.

-from v$log_history its there
-from v$archived_log seq from 216 to 1108 the Name column is null (the physical file not exist)
0
 
LVL 7

Expert Comment

by:MrNed
ID: 34940613
Sounds like it has been backed up and cleared (or simply deleted!). Is RMAN using a recovery catalog or the control file? Are there any other RMAN backups lying around that might include the missing archive log?
0
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 
LVL 23

Author Comment

by:OP_Zaharin
ID: 34940641
It might be deleted as I can't find it anywhere.
RMAN is using control file as I didn't specify any catalog.

Any way of telling RMAN not to read from the missing log in order for me to do a fresh Backup and Duplicate to other server?

0
 
LVL 7

Expert Comment

by:MrNed
ID: 34940659
You can definitely take a new backup without requiring previous archive logs, it should not be looking for them. Best is to take a full database backup (or level 0 incremental) as well as log files so they are kept together. I'd also suggest using a recovery catalog so old backup files are not lost (the control file only keeps records of backed up files a fixed period of time), and if you need to rebuild the control file for some reason, the backup data is still available.
0
 
LVL 23

Author Comment

by:OP_Zaharin
ID: 34940699
MrNed,
Can you assist me a step by step command to execute your suggestion?
0
 
LVL 7

Accepted Solution

by:
MrNed earned 500 total points
ID: 34940722
There are many ways to do this and you should come up with a process to suit your requirements (do you have many databases, what availability do you need to maintain, are you backing up to disk and/or tape, how many copies do you need, are you using incremental backups, using RAC/ASM etc). Here is just one minimal example which should get the job done.

Backup Database

run {
   backup as compressed backupset database
   format 'backupdir/rman_%d_%s%p%c_df_%f_%T';
}
sql 'alter system archive log current';
backup as compressed backupset archivelog all delete all input format 'backupdir/rman_%d_%s%p%c_arch_%h_%e_%T';


Duplicate Database

rman target sys/${SYSPASS}@${SOURCE_INST} auxiliary /
duplicate target database to NEW_DB_NAME;


These were pulled from a script I wrote so might have some superfluous keywords, but I just left them in there and it should still work. Hope it makes sense.
0
 
LVL 23

Author Comment

by:OP_Zaharin
ID: 34940726
thank you MrNed. will run this..
0
 
LVL 23

Author Comment

by:OP_Zaharin
ID: 34940753
by the way, by executing the above backup database, it wont take the missing log?
I have done a RMAN> backup database; without taking the archivelog but when doing duplicate its still look for that missing log.
0
 
LVL 7

Expert Comment

by:MrNed
ID: 34941142
Wait one - are you are running the backup via the web GUI? I never use that, but I believe it defaults to incremental backups so you are probably only taking a level 1 which means a duplicate still needs the previous level 0 and all logs for those two backups. You need to do a new DATABASE or LEVEL 0 backup instead.
0
 
LVL 23

Author Comment

by:OP_Zaharin
ID: 34941782
no i'm running it via command line.
thank you for your help mrNed :)
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

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.

Join & Ask a Question