Solved

RMAN DUPLICATION FROM COLD BACKUP ERROR

Posted on 2011-03-15
4
1,593 Views
Last Modified: 2012-05-11
i just took the cold backup from another server and transferred all the data files to same directory and gave rman duplication ...its saying scn missing...

duplicate target database to ERPVIS;

Starting restore at 15-MAR-11
using channel ORA_AUX_DISK_1
using channel ORA_AUX_DISK_2
using channel ORA_AUX_DISK_3

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/15/2011 15:01:19
RMAN-01005: not all datafiles have backups that can be recovered to scn 10132259341885
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of datafile 234
0
Comment
Question by:Dba_Oracledb2
[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
  • 2
  • 2
4 Comments
 
LVL 15

Expert Comment

by:Devinder Singh Virdi
ID: 35141635
It looks like some file are missing.
can you check with select count(*) from dba_data_files and file you copied.
0
 
LVL 15

Accepted Solution

by:
Devinder Singh Virdi earned 500 total points
ID: 35141638
Please check the following link as well
http://www.akadia.com/services/ora_duplicate_database_rman.html
0
 

Author Comment

by:Dba_Oracledb2
ID: 35141718
i took the cold backup, all the datafiles are present, count matched...
0
 

Author Comment

by:Dba_Oracledb2
ID: 35141866
i backup up all the archive logs once again and started duplication, its working now, ..thanks
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

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…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

705 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