Home » RDBMS Server » Server Administration » Cloning of Database
Cloning of Database [message #56178] Tue, 11 March 2003 04:12 Go to next message
Shivalika Iyer
Messages: 8
Registered: March 2003
Junior Member
Hi,
I cloned one database by copying the cold backup of the database and created a new instance as db1. Then using create controlfile set database command. I opened the database using alter database open resetlogs, I am getting error message as
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:TEMPORACLEORADATAORACLESYSTEM01.DBF'
So I tried to recover the database
and getting message as
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
So what should be done and where I went wrong?
Re: Cloning of Database [message #56180 is a reply to message #56178] Tue, 11 March 2003 04:36 Go to previous messageGo to next message
Uwe KΓΌchler
Messages: 3
Registered: March 2003
Junior Member
Hi,

how did you try to recover the db?
Did you use the phrase "recover database using backup controlfile"?
And, BTW, is your db in archive log mode?

Regards, Uwe.
Re: Cloning of Database [message #56186 is a reply to message #56178] Tue, 11 March 2003 07:41 Go to previous messageGo to next message
Michel Bartov
Messages: 35
Registered: February 2003
Member
I suggest you start all over again. (Sometimes, it is easy to start over that trying to figure out what’s going on)
Delete all data file of the cloned database -
Make sure the control files of the cloned database are also deleted (if previously created).
Copy all datafiles to the new location

If you’re using windows, create a new service for the new database
C:oracleora81binoradim -NEW -SID test02 (test02 is the new instance)

Create the control file

sqlplus /nolog
onnect / as sysdba
spool duplicate_test02.log
startup nomount pfile=C:oracleora81dbsinittest02.ora
CREATE CONTROLFILE
SET DATABASE test02
…………………………
RESET LOGS
LOGFILE
……………………..
DATAFILE
…………………..
NOARCHIVELOG;
alter database open resetlogs;
exit

I just posted an integrated set of GUI tools to administer the Oracle database.
IT has a function that generates a script to clone a database (windows and unix).
You may need same help to get started, so feel free to contact me (michelbartov@go.com). The link is http://www.barsoft.net/
Re: Cloning of Database [message #56197 is a reply to message #56178] Wed, 12 March 2003 04:01 Go to previous messageGo to next message
sak
Messages: 3
Registered: March 2003
Junior Member
Check all the directories like bdump,udump,etc at your new location. if not create it manually and try CREATE CONTROLFILE
Re: Cloning of Database [message #56229 is a reply to message #56197] Thu, 13 March 2003 05:41 Go to previous messageGo to next message
Shivalika Iyer
Messages: 8
Registered: March 2003
Junior Member
Hi,
I tried everything mentioned in the followups, still I am getting the same error. Any solutions for it. My operating system is windows 2000.

thank u.
Re: Cloning of Database [message #56237 is a reply to message #56178] Thu, 13 March 2003 06:03 Go to previous messageGo to next message
psmyth
Messages: 81
Registered: October 2002
Member
try this after running the 'create control file'..

ALTER DATABASE RECOVER AUTOMATIC UNTIL CANCEL USING BACKUP CONTROLFILE;

ALTER DATABASE RECOVER CANCEL;
ALTER DATABASE OPEN RESETLOGS;

You may need to recreate your TEMP tablespace, if it was created as a 'temporary' tablespace.
Re: Cloning of Database [message #56278 is a reply to message #56178] Mon, 17 March 2003 00:07 Go to previous messageGo to next message
Shivalika Iyer
Messages: 8
Registered: March 2003
Junior Member
Yes, I used
recover automatic database until cancel using backup controlfile;

And my database is in archive mode only.

Thanks
Shivalika
Re: Cloning of Database [message #56283 is a reply to message #56278] Mon, 17 March 2003 04:09 Go to previous messageGo to next message
psmyth
Messages: 81
Registered: October 2002
Member
can you list the init.ora file (and any associated init files if you use them), the 'create controlfile' script, the alert log, and the output from the running of the 'create controlfile' script please?

cheers
Re: Cloning of Database- Contents of my init.ora file [message #56315 is a reply to message #56283] Wed, 19 March 2003 00:04 Go to previous messageGo to next message
Shivalika Iyer
Messages: 8
Registered: March 2003
Junior Member
##############################################################################
# Copyright (c) 1991, 2001 by Oracle Corporation
##############################################################################

###########################################
# Archive
############### ############################
log_archive_dest_1='LOCATION=C:oracleoradataoraclearchive'
log_archive_format=%t_%s.dbf
#log_archive_start=true
log_archive_start=false
###########################################
# Cache and I/O
###########################################
db_block_size=4096
db_cache_size=31457280

###########################################
# Cursors and Library Cache
###########################################
open_cursors=300

###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=C:oracleoradataAdminOraclebdump
core_dump_dest=C:oracleoradataAdminOraclebdump
timed_statistics=TRUE
user_dump_dest=C:oracleoradataAdminOraclebdump

###########################################
# Distributed, Replication and Snapshot
###########################################
db_domain=""
remote_login_passwordfile=EXCLUSIVE

###########################################
# File Configuration
###########################################
control_files=("C:oracleoradataoraclecontrol01.ctl", "C:oracleoradataoraclecontrol02.ctl", "C:oracleoradataoraclecontrol03.ctl")

###########################################
# MTS
###########################################
# Uncomment the following line when your listener is configured for SSL
# (listener.ora and sqlnet.ora)
# dispatchers = "(PROTOCOL=TCPS)(SER=MODOSE)", "(PROTOCOL=TCPS)(PRE=oracle.aurora.server.GiopServer)", "(PROTOCOL=TCPS)(PRE=oracle.aurora.server.SGiopServer)"
dispatchers="(PROTOCOL=TCP)(SER=MODOSE)", "(PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer)", "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"

###########################################
# Miscellaneous
###########################################
compatible=9.0.0
db_name=DB1

###########################################
# Network Registration
###########################################
instance_name=DB1

###########################################
# Pools
###########################################
java_pool_size=31457280
shared_pool_size=37748736

###########################################
# Processes and Sessions
###########################################
processes=150

###########################################
# Redo Log and Recovery
###########################################
fast_start_mttr_target=300

###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
sort_area_size=524288

###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_tablespace=UNDOTBS
Re: Cloning of Database- Contents of my init.ora file [message #56318 is a reply to message #56283] Wed, 19 March 2003 05:18 Go to previous messageGo to next message
psmyth
Messages: 81
Registered: October 2002
Member
any chance of listing the other files i mentioned in the earlier posting?

cheers
paul
Re: Cloning of Database [message #215326 is a reply to message #56229] Sun, 21 January 2007 07:10 Go to previous message
vijaykumarsudi
Messages: 9
Registered: September 2006
Location: hyderabad
Junior Member

Hi,
I think u have to recover ur source database first and then take a cold backup of ur database then copy all ur files on clone side.
regards
vijay
Previous Topic: oracle10g installation Problem
Next Topic: ORA-27102: out of memory
Goto Forum:
  


Current Time: Fri Dec 09 09:59:45 CST 2016

Total time taken to generate the page: 0.07219 seconds