Online Backup Restoration

[Former Member]

Hi Guru's,

We are trying to plan for disaster recovery.

we are taking online backup of our SAP system through DB13.

For backup we are using Tivoli server.

We had run ./sapinst - System Copy-Oracle-Target System Instalation-High-Availability System-Based on AS-ABAP-Database Instance

We had reached to step Restore Backup

we restore backup through Tivoli (backfm -p)

but database is not getting started:

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/oracle/ECB/sapdata1/system_1/system.data1'

SQL> recover datafile '/oracle/ECB/sapdata1/system_1/system.data1';

ORA-00283: recovery session canceled due to errors

ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

SQL> recover database using backup controlfile;

ORA-00279: change 476704640 generated at 05/29/2010 15:46:57 needed for thread

1

ORA-00289: suggestion : /oracle/ECB/oraarch/ECBarch1_1_720287205.dbf

ORA-00280: change 476704640 for thread 1 is in sequence #1

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

Any body have any idea.

regards,

Aasmi

[Former Member]

Hi,

When you restore the database backup using "backfm" you need to recover the database.

So please follow the below procedure. (It would be better if you can restore the backup once again to avoid any issues in recovery, because your datafiles headers may have been changed...)

1. Restore database backup and archive logs.

2. Start Listener and Start the database in "mount' mode.

connect / as sysdba
SQL>startup mount;

3. Recover the database.

SQL>recover database using backup controlfile until cancle;

4. It may ask for datafile recovery, so give the path of datafile and proceed.

5. If you don't have required archive log, then cancle recovery at that point.

6. then open database with resetlogs option.

SQL>alter database open resetlogs;

It will show "database opened".

Then go ahead with further...

Regards.

Rajesh Narkhede

[Former Member]

All the steps which u have suggested above we already finished with that.

Actually what happening is after restoring db we are able to start the database.

afetr that we are continuing with SAPINST there the system gives this error.

What can we do?

[former_member204746]

afetr that we are continuing with SAPINST there the system gives this error.

What can we do?

Sorry, My crystal ball was shattered when it fell of my desk. You will have to wait 1 week until my replacement crystal ball comes in after ordering it from eBay. I will be able to answer in about a week.

[Former Member]

If You dont want to give answer then why are u wasting both of us time.

[former_member227600]

Aasmi,

If you will not provide the error log how we can suggest any solution. We do not have access of you system. This is Eric wanted to say. Please paste error logs here.

[Former Member]

Hi Ashmi,

Erric is right...

Whenever you post questions, always try to give more details (logs) as much as possible. So others will have clear idea whats going wrong...

It will also help to save your and others time...

Anyway, first post the sapinst error logs.

Meanwhile try one thing...

1. Stop the database and keep listener running...

2. Create the text file as "control.sql" with below contents and put it in Temporary Installation Directory...

startup
exit

Then retry the installation...

It should work...

Regards.

Rajesh Narkhede

[former_member204746]

Aasmi,

sorry if you did not get my humorous post.

you just told us you had an error and did not tell us which.

anyways, I re-read your topic and you said that you restored with backfm... why have you not used brrestore or brrecover instead? This would make sure that you restore all the files correctly.

[Former Member]

Hi,

We had resolved the error & continue with sapinst.

At step Perform Post load Activities - creating temporary license for SAP System system is giving error.

BBLECCECB:ecbadm 8> R3trans -d

This is R3trans version 6.14 (release 700 - 24.04.08 - 14:09:00).

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'ECB'"

R3trans finished (0012).

BBLECCECB:ecbadm 9> saplicense -show

• SAPLICENSE (Release 700) ERROR ***

ERROR: Connect to database failed

DETAILS: DbSlConnect failed with return code 99

SQL-ERROR 1034 (check DB manual for explanation)

Kindly help

[former_member204746]

post contents from file trans.log

Oracle might be down, or the Oracle listener might not be started.

[Former Member]

Hi,

Our database & listner is already running.

Below is the trans.log file

4 ETW000 R3trans version 6.14 (release 700 - 24.04.08 - 14:09:00).

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 08.06.2010 - 13:38:18

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Tue Jun 8 13:38:18 2010 67 0.000067

4 ETW000 [dev trc ,00000] db_con_init called 9 0.000076

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 23 0.000099

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/ECB/SYS/exe/run/dboraslib.o' ...

4 ETW000 27 0.000126

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/ECB/SYS/exe/run/dboraslib.o), hdl 0

4 ETW000 6028 0.006154

4 ETW000 [dev trc ,00000] Library '/usr/sap/ECB/SYS/exe/run/dboraslib.o' loaded

