Home » RDBMS Server » Backup & Recovery » Duplicate Database Doubt
Duplicate Database Doubt [message #292170] Tue, 08 January 2008 02:14 Go to next message
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,
Re: Duplicate Database Doubt [message #292178 is a reply to message #292170] Tue, 08 January 2008 02:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.
Once duplicated databases are different and disconnected ones.

Regards
Michel
Re: Duplicate Database Doubt [message #292186 is a reply to message #292178] Tue, 08 January 2008 03:05 Go to previous messageGo to next message
navaneethdba
Messages: 71
Registered: July 2007
Location: chennai
Member
Thanks for your reply Michel.
Re: Duplicate Database Doubt [message #292190 is a reply to message #292178] Tue, 08 January 2008 03:13 Go to previous messageGo to next message
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,
Re: Duplicate Database Doubt [message #292205 is a reply to message #292190] Tue, 08 January 2008 03:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
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
Re: Duplicate Database Doubt [message #292240 is a reply to message #292205] Tue, 08 January 2008 04:42 Go to previous messageGo to next message
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,
Re: Duplicate Database Doubt [message #292243 is a reply to message #292240] Tue, 08 January 2008 04:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can copy the database in another server for instance and then have 2 database with same DBID.

Regards
Michel
Re: Duplicate Database Doubt [message #292250 is a reply to message #292243] Tue, 08 January 2008 05:10 Go to previous message
navaneethdba
Messages: 71
Registered: July 2007
Location: chennai
Member
Ok.I will try it.Thanks for your reply Michel.
Previous Topic: How to backup flash recovery area (asm diskgroup) to tape?
Next Topic: RMAN Backup - Applying Retention Policy takes very long
Goto Forum:
  


Current Time: Fri Dec 09 05:47:49 CST 2016

Total time taken to generate the page: 0.06407 seconds