cancel
Showing results for 
Search instead for 
Did you mean: 

how to perform complete database recovery though brtools

Former Member
0 Kudos

BR0651I BRTOOLS 6.40 (15)

BR0280I BRTOOLS time stamp: 2009-12-14 18.42.05

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-12-14 18.42.11

BR0663I Your choice: '5'

BR0280I BRTOOLS time stamp: 2009-12-14 18.42.11

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 input values

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

-


BR0662I Enter your choice:

1

BR0280I BRTOOLS time stamp: 2009-12-14 18.42.21

BR0663I Your choice: '1'

BR0280I BRTOOLS time stamp: 2009-12-14 18.42.21

BR0657I Input menu 34 - please check/enter input values

-


BRRECOVER options for restore and recovery

1 - BRRECOVER profile (profile) ...... [initPRD.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 initPRD.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:

3

BR0280I BRTOOLS time stamp: 2009-12-14 18.42.31

BR0663I Your choice: '3'

BR0280I BRTOOLS time stamp: 2009-12-14 18.42.31

BR0681I Enter string value for "user" [/]:

sys as sysdba/sanjeev@prd

BR0280I BRTOOLS time stamp: 2009-12-14 18.42.50

BR0683I New value for "user": 'sys as sysdba/sanjeev@prd'

BR0280I BRTOOLS time stamp: 2009-12-14 18.42.50

BR0657I Input menu 34 - please check/enter input values

-


BRRECOVER options for restore and recovery

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

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

3 - Database user/password (user) .... [sys as sysdba/***********]

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 initPRD.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-12-14 18.43.01

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0291I BRRECOVER will be started with options '-p initPRD.sap -t complete -i 30

-s 20 -l E'

BR0280I BRTOOLS time stamp: 2009-12-14 18.43.01

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

c

BR0280I BRTOOLS time stamp: 2009-12-14 18.43.04

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

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

BR0701I BRRECOVER 6.40 (15)

BR0705I Start of database recovery: vecdcthw.crv 2009-12-14 18.43.04

BR0049W Last BRRECOVER run was probably killed

BR0280I BRRECOVER time stamp: 2009-12-14 18.43.04

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRECOVER:

c

BR0280I BRRECOVER time stamp: 2009-12-14 18.43.09

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRRECOVER time stamp: 2009-12-14 18.43.09

BR0707I Recovery of database: PRD

BR0708I BRRECOVER action ID: vecdcthw

BR0709I BRRECOVER function ID: crv

BR0710I Recovery type: complete

BR0280I BRRECOVER time stamp: 2009-12-14 18.43.09

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 input values

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

-


BR0662I Enter your choice:

c

BR0280I BRRECOVER time stamp: 2009-12-14 18.43.19

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0342I Database instance PRD is open

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

BR0280I BRRECOVER time stamp: 2009-12-14 18.43.21

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

c

BR0280I BRRECOVER time stamp: 2009-12-14 18.43.27

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRRECOVER time stamp: 2009-12-14 18.43.27

BR0307I Shutting down database instance PRD ...

BR0278E Command output of 'D:\oracle\ora92\bin\SQLPLUS':

SQL*Plus: Release 9.2.0.4.0 - Production on Mon Dec 14 18:43:27 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> SP2-0306: Invalid option.

Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]

where <logon> ::= <username>[/<password>][@<connect_string>] | /

SQL>

SQL> ORA-01012: not logged on

SQL>

BR0280I BRRECOVER time stamp: 2009-12-14 18.43.29

BR0279E Return code from 'D:\oracle\ora92\bin\SQLPLUS': 0

BR0302E SQLPLUS call for database instance PRD failed

BR0309E Shutdown of database instance PRD failed

BR0280I BRRECOVER time stamp: 2009-12-14 18.43.29

BR0064I Database instance PRD will be shut down now with mode 'ABORT'

BR0675I Do you want to perform this action?

BR0676I Enter 'y[es]/c[ont]' to perform the action, 'n[o]' to skip it, 's[top]'

to abort:

y

BR0280I BRRECOVER time stamp: 2009-12-14 18.43.53

BR0257I Your reply: 'y'

BR0677I Action will be performed...

BR0280I BRRECOVER time stamp: 2009-12-14 18.43.53

BR0307I Shutting down database instance PRD ...

BR0278E Command output of 'D:\oracle\ora92\bin\SQLPLUS':

SQL*Plus: Release 9.2.0.4.0 - Production on Mon Dec 14 18:43:53 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> SP2-0306: Invalid option.

Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]

where <logon> ::= <username>[/<password>][@<connect_string>] | /

SQL>

SQL> ORA-01031: insufficient privileges

SQL>

BR0280I BRRECOVER time stamp: 2009-12-14 18.43.55

BR0279E Return code from 'D:\oracle\ora92\bin\SQLPLUS': 0

BR0302E SQLPLUS call for database instance PRD failed

BR0309E Shutdown of database instance PRD failed

BR0669I Cannot continue due to previous warnings or errors - you can go back to

repeat the last action

BR0280I BRRECOVER time stamp: 2009-12-14 18.43.55

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

b

BR0280I BRRECOVER time stamp: 2009-12-14 18.44.12

BR0257I Your reply: 'b'

BR0673I Going back to the previous menu...

BR0280I BRRECOVER time stamp: 2009-12-14 18.44.12

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 input values

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

-


BR0662I Enter your choice:

Accepted Solutions (0)

Answers (1)

Answers (1)

sunny_pahuja2
Active Contributor
0 Kudos

Hi,

Check this [link|http://help.sap.com/SAPHELP_ERP2004/helpdata/EN/65/cade3bd0c8545ee10000000a114084/content.htm]

Thanks

Sunny