Возможно при восстановлении базы остался старый control file

brrestore -b bcnmhluz.aft -m full
Restore all the files from backup bcnmhluz.aft , including the control file and the online redo log files. Restore the mirror copies of the control file and the online redo log files.

Перед запуском нужно создать структуру папок ORACLE, аналогичную исходной базе и переписать логи backup и redo log files (еcли выполнен online backup) из старой в новую папку sapbackup.

Если есть возможность копировать все папки старой базы на новый сервер, и не мучаться с восстановлением из backup, можно действовать по следующему алгоритму
1. Generate a script which will help you to create CONTROL FILE on target machine via SQLPLUS.
• Logon as user ora.
• Call SQLPLUS and login as SYSDBA
# sqlplus /nolog
SQLPLUS> connect internal /as sysdba
• Execute the following commands:
SQLPLUS> alter database backup controlfile to trace;
This will generate a trace file ( *.trc ) under /oracle//saptrace/usertrace .
2. Shutdown the database with SHUTDOWN IMMEDIATE
3. Edit Trace file generated in step 1 so that you can create CONTROL FILE's for Target Database ID TGT.
• Delete all commented lines ( lines starting with '#' character ).
• Delete other repeated lines so that only lines between
STARTUP MOUNT.... and WE8DEC; remains.
• Change all 'SRC' texts with 'TGT'. (Если менял <SID>)
• Change the CREATE CONTROLFILE... line so that it looks like
CREATE CONTROLFILE REUSE SET DATABASE "TGT" RESETLOGS ARCHIVELOG...
• If you are runnig R/3 System on Windows platform, then edit the file paths if you copied files on different disks and folders.
5. Execute the script via SQLPLUS.
SQLPLUS> @/path_to_file/control.sql
6. Open the database
SQLPLUS> alter database open resetlogs;

Всем откликнувшимся большое спасибо за советы!
Круги ада закончились - R/3 подняли посредством экспорта и последующего импорта через SAPInst.

Опиши пожалуйста в общих чертах технологию и узкие места гомогеного копирования базы через экспорт-импорт, вдруг другим прегодится.

Может быть я все-таки ошибаюсь, но с использованием SAPInst при выборе опции (для Database Inctance) "System copy / migration" (именно ее я использовал в последней удачной попытке) осуществляется гетерогенное копирование.

Здесь особых сложностей не возникало.
Хотя база у нас была повреждена неудачным горячим бэкапом и чудом запустилась, при экспорте средствами SapInst возникли ошибки для 2-х таблиц. Путем их пересоздания (копирования записей в новую, trancate оригинальной и создании такой же с записями из временной) эти ошибки были пройдены и экспорт завершился.

Далее была запущена новая инсталяция Oracle, центральная система (с теми же параметрами), Database Instanse - с указанием "System copy / migration", в ходе которой из затруднений было только:
- не забыть скопировать обновленное ядро (т.к. оно уже патчилось)
- возникали ошибки с Oracle-datafile, которые не имеют autoextent (пример: SAPDATA3\TEMP_1\TEMP.DATA1) - при возникновении расширяем и продолжаем sapinst.

И еще на service.sap.com нужно будет получить migration key.

Вот вроде и все.
А гомогенное копирование не получилось. Сам буду рад поучиться

Не удаётся заставить brbackup автоматически удалять старые бэкапы

initDEV_day.sap на данный момент:

