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> run {
2> shutdown immediate;
3> startup mount;
4> backup database;
5> sql 'alter database open';
6> }
using target database controlfile instead of recovery catalog
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 06-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 06-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 06-MAY-08
channel ORA_DISK_1: finished piece 1 at 06-MAY-08
piece handle=/rmanbackup/MLQA/backup_db_MLQA_S_78_P_1_T_654004418 comment=NONE
channel ORA_DISK_1: starting piece 2 at 06-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/06/2008 11:55:
58
ORA-19502: write error on file "/rmanbackup/MLQA/backup_db_MLQA_S_78_P_2_T_65400
4418", blockno 27393 (blocksize=8192)
ORA-27063: skgfospo: number of bytes read/written is incorrect
Additional information: 1024000
Additional information: 1048576
RMAN>
From the previous qoutes:
653481
I did another backup and it failed again
what do i do next?
The above is the output of the error.
This is the configuration below;
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/rmanbackup/MLQ
A/%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'; # def
ault
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 05/06/2008 12:04:23
RMAN-20021: database not set
RMAN-06031: could not translate database keyword
RMAN>