Backup & Recovery :: Exact Fetch Returns More Than Requested Number Of Row

Aug 24, 2011

I have perform a failover and encounters the following problem.

ORA-01422: exact fetch returns more than requested number of rows

initially primary db: chicago
physical standby db: boston

after failover

primary db:boston
physical standby: NA

after recreating physical standby

primary db:boston
physical standby: chicago

over at chicago (new standby)

log_archive_dest_3=E:chicago_arc
over at boston (new primary)
log_archive_dest_3=E:oston_arc

over at boston when I connect to both boston as target db and recovery catalog

RMAN> list archivelog like 'E:CHICAGO_ARC\%';

List of Archived Log Copies

Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
252690 1 10 A 22-AUG-11 E:CHICAGO_ARC10_759842424_1.ARC

over at chicago when I connect to both chicago as target db and recovery catalog

RMAN> list archivelog like 'E:CHICAGO_ARC\%';

List of Archived Log Copies

Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
252690 1 10 A 22-AUG-11 E:CHICAGO_ARC10_759842424_1.ARC

however at E:chicago_arc when I do a os check

C:Documents and SettingsAdministrator>dir /w E:chicago_arc

Volume in drive E is New Volume
Volume Serial Number is C874-DD6D

Directory of E:chicago_arc

[.] [..] 100_759410562_1.ARC
101_759410562_1.ARC 102_759410562_1.ARC 103_759410562_1.ARC

[Code]....

26 File(s) 9,077,989 bytes
2 Dir(s) 2,650,337,280 bytes free

there's more files than indicated by rman

also at both chicago and boston

I have the following error:

RMAN> debug on;

RMAN-03036: Debugging set to level=9, types=ALL

RMAN> report obsolete;

RMAN-06524: RMAN retention policy will be applied to the command
RMAN-06511: RMAN retention policy is set to redundancy 1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of report command at 08/24/2011 23:12:15
RMAN-06004: ORACLE error from recovery catalog database: ORA-01422: exact fetch returns more than requested number of rows

RMAN> debug off;

Debugging turned off

here's the trace files I logged

DBGRCVMAN: EXITING listBackup with exception: ORA-01422: exact fetch returns more than requested number of rows
DBGMISC: krmicomp: error 6004 signalled during compilation [23:12:15.358]
DBGMISC: ENTERED krmkmrsr [23:12:15.358]

[Code]...

How should I resolve this issue?

View 5 Replies


ADVERTISEMENT

Forms :: ORA-01422 / Exact Fetch Returns More Than Requested Number Of Rows

Aug 18, 2010

ORA-01422: exact fetch returns more than requested number of rows.

I receive this error because i tried to introduce the below coding in a post query of the block.

begin
select supplier_cd into :fin_ex_rev_head.vendor_code
from fin_ex_rev_receipts
where receipt_date
between :keyblock.receipt_date

[code].....

View 10 Replies View Related

Backup & Recovery :: OCIServerAttach Returns ORA-1034 Even If Database Is Up And Running

Oct 9, 2012

We are using OCI call library to connect to Oracle database through one application. When we try to run this application through valgrind( a memory leak detection tool for linux) then, OCIServerAttach() call is failing to connect to db and it says that "ORA-1034 :Oracle not available"," Oracle instance may be down", etc. However, our oracle instance is running and database is open. When we run our application normally ( not through the tool) then everything is working fine.

View 11 Replies View Related

Backup & Recovery :: Crosscheck - Number Of Expired Backups

Jan 4, 2012

I've done a crosscheck backup in RMAN and the list of expired objects has actually gone down, in number, from the last time I did this ( 2 weeks prior). We do NOT delete anything from our RMAN catalog on a routine basis (ie. no "DELETE EXPIRED BACKUP commands were issued) so normally the list of expired backup objects increases with each RMAN maintenance task we do. Why the number of expired objects might actually go down in this particular instance ?

View 15 Replies View Related

Recovery Manager (RMAN) :: ORA-19599 Block Number 782 Corrupt In Backup Piece

Oct 23, 2012

I'm using database 11g & restore backup from another location.

RMAN> RESTORE CONTROLFILE FROM '/u01/RMAN/forstandby_0acekubq_1_1';
RMAN> catalog start with '/u01/RMAN/';
RMAN> restore database;
channel ORA_DISK_1: reading from backup piece /u01/RMAN/forstandby_09ceku8r_1_1
channel ORA_DISK_1: ORA-19870: error while restoring backup piece /u01/RMAN/forstandby_09ceku8r_1_1
ORA-19599: block number 782 is corrupt in backup piece /u01/RMAN/forstandby_09ceku8r_1_1