backup_mode = all
restore_mode = all
backup_type offline_force
backup_dev_type = disk
backup_root_dir = e:\oracle\DEV\sapbackup\_day\
stage_root_dir = e:\oracle\DEV\sapbackup\_day\
compress = yes
compress_cmd = "C:\usr\sap\DEV\SYS\exe\run\mkszip -c $ > $"
uncompress_cmd = "C:\usr\sap\DEV\SYS\exe\run\uncompress -c $ > $"
compress_dir = E:\oracle\DEV\sapreorg
archive_function = save
archive_copy_dir = e:\oracle\DEV\sapbackup\_day\
archive_stage_dir = e:\oracle\DEV\sapbackup\_day\
tape_copy_cmd = cpio
disk_copy_cmd = copy
stage_copy_cmd = rcp
cpio_flags = -ovB
cpio_in_flags = -iuvB
cpio_disk_flags = -pdcu
dd_flags = "bs=64k"
dd_in_flags = "bs=64k"
saveset_members = 1
copy_out_cmd = "dd ibs=8k obs=64k of=$"
copy_in_cmd = "dd ibs=64k obs=8k if=$"
rewind = "mt -f $ rewind"
rewind_offline = "mt -f $ offline"
tape_pos_cmd = "mt -f $ fsf $"
tape_size = 1200M
exec_parallel = 0
tape_address = /dev/nmt0
tape_address_rew = /dev/mt0
volume_archive = (DEVA01, DEVA02, DEVA03, DEVA04, DEVA05,
DEVA06, DEVA07, DEVA08, DEVA09, DEVA10,
DEVA11, DEVA12, DEVA13, DEVA14, DEVA15,
DEVA16, DEVA17, DEVA18, DEVA19, DEVA20,
DEVA21, DEVA22, DEVA23, DEVA24, DEVA25,
DEVA26, DEVA27, DEVA28, DEVA29, DEVA30)
volume_backup = (DEVB01, DEVB02, DEVB03, DEVB04, DEVB05,
DEVB06, DEVB07, DEVB08, DEVB09, DEVB10,
DEVB11, DEVB12, DEVB13, DEVB14, DEVB15,
DEVB16, DEVB17, DEVB18, DEVB19, DEVB20,
DEVB21, DEVB22, DEVB23, DEVB24, DEVB25,
DEVB26, DEVB27, DEVB28, DEVB29, DEVB30)
expir_period = 1
tape_use_count = 100
cleanup_owner = sapr3
cleanup_brarchive_log = 2
cleanup_brbackup_log = 2
cleanup_disk_archive = 1
cleanup_disk_backup = 1

R/3 4.7 200

Возможно, не внимательно прочитал всю предыдущую переписку.
Запланировано ли задание "cleanup logs" для удаления устаревших резервных копий?

# @(#)initNT.sap 20.41.5.1 SAP 97/11/07
########################################################################
# #
# SAP backup sample profile. #
# The parameter syntax is the same as for init.ora parameters. #
# Enclose parameter values which consist of more than one symbol in #
# double quotes. #
# After any symbol, parameter definition can be continued on the next #
# line. #
# A parameter value list should be enclosed in parentheses, the list #
# items should be delimited by commas. #
# There can be any number of spaces (blanks, tabs and new lines) #
# between symbols for parameter definition. #
# #
########################################################################

# backup mode [all | all_data | sap_dir | ora_dir | <tablespace_name> |
# <file_id> | <file_id1>-<file_id2> | <generic_path> | (<object_list>)]
# default: all
backup_mode = all

# backup type [offline | offline_force | offline_standby | offline_split
# | offline_stop | online | online_cons | online_split]
# default: offline
backup_type = offline

# backup device type
# [tape | tape_auto | tape_box | pipe | pipe_auto | pipe_box | disk
# | disk_copy | disk_standby | util_file | util_file_online]
# default: tape
backup_dev_type = disk

# backup root directory [<path_name> | (<path_name_list>)]
# default: %SAPDATA_HOME%\sapbackup
backup_root_dir = g:\oracle\VSP\sapbackup

# compression flag [yes | no | hardware | only]
# default: no
compress = yes

# compress command
# first $-character is replaced by the source file name
# second $-character is replaced by the target file name
# <target_file_name> = <source_file_name>.Z
# for compress command the -c option must be set
# recommended setting for brbackup -k only run:
# "%SAPEXE%\mkszip -l 0 -c $ > $"
# no default
compress_cmd = "d:\usr\sap\<SID>\sys\exe\run\mkszip -c $ > $"

