Skip to Content
0
Former Member
Nov 01, 2009 at 05:20 AM

Error with DB REFRESH method using BRBACKUP and BRRESTORE

178 Views

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