Re: oraback problem

From: Tom Brown <tom_at_eazyriders.com>
Date: Thu, 04 Apr 2002 22:12:44 GMT
Message-ID: <wd4r8.721$Fu.4410597@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

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

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:12:44 CST