Error with DB REFRESH method using BRBACKUP and BRRESTORE

[Former Member]

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 u201Cecd_ora_2852.trcu201D.

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

[sunny_pahuja2 · Accepted solution]

Hi,

> 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

>

>

Check SAP Note 784931 - Hom./Het.System Copy SAP Web AS 6.40 SR1 ABAP .

Thanks

sunny

[Former Member]

You may want to refer to documentation

[http://www.sdn.sap.com/irj/sdn/ora?rid=/webcontent/uuid/1cc71b42-0d01-0010-7f91-f352b58078cf] [original link is broken];

[JPReyes]

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

[Former Member]

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

[Former Member]

ORA-00202: controlfile: 'ORA-00202: controlfile: 'E:\oracle\ECP\origlogA\cntrl\cntrlECP.dbf'* ORA-27046: file size is not a multiple of logical block size'

Control file E:\oracle\ECP\origlogA\cntrl\cntrlECP.dbf seems to be corrupt. What did you do to it?

Let me suggest you repeat the step of creating control files, as described in the system copy guide. Read it thoroughly first!

hope this helps