Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Duplicate database using OEM
On Wed, 26 Nov 2003 16:36:07 +0100, Dave wrote
(in message <78cf0572.0311260736.9753d_at_posting.google.com>):
> Hey all,
>
> Anyone here use OEM jobs to duplicate a database? I want to make a
> copy of production every night for testing purposes (so I don't have
> to do it manually when they request it).
>
> Since we are moving to OEM I thought i'd setup a job there to do it.
> I know under the credentials section of the "Run Rman Script" task
> lets you specifiy an auxilary database but it only mentions TSPITR.
> Which would be my target database for the job? The primary database
> or my duplicate database?
The target is the database you backup to copy it, or have backed up before. The auxiliary database is the clone to produce. It's not that difficult to setup in oem, depends on the platform and available bugs in rman.tcl. I would first try to make an rman job to produce any report and see if that works. rman.tcl on windows is in error (9204). On unix it works.
-- With kind regards, Ronald http://ronr.nl/unix-dbaReceived on Wed Nov 26 2003 - 13:44:10 CST