Hi,
I am oracle 10gR2 on Solaris 5.10. I am using following script to take full backup of the database:
#!/bin/bash
ORACLE_HOME=/u01/app/oracle/product/10g
PATH=$ORACLE_HOME/bin:$PATH
ORACLE_SID=aa
export ORACLE_HOME ORACLE_SID PATH
rman target / <<EOF
run
{
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 8;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
ALLOCATE CHANNEL d1 DEVICE TYPE DISK;
ALLOCATE CHANNEL d2 DEVICE TYPE DISK;
ALLOCATE CHANNEL d3 DEVICE TYPE DISK;
ALLOCATE CHANNEL d4 DEVICE TYPE DISK;
ALLOCATE CHANNEL d5 DEVICE TYPE DISK;
ALLOCATE CHANNEL d6 DEVICE TYPE DISK;
ALLOCATE CHANNEL d7 DEVICE TYPE DISK;
ALLOCATE CHANNEL d8 DEVICE TYPE DISK;
BACKUP TAG ATHEER_FULL_DB DATABASE FORMAT '/u02/BACKUPS/WEEKLY_DB_BACKUP/backup_%d_set%s_piece%p_%T_%U';
CROSSCHECK BACKUPSET;
CROSSCHECK BACKUP;
DELETE NOPROMPT OBSOLETE;
RELEASE CHANNEL d1;
RELEASE CHANNEL d2;
RELEASE CHANNEL d3;
RELEASE CHANNEL d4;
RELEASE CHANNEL d5;
RELEASE CHANNEL d6;
RELEASE CHANNEL d7;
RELEASE CHANNEL d8;
}
EOF
I am getting following error:
Starting backup at 12-APR-10
channel d1: starting compressed full datafile backupset
channel d1: specifying datafile(s) in backupset
input datafile fno=00108 name=+MTCDATA_GRP/aa/datafile/undotbs1.368.696699605
input datafile fno=00067 name=+MTCDATA_GRP/aa/datafile/aa_rds_tapin.326.667722723
channel d7: starting piece 1 at 12-APR-10
channel d8: starting compressed full datafile backupset
channel d8: specifying datafile(s) in backupset
input datafile fno=00004 name=+MTCDATA_GRP/aa/datafile/users.264.654101503
input datafile fno=00146 name=+MTCDATA_GRP/aa/datafile/aa_tds.406.707084307
input datafile fno=00084 name=+MTCDATA_GRP/aa/datafile/aa_tds.343.695237005
input datafile fno=00075 name=+MTCDATA_GRP/aa/datafile/aa_tds.334.695040959
input datafile fno=00080 name=+MTCDATA_GRP/aa/datafile/aa_tds.339.695129765
input datafile fno=00153 name=+MTCDATA_GRP/aa/datafile/users.413.708271033
input datafile fno=00014 name=+MTCDATA_GRP/aa/datafile/aa_ads.274.654113499
input datafile fno=00130 name=+MTCDATA_GRP/aa/datafile/aa_ads.390.704194583
input datafile fno=00145 name=+MTCDATA_GRP/aa/datafile/aa_tds.405.707084139
input datafile fno=00096 name=+MTCDATA_GRP/aa/datafile/aa_ods1.355.696598533
input datafile fno=00149 name=+MTCDATA_GRP/aa/datafile/aa_tds.409.707569511
input datafile fno=00106 name=+MTCDATA_GRP/aa/datafile/undotbs1.366.696693453
input datafile fno=00117 name=+MTCDATA_GRP/aa/datafile/aatdscdrpart.377.697290949
input datafile fno=00016 name=+MTCDATA_GRP/aa/datafile/aa_olap.276.654113543
input datafile fno=00013 name=+MTCDATA_GRP/aa/datafile/aa_dds.273.654113489
input datafile fno=00035 name=+MTCDATA_GRP/aa/datafile/aa_ads_indexes.295.654113845
input datafile fno=00064 name=+MTCDATA_GRP/aa/datafile/aa_ads_tapout.323.667722723
input datafile fno=00126 name=+MTCDATA_GRP/aa/datafile/aa_ads_tapout.386.701419275
input datafile fno=00134 name=+MTCDATA_GRP/aa/datafile/aa_ads_tapout.394.704728861
input datafile fno=00055 name=+MTCDATA_GRP/aa/datafile/aa_dds.314.662492689
channel d8: starting piece 1 at 12-APR-10
RMAN-03009: failure of backup command on d1 channel at 04/12/2010 15:57:00
ORA-19505: failed to identify file "+MTCDATA_GRP/aa/datafile/undotbs1.368.696699605"
ORA-17503: ksfdopn:2 Failed to open file +MTCDATA_GRP/aa/datafile/undotbs1.368.696699605
ORA-01031: insufficient privileges
channel d1 disabled, job failed on it will be run on another channel
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on d8 channel at 04/12/2010 15:57:03
ORA-19505: failed to identify file "+MTCDATA_GRP/aa/datafile/users.264.654101503"
ORA-17503: ksfdopn:2 Failed to open file +MTCDATA_GRP/aa/datafile/users.264.654101503
ORA-01031: insufficient privileges
RMAN>
Recovery Manager complete.
In this script, instead "rman target /", I have also tried rman/password. And rman has sysdba privileges.
In my sqlnet.ora the value of sqlnet authentication parameter is set to none.
Please help.
regards
Edited by: Fahd Mirza on Apr 12, 2010 6:47 PM