Hi,
I hope you should create the control file instead of copying it. After
creation of control file you can run startup migrate.
Thanks & Regards
Karthik
-----Original Message-----
From: Kirpal Chana
[mailto:oracledba-ezmlmshield-x66989068.[Email address protected]
Sent: Tuesday, May 31, 2005 4:21 PM
To: LazyDBA Discussion
Subject: ORA-01571
Hi all
I am trying to upgrade oracle 8.1.7 database to 9.2.0.6 to a new server.
I have installed all oracle products onto new server and it works.
Also created the same file structure for databases.
I have copied all database, log and control files to new server.
Problem is when I try to migrate this database to 9.2.0 through "startup
migrate" command, following error occurs
I tried changing some parameters in the intP.ora file, but cannot get
past this error. Please Help
*******************
SQL> startup migrate
ORACLE instance started.
Total System Global Area 622417620 bytes
Fixed Size 456404 bytes
Variable Size 352321536 bytes
Database Buffers 268435456 bytes
Redo Buffers 1204224 bytes
Database mounted.
ORA-01571: redo version 9.2.0.0.0 incompatible with ORACLE version
8.1.7.0.0
************************
initP.ora file looks like this ( i have taken out some standard lines)
db_file_multiblock_read_count = 16
log_buffer = 1048576
timed_statistics = true
_trace_files_public = true
global_names = false
optimizer_mode = choose
optimizer_index_cost_adj = 25
optimizer_index_caching = 90
remote_os_authent = true
compatible = 8.1.7.0.0
open_cursors = 2048
enqueue_resources = 1024
dml_locks = 1024
# added for summit 9.4
partition_view_enabled = TRUE
workarea_size_policy = AUTO
pga_aggregate_target = 256M
java_pool_size = 40M
sql_trace = FALSE
undo_management = AUTO
# tmp for 9i upgrade
job_queue_processes = 0
aq_tm_processes = 0
_system_trig_enabled = FALSE
*****************************
> Kirpal
>
>
>
>
**********************************************************************
This e-mail and any attachment is confidential and intended
soley for use of the individual or entity to whom it is addressed.
If you have received this e-mail in error please notify the sender
and delete the mail from your system.
The Lambeth Building Society is authorised and regulated by the
Financial Services Authority.
**********************************************************************
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Confidentiality Statement:
This message is intended only for the individual or entity to which it is addressed. It may contain privileged, confidential information which is exempt from disclosure under applicable laws. If you are not the intended recipient, please note that you are strictly prohibited from disseminating or distributing this information (other than to the intended recipient) or copying this information. If you have received this communication in error, please notify us immediately by return email.
Oracle LazyDBA home page