failover to previous backup

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/23/2012 19:24:11
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

View 1 Replies View Related

RMAN :: Fetch Result Of Backup Into Log File After Windows Scheduler Runs Backup

Jan 8, 2013

My Rman log location is d:kp man.log, how can i fetch the result of backup into this log file after windows scheduler runs backup..

View 6 Replies View Related

Backup & Recovery :: RMAN Recovery Failing With Incremental Level 0 Backup

Feb 10, 2011

We are trying to restore a database on the different server using RAM incremental level 0 and 1 backups. We have weekly Incremental level 0 backups along with incremental backups on daily basis. During recovery of Incremental level 0 backup, RMAN is expecting/looking for Incremental Level 0 backup of prior week as well. Is this the usual process for RMAN to look for prior level 0 backup though we need to restore from the current level 0 backup and roll forward by a week with subsequent Level 1 backup.?

We intend to restore from the Level 0 of 1/16 and roll forward with daily incrementals till 1/22. RMAN is expecting level 0 backupsets from 1/9 backup as well and keep failing since those backups are not available. quick inputs since we are in middle of recovery and trying to resolve if this is even doable.

View 11 Replies View Related

Backup & Recovery :: ORA-16004 / Backup Database Requires Recovery

Oct 20, 2011

Here is the details

[oracle@localhost dbs]$ export ORACLE_SID=stby
[oracle@localhost dbs]$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Oct 20 09:47:34 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> !
[oracle@localhost dbs]$ pwd
/oraeng/app/oracle/product/10.2.0/dbs
[oracle@localhost dbs]$ exit
exit

[code].....

View 1 Replies View Related

Backup & Recovery :: RMAN Backup Deleted Even Within Recovery Window

Oct 18, 2011

I have problem on using "delete obsolete" in RMAN.

First, let describe my backup configuration.

1. Full backup every Monday (17-Oct, 10-Oct, 3-Oct, 26-Sep)
2. Incremental backup for other days
3. Enable autobackup of control file
4. Backup archive log every day
5. RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS
6. Execute "Delete obsolete" every day
7. control file is used instead of catalog

The results observed:
1. Backup of control files older than 30 days will be deleted
2. Backup of archive log files older than 30 days will be deleted.
3. Backup of datafiles older than ~14 days but before 30 days are also DELETED.

In my example, the backup of datafiles created at 26-Sep is deleted at 16-Oct.

I tried "restore database validate until time "sysdate-22"" at 17-Oct. And RMAN reported "datafile xx will be created automatically during restore operation". It seems that RMAN failed to do restoration up to 22 days ago. The retention policy I set seems not effective on datafile backups.

I checked view v$backup_set and the "Keep" is "No" and "Keep until" is empty.

The only thing I can think of, is the settings of "CONTROL_FILE_RECORD_KEEP_TIME". It is marked "7" in the Oracle, which is less than the retention. But I suppose this only causes the backup not deleted, but NOT be deleted earlier.

View 6 Replies View Related

Backup & Recovery :: SCN Based Backup Do RMAN Generate Backup From Archivelogs

Oct 18, 2012

understanding rman scn based Backup Algorithm .. In SCN based backup do rman generate backup from archivelogs ???

View 1 Replies View Related

Reports & Discoverer :: Using Parameter For Maximum Rows To Fetch To Be A Number

Dec 15, 2010

In Report it is possible to set the maximum rows to fetch to be a number e.g. 1+.Is it possible to use a number that is selected from another query? When I try to do this i.e. I put in the field num_lines or :num_lines I just get invalid number

View 10 Replies View Related

Backup & Recovery :: 2 Separate RMAN Backup One Backup Is Of Only Datafile

Jan 24, 2011

I have 2 seperate rman backup one backup is of only datafile ,spfile and controlfile which i am able to restore and recover without any problem say bkp1 taken at 10 am

other set of backup is of only archive log files of same day but later time than datafile backup say bkp2 taken at 8pm...if i restore and recover bkp1 and try to restore bkp2 it gives error datafile exist (possibly due to fact both backup have control file)

if i just restore bkp1 and try to restore bkp2 so that i can do one recover at time
it gives error datafile permission issue (possibly due to fact both backup have control file)

