Hi can any one guide, I have installed SAP ABAP Instance with SID as ECD. I have taken backup using BRBACKUP method i.e. FULL bakup via OFFLine. I have generated control file. I have setup the same environment in another system. I have installed Java. I have installed Oracle. I have installed CI with SID as ECP. I have installed DB with option brbackup and brrestore method. @ the stage "Oracle preload actions" it has prompt to continue with restore process. Then I have copied the complete bkup i.e. ECD and I have deleted Datafiles. I have deleted Log files. I have deleted Control files. I have deleted Oraarch files. I have changed the SID " ECD" to " ECP". I have edited the generated control file “ecd_ora_2852.trc”. And named it to control.sql file. Note:- where exactly I should paste this file. When I logged into brtools it has throwed an error as show below BR0753E Control file E:\oracle\ora92\database\CTL1ECP.ORA not found Note:- If I create this file i.e. CTL1ECP.ORA and what contents should I paste it in this or I should leave this empty file. I have created this file as empty file. It throwed an error BR0280I BRRECOVER time stamp: 2009-11-01 10.28.00 BR0330I Starting and mounting database instance ECP ... BR0278E Command output of 'E:\oracle\ora92\bin\SQLPLUS': SQL*Plus: Release 9.2.0.7.0 - Production on Sun Nov 1 10:28:00 2009 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL> Connected to an idle instance. SQL> SQL> ORACLE instance started. Total System Global Area 219750124 bytes Fixed Size 454380 bytes Variable Size 134217728 bytes Database Buffers 83886080 bytes Redo Buffers 1191936 bytes ORA-00205: error in identifying controlfile, check alert log for more info SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - Productio n With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.7.0 - Production BR0280I BRRECOVER time stamp: 2009-11-01 10.28.04 BR0279E Return code from 'E:\oracle\ora92\bin\SQLPLUS': 0 BR0302E SQLPLUS call for database instance ECP failed BR0332E Start and mount of database instance ECP failed BR0669I Cannot continue due to previous warnings or errors - you can go back to repeat the last action BR0280I BRRECOVER time stamp: 2009-11-01 10.28.04 BR0671I Enter 'b[ack]' to go back, 's[top]' to abort: When I checked in alert file it is shows the below statements ARCH: STARTING ARCH PROCESSES COMPLETE Sun Nov 01 10:28:03 2009 ARC0: Becoming the 'no FAL' ARCH ARC0: Becoming the 'no FAL' ARCHARC0: Thread not mounted Sun Nov 01 10:28:03 2009 ARC1: Becoming the heartbeat ARCH ARC1: Becoming the heartbeat ARCHARC1: Thread not mounted Sun Nov 01 10:28:03 2009 ALTER DATABASE MOUNT Sun Nov 01 10:28:03 2009 ORA-00202: controlfile: '%ORACLE_HOME%\DATABASE\CTL1%ORACLE_SID%.ORA' ORA-27046: file size is not a multiple of logical block size OSD-04012: file size mismatch O/S-Error: (OS 1248) No more local devices. Sun Nov 01 10:28:04 2009 ORA-205 signalled during: ALTER DATABASE MOUNT... Sun Nov 01 10:29:03 2009 ARC1: Thread not mounted Prashanth