# uncompress command
# first $-character is replaced by the source file name
# second $-character is replaced by the target file name
# <source_file_name> = <target_file_name>.Z
# for uncompress command the -c option must be set
# no default
uncompress_cmd = "d:\usr\sap\VSP\sys\exe\run\uncompress -c $ > $"

# directory for compression [<path_name> | (<path_name_list>)]
# default: values of the backup_root_dir parameter
compress_dir = g:\oracle\<SID>\sapreorg

# brarchive function [save | second_copy | double_save | save_delete
# | second_copy_delete | double_save_delete | copy_save
# | copy_delete_save | delete_saved | delete_copied]
# default: save
archive_function = save

# directory for archive log copies
# default: first value of the backup_root_dir parameter
archive_copy_dir = g:\oracle\<SID>\sapbackup

# new database home directory for disk_copy | disk_standby
# no default
# new_db_home = X:\oracle\C11

# tape copy command for regular files [cpio | dd]
# default: cpio
tape_copy_cmd = cpio

# flags for cpio output command
# default: -ovB
cpio_flags = -ovB

# flags for cpio input command
# default: -iuvB
cpio_in_flags = -iuvB

# flags for cpio command for copy of directories to disk
# default: -pdcu
cpio_disk_flags = -pdcu

# flags for dd output command
# default: "obs=16k"
# caution: option "obs=" not supported for Windows NT
# recommended setting:
# Unix: "obs=nk bs=nk", example: "obs=16k bs=16k"
# NT: "bs=nk", example: "bs=16k"
dd_flags = "bs=16k"

# flags for dd input command
# default: "ibs=16k"
# caution: option "ibs=" not supported for Windows NT
# recommended setting:
# Unix: "ibs=nk bs=nk", example: "ibs=16k bs=16k"
# NT: "bs=nk", example: "bs=16k"
dd_in_flags = "bs=16k"

# remote shell command (backup_dev_type = pipe)
# no default
# HP-UX: "remsh hs0001" or "remsh hs0001 -l orac11"
# OSF1: "rsh ds0011" or "rsh ds0011 -l orac11"
# AIX: "remsh is0001" or "remsh is0001 -l orac11"
# SINIX: "rsh ss0001" or "rsh ss0001 -l orac11"
# SUN: "rsh us0001" or "rsh us0001 -l orac11"
# NT: "rsh xs0001" or "rsh xs0001 -l orac11"
read_fifo_cmd = "rsh xs0001"

# remote copy-out command (backup_dev_type = pipe)
# $-character is replaced by current device address
# no default
copy_out_cmd = "dd bs=5k of=$"

# remote copy-in command (backup_dev_type = pipe)
# $-character is replaced by current device address
# no default
copy_in_cmd = "dd bs=5k if=$"

# rewind command
# $-character is replaced by current device address
# no default
# operating system dependent, examples:
# HP-UX: "mt -t $ rew"
# OSF1: "mt -f $ rew"
# AIX: "tctl -f $ rewind"
# SINIX: "mt -f $ rew"
# SUN: "mt -f $ rew"
# NT: "mt -f $ rewind"
rewind = "mt -f $ rewind"

# rewind and set offline command
# $-character is replaced by current device address
# default: value of the rewind parameter
# operating system dependent, examples:
# HP-UX: "mt -t $ offl"
# OSF1: "mt -f $ offline"
# AIX: "tctl -f $ offline"
# SINIX: "mt -f $ offline"
# SUN: "mt -f $ offline"
# NT: "mt -f $ offline"
rewind_offline = "mt -f $ offline"

