| rman backup in cif mount point [message #393010] |
Fri, 20 March 2009 00:31  |
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 #393449 is a reply to message #393010] |
Sun, 22 March 2009 23:01  |
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 #393480 is a reply to message #393010] |
Mon, 23 March 2009 00:52 |
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 |
 |
Mahesh Rajendran
Messages: 10707
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
