всем привет!
делаю копию системы из полного офлайн бэкапа
sles11+oracle10.2.0.2+ERP6(abap)
копирование гомогенное
делаю согласно гайду и ноты 100328
произвожу всё почти также, как и описывает SergoB в ветке
http://sapboard.ru/forum/viewtopic.php?ns=1&f=14&t=73884восстановление из бэкапа произвожу командой
Code:
brrecover -t reset -b behzyutp.afd -f SEQ
далее из лога восстановления
Code:
BR1273I SQLPLUS will be started for execution of SQL script /oracle/orc/sapbackup/veialscz/control.sql
SQL> ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 3440816128 bytes
Fixed Size 2231248 bytes
Variable Size 1728054320 bytes
Database Buffers 1694498816 bytes
Redo Buffers 16031744 bytes
System altered.
File created.
ORA-01507: database not mounted
ORACLE instance shut down.
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 3440816128 bytes
Fixed Size 2231248 bytes
Variable Size 1728054320 bytes
Database Buffers 1694498816 bytes
Redo Buffers 16031744 bytes
Control file created.
Database altered.
Tablespace altered.
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
BR0280I BRRECOVER time stamp: 2012-03-05 10.15.21
BR1274I Execution of SQL script /oracle/orc/sapbackup/veialscz/control.sql completed
BR1277W SQLPLUS reported warnings or errors during the execution of SQL script /oracle/orc/sapbackup/veialscz/control.sql
BR1406W Creation of new control files failed
BR0280I BRRECOVER time stamp: 2012-03-05 10.15.55
BR0703I BRRECOVER completed successfully with warnings or non-fatal errors
во время восстановления генерится CONTROL.SQL
Code:
STARTUP NOMOUNT
ALTER SYSTEM SET DB_NAME = 'SEQ' SCOPE = SPFILE;
CREATE PFILE FROM SPFILE;
SHUTDOWN
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE SET DATABASE "SEQ" RESETLOGS ARCHIVELOG
MAXLOGFILES 255
MAXLOGMEMBERS 3
MAXDATAFILES 254
MAXINSTANCES 50
MAXLOGHISTORY 11680
LOGFILE
GROUP 1 (
'/oracle/orc/origlogA/log_g11m1.dbf',
'/oracle/orc/mirrlogA/log_g11m2.dbf'
) SIZE 50M BLOCKSIZE 512,
GROUP 2 (
'/oracle/orc/origlogB/log_g12m1.dbf',
'/oracle/orc/mirrlogB/log_g12m2.dbf'
) SIZE 50M BLOCKSIZE 512,
GROUP 3 (
'/oracle/orc/origlogA/log_g13m1.dbf',
'/oracle/orc/mirrlogA/log_g13m2.dbf'
) SIZE 50M BLOCKSIZE 512,
GROUP 4 (
'/oracle/orc/origlogB/log_g14m1.dbf',
'/oracle/orc/mirrlogB/log_g14m2.dbf'
) SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
'/oracle/orc/sapdata1/system_1/system.data1',
'/oracle/orc/sapdata1/sysaux_1/sysaux.data1',
'/oracle/orc/sapdata1/undo_1/undo.data1',
'/oracle/orc/sapdata2/sr3_1/sr3.data1',
'/oracle/orc/sapdata2/sr3_2/sr3.data2',
'/oracle/orc/sapdata2/sr3_3/sr3.data3',
'/oracle/orc/sapdata2/sr3_4/sr3.data4',
'/oracle/orc/sapdata2/sr3_5/sr3.data5',
'/oracle/orc/sapdata2/sr3_6/sr3.data6',
'/oracle/orc/sapdata2/sr3_7/sr3.data7',
'/oracle/orc/sapdata2/sr3_8/sr3.data8',
'/oracle/orc/sapdata2/sr3_9/sr3.data9',
'/oracle/orc/sapdata2/sr3_10/sr3.data10',
'/oracle/orc/sapdata2/sr3_11/sr3.data11',
'/oracle/orc/sapdata2/sr3_12/sr3.data12',
'/oracle/orc/sapdata2/sr3_13/sr3.data13',
'/oracle/orc/sapdata2/sr3_14/sr3.data14',
'/oracle/orc/sapdata2/sr3_15/sr3.data15',
'/oracle/orc/sapdata2/sr3_16/sr3.data16',
'/oracle/orc/sapdata3/sr3702_1/sr3702.data1',
'/oracle/orc/sapdata3/sr3702_2/sr3702.data2',
'/oracle/orc/sapdata3/sr3702_3/sr3702.data3',
'/oracle/orc/sapdata3/sr3702_4/sr3702.data4',
'/oracle/orc/sapdata3/sr3702_5/sr3702.data5',
'/oracle/orc/sapdata3/sr3702_6/sr3702.data6',
'/oracle/orc/sapdata3/sr3702_7/sr3702.data7',
'/oracle/orc/sapdata3/sr3702_8/sr3702.data8',
'/oracle/orc/sapdata3/sr3702_9/sr3702.data9',
'/oracle/orc/sapdata3/sr3702_10/sr3702.data10',
'/oracle/orc/sapdata3/sr3702_11/sr3702.data11',
'/oracle/orc/sapdata3/sr3702_12/sr3702.data12',
'/oracle/orc/sapdata3/sr3702_13/sr3702.data13',
'/oracle/orc/sapdata3/sr3702_14/sr3702.data14',
'/oracle/orc/sapdata4/sr3usr_1/sr3usr.data1'
CHARACTER SET UTF8
;
ALTER DATABASE OPEN RESETLOGS;
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/orc/sapdata1/temp_1/temp.data1'
SIZE 1400M REUSE AUTOEXTEND ON NEXT 20971520 MAXSIZE 10000M;
база данных вроде как восстановлена и продолжает работать sapinst
он генерит файл run_control.sql в sapinst_instdir и запускает его на выполнение
Code:
CONNECT / AS SYSDBA
SHUTDOWN ABORT
@CONTROL.SQL
SHUTDOWN IMMEDIATE
STARTUP MOUNT
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
SHUTDOWN IMMEDIATE
EXIT
после этого база уже не восстанавливается...
проблема похоже косвенно описана в ветке
http://forums.sdn.sap.com/thread.jspa?threadID=1673173можно ли как-то обмануть скрипт run_control.sql ?
(пустой control.sql я уже пробовал подклыдывать)
Вход
Регистрация
FAQ пользователя
Поиск
