| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: oraback problem
Thanks for the thought but i have put an export in there ans an echo just to
check and it is still the same, see below. There is only one SID on this
particular box and it is most definately running...
Tom
[oracle_at_dbrestore oracle]$ oraback/oraback.sh ORACLE SID IS DCST
Creating table of contents for this backup...
Checking the status of Oracle instance DCST..
Apr 4 22:57:08 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)
"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
news:a8ikc4$62b$1_at_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:50:59 CST
 |
 |