oracle rman ora19602,RMAN-00571: | RMAN-00569: | RMAN-00571: | RMAN-03009: | ORA-19504: |

SunOS 5.8

$ rman target /

Recovery Manager: Release 9.2.0.6.0 - 64bit Production

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

connected to target database: MLQA (DBID=1439070802)

RMAN> show all;

using target database controlfile instead of recovery catalog

RMAN configuration parameters are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default

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 '/oracle/ora926/dbs/snapcf_MLQA.f'; # def

ault

RMAN> run {

2> CONFIGURE RETENTION POLICY TO REDUNDANCY 1;

3> CONFIGURE DEFAULT DEVICE TYPE TO DISK;

4> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'rmanbackup/MLQA/%F';

5> CONFIGURE DEVICE TYPE DISK PARALLELISM 2;

6> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/rmanbackup/MLQA/backup_db_%d_S_%s_P_%p_T_%t' MAXPIECESIZE 1024m;

7> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/rmanbackup/MLQA/backup_db_%d_S_%s_P_%p_T_%t' MAXPIECESIZE 1024m;

8> }

new RMAN configuration parameters:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1;

new RMAN configuration parameters are successfully stored

new RMAN configuration parameters:

CONFIGURE DEFAULT DEVICE TYPE TO DISK;

new RMAN configuration parameters are successfully stored

new RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'rmanbackup/MLQA/%F';

new RMAN configuration parameters are successfully stored

new RMAN configuration parameters:

CONFIGURE DEVICE TYPE DISK PARALLELISM 2;

new RMAN configuration parameters are successfully stored

new RMAN configuration parameters:

CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/rmanbackup/MLQA/backup_db_%d_S_%s_P_%p_T_%t' MAXPIECESIZE 1024 M;

new RMAN configuration parameters are successfully stored

new RMAN configuration parameters:

CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/rmanbackup/MLQA/backup_db_%d_S_%s_P_%p_T_%t' MAXPIECESIZE 1024 M;

new RMAN configuration parameters are successfully stored

RMAN> show all;

RMAN configuration parameters are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1;

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK;

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'rmanbackup/MLQA/%F';

CONFIGURE DEVICE TYPE DISK PARALLELISM 2;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/rmanbackup/MLQA/backup_db_%d_S_%s_P_%p_T_%t' MAXPIECESIZE 1024 M;

CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/rmanbackup/MLQA/backup_db_%d_S_%s_P_%p_T_%t' MAXPIECESIZE 1024 M;

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/ora926/dbs/snapcf_MLQA.f'; # default

RMAN> run {

2> SHUTDOWN IMMEDIATE;

3> STARTUP MOUNT;

4> BACKUP DATABASE;

5> ALTER DATABASE OPEN;

6> }

database closed

database dismounted

Oracle instance shut down

connected to target database (not started)

Oracle instance started

database mounted

Total System Global Area 840404224 bytes

Fixed Size 732416 bytes

Variable Size 301989888 bytes

Database Buffers 536870912 bytes

Redo Buffers 811008 bytes

Starting backup at 05-MAY-08

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=11 devtype=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: sid=12 devtype=DISK

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00019 name=/data1/oradata/mlqa/da_rating_01.dbf

input datafile fno=00035 name=/data2/oradata/mlqa/ind_general_02.dbf

input datafile fno=00041 name=/data2/oradata/mlqa/da_mediation_02.dbf

input datafile fno=00033 name=/data2/oradata/mlqa/ind_mediation_01.dbf

input datafile fno=00038 name=/data2/oradata/mlqa/da_usage02_02

input datafile fno=00061 name=/data4/oradata/mlqa/da_general_05.dbf

input datafile fno=00048 name=/data4/oradata/mlqa/da_usage6_02

input datafile fno=00053 name=/data4/oradata/mlqa/da_usage02_06

input datafile fno=00042 name=/data3/oradata/mlqa/da_general_04.dbf

input datafile fno=00062 name=/data3/oradata/mlqa/da_usage4_03

input datafile fno=00063 name=/data3/oradata/mlqa/da_usage05_03

input datafile fno=00037 name=/oracle/ora926/dbs/c:oracledusage

