Home » RDBMS Server » Backup & Recovery » rman repository and duplicate DBID's
rman repository and duplicate DBID's [message #219692] Thu, 15 February 2007 09:55 Go to next message
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
Re: rman repository and duplicate DBID's [message #219693 is a reply to message #219692] Thu, 15 February 2007 09:58 Go to previous messageGo to next message
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
Re: rman repository and duplicate DBID's [message #219695 is a reply to message #219693] Thu, 15 February 2007 10:14 Go to previous messageGo to next message
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.
Re: rman repository and duplicate DBID's [message #219697 is a reply to message #219695] Thu, 15 February 2007 10:21 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: rman repository and duplicate DBID's [message #219699 is a reply to message #219695] Thu, 15 February 2007 10:22 Go to previous messageGo to next message
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
Re: rman repository and duplicate DBID's [message #219702 is a reply to message #219699] Thu, 15 February 2007 10:33 Go to previous messageGo to next message
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

Re: rman repository and duplicate DBID's [message #219704 is a reply to message #219702] Thu, 15 February 2007 10:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.

Re: rman repository and duplicate DBID's [message #219706 is a reply to message #219704] Thu, 15 February 2007 10:39 Go to previous message
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
Previous Topic: Oracle 9i Backup getting stuck
Next Topic: logical standby Vs physical standby
Goto Forum:
  


Current Time: Fri Dec 09 21:27:14 CST 2016

Total time taken to generate the page: 0.06507 seconds