?
Solved

RMAN DUPLICATION FROM COLD BACKUP ERROR

Posted on 2011-03-15
4
Medium Priority
?
1,621 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 2000 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
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.  …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
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.
Suggested Courses

752 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