-
ORA-27063: skgfospo: number of bytes read/written is incorrect
hi,
I'm trying to do a hot backup to disk using RMAN and I'm keep getting following error messages. I know I have enough space on disk and I also find a not from metalink saying that I need to specify set limit channel d1 kbytes 2024800 (as an examplem) and still does not work and getting same error messages.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c0 channel at 05/25/2005 14:03:29
ORA-19502: write error on file "bk_698_1_559231200", blockno 132353
(blocksize=8192)
ORA-27063: skgfospo: number of bytes read/written is incorrect
SVR4 Error: 28: No space left on device
Additional information: -1
Additional information: 1048576
Anyone has any idea?
following is my RMAN script that I ran:
$RMAN target $TARGET_CONNECT_STR catalog rman_${ORACLE_SID%[1-9]}/rman_${ORACLE_SID%[1-9]}@rmancat msglog $RMAN_LOG_FILE append << EOF
RUN {
allocate channel c0 type disk format '/a03/app/oracle/admin/backup/';
allocate channel c1 type disk format '/a03/app/oracle/admin/backup/';
allocate channel c2 type disk format '/a03/app/oracle/admin/backup/';
allocate channel c3 type disk format '/a03/app/oracle/admin/backup/';
allocate channel c4 type disk format '/a03/app/oracle/admin/backup/';
allocate channel c5 type disk format '/a01/app/oracle/arch/backup/';
allocate channel c6 type disk format '/a01/app/oracle/arch/backup/';
allocate channel c7 type disk format '/a01/app/oracle/arch/backup/';
allocate channel c8 type disk format '/a01/app/oracle/arch/backup/';
allocate channel c9 type disk format '/a01/app/oracle/arch/backup/';
#
#
setlimit channel c0 kbytes 5194300;
setlimit channel c1 kbytes 5194300;
setlimit channel c2 kbytes 5194300;
setlimit channel c3 kbytes 5194300;
setlimit channel c4 kbytes 5194300;
setlimit channel c5 kbytes 5194300;
setlimit channel c6 kbytes 5194300;
setlimit channel c7 kbytes 5194300;
setlimit channel c8 kbytes 5194300;
setlimit channel c9 kbytes 5194300;
BACKUP
$BACKUP_TYPE
# SKIP INACCESSIBLE
TAG hot_db_bk_level0
#FILESPERSET 5
#FILESPERSET 20
setsize 20971520
# recommended format
FORMAT 'bk_%s_%p_%t'
DATABASE;
sql 'alter system archive log current';
release channel c0;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
release channel c5;
release channel c6;
release channel c7;
release channel c8;
release channel c9;
-
show me the output from:
ls-l /a03/app/oracle/admin/backup/
Jeff Hunter
-
that directory is empty. Did not generate anything.
-
Ah, I see now. I bet your bk* files are in your $ORACLE_HOME/dbs directory, right? The format you want to use is:
allocate channel c0 type disk format '/a03/app/oracle/admin/backup/bk%U';
Jeff Hunter
-
I specified file like $path/bk%U'; and still getting same error messages.
-
and yes you're right....bk_, al_, and cntrl_.. all were in $ORACLE_HOME/dbs directory.
-
OK, here's your problem. You are allocating channels, but then specifying a single format. Try:
Code:
allocate channel c0 type disk format '/a03/app/oracle/admin/backup/bk0%U';
setlimit channel c0 kbytes 2097150;
allocate channel c1 type disk format '/a03/app/oracle/admin/backup/bk1%U';
setlimit channel c1 kbytes 2097150;
allocate channel c2 type disk format '/a03/app/oracle/admin/backup/bk2%U';
setlimit channel c2 kbytes 2097150;
allocate channel c3 type disk format '/a03/app/oracle/admin/backup/bk3%U';
setlimit channel c3 kbytes 2097150;
BACKUP
$BACKUP_TYPE
TAG hot_db_bk_level0
DATABASE;
release channel c0;
release channel c1;
release channel c2;
release channel c3;
Last edited by marist89; 05-26-2005 at 01:21 PM.
Jeff Hunter
-
it works now. format was the problem. what's the query to find out SCN and time so that I can do PITTR?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|