input datafile fno=00024 name=/data1/oradata/mlqa/da_general_03.dbf

input datafile fno=00022 name=/data1/oradata/mlqa/da_general_01.dbf

input datafile fno=00023 name=/data1/oradata/mlqa/da_general_02.dbf

input datafile fno=00002 name=/data1/oradata/mlqa/undotbs01.dbf

input datafile fno=00018 name=/data1/oradata/mlqa/da_usage01_01.dbf

input datafile fno=00020 name=/data1/oradata/mlqa/da_mediation_01.dbf

input datafile fno=00001 name=/data1/oradata/mlqa/system01.dbf

input datafile fno=00012 name=/data1/oradata/mlqa/df_data_01.dbf

input datafile fno=00025 name=/data1/oradata/mlqa/da_fits_01.dbf

input datafile fno=00021 name=/data1/oradata/mlqa/da_lob_01.dbf

input datafile fno=00046 name=/data1/oradata/mlqa/inf_usage02_02.dbf

input datafile fno=00008 name=/data1/oradata/mlqa/tools01.dbf

input datafile fno=00013 name=/data1/oradata/mlqa/da_usage06_01.dbf

input datafile fno=00005 name=/data1/oradata/mlqa/example01.dbf

input datafile fno=00014 name=/data1/oradata/mlqa/da_usage05_01.dbf

input datafile fno=00015 name=/data1/oradata/mlqa/da_usage04_01.dbf

input datafile fno=00016 name=/data1/oradata/mlqa/da_usage03_01.dbf

input datafile fno=00017 name=/data1/oradata/mlqa/da_usage02_01.dbf

input datafile fno=00029 name=/data1/oradata/mlqa/ind_usage03_01.dbf

input datafile fno=00030 name=/data1/oradata/mlqa/ind_usage02_01.dbf

channel ORA_DISK_1: starting piece 1 at 05-MAY-08

channel ORA_DISK_2: starting full datafile backupset

channel ORA_DISK_2: specifying datafile(s) in backupset

input datafile fno=00034 name=/data2/oradata/mlqa/ind_general_01.dbf

input datafile fno=00060 name=/data4/oradata/mlqa/ind_usage01_02

input datafile fno=00050 name=/data4/oradata/mlqa/da_usage03_02

input datafile fno=00057 name=/data4/oradata/mlqa/ind_usage5_02

input datafile fno=00043 name=/data1/oradata/mlqa/da_usage02_03.dbf

input datafile fno=00010 name=/data1/oradata/mlqa/xdb01.dbf

input datafile fno=00006 name=/data1/oradata/mlqa/indx01.dbf

input datafile fno=00009 name=/data1/oradata/mlqa/users01.dbf

input datafile fno=00003 name=/data1/oradata/mlqa/cwmlite01.dbf

input datafile fno=00004 name=/data1/oradata/mlqa/drsys01.dbf

input datafile fno=00007 name=/data1/oradata/mlqa/odm01.dbf

input datafile fno=00040 name=/data2/oradata/mlqa/da_rating_02.dbf

channel ORA_DISK_2: starting piece 1 at 05-MAY-08

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/05/2008 11:44:08

ORA-19504: failed to create file "/rmanbackup/MLQA/backup_db_MLQA_S_72_P_1_T_653917447"

ORA-27040: skgfrcre: create error, unable to create file

SVR4 Error: 13: Permission denied

RMAN> SHOW ALL;

RMAN configuration parameters are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1;

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK;

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'rmanbackup/MLQA/%F';

CONFIGURE DEVICE TYPE DISK PARALLELISM 2;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/rmanbackup/MLQA/backup_db_%d_S_%s_P_%p_T_%t' MAXPIECESIZE 1024 M;

CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/rmanbackup/MLQA/backup_db_%d_S_%s_P_%p_T_%t' MAXPIECESIZE 1024 M;

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/ora926/dbs/snapcf_MLQA.f'; # default

RMAN>

I was trying to backup my database in noarchivelog mode and got the following errors

pls any idea on what is all about.

Meanwhile I created the directory /rmanbackup/MLQA/ as a root user. does it mean that oracle user cannot write on the directory.