Using Standby for cloning

[gopi]

Originally posted by Axr2
As for Jurij's method, it'll work - Depends if you don't mind retaining the same dbname.

in 9.2 the DBNEWID utility can be used to change both.

Thanks.

[Axr2]

Yup. Pick your poison. Do whatever is appropriate/easier in your enviroment and whichever makes sense.

[julian]

Originally posted by gopi
in 9.2 the DBNEWID utility can be used to change both.

Thanks.

The utility is called NID, not DBNEWID.

[julian]

Originally posted by gopi

Julian...I need to purchase the Veritas MML Oracle extension in order to use rman to backup to tape (not enought disk) - my management has been warned many times. Once I have rman backups I can duplicate. thanx

You can use disk backups for cloning. No need for MML in order to run the duplicate command :-)

[julian]

Originally posted by Axr2
As for Jurij's method, it'll work - Depends if you don't mind retaining the same dbname.

With NID, he will change it within 5 minutes, what's the biggy?

[jmodic]

Originally posted by julian
The utility is called NID, not DBNEWID.

No, the utility is caled "DBNEWID utility". The executable is called "nid".

It's like you would say: No, the utility is not aclled SQL*Loader, it's caled sqlldr.

[julian]

Originally posted by jmodic
No, the utility is caled "DBNEWID utility". The executable is called "nid".

It's like you would say: No, the utility is not aclled SQL*Loader, it's caled sqlldr.

No, it is called NID or DBNEWID.

Go to note 224266.1:

"The NID (New Database ID)is a new utility introduced with Oracle 9.2. The NID
utility allows you to change only the DBNAME, or only the DBID or both
DBNAME and DBID in the same command. "

[julian]

And you don't say sqlldr, because it is hard to pronounce. Unlike NID.

[jmodic]

Oh, give us a break! It's officialy called NEWDBID. A short glimps on the manuals tells it all. http://download-west.oracle.com/docs.../ch14.htm#1656

[OracleDoc]

*tap tap is this thing on?

you could do what we did at my last gig.
simply take a hot backup of the standby. ftp the datafiles over to your dev. Rename the database, startup using an edited controlfile from prod. Rinse and repeat as neccessary.
We did this on a nightly basis, we had a Reporting database that users could run thier reports off of instead of having to use prod.
It's particularly sweet if you're in an unsecure environment and have rsh available to use. If not use the ssh, A couple of scripts and voila` you've got yourself a nightly refresh job.