I want to restore database upto 8pm time how can i use both bkp1 and bkp2 to do it(restore datafiles and apply all archive logs on it)

View 17 Replies View Related

Backup & Recovery :: ORA-01139 / RESETLOGS Option Only Valid After Incomplete Database Recovery

Jan 25, 2011

SQL> alter database mount;
Database altered.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery

View 5 Replies View Related

Backup & Recovery :: RMAN Restore / Recovery To Previous Cold Backups

Aug 13, 2013

My scenario is: database is in archivelog mode.

I run DLY cold backups including controlfile & archivelogs and keep 3 gens of backups and archivelogs to 3 days also. What is the correct procedure to restore back to an old cold backup. Database is backed up Mon,Tue,Wed on Thur we require to bring database back to Tuesday DLY security.

I have tried:
startup mount
restore database from tag 'DLYTUE'
recover database

( this just rolls forward on all archive logs once it restores datafiles, not getting to point to alter database open resetlogs.)

Next tried to :

recover database archivelog tag 'DLYTUE'
( same outcome )

What is the correct rman procedure including should I remove old archive logs from working OS directory ? Also need to know once I restore back and open database to TUE security how do you tidy up the archive logs and dumps which are no longer require i.e. : weds..

I have read about using the set until time option but how to I get absolute time from when cold backup completed if this is the correct procedure.

View 9 Replies View Related

Backup & Recovery :: ORA-00265 / Instance Recovery Required - Cannot Set ARCHIVELOG Mode

May 28, 2008

I need to make my database to ARCHIVELOG mode when i try it it gives below following error

SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

View 9 Replies View Related

Backup & Recovery :: Initialization Of Internal Recovery Manager Package Failed

Sep 28, 2011

I have a database in Archivelog mode and Flashback mode. I am trying to connect to RMAN. But am getting the error

SQL> select name,log_mode,flashback_on from v$database
2 /

NAME LOG_MODE FLA
--------- ------------ ---
ORCL ARCHIVELOG YES

SQL> show user
USER is "SYS"
SQL> host rman target /
[code]....

View 16 Replies View Related

Backup & Recovery :: Cannot Update Recovery Area Reclaimable File List

Oct 18, 2012

I just switched my STBDY DB to a PRIMARY DB and I am ran the following:

RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
new RMAN configuration parameters are successfully stored
ORA-00245: control file backup operation failed

RMAN-08132: WARNING: cannot update recovery area reclaimable file list

RMAN> show all;

RMAN configuration parameters for database with db_unique_name ORARZULB are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
[code]....

what causes this warning and how to get rid of it?

View 2 Replies View Related

Backup & Recovery :: RMAN-00554 - Initialization Of Internal Recovery Manager Package Failed?

Feb 11, 2011

I have recently patched my catalog home to 9208 from 9204; the target database is still on 9204 but now I cannot connect to the catalog database.

oracle@mogw:TES1:/u01/app/oracle/admin/TES1/bdump
rman rcvcat rman/rman@RMANDB

Recovery Manager: Release 9.2.0.4.0 - 64bit Production

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

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

[code]...

View 11 Replies View Related

Backup & Recovery :: RMAN-00554 - Initialization Of Internal Recovery Manager Package Failed

Jun 25, 2013

While connecting to target database from stand database. I am getting below error.

calhost dbs]$ sqlplus system/oracle@proddb

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jun 22 00:18:10 2013

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[standdb@localhost dbs]$ rman target system/oracle@proddb auxiliary system/oracle@standdb

Recovery Manager: Release 10.2.0.1.0 - Production on Sat Jun 22 00:18:22 2013

Copyright (c) 1982, 2005, Oracle. All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges

View 7 Replies View Related

Recovery Manager (RMAN) :: Backup-Based Duplication Without A Target And A Recovery Catalog Connection?

Sep 30, 2012

how to duplicate it on oracle 11g xe windows 2003

i have read from documentation but getting some error.

in last

E:Documents and SettingsAdministrator>rman
Recovery Manager: Release 11.2.0.2.0 - Production on Sun Sep 30 03:03:09 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN> connect auxiliary sys/12
connected to auxiliary database: XE (not mounted)
RMAN>
RMAN> DUPLICATE DATABASE TO xe

[code]...

Backup-Based Duplication Without a Target and a Recovery Catalog Connection?

View 6 Replies View Related

Backup & Recovery :: Incomplete Recovery Shows RMAN-20207

Jan 4, 2012

