Solved

RMAN DUPLICATION FROM COLD BACKUP ERROR

Posted on 2011-03-15
4
1,553 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
  • 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
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
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

840 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