- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- rman question
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-22-2007 08:03 PM
тАО02-22-2007 08:03 PM
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,...'?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-22-2007 08:20 PM
тАО02-22-2007 08:20 PM
Re: rman question
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-22-2007 09:57 PM
тАО02-22-2007 09:57 PM
Re: rman question
How many rows exists in sys.dual?
Best Regards,
Eric
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-22-2007 10:54 PM
тАО02-22-2007 10:54 PM
SolutionAccording 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-22-2007 10:56 PM
тАО02-22-2007 10:56 PM
Re: rman question
Rgds
Subodh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-25-2007 03:29 PM
тАО02-25-2007 03:29 PM
Re: rman question
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...