# tape positioning command
# first $-character is replaced by current device address
# second $-character is replaced by number of files to be skipped
# no default
# operating system dependent, examples:
# HP-UX: "mt -t $ fsf $"
# OSF1: "mt -f $ fsf $"
# AIX: "tctl -f $ fsf $"
# SINIX: "mt -f $ fsf $"
# SUN: "mt -f $ fsf $"
# NT: "mt -f $ fsf $"
tape_pos_cmd = "mt -f $ fsf $"

# mount backup volume command in auto loader / juke box
# used if backup_dev_type = tape_box | pipe_box
# caution: if successful, exit code 0 and no output!
# no default
# mount_cmd = "<mount_cmd> $ $ $ [$]"

# dismount backup volume command in auto loader / juke box
# used if backup_dev_type = tape_box | pipe_box
# caution: if successful, exit code 0 and no output!
# no default
# dismount_cmd = "<dismount_cmd> $ $ [$]"

# split mirror disks command
# used if backup_type = offline_split | online_split
# caution: if successful, exit code 0 and no output!
# no default
# split_cmd = "<split_cmd> [$]"

# resynchronize mirror disks command
# used if backup_type = offline_split | online_split
# caution: if successful, exit code 0 and no output!
# no default
# resync_cmd = "<resync_cmd> [$]"

# volume size in KB = K, MB = M or GB = G (backup device dependent)
# default: 1200M
# recommended values for tape devices without hardware compression:
# 60 m 4 mm DAT DDS-1 tape: 1200M
# 90 m 4 mm DAT DDS-1 tape: 1800M
# 120 m 4 mm DAT DDS-2 tape: 3800M
# 125 m 4 mm DAT DDS-3 tape: 11000M
# 112 m 8 mm Video tape: 2000M
# 112 m 8 mm high density: 4500M
# DLT 2000 10/20 GB: 10000M
# DLT 2000XT 15/30 GB: 15000M
# DLT 4000 20/40 GB: 20000M
# DLT 7000 35/70 GB: 35000M
# recommended values for tape devices with hardware compression:
# 60 m 4 mm DAT DDS-1 tape: 1000M
# 90 m 4 mm DAT DDS-1 tape: 1600M
# 120 m 4 mm DAT DDS-2 tape: 3600M
# 125 m 4 mm DAT DDS-3 tape: 10000M
# 112 m 8 mm Video tape: 1800M
# 112 m 8 mm high density: 4300M
# DLT 2000 10/20 GB: 9000M
# DLT 2000XT 15/30 GB: 14000M
# DLT 4000 20/40 GB: 18000M
# DLT 7000 35/70 GB: 30000M
tape_size = 1200M

# volume size in KB = K, MB = M or GB = G used by brarchive
# default: value of the tape_size parameter
# tape_size_arch = 1200M

# level of parallel execution
# default: 0 - set to number of backup devices
exec_parallel = 4

# address of backup device without rewind
# [<dev_address> | (<dev_address_list>)]
# no default
# operating system dependent, examples:
# HP-UX: /dev/rmt/0mn
# OSF1: /dev/nrmt0h
# AIX: /dev/rmt0.1
# SINIX: /dev/ios0/rstape005n
# SUN: /dev/rmt/0mn
# NT: /dev/nmt0
tape_address = /dev/nmt0

# address of backup device without rewind used by brarchive
# default: value of the tape_address parameter
# operating system dependent
# tape_address_arch = /dev/nmt0

# address of backup device with rewind
# [<dev_address> | (<dev_address_list>)]
# no default
# operating system dependent, examples:
# HP-UX: /dev/rmt/0m
# OSF1: /dev/rmt0h
# AIX: /dev/rmt0
# SINIX: /dev/ios0/rstape005
# SUN: /dev/rmt/0m
# NT: /dev/mt0
tape_address_rew = /dev/mt0

# address of backup device with rewind used by brarchive
# default: value of the tape_address_rew parameter
# operating system dependent
# tape_address_rew_arch = /dev/mt0

# address of backup device with control for mount/dismount command
# [<dev_address> | (<dev_address_list>)]
# default: value of the tape_address_rew parameter
# operating system dependent
# tape_address_ctl = /dev/...

# address of backup device with control for mount/dismount command
# used by brarchive
# default: value of the tape_address_rew_arch parameter
# operating system dependent
# tape_address_ctl_arch = /dev/...

# volumes for brarchive
# [<volume_name> | (<volume_name_list>) | SCRATCH]
# no default
volume_archive = (VSPA01, VSPA02, VSPA03, VSPA04, VSPA05,
VSPA06, VSPA07, VSPA08, VSPA09, VSPA10,
VSPA11, VSPA12, VSPA13, VSPA14, VSPA15,
VSPA16, VSPA17, VSPA18, VSPA19, VSPA20,
VSPA21, VSPA22, VSPA23, VSPA24, VSPA25,
VSPA26, VSPA27, VSPA28, VSPA29, VSPA30)

# volumes for brbackup
# [<volume_name> | (<volume_name_list>) | SCRATCH]
# no default
volume_backup = (VSPB01, VSPB02, VSPB03, VSPB04, VSPB05,
VSPB06, VSPB07, VSPB08, VSPB09, VSPB10,
VSPB11, VSPB12, VSPB13, VSPB14, VSPB15,
VSPB16, VSPB17, VSPB18, VSPB19, VSPB20,
VSPB21, VSPB22, VSPB23, VSPB24, VSPB25,
VSPB26, VSPB27, VSPB28, VSPB29, VSPB30)

# expiration period for backup volumes in days
# default: 30
expir_period = 30

# recommended usages of backup volumes
# default: 100
tape_use_count = 100

# backup utility parameter file
# default: no parameter file
# util_par_file = initVSP.utl

# mount/dismount command parameter file
# default: no parameter file
# mount_par_file = initVSP.mnt

# Oracle instance string to the primary database
# no default
# primary_db = <inst_str>

# description of parallel instances for Oracle Parallel Server
# parallel_instances = <instance_desc> | (<instance_desc_list>)
# <instance_desc_list> -> <instance_desc>[,<instance_desc>...]
# <instance_desc> -> <Oracle_sid>:<Oracle_home>@<inst_str>
# <Oracle_sid> -> Oracle system id for parallel instance
# <Oracle_home> -> Oracle home for parallel instance
# <inst_str> -> Oracle instance string to parallel instance
# Do not include the local instance in the parameter definition!
# default: no parallel instances
#
# example for initC11.sap:
# parallel_instances = (C11_002:/oracle/C11@C11_002,
# C11_003:/oracle/C11@C11_003)
#
# example for initC11_002.sap:
# parallel_instances = (C11:/oracle/C11@C11,
# C11_003:/oracle/C11@C11_003)

А это собственно прописанная в батнике командная строка.
d:\usr\sap\<SID>\sys\exe\run\brbackup.exe -p init<SID>.sap -u system/<password> -c

Все стреляет как с ружья)))) Если зашедулить батник, то копируется на диск с необходимой периодичностью периодичностью)))

Релиз 4.0В, под Win 2000 Sr

Так для инфы, может кому-то понадобится. С вероятностью 90% могу предположить, что решением проблеммы является.

sqlplus /nolog
connect / as sysdba
SQL> create spfile from pfile;

Есть Note номер не помню, но нота свежая январьская.

Всем удачи!

Ерунда какая-то. Причем тут spfile/pfile? Если нет spfile оракл прекрасно стартует с pfile.

Аффтор, в супер системе Виндовз чтобы восстановить базу недостаточно просто восстановить файлы на то же место, надо еще создать сервис, команда oradim оракловая.

Вообще восстанавливать лично мне гораздо проще руками чем brrestore всякими.... тьфу-тьфу-тьфу конечно...

Добрый день!

Кто-нибудь реализовывал инкриментный бэкап БД Oracle с помощью BRTOOLS (+ RMAN)?