rman question

[file system]

Hi experts.

when i started rman and begin backup but there is a error so, terminated.

can You guess why the error dose generate?

oracle version is SQL*Plus: Release 9.2.0.1.0 - Production on Fri Feb 23 17:59:51 2007

and
I issued a command like this

$ rman target backup_admin/backup_admin

Recovery Manager: Release 9.2.0.1.0 - 64bit Production

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

connected to target database: CHULHA (DBID=1490410073)

RMAN> show all;

using target database controlfile instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 1;
CONFIGURE DEVICE TYPE DISK PARALLELISM 4;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/data5/backup/ora_df%t_s%s_s%p';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/app/oracle/product/9.2.0/dbs/snapcf_chulha.f'; # default

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO DISK;

new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters are successfully stored
RMAN> backup database;

Starting backup at 23-FEB-07
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 02/23/2007 18:02:04
RMAN-06171: not connected to target database

RMAN> connect target

connected to target database: CHULHA (DBID=1490410073)

RMAN> backup database;

Starting backup at 23-FEB-07
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=12 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=9 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=13 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=14 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00020 name=/data2/oradata/chulha/ts_maro_pat01.dbf
input datafile fno=00028 name=/data4/oradata/chulha/ts_idx_wo_real_price01.dbf
input datafile fno=00011 name=/data1/oradata/chulha/ts_maro_etc01.dbf
input datafile fno=00024 name=/data3/oradata/chulha/ts_maro_wo_real_price01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/23/2007 18:02:22
ORA-01422: exact fetch returns more than requested number of rows

RMAN>

what does it mean that 'exact fetch returns more,...'?

[Peter Godron]

Hi,
the details for the error message:
ORA-01422 exact fetch returns more than requested number of rows

Cause: The number specified in exact fetch is less than the rows returned.

Action: Rewrite the query or change number of rows requested.

Check the number of record you receive from your query. Check the rec ord count on dual.

Please also read:
http://forums1.itrc.hp.com/service/forums/helptips.do?#33 on how to reward any useful answers given to your questions.

[Eric Antunes]

Hi,

How many rows exists in sys.dual?

Best Regards,

Eric

[Yogeeraj_1 · Accepted solution]

hi,

According to Oracle Metalink, there must be a problem with your DUAL table.

When you have multiple rows in the Dual Table , this problem can occur. Try to run the command below and see what it gives:
e.g.
SQL> select count(*) from dual;

COUNT(*)
----------
2


Normally, a "Select count(*) from dual" should return only a single record.

To fix the problem, please do the following:

1. Delete the extra rows from the dual table:
Delete from dual where rownum > 0;

2. commit

3. Confirm there is only one row in DUAL, record should look like:
SQL> select * from dual;
D
-
X

4. Run the backup again , which will run smoothly

hope this helps!

kind regards
yogeeraj

[Subodh deshpande_1]

why dont you run this backup in the run block. may be it may help.

Rgds
Subodh

[file system]

Thank you for all your reply.
I'm going to select 'Yoggeerai' reply.
as you give solution, it would run rman backup without error like 'RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/23/2007 18:02:22
ORA-01422: exact fetch returns more than requested number of rows'

Thank you again.
And other helps are good for me.

but I will ask 'Peter Godron' reply..
Was I not pointed any tips you give?
can you tell me where the thread is?

I will give you point according to solving my problems...