cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Online Recovery Failed err: BR0752E Control files are not 'CURRENT'

Former Member

on ‎02-27-2009 7:24 AM

0 Kudos

Hi,

This is the first time i am doing the online recovery of oracle DB after taking online backup.

So, this what i am facing while doing the activity.

"BR0752E Control files are not 'CURRENT' - complete recovery not possible"

Steps that i have performed before running brtools:

1>. Configured the profile (initQ50.sap) for full online backup to disk

2>. Online backup completed with RC=0

3>. BRARCHIVE completed with RC=0

4>. On the target system installed SAP , Oracle 10 restored all the BR * Logs

5>. Started completed recovery.

FLGPRSAP02:oraq50 64% brtools

BR0651I BRTOOLS 7.00 (18)

BR0280I BRTOOLS time stamp: 2009-02-27 12.32.16

BR0656I Choice menu 1 - please make a selection

-

BR*Tools main menu

1 = Instance management

2 - Space management

3 - Segment management

4 - Backup and database copy

5 - Restore and recovery

6 - Check and verification

7 - Database statistics

8 - Additional functions

9 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

BR0662I Enter your choice:

5

BR0280I BRTOOLS time stamp: 2009-02-27 12.32.20

BR0663I Your choice: '5'

BR0280I BRTOOLS time stamp: 2009-02-27 12.32.20

BR0656I Choice menu 11 - please make a selection

-

Restore and recovery

1 = Complete database recovery

2 - Database point-in-time recovery

3 - Tablespace point-in-time recovery

4 - Whole database reset

5 - Restore of individual backup files

6 - Restore and application of archivelog files

7 - Disaster recovery

8 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

BR0662I Enter your choice:

1

BR0280I BRTOOLS time stamp: 2009-02-27 12.32.22

BR0663I Your choice: '1'

BR0280I BRTOOLS time stamp: 2009-02-27 12.32.22

BR0657I Input menu 34 - please check/enter input values

-

BRRECOVER options for restore and recovery

1 - BRRECOVER profile (profile) ...... [initQ50.sap]

2 ~ BACKINT/Mount profile (parfile) .. []

3 - Database user/password (user) .... [/]

4 - Recovery interval (interval) ..... [30]

5 - Confirmation mode (confirm) ...... [yes]

6 - Scrolling line count (scroll) .... [20]

7 - Message language (language) ...... [E]

8 - BRRECOVER command line (command) . [-p initQ50.sap -t complete -i 30 -s 20 -l E]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2009-02-27 12.32.26

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0291I BRRECOVER will be started with options '-p initQ50.sap -t complete -i 30 -s 20 -l E'

BR0280I BRTOOLS time stamp: 2009-02-27 12.32.26

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR0280I BRTOOLS time stamp: 2009-02-27 12.32.28

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

###############################################################################

BR0701I BRRECOVER 7.00 (18)

BR0705I Start of database recovery: veaaddlc.crv 2009-02-27 12.32.28

BR0280I BRRECOVER time stamp: 2009-02-27 12.32.28

BR0707I Recovery of database: Q50

BR0708I BRRECOVER action ID: veaaddlc

BR0709I BRRECOVER function ID: crv

BR0710I Recovery type: complete

BR0280I BRRECOVER time stamp: 2009-02-27 12.32.28

BR0655I Control menu 101 - please decide how to proceed

-

Complete database recovery main menu

1 = Check the status of database files

2 * Select database backup

3 * Restore data files

4 * Restore and apply incremental backup

5 * Restore and apply archivelog files

6 * Open database and post-processing

7 * Exit program

8 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

BR0662I Enter your choice:

1

BR0280I BRRECOVER time stamp: 2009-02-27 12.32.31

BR0663I Your choice: '1'

BR0699I Reading log file /oracle/Q50/sapbackup/backQ50.log ...

BR0280I BRRECOVER time stamp: 2009-02-27 12.32.31

BR0549I Checking symbolic links using the last good BRBACKUP log file...

BR0699I Reading log file /oracle/Q50/sapbackup/bdzzulxv.and ...

BR0460W Termination message not found in /oracle/Q50/sapbackup/bdzzulxv.and - log file incomplete (this is OK if the log file was restored)

BR0614I Database instance Q50 is mounted

BR0750I Database instance Q50 will be remounted now with mode 'IMMEDIATE'

BR0280I BRRECOVER time stamp: 2009-02-27 12.32.31

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR0280I BRRECOVER time stamp: 2009-02-27 12.32.34

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRRECOVER time stamp: 2009-02-27 12.32.34

BR0307I Shutting down database instance Q50 ...

BR0280I BRRECOVER time stamp: 2009-02-27 12.32.42

BR0308I Shutdown of database instance Q50 successful

BR0280I BRRECOVER time stamp: 2009-02-27 12.32.42

BR0330I Starting and mounting database instance Q50 ...

BR0280I BRRECOVER time stamp: 2009-02-27 12.32.56

BR0331I Start and mount of database instance Q50 successful

BR0752E Control files are not 'CURRENT' - complete recovery not possible

BR0669I Cannot continue due to previous warnings or errors - you can go back to repeat the last action

BR0280I BRRECOVER time stamp: 2009-02-27 12.32.56

BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

Awaiting reply !!

Thank you in advance

Regards,

Sohal....

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
‎03-03-2009 4:37 AM
0 Kudos

Hi Harwinder,

Before creating a new controlfile just rename old control file in according directories.

And retry to create a new controlfile. It will solve your problem.

Regards

Nick Loy

Show replies
Show replies
Former Member
‎03-01-2009 10:36 AM
0 Kudos

Hi,

Please also check about this warnign.

BR0460W Termination message not found in /oracle/Q50/sapbackup/bdzzulxv.and - log file incomplete (this is OK if the log file was restored)

Have you followed the complete steps to create control file ?

Pleae see the below link and may helps you.

http://help.sap.com/saphelp_nw70/helpdata/EN/0d/d2ffba4a0c11d182b80000e829fbfe/frameset.htm

Thanks

Upender Reddy

Show replies
Show replies
Former Member
‎02-27-2009 9:43 AM
0 Kudos

hi,

It seems that your control file is not up to date. You can create new control file with sqlplus command :

>CREATE CONTROLFILE SET DATABASE u201C<DATABASE NAME>u201D RESETLOGS ARCHIVELOG

to create new control file.

ardhian

http://ardhian.kioslinux.com

http://sapbasis.wordpress.com

Show replies
Show replies
Former Member
‎02-28-2009 11:20 AM
0 Kudos

Hi Ardhian,

Tried as per your suggestion but faced below errors:

CREATE CONTROLFILE SET DATABASE "Q50" resetlogs archivelog;

CREATE CONTROLFILE SET DATABASE "Q50" resetlogs archivelog

*

ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed

ORA-01565: error in identifying file '?/dbs/dbs1@.dbf'

ORA-27037: unable to obtain file status

SVR4 Error: 2: No such file or directory

Additional information: 3

    • i tried the above cmd when DB was in nomount state**

Regards,

Sohal...

Ask a Question