Video Screencast Help

Oracle OFFLINE - user backup script

Created: 17 May 2010 | 9 comments

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?

Comments 9 CommentsJump to latest comment

Nicolai's picture

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.

Assumption is the mother of all mess ups.

If this post answered your'e qustion -  Please mark as a soloution.

Claudio Veronezi's picture

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

soooo wierd

Claudio Veronezi Mendes
IT Manager at Lb2 Consultoria
Londrina - Pr - Brazil
 

Jim Horalek's picture

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

Nicolai's picture

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 ?

Assumption is the mother of all mess ups.

If this post answered your'e qustion -  Please mark as a soloution.

Claudio Veronezi's picture

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.

Claudio Veronezi Mendes
IT Manager at Lb2 Consultoria
Londrina - Pr - Brazil
 

Nicolai's picture

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.

Assumption is the mother of all mess ups.

If this post answered your'e qustion -  Please mark as a soloution.

Claudio Veronezi's picture

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

Claudio Veronezi Mendes
IT Manager at Lb2 Consultoria
Londrina - Pr - Brazil
 

Will Restore's picture

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

Will Restore -- where there is a Will there is a way

Claudio Veronezi's picture

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

Claudio Veronezi Mendes
IT Manager at Lb2 Consultoria
Londrina - Pr - Brazil