OraFAQ Forum: Backup & Recovery » rman repository and duplicate DBID's

Home » RDBMS Server » Backup & Recovery » rman repository and duplicate DBID's

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

rman repository and duplicate DBID's [message #219692]

Thu, 15 February 2007 09:55

meggens
Messages: 57
Registered: February 2007
Location: Netherlands

Member

Hello,

I would like to backup serveral oracle databases using RMAN and an RMAN repository. Some of the databases are clones made by copy on OS level so the DBID is the same for some databases. Also SID is the same in some cases. Should I changed DBID before backing up these databases with RMAN?

Regards,
Martin

Report message to a moderator

Re: rman repository and duplicate DBID's [message #219693 is a reply to message #219692]

Thu, 15 February 2007 09:58

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

Some of the databases are clones made by copy on OS level so the DBID is the same for some databases

Can you please explain more about OS LEVEL clone database ?

regards
Taj

Report message to a moderator

Re: rman repository and duplicate DBID's [message #219695 is a reply to message #219693]

Thu, 15 February 2007 10:14

meggens
Messages: 57
Registered: February 2007
Location: Netherlands

Member

thanks for your prompt reply.

Yes I can. the databases (datafiles, control files and online redo log files) are simly copied with the cp (unix copy) command so they are identical. When I understand well, RMAN used the DBID in the repository to identiefy the database.

Report message to a moderator

Re: rman repository and duplicate DBID's [message #219697 is a reply to message #219695]

Thu, 15 February 2007 10:21

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

Senior Member
Account Moderator

>> Should I changed DBID before backing up these databases with RMAN?
If you are intending to backup those cloned databases, then Yes.
You have'nt mentioned the Oracle version. For 9i and above, just use the utiltiy nid to change the DBID.

Report message to a moderator

Re: rman repository and duplicate DBID's [message #219699 is a reply to message #219695]

Thu, 15 February 2007 10:22

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
RMAN used the DBID in the repository to identiefy the database.
Yes it is correct.

are simly copied with the cp (unix copy) command so
and hope your database STATUS is CLOSE (shutdown) when you copying database files. ( mean your taken cold backup ) or if open then that is useless backup you must use RMAN or USER MANAGED BACKUP procedure for HOT BACKUP.

Should I changed DBID before backing up these databases with RMAN?
No, there is no way to change DBID during BACKUP process.

regards
Taj

Report message to a moderator

Re: rman repository and duplicate DBID's [message #219702 is a reply to message #219699]

Thu, 15 February 2007 10:33

meggens
Messages: 57
Registered: February 2007
Location: Netherlands

Member

I think I was not clear. I'm new to my current job. One of my first tasks is to check the backups. I found out backups are done by full database exports and I'm not happy with this.

All databases are running in noarchivelog mode. This is what I would like to do:

1.Run all databases in archivelog mode.
2.Create an RMAN repository
3.Backup all databases using RMAN (hot backups)

So if necessary I'll change the BID of the database first and then I'll setup the repository.

Databases are all oracle 9 and 10.

Herewith an example of some cloned databases the all run on different hosts:

name dbid host
BWBA 600058465 lnx131
BWBA_ACC 600058465 lnx131
BWBA 600058465 lnx132
BWBA 600058465 lnx133
BWBA 600058465 lnx134

So when I would like to backup above mentioned databases using RMAN and an RMAN repository should I changed the DBID to make this possible.

Thanks
Martin

Report message to a moderator

Re: rman repository and duplicate DBID's [message #219704 is a reply to message #219702]

Thu, 15 February 2007 10:36

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

Senior Member
Account Moderator

>>should I changed the DBID to make this possible.
Yes. As we responded before

Quote:

If you are intending to backup those cloned databases, then Yes.

Report message to a moderator

Re: rman repository and duplicate DBID's [message #219706 is a reply to message #219704]

Thu, 15 February 2007 10:39

meggens
Messages: 57
Registered: February 2007
Location: Netherlands

Member

thanks!, I already expected this but would like to make it sure

thanks again this information will be very helpfull when I discuss this during the meeting about this tomorrow.

regard,
Martin

Report message to a moderator

Previous Topic:	Oracle 9i Backup getting stuck
Next Topic:	logical standby Vs physical standby

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 02 12:21:22 CDT 2024