Skip to Content
0
Former Member
Feb 27, 2009 at 07:24 AM

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

604 Views

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