when i performed incomplete recovery i try to set until time but it shows RMAN-20207:until time or recovery window shoubld be before resetlogs.

View 3 Replies View Related

Backup & Recovery :: Recovery Of Database From Crashed Host Server?

Jul 20, 2012

Backgroud info:

host server crashed.

Database was not cleanly shutdown.

Database is not in archivelog mode.

Datafiles were saved.

My goal:I want to recover the database based on the available files.

My approach:

Install new database.

ALTER DATABASE BACKUP CONTROLFILE TO TRACE.

shutdown database.

Place available dbf files in the location for new database, replacing existing files.

edit trace file to create new controlfile. Script is:

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "newdatabase" RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292

[code]....

View 12 Replies View Related

Backup & Recovery :: Oracle11gR2 Not Allow To Open Database After Complete Recovery?

Feb 24, 2012

My database is in NOARCHIVELOG mode.I took whole DB backup ( cold).Then just after half an hour I ran following script.

RMAN> RUN { RESTORE DATABASE;RECOVER DATABASE;alter database open;}

Starting restore at 24-FEB-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=133 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore

[code]...

Starting recover at 24-FEB-12
using channel ORA_DISK_1

starting media recovery archived log for thread 1 with sequence 2 is already on disk as file /u01/app/oracle/oradata/PROD/redo02.log
archived log file name=/u01/app/oracle/oradata/PROD/redo02.log thread=1 sequence=2
media recovery complete, elapsed time: 00:00:01

[code]...

Why do I need to specify an option at the first place?As my redo is intact, it is not incomplete recovery and, I do not want to generate new incarnation of my database.Why oracle simply not opening my database?

View 12 Replies View Related

Backup & Recovery :: RMAN-06428 / Recovery Catalog Is Not Installed

Jan 1, 2012

REGISTER DATABASE;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of register command at 01/01/2012 11:02:40
RMAN-06428: recovery catalog is not installed

View 4 Replies View Related

Backup & Recovery :: Finding Rman Restore And Recovery Process?

Feb 7, 2011

I have a doubt regarding the process the RMAN follows for restore and recovery of the database.

My Level 0 full backup completes on Saturdays at around 11 am after taking 8 hours (It starts at 3am).On Sunday, I ask RMAN to restore (on a different box) till Saturday 11:30 am.Then, after the restore is successful, I recover it till 11:45 am.

The recovery also goes fine and Iam able to clone to test box.

Till what time is the database restored? I assume its till 11 am since the L0 backup finishes at 11 am though I have asked it to restore till 11:30 am

During the recovery, ONLY the archives generated between Saturday 3 am and till the time i asked for recovery (Saturday 11:45 am ) are required. But, checking the recovery log file, i was surprised to see that RMAN has restored archive files starting from Friday 9:30 pm (Much before the time the Level 0 backup even started).

why does RMAN require the old archive log files.

View 4 Replies View Related

Backup & Recovery :: ORA-00283 - Recovery Session Canceled Due To Errors

Dec 1, 2011

I have problem when i am trying to recover database

i am getting above error.

View 16 Replies View Related

Backup & Recovery :: ORA-19809 / Limit Exceeded For Recovery Files

Mar 22, 2012

while opening my database i got this error i already increase my db_recovery_file_dest_size but still i got this error

E:oracleproduct10.2.0db_1BIN>SET ORACLE_SID=LIVEDB
E:oracleproduct10.2.0db_1BIN>SQLPLUS
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Mar 22 11:14:47 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Enter user-name: SYS AS SYSDBA
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

[code].....

View 8 Replies View Related

Backup & Recovery :: Database Recovery With Missing One Of The Archivelog

Feb 10, 2011

I want to do the recovery of my database using the archive log files but one of the archive log in between is missing,

View 17 Replies View Related

Backup & Recovery :: ORA-19573 / Flashing During RMAN Recovery

May 5, 2011

I was trying to backup my database via RMAN and I had deleted a datafile from the database while it was still in open mode.Since I can't return back to mount stage again,I tried to bring the tablespace pertaining to that datafile offline and then restore backup of the tablespace but it's falshing error during recovery.

When I try to restore entire database,it is not even able to restore.

View 4 Replies View Related

Backup & Recovery :: ORA-01194 / File 1 Needs More Recovery To Be Consistent

May 16, 2012

I am trying to open the database bur gettinf following errors

ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBF'

SQL> shutdown
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 289406976 bytes

[code]....

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved