OraFAQ Forum: Server Utilities » Error while duplicating a database

Home » RDBMS Server » Server Utilities » Error while duplicating a database - urgent

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error while duplicating a database - urgent [message #73029]

Mon, 19 January 2004 19:05

Ananth K.T
Messages: 5
Registered: May 2002

Junior Member

Hi,

�i want to duplicate a database using RMAN.
I connect to RMAN with� target,catalog & auxiliary� databases.
I used db_file_name_convert in auxiliary's init.ora.

when i issued�
run
{
allocate auxiliazry� channel ax1 type disk ;
duplicate target database to dup ; -- dup is duplicate instance
logfile
�group 1 ('e:ananthrmclredo01.f') size 100k,
�group 2 ('e:ananthrmclredo02.f') size 100k;
}

i'm getting a message like
'no backup or datafile cop found ' .

so that i took a complete backup� & tried.but the same error message continus.

How can i resolve this..

with thanks in advance
Ananth K.T

Report message to a moderator

Re: Error while duplicating a database - urgent [message #73031 is a reply to message #73029]

Tue, 20 January 2004 02:34

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

consider these :
host1: your source database is in this host
sourcedb: your source database
/backup: place where RMAN backups of sourcedb recide
dup: your duplicate (auxillary database);
you didnt mention whether u are duplicatiing the database in the same host or different host?
whatever it is, make sure that, /backup is available to the duplicate database also ( it should look like it is local to DUP database). and make sure, that the database backups are valid and obsolete backups are marked obsolete in catalog. You may have take the backups recently..but if the catalog is not updated with the unavailablity of old backups, you may end up like this. And did u backup the archived logs also?

Report message to a moderator

Re: Error while duplicating a database - urgent [message #73035 is a reply to message #73031]

Tue, 20 January 2004 17:38

Ananth K.T
Messages: 5
Registered: May 2002

Junior Member

Thanks Mahesh.

I duplicated on the different host.The backup wasn't available on the another host.I solved it.

Report message to a moderator

Previous Topic:	SQL Ldr
Next Topic:	import/export console

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 27 21:50:03 CDT 2024