I prefer RMAN's duplicate database command, although I find myself using
RMAN's restore and recover more often than not.

Kevin

-----Original Message-----
From: Rosanna Lam
[mailto:oracledba-ezmlmshield-x53917459.[Email address protected]
Sent: Tuesday, February 27, 2007 6:28 PM
To: LazyDBA Discussion
Subject: Cloning database

Hello everyone,

I am a newcomer to Lazydba as well as a beginner dba. I have a question
re cloning databases.

I was trying to clone a test database (version 9.2.0.6) from a
production database (same version). I copied all dbf files over to the
test database server. Recreated the control file and setting it to a new
name (using create controlfile set database "test" resetlogs...). Then
do the following:
alter database open resetlogs;
alter tablespace temp add tempfile '...' reuse;

The db opened ok but the last statement gave me the error:
ora-00604:error occurred at recursive SQL level 1
ORA-06553:PLS-801:internal error[56319]

I next tried:
drop tablespace temp
and get the same error.

In fact, it gave me the same error even when I tried to change a user's
password!

Any ideas what's going on here?

Can I ask what others do to quickly clone a database without having to
go thru db creation?

Thanks.
Rosanna




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page