4 ETW000 14 0.006168

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/ECB/SYS/exe/run/dboraslib.o

4 ETW000 15 0.006183

4 ETW000 [dev trc ,00000] Version of '/usr/sap/ECB/SYS/exe/run/dboraslib.o' is "700.08", patchlevel (0.158)

4 ETW000 344 0.006527

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/ECB/SYS/exe/run/dboraslib.o

4 ETW000 13 0.006540

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/ECB/SYS/exe/run/dboraslib.o

4 ETW000 34 0.006574

4 ETW000 [dev trc ,00000] New connection 0 created 14 0.006588

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 16 0.006604

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 24 0.006628

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 13 0.006641

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 13 0.006654

4 ETW000 [dev trc ,00000] Got LIBPATH=/usr/lib:/lib:/usr/sap/ECB/SYS/exe/run:/oracle/client/10x_64/instantclient from environment

4 ETW000 256 0.006910

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 39 0.006949

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 10 0.006959

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 1832 0.008791

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 12 0.008803

4 ETW000 [dev trc ,00000] Connecting as /@ECB on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

4 ETW000 12 0.008815

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 13 0.008828

4 ETW000 [dev trc ,00000] 0 UTF8 1 1109ba3c0 1109d2838 1109d20e8

4 ETW000 25 0.008853

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 9 0.008862

4 ETW000 [dev trc ,00000] Allocating server context handle 9 0.008871

4 ETW000 [dev trc ,00000] Attaching to DB Server ECB (con_hdl=0,svchp=1109c2d98,srvhp=1109d4b58)

4 ETW000 45 0.008916

4 ETW000 [dev trc ,00000] Tue Jun 8 13:38:19 2010 40488 0.049404

4 ETW000 [dev trc ,00000] Assigning server context 1109d4b58 to service context 1109c2d98

4 ETW000 19 0.049423

4 ETW000 [dev trc ,00000] Allocating user session handle 26 0.049449

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=1109c2d98,srvhp=1109d4b58,usrhp=1109c21a0)

4 ETW000 25 0.049474

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1034

4 ETW000 6800 0.056274

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=1109d4b58)

4 ETW000 12 0.056286

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=1109c2d98,srvhp=1109d4b58)

4 ETW000 13 0.056299

4 ETW000 [dev trc ,00000] Deallocating server context handle 1109d4b58 1848 0.058147

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1034'

4 ETW000 20 0.058167

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1034 7 0.058174

4 ETW000 [dev trc ,00000] Try to connect with default password 10 0.058184

4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@ECB on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

4 ETW000 13 0.058197

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 13 0.058210

4 ETW000 [dev trc ,00000] 0 UTF8 1 1109ba3c0 1109d2838 1109d20e8

4 ETW000 13 0.058223

4 ETW000 [dev trc ,00000] Allocating server context handle 9 0.058232

4 ETW000 [dev trc ,00000] Attaching to DB Server ECB (con_hdl=0,svchp=1109c2d98,srvhp=1109d4b58)

4 ETW000 18 0.058250

4 ETW000 [dev trc ,00000] Assigning server context 1109d4b58 to service context 1109c2d98

4 ETW000 36714 0.094964

4 ETW000 [dev trc ,00000] Assigning username to user session 1109c21a0 11 0.094975

4 ETW000 [dev trc ,00000] Assigning password to user session 1109c21a0 10 0.094985

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=1109c2d98,srvhp=1109d4b58,usrhp=1109c21a0)

4 ETW000 13 0.094998

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1034

4 ETW000 3429 0.098427

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=1109d4b58)

4 ETW000 12 0.098439

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=1109c2d98,srvhp=1109d4b58)

4 ETW000 25 0.098464

4 ETW000 [dev trc ,00000] Deallocating server context handle 1109d4b58 1802 0.100266

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1034'

4 ETW000 18 0.100284

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1034 8 0.100292

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 1034 performing CON [dblink#5 @ 431]

4 ETW000 41 0.100333

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01034: ORACLE not available 10 0.100343

4 ETW000 ORA-27101: shared memory realm does not exist

4 ETW000 IBM AIX RISC System/6000 Error: 2: No such file or directory [dblink#5 @ 431]

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'ECB'"

[Former Member]

Hi Ashmi,

ERROR => OCI-call 'OCISessionBegin' failed with rc=1034

It's clearly indicating either LISTENER is down or Database is not up.

Make sure that below enviroment variables are configured for ORA<SID> user.

ORACLE_SID=ECB
ORACLE_HOME=/oracle/ECB/102_64

Then stop and start the LISTENER and Also stop and start database at OS level.

Then retry the installation...

Hope, this will help you.

Regards.

Rajesh Narkhede