Cloning of Database [message #56178] |
Tue, 11 March 2003 04:12 |
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 |
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 |
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 whats 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 youre 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 #56237 is a reply to message #56178] |
Thu, 13 March 2003 06:03 |
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 #56283 is a reply to message #56278] |
Mon, 17 March 2003 04:09 |
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 |
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 [message #215326 is a reply to message #56229] |
Sun, 21 January 2007 07:10 |
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
|
|
|