BRTOOLS - Recreate database > Create new database fails URGENT HELP

[former_member204618]

Hi All,

I'm following sap note 748434 to recreate SYSTEM tablespace but when I've got to step 4 Create new database it errors :-

Recreate database main menu


 1 + Specify new database options
 2 + Export user tablespaces
 3 + Export global objects
 4 = Create new database
 5 * Import global objects
 6 * Import user tablespaces
 7 * Exit program
 8 - Reset program status


Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
4
BR0280I BRSPACE time stamp: 2014-03-13 15.26.00
BR0663I Your choice: '4'


BR0613I Database instance BWD is shut down
BR0618I Database instance BWD will be started now


BR0280I BRSPACE time stamp: 2014-03-13 15.26.00
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRSPACE time stamp: 2014-03-13 15.26.04
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...


BR0280I BRSPACE time stamp: 2014-03-13 15.26.04
BR0619I Starting database instance BWD ...


BR0280I BRSPACE time stamp: 2014-03-13 15.26.06
BR0620I Start of database instance BWD successful


BR0490I Database file /oracle/BWD/sapdata1/system_1/system.data1 (and its subdirectory or link if applicable) will be deleted now
BR0490I Database file /oracle/BWD/origlogA/log_g11m1.dbf (and its subdirectory or link if applicable) will be deleted now
BR0490I Database file /oracle/BWD/mirrlogA/log_g11m2.dbf (and its subdirectory or link if applicable) will be deleted now
BR0490I Database file /oracle/BWD/origlogB/log_g12m1.dbf (and its subdirectory or link if applicable) will be deleted now
BR0490I Database file /oracle/BWD/mirrlogB/log_g12m2.dbf (and its subdirectory or link if applicable) will be deleted now
BR0490I Database file /oracle/BWD/origlogA/log_g13m1.dbf (and its subdirectory or link if applicable) will be deleted now
BR0490I Database file /oracle/BWD/mirrlogA/log_g13m2.dbf (and its subdirectory or link if applicable) will be deleted now
BR0490I Database file /oracle/BWD/origlogB/log_g14m1.dbf (and its subdirectory or link if applicable) will be deleted now
BR0490I Database file /oracle/BWD/mirrlogB/log_g14m2.dbf (and its subdirectory or link if applicable) will be deleted now
BR0490I Database file /oracle/BWD/origlogA/cntrl/cntrlBWD.dbf (and its subdirectory or link if applicable) will be deleted now
BR0490I Database file /oracle/BWD/sapdata1/cntrl/cntrlBWD.dbf (and its subdirectory or link if applicable) will be deleted now
BR0490I Database file /oracle/BWD/saparch/cntrl/cntrlBWD.dbf (and its subdirectory or link if applicable) will be deleted now


BR0280I BRSPACE time stamp: 2014-03-13 15.26.06
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRSPACE time stamp: 2014-03-13 15.27.22
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...


BR0280I BRSPACE time stamp: 2014-03-13 15.27.22
BR0792I Database files can be saved before deletion
BR0675I Do you want to perform this action?


BR0280I BRSPACE time stamp: 2014-03-13 15.27.22
BR0676I Enter 'y[es]' to perform the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort:
c
BR0280I BRSPACE time stamp: 2014-03-13 15.27.28
BR0257I Your reply: 'c'
BR0678I The action will be skipped...
BR0259I Program execution will be continued...
BR0794I Database file /oracle/BWD/sapdata1/system_1/system.data1 deleted
BR0480I Directory /oracle/BWD/sapdata1/system_1 deleted
BR0794I Database file /oracle/BWD/origlogA/log_g11m1.dbf deleted
BR0794I Database file /oracle/BWD/mirrlogA/log_g11m2.dbf deleted
BR0794I Database file /oracle/BWD/origlogB/log_g12m1.dbf deleted
BR0794I Database file /oracle/BWD/mirrlogB/log_g12m2.dbf deleted
BR0794I Database file /oracle/BWD/origlogA/log_g13m1.dbf deleted
BR0794I Database file /oracle/BWD/mirrlogA/log_g13m2.dbf deleted
BR0794I Database file /oracle/BWD/origlogB/log_g14m1.dbf deleted
BR0794I Database file /oracle/BWD/mirrlogB/log_g14m2.dbf deleted
BR0794I Database file /oracle/BWD/origlogA/cntrl/cntrlBWD.dbf deleted
BR0794I Database file /oracle/BWD/sapdata1/cntrl/cntrlBWD.dbf deleted
BR0794I Database file /oracle/BWD/saparch/cntrl/cntrlBWD.dbf deleted


