Re: oraback problem

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Fri, 5 Apr 2002 08:32:23 +1000
Message-ID: <a8ikc4$62b$1@lust.ihug.co.nz>
My guess is that the environment variables are not set correctly when the script is run. In particular, ORACLE_SID. The thing connects, but we don't know what it's attempting to connect to.
When you run it, it works fine... I bet you have an ORACLE_SID set in your .profile, don't you? So it;s fine for you because there's no ambiguity about what you want to connect to.
I'm not familiar with this script, though, so I don't know for certain. Can you edit it, and stick in an explicit export of ORACLE_SID?
Regards
HJR
--
-----------------------------------------------
Resources for Oracle : http://www.hjrdba.com
===============================

"Tom Brown" <tom_at_eazyriders.com> wrote in message
news:wd4r8.721$Fu.4410597_at_news-text.cableinet.net...


> sorry to seem like i'm apamming the group but here is a summary of what i

> have done so far to try and get oraback.sh working. If anyone can suggest

> anything at all that might be wrong please offer any thoughts what so ever

> or suggest possible locations for knowledge on the oraback script as the

> forums at backupcentral seem to have vanished. I'd like to thank David

> Fitzjarrell for all his advice so far.

>

> In short when i try and run the script i get an error about the SID not

> being available and the script exits. The SID is up and running and the

user


> running the script, ORACLE, can sqlplus and svrmgrl to the instance fine.

>

> If i look in my tmp logs i get this....

>

> [oracle_at_dbrestore oracle]$ more /var/tmp/7537.databaseup

>

> Oracle Server Manager Release 3.1.7.0.0 - Production

>

> Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

>

> Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production

> With the Partitioning option

> JServer Release 8.1.7.0.1 - Production

>

> SVRMGR> Connected.

> SVRMGR> select * from sys.dba_data_files

> *

> ORA-01034: ORACLE not available

> SVRMGR> Server Manager complete.

> [oracle_at_dbrestore oracle]$

>

>

> BUT if i run the select manually i get the following.....

>

>

> [oracle_at_dbrestore oracle]$ svrmgrl

>

> Oracle Server Manager Release 3.1.7.0.0 - Production

>

> Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

>

> Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production

> With the Partitioning option

> JServer Release 8.1.7.0.1 - Production

>

> SVRMGR> connect internal

> Connected.

> SVRMGR> select * from sys.dba_data_files

>      2> ;

> FILE_NAME

> FILE_ID    TABLESPACE_NAME                BYTES      BLOCKS     STATUS

> RELATIVE_F AUT MAXBYTES   MAXBLOCKS  INCREMENT_ USER_BYTES USER_BLOCK

> --------------------------------------------------------------------------

--


> ---- ---------- ------------------------------ ---------- ---------- -----

--


> -- ---------- --- ---------- ---------- ---------- ---------- ----------

> /u01/app/oracle/oradata/DCST/tools01.dbf

> 2 TOOLS                            10485760       1280 AVAILABLE

2


> YES 3.4360E+10    4194302         40   10477568       1279

> /u01/app/oracle/oradata/DCST/drsys01.dbf

> 7 DRSYS                            20971520       2560 AVAILABLE

7


> YES 3.4360E+10    4194302         80   20963328       2559

> /u01/app/oracle/oradata/DCST/users01.dbf

> 5 USERS                            20971520       2560 AVAILABLE

5


> YES 3.4360E+10    4194302        160   20963328       2559

> /u01/app/oracle/oradata/DCST/indx01.dbf

> 6 INDX                             20971520       2560 AVAILABLE

6


> YES 3.4360E+10    4194302        160   20963328       2559

> /u01/app/oracle/oradata/DCST/rbs01.dbf

> 3 RBS                              52428800       6400 AVAILABLE

3


> YES 3.4360E+10    4194302        640   52420608       6399

> /u01/app/oracle/oradata/DCST/temp01.dbf

> 4 TEMP                             20971520       2560 AVAILABLE

4


> YES 3.4360E+10    4194302         80   20963328       2559

> /u01/app/oracle/oradata/DCST/system01.dbf

> 1 SYSTEM                          283115520      34560 AVAILABLE

1


> YES 3.4360E+10    4194302       1280  283107328      34559

> /u01/app/oracle/oradata/DCST/deccablob01.dbf

> 8 DECCABLOB                       524288000      64000 AVAILABLE

8


> NO           0          0          0  523837440      63945

> /u01/app/oracle/oradata/DCST/deccablob02.dbf

> 9 DECCABLOB                       524288000      64000 AVAILABLE

9


> NO           0          0          0  523837440      63945

> /u01/app/oracle/oradata/DCST/deccablob03.dbf

> 10 DECCABLOB                       524288000      64000 AVAILABLE

10


> NO           0          0          0  523837440      63945

> /u01/app/oracle/oradata/DCST/deccablob04.dbf

> 11 DECCABLOB                       524288000      64000 AVAILABLE

11


> NO           0          0          0  523837440      63945

> /u01/app/oracle/oradata/DCST/deccablob05.dbf

> 12 DECCABLOB                       524288000      64000 AVAILABLE

12


> NO           0          0          0  523837440      63945

> /u01/app/oracle/oradata/DCST/deccablob06.dbf

> 13 DECCABLOB                       524288000      64000 AVAILABLE

13


> NO           0          0          0  523837440      63945

> /u01/app/oracle/oradata/DCST/deccadata04.dbf

> 14 DECCADATA                       148283392      18101 AVAILABLE

14


> YES 3.4360E+10    4194302          1  148119552      18081

> /u04/bmrestore/applications01.dbf

> 15 APPLICATIONS                                         AVAILABLE

15


> /u04/bmrestore/mining01.dbf

> 16 MINING                                               AVAILABLE

16


> /u04/bmrestore/mining02.dbf

> 17 MINING                                               AVAILABLE

17


> /u04/bmrestore/temp_mining01.dbf

> 18 TEMP_MINING                                          AVAILABLE

18


> /u04/bmrestore/temp_applications01.dbf

> 19 TEMP_APPLICATIONS                                    AVAILABLE

19


> 19 rows selected.

> SVRMGR> exit

> Server Manager complete.

> [oracle_at_dbrestore oracle]$

>

>

> do you have ANY odea what might be causing this? I'm totally out of luck

> debugging this one and this is getting urgent.

>

> one last thing is the output of the oraback.sh script whan run manually by

> the ORACLE user....

>

> [oracle_at_dbrestore oracle]$ oraback/oraback.sh

> ==============================================================

> Oracle database backup started on dbrestore: 10:16:55 PM 04/04/2002

> ==============================================================

>

> Creating table of contents for this backup...

>

>  Checking the status of Oracle instance DCST..

> Apr  4 22:16:55 dbrestore  oraback.sh DCST: WARNING: ORA-01034: ORACLE not

> available

>   Oracle instance DCST appears to be down...

> basename: too few arguments

> Try `basename --help' for more information.

>   Oracle instance DCST is supposed to backed up live...

>   Oracle instance DCST WILL NOT be backed up...

>  (It is down and there are no backup config files in

>  /home/oracle/backup/DCST from a previous run of oraback/oraback.sh)

> ===============================================================

> Oracle database backup ended on dbrestore: 10:16:55 PM 04/04/2002

> ===============================================================

> [oracle_at_dbrestore oracle]$

>

> .. which it is not down?

>

> hope you can help!!

>

> thanks very much

>

> Tom

>

>
Received on Thu Apr 04 2002 - 16:32:23 CST