Hi, Kindly find the last statements of the " ALERT file" that show the error. Please let me know the sloution for this error. Tue Nov 03 19:52:50 2009 ORA-1507 signalled during: alter database open resetlogs ... Tue Nov 03 19:53:35 2009 ARC1: Thread not mounted Tue Nov 03 19:54:35 2009 ARC0: Thread not mounted Tue Nov 03 19:54:35 2009 ARC1: Thread not mounted Tue Nov 03 19:55:35 2009 ARC1: Thread not mounted Tue Nov 03 19:56:35 2009 ARC1: Thread not mounted Tue Nov 03 19:57:35 2009 ARC1: Thread not mounted Tue Nov 03 19:58:35 2009 ARC1: Thread not mounted Tue Nov 03 19:59:35 2009 ARC0: Thread not mounted Tue Nov 03 19:59:35 2009 ARC1: Thread not mounted Tue Nov 03 20:00:35 2009 ARC1: Thread not mounted Tue Nov 03 20:01:35 2009 ARC1: Thread not mounted Tue Nov 03 20:02:11 2009 Shutting down instance: further logons disabled Shutting down instance (immediate) License high water mark = 2 Tue Nov 03 20:02:17 2009 ALTER DATABASE CLOSE NORMAL ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL... ARCH: Archiving is disabled Shutting down archive processes Archiving is disabled Tue Nov 03 20:02:17 2009 ARCH shutting down ARC0: Archival stopped Tue Nov 03 20:02:17 2009 ARCH shutting down ARC1: Archival stopped Tue Nov 03 20:02:20 2009 ARCH: Archiving is disabled Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Tue Nov 03 20:02:20 2009 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 SCN scheme 2 LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 9.2.0.7.0. System parameters with non-default values: processes = 80 sessions = 96 timed_statistics = TRUE shared_pool_size = 192937984 sga_max_size = 429465824 shared_pool_reserved_size= 19220398 enqueue_resources = 8000 control_files = E:\oracle\ECP\origlogA\cntrl\cntrlECP.dbf, E:\oracle\ECP\sapdata1\system_1\cntrl\cntrlECP.dbf, E:\oracle\ECP\saparch\cntrl\cntrlECP.dbf db_block_size = 8192 db_cache_size = 192937984 compatible = 9.2.0 log_archive_start = TRUE log_archive_dest = E:\oracle\ECP\oraarch\ECParch log_buffer = 1048576 log_checkpoint_interval = 0 log_checkpoint_timeout = 0 db_files = 254 db_file_multiblock_read_count= 8 fast_start_mttr_target = 900 log_checkpoints_to_alert = TRUE control_file_record_keep_time= 30 dml_locks = 4000 transaction_auditing = FALSE undo_management = AUTO undo_tablespace = PSAPUNDO undo_retention = 43200 remote_os_authent = TRUE hash_join_enabled = FALSE background_dump_dest = E:\oracle\ECP\saptrace\background user_dump_dest = E:\oracle\ECP\saptrace\usertrace core_dump_dest = E:\oracle\ECP\saptrace\background optimizer_features_enable= 9.2.0 sort_area_size = 2097152 sort_area_retained_size = 0 db_name = ECP open_cursors = 800 optimizer_mode = choose optimizer_index_cost_adj = 10 pga_aggregate_target = 256271974 workarea_size_policy = AUTO statistics_level = typical PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7 Tue Nov 03 20:02:22 2009 ARCH: STARTING ARCH PROCESSES ARC0 started with pid=8 ARC0: Archival started ARC1 started with pid=9 ARC1: Archival started Tue Nov 03 20:02:22 2009 ARCH: STARTING ARCH PROCESSES COMPLETE Tue Nov 03 20:02:22 2009 *ARC0: Becoming the 'no FAL' ARCH* *ARC0: Becoming the 'no FAL' ARCHARC0: Thread not mounted* *Tue Nov 03 20:02:22 2009* *ARC1: Becoming the heartbeat ARCH* *ARC1: Becoming the heartbeat ARCHARC1: Thread not mounted* *Tue Nov 03 20:02:23 2009* *ALTER DATABASE MOUNT* *Tue Nov 03 20:02:23 2009* *ORA-00202: controlfile: 'E:\oracle\ECP\origlogA\cntrl\cntrlECP.dbf'* *ORA-27046: file size is not a multiple of logical block size* *OSD-04000: logical block size mismatch (OS 512)* Tue Nov 03 20:02:23 2009 ORA-205 signalled during: ALTER DATABASE MOUNT... Prashanth

You need to recreate the controlfiles on the target system before you can restore the DB.

You can generate a backup of the controlfiles on your source system using SQL command,

alter database backup controlfile to trace;

This will create a dump on your /oracle/<SID>/saptrace/usertrace directory the you'll need to modify the file to suit your target system and restore as sql script (you'll have to rename the dump to work as script)

Haven said this you should not be doing a system copy/refresh via DB copy on an ABAP+JAVA system... you should follow the homogenous system copy guide otherwise you'll have a bit of a headache with the JAVA side.

Regards
Juan