Home » RDBMS Server » Backup & Recovery » Error in creating backup set.
Error in creating backup set. [message #294284] Thu, 17 January 2008 01:41 Go to next message
sushilkumarmohanty
Messages: 27
Registered: January 2008
Location: Bangalore
Junior Member
Hi all,

When I am issuing backup command following error ocours.
My target and catalog databases resides on different servers and my backup sets destinationis on catalog side.

RMAN> backup database plus archive log.

Starting backup at 17-JAN-08
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=15 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=16 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=6 recid=1 stamp=644172823
channel ORA_DISK_1: starting piece 1 at 17-JAN-08
channel ORA_DISK_2: starting archive log backupset
channel ORA_DISK_2: specifying archive log(s) in backup set
input archive log thread=1 sequence=7 recid=2 stamp=644173896
input archive log thread=1 sequence=8 recid=3 stamp=644174049
input archive log thread=1 sequence=9 recid=4 stamp=644242273
channel ORA_DISK_2: starting piece 1 at 17-JAN-08
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 01/17/2008 06:40:07
ORA-19504: failed to create file "/ora0/rman/backup/hawk/bkup_piece_c1_01j6cp9g_1_1"
ORA-27040: skgfrcre: create error, unable to create file
SVR4 Error: 2: No such file or directory



But /ora0/rman/backup/hawk/ is present.
and here are my configuration parameters.
CONFIGURE RETENTION POLICY TO REDUNDANCY 2; # default
CONFIGURE BACKUP OPTIMIZATION ON; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/ora0/rman/backup/hawk/conf_bkp_hawk_%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 2; # default
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/ora0/rman/backup/hawk/bkup_piece_c1_%U';
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/ora0/rman/backup/hawk/bkup_piece_c1_%U';
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/ora0/app/oracle/product/9.2.0/dbs/snapcf_hawk.f'; # default



Please suggest me.


Regards
Sushil
Re: Error in creating backup set. [message #294288 is a reply to message #294284] Thu, 17 January 2008 02:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
But /ora0/rman/backup/hawk/ is present.

Given your previous questions I will ask: Where? In which server?
Are you sure you have the privilege to read/write in this directory.

Post "id;groups;ls -ld /ora0/rman/backup/hawk/"

Regards
Michel

Re: Error in creating backup set. [message #294294 is a reply to message #294284] Thu, 17 January 2008 02:26 Go to previous messageGo to next message
sushilkumarmohanty
Messages: 27
Registered: January 2008
Location: Bangalore
Junior Member
Thanks Michel for your response


bash-2.03$ ls -ld /ora0/rman/backup/hawk/
drwxr-xr-x   2 oracle   dba          512 Jan 17 06:41 /ora0/rman/backup/hawk/




Regards,
Sushil
Re: Error in creating backup set. [message #294298 is a reply to message #294294] Thu, 17 January 2008 02:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And the 2 first commands? "id" and "groups"

Regards
Michel
Re: Error in creating backup set. [message #294301 is a reply to message #294284] Thu, 17 January 2008 02:52 Go to previous messageGo to next message
sushilkumarmohanty
Messages: 27
Registered: January 2008
Location: Bangalore
Junior Member


bash-2.03# id
uid=0(root) gid=1(other)
bash-2.03# groups
other root bin sys adm uucp mail tty lp nuucp daemon


regards
sushil
Re: Error in creating backup set. [message #294306 is a reply to message #294301] Thu, 17 January 2008 03:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Never use root to execute Oracle tasks.
Use oracle or a member of dba group.

Regards
Michel
Re: Error in creating backup set. [message #294307 is a reply to message #294284] Thu, 17 January 2008 03:13 Go to previous messageGo to next message
sushilkumarmohanty
Messages: 27
Registered: January 2008
Location: Bangalore
Junior Member

bash-2.03$ id
uid=101(oracle) gid=102(oinstall)

bash-2.03$ groups
oinstall dba




regards
sushil
Re: Error in creating backup set. [message #294312 is a reply to message #294307] Thu, 17 January 2008 03:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ok now retry with this user.

Regards
Michel
Re: Error in creating backup set. [message #294343 is a reply to message #294284] Thu, 17 January 2008 05:03 Go to previous messageGo to next message
sushilkumarmohanty
Messages: 27
Registered: January 2008
Location: Bangalore
Junior Member
Hi Michel,

I am getting the same error.


Regards
Sushil
Re: Error in creating backup set. [message #294358 is a reply to message #294343] Thu, 17 January 2008 05:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Copy and paste the whole session including the command you executed to start rman and id and groups ones.

Regards
Michel
Re: Error in creating backup set. [message #294369 is a reply to message #294284] Thu, 17 January 2008 06:10 Go to previous messageGo to next message
sushilkumarmohanty
Messages: 27
Registered: January 2008
Location: Bangalore
Junior Member
Hi
here are the details
login: oracle
Password :*******

export ORACLE_SID=hawk

bash-2.03$ rman catalog lman/lman target sys/sys@dolphin

Recovery Manager: Release 9.2.0.1.0 - 64bit Production

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

connected to target database: DOLPHIN (DBID=1224835204)
connected to recovery catalog database

vi show_dol.log
CONFIGURE RETENTION POLICY TO REDUNDANCY 2; # default
CONFIGURE BACKUP OPTIMIZATION ON; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/ora0/disk1/oradata/dolphin/conf_bkp_hawk_%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 2; # default
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/ora0/disk1/oradata/dolphin/bkup_piece_c1_%U';
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/ora0/disk1/oradata/dolphin/bkup_piece_c2_%U';
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
E DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/ora0/app/oracle/product/9.2.0/dbs/snapcf_hawk.f'; # default[CODE]
[/CODE]RMAN>@show_dol.log

RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
 # default
RMAN> CONFIGURE BACKUP OPTIMIZATION ON;
old RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
 # default
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO DISK;
old RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
 # default
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF;
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
 # default
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/ora0/disk1/oradata/dolphin/conf_bkp_hawk_%F';
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/ora0/disk1/oradata/dolphin/conf_bkp_hawk_%F';
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/ora0/disk1/oradata/dolphin/conf_bkp_hawk_%F';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
 # default
RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 2;
old RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 2;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 2;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
 # default
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/ora0/disk1/oradata/dolphin/bkup_piece_c1_%U';
old RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/ora0/disk1/oradata/dolphin/bkup_piece_c1_%U';
new RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/ora0/disk1/oradata/dolphin/bkup_piece_c1_%U';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/ora0/disk1/oradata/dolphin/bkup_piece_c2_%U';
old RMAN configuration parameters:
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '/ora0/disk1/oradata/dolphin/bkup_piece_c2_%U';
new RMAN configuration parameters:
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '/ora0/disk1/oradata/dolphin/bkup_piece_c2_%U';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
old RMAN configuration parameters:
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
new RMAN configuration parameters:
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
 # default
RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
old RMAN configuration parameters:
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
 # default
RMAN> CONFIGURE MAXSETSIZE TO UNLIMITED;
old RMAN configuration parameters:
CONFIGURE MAXSETSIZE TO UNLIMITED;
new RMAN configuration parameters:
CONFIGURE MAXSETSIZE TO UNLIMITED;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
 # default
RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
old RMAN configuration parameters:
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
new RMAN configuration parameters:
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
 # default
RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
old RMAN configuration parameters:
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
 # default
RMAN> CONFIGURE MAXSETSIZE TO UNLIMITED;
old RMAN configuration parameters:
CONFIGURE MAXSETSIZE TO UNLIMITED;
new RMAN configuration parameters:
CONFIGURE MAXSETSIZE TO UNLIMITED;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
 # default
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/ora0/app/oracle/product/9.2.0/dbs/snapcf_hawk.f';
snapshot controlfile name set to: /ora0/app/oracle/product/9.2.0/dbs/snapcf_hawk.f
new RMAN configuration parameters are successfully stored

RMAN> backup database plus archivelog;

Starting backup at 17-JAN-08
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=10 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=16 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=385 recid=1 stamp=644172081
input archive log thread=1 sequence=386 recid=2 stamp=644172131
input archive log thread=1 sequence=387 recid=3 stamp=644173551
input archive log thread=1 sequence=388 recid=4 stamp=644173561
input archive log thread=1 sequence=389 recid=5 stamp=644173677
input archive log thread=1 sequence=390 recid=6 stamp=644174009
input archive log thread=1 sequence=391 recid=7 stamp=644175045
channel ORA_DISK_1: starting piece 1 at 17-JAN-08
channel ORA_DISK_2: starting archive log backupset
channel ORA_DISK_2: specifying archive log(s) in backup set
input archive log thread=1 sequence=392 recid=8 stamp=644175049
input archive log thread=1 sequence=393 recid=9 stamp=644175054
input archive log thread=1 sequence=394 recid=10 stamp=644175055
input archive log thread=1 sequence=395 recid=11 stamp=644232126
input archive log thread=1 sequence=396 recid=12 stamp=644232128
input archive log thread=1 sequence=397 recid=13 stamp=644236797
input archive log thread=1 sequence=398 recid=14 stamp=644241423
input archive log thread=1 sequence=399 recid=15 stamp=644261430
channel ORA_DISK_2: starting piece 1 at 17-JAN-08
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 01/17/2008 11:23:05
ORA-19504: failed to create file "/ora0/disk1/oradata/dolphin/bkup_piece_c1_08j6d9s2_1_1"
ORA-27040: skgfrcre: create error, unable to create file
SVR4 Error: 2: No such file or directory

bash-2.03$ ls -ld /ora0/disk1/oradata/dolphin/
drwxr-xr-x   6 oracle   dba          512 Jan 16 08:16 /ora0/disk1/oradata/dolphin/
bash-2.03$ id
uid=101(oracle) gid=102(oinstall)
bash-2.03$ groups
oinstall dba


Waiting for your reply.

Regards
Sushil

[Updated on: Thu, 17 January 2008 07:05] by Moderator

Report message to a moderator

Re: Error in creating backup set. [message #294467 is a reply to message #294369] Thu, 17 January 2008 13:03 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Have you verified the privileges for the mount point and the directory itself on the remote node?
Re: Error in creating backup set. [message #294518 is a reply to message #294284] Thu, 17 January 2008 22:02 Go to previous messageGo to next message
sushilkumarmohanty
Messages: 27
Registered: January 2008
Location: Bangalore
Junior Member
Thanks for your reply.
I have changedthe backup destination directory and its working fine.
But during backup I am getting following error.


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 01/18/2008 03:12:18
ORA-19502: write error on file "/ora0/DOLPHIN_bkup_piece_c2_0hj6f1eb_1_1", blockno 28929 (blocksize=8192)
ORA-27063: skgfospo: number of bytes read/written is incorrect
Additional information: 286720
Additional information: 1048576



Please suggest me.


Regards,
Sushil
Re: Error in creating backup set. [message #294519 is a reply to message #294284] Thu, 17 January 2008 22:06 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
I have a couple of guesses.
1) The disk filled up
2) The disk had media failure
Previous Topic: Is sqlnet.ora is needed for connecting to target?
Next Topic: oracle not available
Goto Forum:
  


Current Time: Thu Dec 08 20:32:18 CST 2016

Total time taken to generate the page: 0.21192 seconds