Steve Hewett wrote:
>
> I was wondering if any of you could provide some help here. I am new to
> Oracle DB Administration, and I have a need to create a exact duplicate of
> an Oracle 7.3 database under a different schema name. I am wondering if
> anyone could explain how to accomplish this, or point me out to a good
> reference.
>
> Thanks,
Hi Steve,
The easiest way we do this is to take a full consistant backup of our
production database. During the shutdown procedures before the backup
we issue a command "alter database backup controlfile to trace;" then
shut down the database cleanly.
Next we backup the entire database. We use a mirroring technique
where a second set of disks mirror our database. We take these off line
and copy all the files to tape.
On our test machine we have created a duplicate setup for all the file
systems and raw devices as the production system had. We rename the
links to the raw devices as the new name such as was prod now is test.
we restore the entire backup to these files. We copy our trace file
from the user dump directory that was created with the alter statement
above and edit to remove all the comments. We change the names of all
the files that were identified by the production schema name to the
test schema name.
after the restore is done we rename the physical files we restored to
the new schema name. Then in svrmgr line mode we start up the database
in nomount mode and run the trace file as a sql script that rebuilds the
control files.
Then alter database noarchivelog; and alter database open resetlogs.
Be sure that the init ora file for the new database is set up to point
to these new files for the control file and schema name.
Hope this helps.
Regards, Dick
Received on Wed Nov 05 1997 - 00:00:00 CST
