Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

rman question

SOLVED
Go to solution
file system
Frequent Advisor

rman question

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,...'?

5 REPLIES
Peter Godron
Honored Contributor

Re: rman question

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
Honored Contributor

Re: rman question

Hi,

How many rows exists in sys.dual?

Best Regards,

Eric
Each and every day is a good day to learn.
Yogeeraj_1
Honored Contributor
Solution

Re: rman question

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)

Re: rman question

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

Rgds
Subodh
file system
Frequent Advisor

Re: rman question

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...