Reply from Satish Ahirkar on Feb 19 at 5:19 AM Dear All,
Sorry for late reply. please check the following errors:
D:\usr\sap\ECP\DVEBMGS00\exe>brtools
BR0651I BRTOOLS 7.20 (1)
BR0280I BRTOOLS time stamp: 2014-02-19 13.02.14
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: 2014-02-19 13.02.17
BR0663I Your choice: '5'
BR0280I BRTOOLS time stamp: 2014-02-19 13.02.17
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 - Manage flashback database
9 - Reset program status
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
BR0662I Enter your choice:
5
BR0280I BRTOOLS time stamp: 2014-02-19 13.02.22
BR0663I Your choice: '5'
BR0280I BRTOOLS time stamp: 2014-02-19 13.02.22
BR0657I Input menu 34 - please enter/check input values
BRRECOVER options for restore and recovery
1 * Recovery type (type) ............. [restore]
2 - BRRECOVER profile (profile) ...... [initECP.sap]
3 ~ BACKINT/Mount profile (parfile) .. []
4 - Database user/password (user) .... [/]
5 - Recovery interval (interval) ..... [30]
6 - Confirmation mode (confirm) ...... [yes]
7 - Scrolling line count (scroll) .... [20]
8 - Message language (language) ...... [E]
9 - BRRECOVER command line (command) . [-p initECP.sap -t restore -i 30 -s
20 -
l E]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
BR0662I Enter your choice:
2
BR0280I BRTOOLS time stamp: 2014-02-19 13.02.26
BR0663I Your choice: '2'
BR0681I Enter string value for "profile" [initECP.sap]:
External_initECP.sap
BR0280I BRTOOLS time stamp: 2014-02-19 13.02.39
BR0683I New value for "profile": 'External_initECP.sap'
BR0280I BRTOOLS time stamp: 2014-02-19 13.02.39
BR0657I Input menu 34 - please enter/check input values
BRRECOVER options for restore and recovery
1 * Recovery type (type) ............. [restore]
2 - BRRECOVER profile (profile) ...... [External_initECP.sap]
3 ~ BACKINT/Mount profile (parfile) .. []
4 - Database user/password (user) .... [/]
5 - Recovery interval (interval) ..... [30]
6 - Confirmation mode (confirm) ...... [yes]
7 - Scrolling line count (scroll) .... [20]
8 - Message language (language) ...... [E]
9 - BRRECOVER command line (command) . [-p External_initECP.sap -t restore
-i 3
0 -s 20 -l E]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
BR0662I Enter your choice:
4
BR0280I BRTOOLS time stamp: 2014-02-19 13.02.42
BR0663I Your choice: '4'
BR0681I Enter string value for "user" [/]:
system/xxxxxxxxx
BR0280I BRTOOLS time stamp: 2014-02-19 13.02.50
BR0683I New value for "user": 'system/*********'
BR0280I BRTOOLS time stamp: 2014-02-19 13.02.50
BR0657I Input menu 34 - please enter/check input values
BRRECOVER options for restore and recovery
1 * Recovery type (type) ............. [restore]
2 - BRRECOVER profile (profile) ...... [External_initECP.sap]
3 ~ BACKINT/Mount profile (parfile) .. []
4 - Database user/password (user) .... [system/*********]
5 - Recovery interval (interval) ..... [30]
6 - Confirmation mode (confirm) ...... [yes]
7 - Scrolling line count (scroll) .... [20]
8 - Message language (language) ...... [E]
9 - BRRECOVER command line (command) . [-p External_initECP.sap -t restore
-i 3
0 -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: 2014-02-19 13.03.10
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0291I BRRECOVER will be started with options '-p External_initECP.sap -t
resto
re -i 30 -s 20 -l E'
BR0280I BRTOOLS time stamp: 2014-02-19 13.03.10
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2014-02-19 13.03.15
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
###############################################################################
BR0701I BRRECOVER 7.20 (1)
BR0705I Start of database recovery: venfwrgd.rif 2014-02-19 13.03.15
BR0484I BRRECOVER log file: H:\oracle\ECP\sapbackup\venfwrgd.rif
BR0280I BRRECOVER time stamp: 2014-02-19 13.03.15
BR0707I Recovery of database: ECP
BR0708I BRRECOVER action ID: venfwrgd
BR0709I BRRECOVER function ID: rif
BR0710I Recovery type: restore
BR0280I BRRECOVER time stamp: 2014-02-19 13.03.15
BR0656I Choice menu 120 - please make a selection
Restore of individual backup files main menu
1 = Restore files from BRBACKUP backup
2 - Restore individual files from tape
3 - Restore individual files from disk
4 - Restore individual files from backup utility
5 - Restore and apply incremental backup
6 * Exit program
7 - Reset program status
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
BR0662I Enter your choice:
3
BR0280I BRRECOVER time stamp: 2014-02-19 13.03.18
BR0663I Your choice: '3'
BR0280I BRRECOVER time stamp: 2014-02-19 13.03.18
BR0657I Input menu 126 - please enter/check input values
BRRESTORE options for restore of individual files from BRBACKUP/BRARCHIVE
disk b
ackup
1 - BRRESTORE profile (profile) ...... [External_initECP.sap]
2 - Disk device type (device) ........ [disk]
3 ? Backup file name (back_name) ..... []
4 ? Restore destination (rest_dest) .. []
5 - Confirmation mode (confirm) ...... [yes]
6 - Query mode (query) ............... [no]
7 - Compression mode (compress) ...... [no]
8 - Additional output (output) ....... [no]
9 - Message language (language) ...... [E]
10 - BRRESTORE command line (command) . [-p External_initECP.sap -d disk
-n2 -k
no -l E]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
BR0662I Enter your choice:
3
BR0280I BRRECOVER time stamp: 2014-02-19 13.03.23
BR0663I Your choice: '3'
BR0681I Enter string value for "back_name" []:
bemyzvvv.fnd
BR0280I BRRECOVER time stamp: 2014-02-19 13.03.28
BR0683I New value for "back_name": 'bemyzvvv.fnd'
BR0280I BRRECOVER time stamp: 2014-02-19 13.03.28
BR0657I Input menu 126 - please enter/check input values
BRRESTORE options for restore of individual files from BRBACKUP/BRARCHIVE
disk b
ackup
1 - BRRESTORE profile (profile) ...... [External_initECP.sap]
2 - Disk device type (device) ........ [disk]
3 - Backup file name (back_name) ..... [bemyzvvv.fnd]
4 ? Restore destination (rest_dest) .. []
5 - Confirmation mode (confirm) ...... [yes]
6 - Query mode (query) ............... [no]
7 - Compression mode (compress) ...... [no]
8 - Additional output (output) ....... [no]
9 - Message language (language) ...... [E]
10 - BRRESTORE command line (command) . [-p External_initECP.sap -d disk
-n2 bem
yzvvv.fnd -k no -l E]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
BR0662I Enter your choice:
4
BR0280I BRRECOVER time stamp: 2014-02-19 13.03.37
BR0663I Your choice: '4'
BR0681I Enter string value for "rest_dest" []:
L:\ECP_Backup
BR0280I BRRECOVER time stamp: 2014-02-19 13.03.47
BR0683I New value for "rest_dest": 'L:\ECP_Backup'
BR0280I BRRECOVER time stamp: 2014-02-19 13.03.47
BR0657I Input menu 126 - please enter/check input values
BRRESTORE options for restore of individual files from BRBACKUP/BRARCHIVE
disk b
ackup
1 - BRRESTORE profile (profile) ...... [External_initECP.sap]
2 - Disk device type (device) ........ [disk]
3 - Backup file name (back_name) ..... [bemyzvvv.fnd]
4 - Restore destination (rest_dest) .. [L:\ECP_Backup]
5 - Confirmation mode (confirm) ...... [yes]
6 - Query mode (query) ............... [no]
7 - Compression mode (compress) ...... [no]
8 - Additional output (output) ....... [no]
9 - Message language (language) ...... [E]
10 - BRRESTORE command line (command) . [-p External_initECP.sap -d disk
-n2 bem
yzvvv.fnd=L:\ECP_Backup -k no -l E]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
BR0662I Enter your choice:
c
BR0280I BRRECOVER time stamp: 2014-02-19 13.03.52
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0613I Database instance ECP is shut down
BR0291I BRRESTORE will be started with options '-p External_initECP.sap -d
disk
-n2 bemyzvvv.fnd=L:\ECP_Backup -k no -l E'
BR0280I BRRECOVER time stamp: 2014-02-19 13.03.53
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRRECOVER time stamp: 2014-02-19 13.03.57
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0401I BRRESTORE 7.20 (1)
BR0405I Start of file restore: renfwrhu.rsf 2014-02-19 13.03.58
BR0484I BRRESTORE log file: H:\oracle\ECP\sapbackup\renfwrhu.rsf
BR0280I BRRESTORE time stamp: 2014-02-19 13.03.58
BR0407I Restore of database: ECP
BR0408I BRRESTORE action ID: renfwrhu
BR0409I BRRESTORE function ID: rsf
BR0422I Backup file for restore directly from disk:
bemyzvvv.fnd=L:\ECP_Backup
BR0416I 1 file found to restore, size 0.000 MB
BR0424I Files will not be decompressed
BR0421I Restore device type: disk
BR0280I BRRESTORE time stamp: 2014-02-19 13.03.58
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:
c
BR0280I BRRESTORE time stamp: 2014-02-19 13.04.01
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0274E File 'bemyzvvv.fnd' not found
BR0406I End of file restore: renfwrhu.rsf 2014-02-19 13.04.01
BR0280I BRRESTORE time stamp: 2014-02-19 13.04.01
BR0404I BRRESTORE terminated with errors
BR0292I Execution of BRRESTORE finished with return code 5
BR0280I BRRECOVER time stamp: 2014-02-19 13.04.01
BR0668I Warnings or errors occurred - you can continue to ignore them or go
back
to repeat the last action
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
*also check the details of init<SID>.ora file.*
ecp.__oracle_base='E:\oracle'#ORACLE_BASE set from environment
*._B_TREE_BITMAP_PLANS=FALSE
*._IN_MEMORY_UNDO=FALSE
*._INDEX_JOIN_ENABLED=FALSE
*._OPTIM_PEEK_USER_BINDS=FALSE
*._OPTIMIZER_MJC_ENABLED=FALSE
*._SORT_ELIMINATION_COST_RATIO=10
*._TABLE_LOOKUP_PREFETCH_SIZE=0
*._use_zero_copy_io=FALSE
*.archive_lag_target=1200
*.audit_file_dest='H:\oracle\ECP\saptrace\audit'
*.compatible='11.2.0'
*.control_file_record_keep_time=30
*.control_files='K:\oracle\ECP\origlogA\cntrl\cntrlE CP.dbf','K:\oracle\ECP\origlogB\cntrl\cntrlECP.dbf', 'H:\oracle\ECP\sapdata1\cntrl\cntrlECP.dbf'
*.db_block_size=8192
*.db_cache_size=3863268556
*.db_name='ECP'
*.db_recovery_file_dest='I:\oracle\ECP\oraflash'
*.db_recovery_file_dest_size=30000M
*.db_unique_name='ecp_north'
*.dg_broker_start=true
*.diagnostic_dest='H:\oracle\ECP\saptrace'
*.dml_locks=4000
*.fal_server='ecp_qxxxxxxxxr.world'
*.FILESYSTEMIO_OPTIONS='setall'
*.local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = eccdbprd)(PORT =
1527))'
*.log_archive_config='dg_config=(ecp_north,ecp_south )'
*.log_archive_dest_1='LOCATION="I:\oracle\ECP\o raarch\ecparch",
valid_for=(ONLINE_LOGFILE,ALL_ROLES)'
*.log_archive_dest_2='service="ecp_qxxxxxxxxr.w orld"','LGWR ASYNC NOAFFIRM
delay=0 optional compression=disable max_failure=100 max_connections=1
reopen=300 db_unique_name="ecp_south"
net_timeout=30','valid_for=(all_logfiles,primary_r ole)'
ecp.log_archive_dest_3='location="I:\oracle\E CP\oraarch\ECParch"','
valid_for=(STANDBY_LOGFILE,STANDBY_ROLE)'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
ecp.log_archive_dest_state_3='ENABLE'
*.log_archive_format='%t_%s_%r.dbf'
ecp.log_archive_format='%t_%s_%r.dbf'
*.log_archive_max_processes=2
*.log_archive_min_succeed_dest=1
*.log_archive_trace=0
ecp.log_archive_trace=0
*.log_buffer=4096512
*.log_checkpoints_to_alert=true
*.log_file_name_convert='ecp','ecp'
*.max_dump_file_size='20000'
*.open_cursors
00
*.parallel_execution_message_size=16384
*.parallel_threads_per_cpu=1
*.pga_aggregate_target=629145600
*.processes=180
*.query_rewrite_enabled='false'
*.recyclebin='off'
*.remote_login_passwordfile='exclusive'
*.remote_os_authent=true
*.replication_dependency_tracking=false
*.sessions=160
*.shared_pool_reserved_size=386326855
*.shared_pool_size=3863268556
*.standby_file_management='AUTO'
*.star_transformation_enabled='true'
*.undo_tablespace='PSAPUNDO'
Regards,
| | | ---------------Original Message---------------
From: abdulhamed51
Sent: Tuesday, February 18, 2014 3:30 AM
Subject: Restore Database Error
Hi Satish,
Check the values in profiles
initsid.ora whether all the parameters are correctly defined |
| Reply to this email to post your response. __.____._ |   _.____.__ |
