Home » RDBMS Server » Backup & Recovery » rman backup in cif mount point (oracle 9i, AIX 5.3.0.0)
rman backup in cif mount point [message #393010] Fri, 20 March 2009 00:31 Go to next message
juniordba
Messages: 12
Registered: February 2009
Location: malaysia
Junior Member
Hi,

I am trying to perform rman backup using cifs mounted from window 2003(NAS) to AIX unix share folder, the backup failed with the below error. I have ample of space in that file system and full permission to oracle.


10.200.215.46:PPRCCONL 2048.00 1077.56 48% 0 0% /testing

# ls -ld /testing
drwxrwxrwx 1 oracle dba 16384 Jan 01 1970 /testing

/home/oracle ## ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 32768
memory(kbytes) 32768
coredump(blocks) 2097151
nofiles(descriptors) 2000

format used to mount : /home/oracle$ mount -v cifs -n 10.200.215.46/dummy/dummy123 -o uid=202,gid=201,fmode=777 PPRCCONL /testing


Error :
/testing/DAM/script ## rman target /

Recovery Manager: Release 9.2.0.7.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: DAM (DBID=1410433904)

RMAN> run {
2> shutdown immediate;
3> startup force;
4> shutdown immediate;
5> startup mount;
6> allocate channel ch1 type disk format '/testing/DAM/script/coldbkp/%d_COLD_BKP_%T_%u_%s_%p';
7> backup database include current controlfile tag = 'DAM_cold_backup';
8> release channel ch1;
9> alter database open;
10> sql 'ALTER DATABASE BACKUP CONTROLFILE TO TRACE';
11> copy current controlfile to '/testing/DAM/script/coldbkp/cold_ctl.ctl';
12> }

using target database controlfile instead of recovery catalog
database closed
database dismounted
Oracle instance shut down

Oracle instance started
database mounted
database opened

Total System Global Area 248809176 bytes

Fixed Size 743128 bytes
Variable Size 197132288 bytes
Database Buffers 50331648 bytes
Redo Buffers 602112 bytes

database closed
database dismounted
Oracle instance shut down

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area 248809176 bytes

Fixed Size 743128 bytes
Variable Size 197132288 bytes
Database Buffers 50331648 bytes
Redo Buffers 602112 bytes

allocated channel: ch1
channel ch1: sid=10 devtype=DISK

Starting backup at 20-MAR-09
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
including current controlfile in backupset
input datafile fno=00005 name=/disc10/CW/amdata/I1T02_01.dbf
input datafile fno=00060 name=/disc10/CW/amdata/T1T01_01.dbf
input datafile fno=00054 name=/disc10/CW/amdata/S2X01_01.dbf
input datafile fno=00049 name=/disc10/CW/amdata/S2T02_01.dbf
input datafile fno=00017 name=/disc10/CW/amdata/M1T04_01.dbf
input datafile fno=00031 name=/disc10/CW/amdata/P4X01_01.dbf
input datafile fno=00001 name=/disc10/CW/amdata/systemAM01.dbf
input datafile fno=00010 name=/disc10/CW/amdata/I1X02_01.dbf
input datafile fno=00064 name=/disc10/CW/amdata/V1T01_01.dbf
input datafile fno=00015 name=/disc10/CW/amdata/M1T02_01.dbf
input datafile fno=00050 name=/disc10/CW/amdata/S2T03_01.dbf
input datafile fno=00020 name=/disc10/CW/amdata/M1X01_01.dbf
input datafile fno=00006 name=/disc10/CW/amdata/I1T03_01.dbf
input datafile fno=00016 name=/disc10/CW/amdata/M1T03_01.dbf
input datafile fno=00033 name=/disc10/CW/amdata/R1T02_01.dbf
input datafile fno=00068 name=/disc10/CW/amdata/V1T05_01.dbf
input datafile fno=00021 name=/disc10/CW/amdata/M1X02_01.dbf
input datafile fno=00030 name=/disc10/CW/amdata/P4T01_01.dbf
input datafile fno=00056 name=/disc10/CW/amdata/S2X03_01.dbf
input datafile fno=00037 name=/disc10/CW/amdata/R1X02_01.dbf
input datafile fno=00029 name=/disc10/CW/amdata/P3X01_01.dbf
input datafile fno=00022 name=/disc10/CW/amdata/M1X03_01.dbf
input datafile fno=00028 name=/disc10/CW/amdata/P3T01_01.dbf
input datafile fno=00036 name=/disc10/CW/amdata/R1X01_01.dbf
input datafile fno=00042 name=/disc10/CW/amdata/S1T03_01.dbf
input datafile fno=00045 name=/disc10/CW/amdata/S1X02_01.dbf
input datafile fno=00047 name=/disc10/CW/amdata/S1X04_01.dbf
input datafile fno=00053 name=/disc10/CW/amdata/S2T06_01.dbf
input datafile fno=00059 name=/disc10/CW/amdata/S2X06_01.dbf
input datafile fno=00081 name=/disc10/CW/amdata/P1T01_01.dbf
input datafile fno=00008 name=/disc10/CW/amdata/I1T05_01.dbf
input datafile fno=00013 name=/disc10/CW/amdata/I1X05_01.dbf
input datafile fno=00019 name=/disc10/CW/amdata/M1T06_01.dbf
input datafile fno=00025 name=/disc10/CW/amdata/M1X06_01.dbf
input datafile fno=00062 name=/disc10/CW/amdata/T2T01_01.dbf
input datafile fno=00066 name=/disc10/CW/amdata/V1T03_01.dbf
input datafile fno=00070 name=/disc10/CW/amdata/V1X02_01.dbf
input datafile fno=00073 name=/disc10/CW/amdata/V1X05_01.dbf
input datafile fno=00076 name=/disc10/CW/amdata/W1X01_01.dbf
input datafile fno=00078 name=/disc10/CW/amdata/G1T01_01.dbf
channel ch1: starting piece 1 at 20-MAR-09
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch1 channel at 03/20/2009 13:25:39
ORA-19502: write error on file "/testing/DAM/script/coldbkp/DAM_COLD_BKP_20090320_1akad32h_42_1", blockno 1

(blocksize=512)
ORA-27063: skgfospo: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 14: Bad address
Additional information: -1
Additional information: 1048576



Please advice on this. thanks in advance

regards,

Re: rman backup in cif mount point [message #393208 is a reply to message #393010] Fri, 20 March 2009 14:19 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Could you post the contents of /etc/security/limit
Re: rman backup in cif mount point [message #393211 is a reply to message #393010] Fri, 20 March 2009 14:26 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>IBM AIX RISC System/6000 Error: 14: Bad address
>Additional information: -1
>Additional information: 1048576

This indicates the root cause is an OS error; not Oracle.
When was the last time this worked?
What changed?

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

Re: rman backup in cif mount point [message #393449 is a reply to message #393010] Sun, 22 March 2009 23:01 Go to previous messageGo to next message
juniordba
Messages: 12
Registered: February 2009
Location: malaysia
Junior Member
Hi Mahesh,

this is the contains of /etc/security/limits

* NOTE: A value of -1 implies "unlimited"
*

default:
fsize = -1
core = 2097151
cpu = -1
data = -1
rss = 65536
stack = 65536
nofiles = 2000

root:

daemon:

bin:

sys:

adm:

uucp:

guest:

nobody:

lpd:

oracle :
fsize = -1
core = -1
cpu = -1
data = -1
rss = -1
stack = -1
nofiles = -1

This is the first time we are trying rman backup.

He had never try taking a backup before.

Please advice..thanks in advance.

regards,
Re: rman backup in cif mount point [message #393454 is a reply to message #393010] Sun, 22 March 2009 23:21 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
touch /testing/DAM/script/coldbkp/foobar.txt
ls -l /testing/DAM/script/coldbkp/

Using CUT & PASTE issue commands above & post results.

[Updated on: Sun, 22 March 2009 23:32]

Report message to a moderator

Re: rman backup in cif mount point [message #393480 is a reply to message #393010] Mon, 23 March 2009 00:52 Go to previous messageGo to next message
juniordba
Messages: 12
Registered: February 2009
Location: malaysia
Junior Member
Hi BlackSwan,

Here is the cut paste :

/home/oracle ## touch /testing/DAM/script/coldbkp/foobar.txt

/home/oracle ## ls -l /testing/DAM/script/coldbkp
total 568
-rwxrwxrwx 1 oracle dba 0 Mar 23 13:48 foobar.txt

regards,
Re: rman backup in cif mount point [message #393599 is a reply to message #393449] Mon, 23 March 2009 09:36 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
As BlackSwan already indicated, this is something to do with OS.
I have not used AIX in recent days and nothing comes out of my head except that AIX needs the "large file" options to be turned on. If it is not turned on, give it a try.
I have seen several related bugs in metalink. Please do a search over there.
Previous Topic: sql query for RMAN catalog database to report SID and last successfull backup
Next Topic: offline backup
Goto Forum:
  


Current Time: Fri Dec 09 21:37:01 CST 2016

Total time taken to generate the page: 0.08480 seconds