Home » RDBMS Server » Backup & Recovery » RMAN DUPLICATE error (10g)
RMAN DUPLICATE error [message #383198] Tue, 27 January 2009 12:44 Go to next message
aopex
Messages: 2
Registered: January 2009
Junior Member
Hi,
I am in process of cloning using RMAN DUPLICATE
Here is what i have done so far
on the prod server
RMAN>list backupset of database;
this gave me the scn number to use for restore.
RMAN>list backupset of archivelog from scn <scn from above>
confirmed that the backup piece exits under the backup folder

Now on the TEST box
started DB in nomount
RMAN> run {set until scn <scn from above>
allocate channel ch1 type disk;
allocate auxiliary channel ch2 type disk;
duplicate target database to TEST
}

exit;

After this script runs, i see following error messages in
the log

RA-19870: error reading backup piece /b02/backup/oppa/l0k5nbhq_1_1
ORA-19505: failed to identify file "/b02/backup/oppa/l0k5nbhq_1_1"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory

the backup piece its tryig to read is not present in the
backup folder on the prod bax. Also the backup piece its
trying to read is totally different than the backup piece asoociated with the SCN.

Please help
Re: RMAN DUPLICATE error [message #383229 is a reply to message #383198] Tue, 27 January 2009 18:52 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you.

Believe the RMAN error messages!
Re: RMAN DUPLICATE error [message #383380 is a reply to message #383198] Wed, 28 January 2009 10:41 Go to previous messageGo to next message
louispo
Messages: 1
Registered: January 2009
Junior Member
Hello,

just a simple thing to verify first :

your backup directory /b02/backup/oppa needs to be copied on the test server so rman could see it with the same path as when backup was done....!

Hope this helps,

best regards,

Louis
Re: RMAN DUPLICATE error [message #383538 is a reply to message #383198] Thu, 29 January 2009 02:07 Go to previous messageGo to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member

Hi,

The error because RMAN not able to find out the expexted backup at the server.

The steps should be:-
=========================
1. Copy the backup sets to the server where you want to clone/Duplicate
2. if the filesystem structure is different from the Source server then create softlinks for the same.


Raj
Re: RMAN DUPLICATE error [message #383655 is a reply to message #383538] Thu, 29 January 2009 09:07 Go to previous message
aopex
Messages: 2
Registered: January 2009
Junior Member
Thanks for you reply Raj and Loius,
that was the issue.
We reolved the issue by creating softlink from prod to test
Previous Topic: RMAN Backup done..Now what should I do?
Next Topic: Connecting Oracle 10g Database from Oracle 8i Client for backup
Goto Forum:
  


Current Time: Wed May 08 08:57:03 CDT 2024