Database Backup and Recovery (MOSC)

MOSC Banner

Duplicate DB fails with RMAN-05001

edited Mar 19, 2013 4:39AM in Database Backup and Recovery (MOSC) 10 commentsAnswered ✓

11.2.0.2

Hi,

Im tryiing to use RMAN to duplicate a database, DEV to TEST. The script runs just fine in another environment (just changed the paths). Below is what happens:

RMAN> @duplicateSPLQTEST.rman

RMAN> #
2> # rman cmdfile "D:\oracle\admin\duplicate\PDMTEST\duplicatePDMTEST.rman" log "D:\oracle\admin\PDMTEST\scripts\duplicatePDMTEST.log"
3> #
4> # Don't forget to run the post clone script on: /home/oracle/maintenance/duplicate/postduplicateSPLQTEST.sql efter dump till PDMDEV_TEST"
5> #
6> connect target *
connected to target database: SPLQDEV (DBID=2733765854)

RMAN> connect auxiliary *
connected to auxiliary database: SPLQTEST (not mounted)

RMAN>
RMAN> run {
2> set newname for datafile '/splqdev/data/SPLQDEVarchivedata01.dbf' to '/splqtest/data/SPLQTESTarchivedata01.dbf';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center