Cloning A database

[sunkutup]

I would like to clone our prodution database as a backup database. Our database runs in noarchive mode.

How can I start the process up to the end and what will I need to do to update from time to time. I would like to be updating the clone database atleast every 17:00 hrs. Please advise me.

[bkrish]

Hi,

Correct me if I'm wrong. If your production database is running in no archivelog mode, the only way to clone would be as follows.

0. Production Normal shutdown
1. Generate controlfile script (ASCII) if you do not have one.
2. Copy the files (dbf,log,ASCII controlfile to development server.
3. Start Production instance.
4. Modify the absolute paths (if different) of the db and log files.
5. Launch Server Manager. Run the controlfile script.

Hope this is what you are looking for.

BK.

[bmycroft]

Yeah, kind of...but then do you really want two databasees called the same name?

So....

1. Generate controlfile script (ASCII) if you do not have one.
- ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

2. The trace file from above will be in your udump, edit it and change REUSE to SET and have RESETLOGS

"CREATE CONTROLFILE SET DATABASE "O01D" RESETLOGS NOARCHIVELOG"

3. Modify the datafile paths in the create controlfile command.

4. Copy the files (dbf, pwdfiles, inifiles, ASCII controlfile to development server, you dont need the log files or controlfiles.

5. in unix, remember to alter the ORATAB. In NT remember to add the new services.

6. TNSNAMES, Listener and all that tat needs amending.

7. connect internal on the destination box and run the create controlfile script.

8. Alter database open.

[sunkutup]

Thanks bmycroft

I have taken note of the procedure. I want confirm at what stage do I make changes to the TNSNAMES and the LISTENER?

I would also want to find out if I have to start up the second database with the old database file and then run the backup control file theirafter changing few things in the backup control file.

[mwillems]

Hi,
This looks interesting, how do you add the new service?