OraFAQ Forum: Backup & Recovery » Duplicate Database Doubt

Home » RDBMS Server » Backup & Recovery » Duplicate Database Doubt

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

Duplicate Database Doubt [message #292170]

Tue, 08 January 2008 02:14

navaneethdba
Messages: 71
Registered: July 2007
Location: chennai

Member

Hi,

Version :10.2.0
OS:Windows 2000 server

I have a created a duplicate database using RMAN backup in the same machine(for practice)in a different name(dupdb).Now i have taken cold backup of my original database and need to restore that backup in the duplicate database,How to do it?

When i catalog that backup in duplicate database it shows error.
Database name is different and DBID too.Any way to restore that backup in the duplicate db ? plz advice...

RMAN> catalog backuppiece 'd:\TMPBACKUP\DB_7JJ5L2EB_1_1'
2> ;

ORA-19870: error reading backup piece D:\TMPBACKUP\DB_7JJ5L2EB_1_1
ORA-19691: D:\TMPBACKUP\DB_7JJ5L2EB_1_1 is from different database: id=1165473122, name=ORCL
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of catalog command at 01/08/2008 13:14:42
RMAN-06209: List of failed objects
RMAN-06211: ==========================
RMAN-06212:   Object Type   Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Backup Piece    D:\TMPBACKUP\DB_7JJ5L2EB_1_1

TIA,

Report message to a moderator

Re: Duplicate Database Doubt [message #292178 is a reply to message #292170]

Tue, 08 January 2008 02:38

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

No.
Once duplicated databases are different and disconnected ones.

Regards
Michel

Report message to a moderator

Re: Duplicate Database Doubt [message #292186 is a reply to message #292178]

Tue, 08 January 2008 03:05

navaneethdba
Messages: 71
Registered: July 2007
Location: chennai

Member

Thanks for your reply Michel.

Report message to a moderator

Re: Duplicate Database Doubt [message #292190 is a reply to message #292178]

Tue, 08 January 2008 03:13

navaneethdba
Messages: 71
Registered: July 2007
Location: chennai

Member

Hi,

I have another doubt.Shall i restore the original database backup to different database which has same db name but in a different machine? Any possibilities ?

I think we cant b'cause the DBID varies isn't it? Am i correct?
Plz advice..

TIA,

Report message to a moderator

Re: Duplicate Database Doubt [message #292205 is a reply to message #292190]

Tue, 08 January 2008 03:50

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Shall i restore the original database backup to different database which has same db name but in a different machine?

Yes, of course, otherwise backup should have a limited interest.

You can have same DBID in different databases and/or server without any problem (other than using RMAN with recovery catalog database).

Regards
Michel

Report message to a moderator

Re: Duplicate Database Doubt [message #292240 is a reply to message #292205]

Tue, 08 January 2008 04:42

navaneethdba
Messages: 71
Registered: July 2007
Location: chennai

Member

Thanks for your reply Michel.

But its confusing a little bit. I think we can have databases with same dbid, only in standby database environment. Am i correct?

So we can apply backups of original database only to the standby database isn't it?

TIA,

Report message to a moderator