Home » RDBMS Server » Server Administration » How can I easily make an exact copy of an existing NT-Database, and...
How can I easily make an exact copy of an existing NT-Database, and... [message #54229] Wed, 06 November 2002 02:46 Go to next message
Sascha
Messages: 15
Registered: November 2002
Junior Member
run this as the same Database on the same server,
only with another name. (It's an NT 4.0 Server)
Can you please give me a summary, how it works and what to do?

Thanks.
Sascha

Report message to a moderator

Re: How can I easily make an exact copy of an existing NT-Database, and... [message #54234 is a reply to message #54229] Wed, 06 November 2002 05:30 Go to previous messageGo to next message
B
Messages: 327
Registered: August 1999
Senior Member
Do an hot or cold backup of Ur DB ( ALLWAYS )
if cold bck don't backup REDOLOG
create a new control file creation script
ie: "alter database backup controlfile to trace"
copy backup files to new location.
create a new init.ora ( set db_name to [[NEW_NAME]] )
create a new service
nomount the new database
edit the control file script
change CREATE CONTROL FILE REUSE DATABASE [[NAME]]
by
CREATE CONTROL FILE SET DATABASE [[NEW_NAME]]

delete lines that u don't need
and run it ...

Report message to a moderator

Re: How can I easily make an exact copy of an existing NT-Database, and... [message #54246 is a reply to message #54229] Wed, 06 November 2002 12:03 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
What to do to Clone DB on the same machine explained step by step.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: Adding maxdatafiles
Next Topic: regarding clusters
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 17:08:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.