Oracle OFFLINE - user backup script

[Claudio_Veronez]

Hello,

I'm trying to backup a DB offline

I'll have to archive this tapes for at least 5 years,

I have made a script to:

- Stop listener
- Stop DB
- run a files backup
- start DB
- start listener

I'm getting a long list of

could not CD to
cannot change access time
cannot open file

w/ permission denied.

I have created a BACKUP user, this user is in DBA/OINSTAL/ROOT group

I really don't know why I'm getting this message,

does anyone have done something like that before?




BPBKAR
00:25:12.114 [29285] <4> bpbkar: INF - setenv KEYWORD=NONE
00:25:12.114 [29285] <4> bpbkar: INF - setenv STREAM_PID=29285
00:25:12.114 [29285] <4> bpbkar: INF - setenv STREAM_NUMBER=0
00:25:12.114 [29285] <4> bpbkar: INF - setenv STREAM_COUNT=0
00:25:12.114 [29285] <4> bpbkar: INF - setenv STREAMS=0
00:25:12.114 [29285] <4> bpbkar: INF - setenv BPSTART_TIMEOUT=300
00:25:12.114 [29285] <4> bpbkar: INF - setenv BPEND_TIMEOUT=300
00:25:12.114 [29285] <4> bpbkar: INF - setenv RESTARTED=0
00:25:12.114 [29285] <4> bpbkar: INF - setenv BACKUPID=svsistel_1273980448
00:25:12.114 [29285] <4> bpbkar: INF - setenv UNIXBACKUPTIME=1273980448
00:25:12.115 [29285] <4> bpbkar: INF - setenv BACKUPTIME=Sun May 16 00:27:28 2010
00:25:12.115 [29285] <4> bpbkar: INF - BACKUP START
00:25:12.115 [29285] <4> bpbkar: INF - Estimate:-1 -1
00:25:12.137 [29285] <2> bpbkar add_to_filelist: starting sizeof(filelistrec) <68>
00:25:12.139 [29285] <4> bpbkar: INF - Processing /vol01
00:25:12.203 [29285] <8> bpbkar: WRN - Could not reset access time of /vol01/EXREL.class. Errno = 1: Not owner
00:25:12.204 [29285] <16> bpbkar: ERR - Cannot open file /vol01/.bash_history. Errno = 13: Permission denied
00:25:12.209 [29285] <8> bpbkar: WRN - Could not reset access time of /vol01/arquivo_corpo.txt. Errno = 1: Not owner

...

01:01:11.630 [29285] <16> bpbkar: ERR - Cannot open file /vol01/banco/app/oracle/oraInventory/logs/installActions2009-04-16_03-15-01PM.log. Errno = 13: Permission denied
01:01:11.631 [29285] <16> bpbkar: ERR - Cannot open file /vol01/banco/app/oracle/oraInventory/logs/oraInstall2009-04-16_03-15-01PM.err. Errno = 13: Permission denied
01:01:38.269 [29285] <16> bpbkar: ERR - Cannot open file /vol01/banco/app/oracle/product/10.2.0/network/install/sqlnet/setowner.sh. Errno = 13: Permission denied
01:01:44.016 [29285] <16> bpbkar: ERR - Cannot open file /vol01/banco/app/oracle/product/10.2.0/bin/emagent. Errno = 13: Permission denied
01:01:51.448 [29285] <16> bpbkar: ERR - Cannot open file /vol01/banco/app/oracle/product/10.2.0/bin/emdctl. Errno = 13: Permission denied
01:01:51.790 [29285] <16> bpbkar: ERR - Cannot open file /vol01/banco/app/oracle/product/10.2.0/bin/onsctl. Errno = 13: Permission denied
01:01:52.499 [29285] <16> bpbkar: ERR - Cannot open file /vol01/banco/app/oracle/product/10.2.0/bin/extjobo. Errno = 13: Permission denied
01:02:12.072 [29285] <16> bpbkar: ERR - Cannot open file /vol01/banco/app/oracle/product/10.2.0/inventory/Templates/opmn/conf/ons.config. Errno = 13: Permission denied

...

01:02:31.414 [29285] <8> bpbkar: WRN - Cannot cd to em. Errno = 13: Permission denied
01:02:31.415 [29285] <16> bpbkar: ERR - Cannot cd to /vol01/banco/app/oracle/product/10.2.0/oc4j/j2ee/OC4J_DBConsole_svsistel_DBSISTEL/application-deployments/em. Errno = 13: Permission denied
01:02:31.417 [29285] <8> bpbkar: WRN - Cannot cd to dms. Errno = 13: Permission denied
01:02:31.417 [29285] <16> bpbkar: ERR - Cannot cd to /vol01/banco/app/oracle/product/10.2.0/oc4j/j2ee/OC4J_DBConsole_svsistel_DBSISTEL/application-deployments/default/dms. Errno = 13: Permission denied
01:02:31.417 [29285] <8> bpbkar: WRN - Cannot cd to dms0. Errno = 13: Permission denied
01:02:31.417 [29285] <16> bpbkar: ERR - Cannot cd to /vol01/banco/app/oracle/product/10.2.0/oc4j/j2ee/OC4J_DBConsole_svsistel_DBSISTEL/application-deployments/default/dms0. Errno = 13: Permission denied



Any help please?

[Nicolai]

Seems is a simple read permission problem  in the UNIX  file system. Try to make the backup user a member of the dba group.

Cannot cd to /vol01/banco/app/oracle/product/10.2.0/oc4j/j2ee/OC4J_DBConsole_svsistel_DBSISTEL/application-deployments/em. Errno = 13: Permission denied

Remember : You need read & execute permissions for directories.

[Claudio_Veronez]

the backup user is already member off the DBA / oinstal / root group...

soooo wierd

[Jim_Horalek]

So have you tried to login as the user and manually copy the files?

[Nicolai]

If access control list (ACL) are used, they can limit the file right as well. Is this a user initiated backup - e..g  bpbackup executed from the client ?

[Claudio_Veronez]

Thanks for your help Nicolai.

but there is no ACL 

the backup user is in the same group as root / oracle / oinstal /dba

the problem is:

when I  ls -l 
there is no perm for the group, just oinstall or oracle.
I´m not sure about changing orcle bin perms.

[Nicolai]

Sound like you're Oracle installation is far away from standard. You need to talk to a DBA before changing any permissions. Remember to restart Oracle or else the new permission don't take affect.

[Claudio_Veronez]

exactely what I was thinking, but the wors problem is:

there is another 3 servers running OK .

I´ll compare them to see if there is something wrong.

Thanks a log Nicolai

[Will_Restore]

Our scripts do su - oracle which then handles the listener & db shutdown without issue

[Claudio_Veronez]

The problem is..

The person that runs it canot log as root user.

security issue, I know that backup user have greate power. but.. A client is a client

and that is the first of my problems, I´ll have to down de DB forcing and killing PTS/SESSIONS

sooo, witch user cand kill other users session?? RIGHT.. Root... imagine what is waiting for me haha