BR0280I BRSPACE time stamp: 2014-03-13 15.27.28
BR0491I Subdirectory or link for database file /oracle/BWD/sapdata1/system_1/system.data1 and will be recreated now if needed
BR0491I Subdirectory or link for database file /oracle/BWD/sapdata1/sysaux_1/sysaux.data1 and will be recreated now if needed
BR0491I Subdirectory or link for database file /oracle/BWD/sapdata1/temp_1/temp.data1 and will be recreated now if needed
BR0491I Subdirectory or link for database file /oracle/BWD/sapdata4/undo_1/undo.data1 and will be recreated now if needed


BR0280I BRSPACE time stamp: 2014-03-13 15.27.28
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRSPACE time stamp: 2014-03-13 15.27.30
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0370I Directory /oracle/BWD/sapdata1/system_1 created


BR0280I BRSPACE time stamp: 2014-03-13 15.27.30
BR1273I SQLPLUS will be started for execution of SQL script /oracle/BWD/sapreorg/senkbgrd/dbcrt.sql


BR0280I BRSPACE time stamp: 2014-03-13 15.27.30
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRSPACE time stamp: 2014-03-13 15.27.43
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...


BR0280I BRSPACE time stamp: 2014-03-13 15.27.43
BR0278I Command output of '/oracle/BWD/102_64/bin/sqlplus /nolog < /oracle/BWD/sapreorg/.senkbgrd.spi':


SQL*Plus: Release 10.2.0.4.0 - Production on Thu Mar 13 15:27:43 2014
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
SQL> SQL> SQL> Connected.
SQL>
SQL> CREATE DATABASE BWD
*
ERROR at line 1:
BR0278E Command output of '/oracle/BWD/102_64/bin/sqlplus /nolog < /oracle/BWD/sapreorg/.senkbgrd.spi':
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options


BR0280I BRSPACE time stamp: 2014-03-13 15.28.32
BR1274I Execution of SQL script /oracle/BWD/sapreorg/senkbgrd/dbcrt.sql completed


BR1277W SQLPLUS reported warnings or errors during the execution of SQL script /oracle/BWD/sapreorg/senkbgrd/dbcrt.sql


BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action


BR0280I BRSPACE time stamp: 2014-03-13 15.28.32
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

The file it refers to Command output of '/oracle/BWD/102_64/bin/sqlplus /nolog < /oracle/BWD/sapreorg/.senkbgrd.spi': contains this :- 

cat /oracle/BWD/sapreorg/.senkbgrd.spi
set linesize 250;
set pagesize 1000;
@/oracle/BWD/sapreorg/.senkbgrd.spu
host /usr/sap/BWD/SYS/exe/run/brtools -f delete /oracle/BWD/sapreorg/.senkbgrd.spu;
@/oracle/BWD/sapreorg/senkbgrd/dbcrt.sql
exit;

But the file it tries to run first @/oracle/BWD/sapreorg/.senkbgrd.spu doesn't exist at runtime it seems!

Anyone offer any help urgently as this system is now dead!

Thanks

Craig

[former_member188883 · Accepted solution]

Hi Craig,

Can you retry with steps in sap help

Recreating a Database with BR*Tools (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Incase of errors please share details from alert_SID.log

Hope this helps.

Regards,

Deepak Kori

[former_member204618 · Accepted solution]

Hi again Deepak, there is no alert_SID.log file!

Should there be some other file?

I noticed that when it tries to run the CREATE DATABASE statement it doesn't connect as sysdba!  Presumably this is the cause maybe?

Unfortunately the script that is run is automatically generated so I can't alter it.

Any suggestions?

Thanks

Craig

[ACE-SAP · Accepted solution]

Hello

Alert log for your DB will be called alert_BWD.log... the path is defined in Oracle parameter background_dump_dest (show parameter background_dump_dest)

Watch out the DB version you are using is out of support... only version 10.2.0.5 is still supported.

Regards

[Former Member · Accepted solution]

you can find the alert log in /oracle/<SID>/saptrace/background/alert_<SID>/.log

/oracle/BWD/saptrace/background/alert_BWD.log

[former_member204618 · Accepted solution]

Apologies, I resolved this myself.  Was not obvious and no error logs indicated what the problem was.

Turns out that the initial configuration of tablespace data files was incorrect.  Even though it matched the correct size it tried creating them as 1 file and subsequently ran out of file system space.

After realising this I changed the values and adjusted the tablespaces post creation.

Thanks anyway.

Cheers

Craig