Добрый день.


Возникла необходимость востановить систему.

saperp1:~ # su oraerp
saperp1:oraerp 51> brtools
BR0651I BRTOOLS 7.00 (28)

BR0280I BRTOOLS time stamp: 2008-05-22 13.52.31
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: 2008-05-22 13.55.57



BR0663I Your choice: '5'

BR0280I BRTOOLS time stamp: 2008-05-22 13.55.57
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:
4
BR0280I BRTOOLS time stamp: 2008-05-22 13.56.13
BR0663I Your choice: '4'

BR0280I BRTOOLS time stamp: 2008-05-22 13.56.13
BR0657I Input menu 34 - please check/enter input values
-------------------------------------------------------------------------------
BRRECOVER options for restore and recovery

1 * Recovery type (type) ............. [reset]
2 - BRRECOVER profile (profile) ...... [initERP.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 initERP.sap -t reset -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: 2008-05-22 13.56.26
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

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

BR0280I BRTOOLS time stamp: 2008-05-22 13.56.26
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2008-05-22 13.56.37
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

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

BR0701I BRRECOVER 7.00 (28)
BR0705I Start of database recovery: vdxzakcj.drs 2008-05-22 13.56.37
BR0484I BRRECOVER log file: /oracle/ERP/sapbackup/vdxzakcj.drs

BR0280I BRRECOVER time stamp: 2008-05-22 13.56.37
BR0707I Recovery of database: ERP
BR0708I BRRECOVER action ID: vdxzakcj
BR0709I BRRECOVER function ID: drs
BR0710I Recovery type: reset

BR0280I BRRECOVER time stamp: 2008-05-22 13.56.37
BR0655I Control menu 109 - please decide how to proceed
-------------------------------------------------------------------------------
Whole database reset main menu

1 = Select consistent database backup
2 * Check the status of database files
3 * Restore control files and redolog files
4 * Restore data files
5 * Restore and apply incremental backup
6 * Apply archivelog files
7 * Open database and post-processing
8 * Exit program
9 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:

c
BR0280I BRRECOVER time stamp: 2008-05-22 13.57.02
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0699I Reading log file /oracle/ERP/sapbackup/backERP.log ...

BR0730W No appropriate backup created since 2008-04-23 00.00.00 found in /oracle
/ERP/sapbackup/backERP.log
BR0417E No files found for restore/verification

BR0669I Cannot continue due to previous warnings or errors - you can go back to
repeat the last action
BR0280I BRRECOVER time stamp: 2008-05-22 13.57.02
BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

c
BR0280I BRRECOVER time stamp: 2008-05-22 13.57.10
BR0258W Wrong reply: 'c'
BR0280I BRRECOVER time stamp: 2008-05-22 13.57.10
BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

BR0699I Reading log file /oracle/ERP/sapbackup/backERP.log ...

BR0730W No appropriate backup created since 2008-04-23 00.00.00 found in /oracle
/ERP/sapbackup/backERP.log
BR0417E No files found for restore/verification

BR0669I Cannot continue due to previous warnings or errors - you can go back to
repeat the last action
BR0280I BRRECOVER time stamp: 2008-05-22 13.57.31
BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:


Почему так?

Так в чем именно проблема?
BrTools не находит ни одного бэкапа, за последние 30 дней (именно столько у тебя указано в параметрах). Когда был создан бэкап, с которого хочешь восстанавливаться?

"saperp1:~ # su oraerp"

И неудивительно, что возникла =))

В этот понедельник.

И причем он не находит это в своем логе.

Бекапы нормальные, смотрю в db13 - отработали без ошибок.

А как надо?

Не видит он у тебя файла. Сам, на всякий случай проверь, есть там запись о бэкапе.
Ну, а звезда намекает тебе на su erpadm...

Запись есть, oraerp имеет доступ к файлу лога бекапов.
А под erpadm не получается

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

BR0701I BRRECOVER 7.00 (28)
BR0252E Function remove() failed for '/oracle/ERP/sapbackup/.user.pas' at locati
on global_set-5
BR0253E errno 13: Permission denied

BR0280I BRRECOVER time stamp: 2008-05-22 14.31.45
BR0700E Fatal errors occurred - terminating processing...

BR0797I Number of restored/recovered database files: 0/0
BR0798I Number of restored/applied incremental files: 0/0
BR0799I Number of restored/applied archivelog files: 0/0

BR0706I End of database recovery: vdxzanfl.log 2008-05-22 14.31.45
BR0280I BRRECOVER time stamp: 2008-05-22 14.31.45
BR0704I BRRECOVER terminated with errors

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

так скажите под каким пользователем надо восстанавливать oraerp или erpadm?

Еще "звезда" намекает обновить brtools.
Восстанавливаться под рутом.

под root'ом не видет brtools

saperp1:~ # brtools
bash: brtools: command not found

Так-с... посмотрел доку.. все-таки подходы в зависимости от оси отличаются:)

"You have to have SYSDBA privilege to let BRRECOVER connect to the database. This means that you have to log on as ora<sid> (UNIX) or <sid>adm (Windows)."

Так что начал ты правильно.
Покажи файл /oracle/ERP/sapbackup/backERP.log

online tape a----d 7.00 (28)
bdxwlfsn ant 2008-05-08 22.00.45 2008-05-08 22.32.54 0 ............... 4
4 43 0 2571 29788816 2572 29818130 ALL
online tape a----d 7.00 (28)
bdxwvbiv ant 2008-05-10 22.00.49 2008-05-10 22.00.51 5 ............... 4
4 0 0 2577 29984816 0 0 ALL
online tape a----d 7.00 (28)
bdxwwmqc dbv 2008-05-11 05.00.50 2008-05-11 05.18.25 1 ............... 4
4 43 0 2578 30015715 0 0 ALL
online null ----dg 7.00 (28)
bdxxheep ant 2008-05-13 09.07.59 2008-05-13 09.40.21 0 ............... 4
4 43 0 2715 31389556 2717 31404554 ALL
online tape a----d 7.00 (28)
bdxxiasu ant 2008-05-13 13.22.00 2008-05-13 13.22.06 5 ............... 4
4 0 0 2825 32212984 0 0 ALL
online tape a----d 7.00 (28)
bdxxibbz ant 2008-05-13 13.25.59 2008-05-13 13.59.06 0 ............... 4
4 43 0 2825 32212984 2832 32241162 ALL
online tape a----d 7.00 (28)
bdxxjusf ant 2008-05-13 22.00.01 2008-05-13 22.48.07 5 ............... 4
4 43 0 2902 32621628 2904 32798746 ALL
online tape a----d 7.00 (28)
bdxxmgle ant 2008-05-14 09.58.02 2008-05-14 10.31.07 0 ............... 4
4 43 0 2905 32827104 2906 32830201 ALL
online tape a----d 7.00 (28)
bdxxosnj ant 2008-05-14 22.00.03 2008-05-14 22.32.57 0 ............... 4
4 43 0 3254 34713855 3255 34869361 ALL
online tape a----d 7.00 (28)
bdxxtqin ant 2008-05-15 22.00.05 2008-05-15 22.32.39 0 ............... 4
4 43 0 3302 35183963 3303 35331449 ALL
online tape a----d 7.00 (28)
bdxydmah ant 2008-05-17 22.00.47 2008-05-17 22.00.50 5 ............... 4
4 0 0 3309 35561976 0 0 ALL
online tape a----d 7.00 (28)
bdxyexho dbv 2008-05-18 05.00.48 2008-05-18 05.17.50 1 ............... 4
4 43 0 3310 35594540 0 0 ALL
online null ----dg 7.00 (28)
bdxynhqp ant 2008-05-19 22.00.51 2008-05-19 22.25.50 0 ............... 4
4 43 0 3316 35720274 3317 35753787 ALL
online tape a----d 7.00 (28)
bdxysfkq ant 2008-05-20 22.00.24 2008-05-20 22.00.47 5 ............... 4
4 0 0 3436 36754542 0 0 ALL
online tape a----d 7.00 (28)
bdxyvxmo ant 2008-05-21 16.02.50 2008-05-21 16.26.58 0 ............... 4
4 43 0 3461 37033427 3462 37064096 ALL
online tape a----d 7.00 (28)
bdxzafzu dbv 2008-05-22 13.10.26 2008-05-22 13.24.29 1 ............... 4
4 43 0 3467 37133002 0 0 ALL
online null ----dg 7.00 (28)

Сделал update BRTOOLS 7.10 (9)

Не помогло.

На сколько я понимаю, на последнем экране выбора в brtools необходимо нажать цифру "1" и выбрать бэкап, из которого Вы хотите восстановить. Вместо этого Вы нажимаете "c"...

Whole database reset main menu

1 = Select database backup or restore point
2 * Check the status of database files
3 * Restore control files and redolog files
4 * Restore data files
5 * Restore and apply incremental backup
6 * Apply archivelog files
7 * Restore archivelog files and flashback
8 * Open database and post-processing
9 * Exit program
10 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
1
BR0280I BRRECOVER time stamp: 2008-05-22 18.13.43
BR0663I Your choice: '1'

BR0699I Reading log file /oracle/ERP/sapbackup/backERP.log ...

BR0730W No appropriate backup created since 2008-04-23 00.00.00 found in /oracle
/ERP/sapbackup/backERP.log
BR0417E No files found for restore/verification

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

BR0280I BRRECOVER time stamp: 2008-05-22 18.13.43
BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:


Результат тотже.

У тебя бэкапы - онлайн. Выбирай другой тип восстановления.