Backup & Recovery :: ORA-01115 - IO Error Reading Block From File 11?

May 17, 2013

During the scheduled backup we observed that, backup got failed. Error is "ORA-01115: IO error reading block from file 11 (block # 118736)
".
unable to rectify it. Below are the part of log file -

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.MAIN [TABLE_DATA:"DW_REP"."DW_MOTOR_CLAIM_INFO_DTLS"]
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 8976
ORA-24795: Illegal ROLLBACK attempt made

[code]...

This is development server. Dont have RMAN configured.But when we connected to RMAN and issued block recovery, it started process and shows media recovery done. Since no RMAN backup was taken before, what it does here?

C:UsersAdministrator>RMAN
Recovery Manager: Release 11.2.0.1.0 - Production on Fri May 17 10:48:40 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN> CONECT target /
connected to target database: MAGMADEV (DBID=2469200049)

[code]...

how to resolve this problem?

View 6 Replies


ADVERTISEMENT

Backup & Recovery :: Error / Corrupt Block Relative Dba / 0x01c12a58 (file 7 / Block 76376)

Jan 25, 2011

i have an error with block corruption

Error: Corrupt block relative dba: 0x01c12a58 (file 7, block 76376)

What all the ,methods I can go for if we are working on a production environment with out any down time.

I can go for dbms repair package and restore and recover

View 3 Replies View Related

Backup & Recovery :: ORA-19870 / Error Reading Backup Piece During Database Cloning

Mar 15, 2011

I am trying to clone a database on another server with different direcory structure. So that path on the source db server are /u04 whereas on on target db server it would be /u03.

Since this I am testing it on small database initially I have kept all datafiles, backup and archivelogs at /u04 and /u03 on the source and target db servers respectively Now I have copied the backups from source db server to target and since path is changed, I cataloged it

However during restore I am getting

Quote:ORA-19870: error reading backup

Here are the session details

RMAN> catalog start with '/u03/oradata/db7fra';
searching for all files that match the pattern /u03/oradata/db7fra
List of Files Unknown to the Database
=====================================
File Name: /u03/oradata/db7fra/DB7/archivelog/2011_03_15/o1_mf_1_16_6qyvpb3w_.arc
File Name: /u03/oradata/db7fra/DB7/backupset/2011_03_15/o1_mf_annnn_TAG20110315T123018_6qypyv5v_.bkp

[code].....

I have altered permissions on the backup files as well but of no use

oracle@dev-biz:/u03/oradata/db7fra/DB7/backupset/2011_03_15 $ls -ltr
total 545260
-rwxrwxrwx 1 oracle dba 12419072 Mar 15 13:52 o1_mf_ncsnf_TAG20110315T123008_6qypyrz2_.bkp
-rwxrwxrwx 1 oracle dba 3072 Mar 15 13:52 o1_mf_annnn_TAG20110315T125043_6qyr54to_.bkp
-rwxrwxrwx 1 oracle dba 426496 Mar 15 13:52 o1_mf_annnn_TAG20110315T125006_6qyr3zk4_.bkp
-rwxrwxrwx 1 oracle dba 14336 Mar 15 13:52 o1_mf_annnn_TAG20110315T123018_6qypyv5v_.bkp

[code].....

View 13 Replies View Related

Backup & Recovery :: Block Change Tracking File

Sep 10, 2011

does, block change tracking file is read during incremental level 0 backup?

View 4 Replies View Related

Backup & Recovery :: Block Change Tracking File When It Is Used

Oct 11, 2011

i did such commands

1. RMAN -> backup incremental level 0 database;

2. SQLPLUS -> alter database enable block change tracking using file '/home/oracle/block_change_tracking.tr';

3. RMAN -> backup incremental level 1 cumulative database;

4. RMAN -> backup incremental level 1 cumulative database;

5. RMAN -> backup incremental level 1 cumulative database;

and for such order i noticed that block change tracking file wasn't used for any cumulative backup. for each cumulative backup was done full scan over database.

it was used after i did incremental level 0 backup, and again incremental 1 cumulative.

if i want this feature to be usefull i should enable it before my incremental level 0, or i should do incremental level 0 immediately after i enable it?

View 6 Replies View Related

Backup & Recovery :: ORA-00368 / Checksum Error In Redo Log Block

Oct 15, 2012

I am facing some problems in recovery on oracle 9.2.0.1.0 Standard Edition.

Quote:

ORA-00283: recovery session canceled due to errors
ORA-00368: checksum error in redo log block
ORA-00353: log corruption near block 43200 change 1021681146 time 10/11/2012 18:25:25
ORA-00334: archived log: '/oradb/odb/archivedata/ARCH0000002343.ARC'

View 3 Replies View Related

Backup & Recovery :: RMAN Control File Auto Backup Error?

Dec 13, 2011

This is what I run

run {
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/dd_oraback/tkprod/%F';
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 22 DAYS;
sql 'alter system archive log current';

[code]...

So /dd_oraback is a Data Domain mount. Not sure if that makes any difference or not.

View 1 Replies View Related

Backup & Recovery :: RMAN Backup Empty Block From Datafiles?

Apr 27, 2012

Does change in segment size effect the rman backup size..??

I'm trying to understand do Rman backup the empty block from datafiles..?? And if it escape the empty block than inserting data in tables (increasing the number of used block) might change the size of total backup (Rman) size

View 2 Replies View Related

Backup & Recovery :: Block Corruption In Expdp?

Feb 15, 2011

I am facing issue of block corruption in my exp backup which I am taking through expdp command. (Refer Attachment of Screen shot of error)

I want to know few things about the block corruption.

1. Why the block corruption occur.

2. How can I resolve this.

3. Can I rosolve this by deleting the same record on which this error is coming. if yes then how can I track that row in a table.

I already tried for DB verify utility. It shows the below result.

===================================================================
C:Documents and SettingsAdministrator>dbv file='E:ORADATAAFCCV1MONETA01.DBF' blocksize=8192
DBVERIFY: Release 11.1.0.6.0 - Production on Wed Feb 16 10:13:11 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
DBVERIFY - Verification starting : FILE = E:ORADATAAFCCV1MONETA01.DBF
DBV-00600: Fatal Error - [28] [27070] [0] [0]
C:Documents and SettingsAdministrator>
================================================================

View 12 Replies View Related

Backup & Recovery :: How To Find Corruption Block

Jun 9, 2012

how to find the corruption block and judge whether it is physical corruption or logical corruption?

View 3 Replies View Related

Backup & Recovery :: Routine To Corrupt A Block?

Jul 14, 2011

have a repeatable technique for damaging a datafile block?

I need to demonstrate and contrast various recovery techniques, such as dbms_repair, RMAN block recovery, and Data Guard automatic block repair.

I'll end up with a shell script (or batch file) where I can enter a file number and block number, and wipe out that block.

View 3 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 :: How To Determine The Rate Of Block Change

Aug 3, 2011

rdbms:oracle 10gr2
os:windows

with reference to

[URL]......

Quote:
A.2.2 Writing Backup Scripts for Disk and Tape Scenarios

As in the disk-only scenarios, the backup scripts in this section are categorized based on database workload. as stated very clearly it depends on the workload, more precisely the rate of block change. The size of the database can be found out based on formula from

[URL]....

so how would I know the rate of block change in order to know which script is suitable for me? I try to find out the rate of block change for the database based on change tracking file but based on

[URL].....

Quote:

The size of the change tracking file is proportional to the size of the database and the number of enabled threads of redo. The size is not related to the frequency of updates to the database. So how do I determine the rate of change? can the rate of block change based on size of archive logs?

I have the following information with me:

starting from 5/10/2011 0101
ending 5/18/2011 1114

this constitute to 9.5 days

F:
ecover_area>dir/w
1644 File(s) 27,942,770,176 bytes
2 Dir(s) 10,019,270,656 bytes free

average size of each file 27,942,770,176/1644
=16996818.841849148418491484184915

average size of each day's log = 27,942,770,176/9.5
=2941344229.0526315789473684210526
about 3G

If I have a database size of 92G, based on the archive log size of about 3G per day, can I conclude that a change of 3G/92G is considered as few block change?

View 1 Replies View Related

Backup & Recovery :: Block Corruption In System Datafile?

Dec 25, 2011

I have noticed a block corruption issue in my RAC database. Its an index , how to recover a corrupted index in system datafile.

SELECT tablespace_name, segment_type, owner, segment_name
FROM dba_extents WHERE file_id = 5
3 and 147551 between block_id AND block_id + blocks - 1;
TABLESPACE_NAME SEGMENT_TYPE OWNER

[code]....

We are using OCFS2 and O/S is RHEL 4.7.

View 3 Replies View Related

Backup & Recovery :: What Is Data Block Check Sum Algorithm

May 18, 2013

It seems that Oracle does not use XOR to calculate the checksum of data blocks any more. What is the new checksum algorithm?

View 3 Replies View Related

Backup & Recovery :: Enabling Block Change Tracking?

Jun 20, 2012

i want to enable block change tracking as our incremental level1 backup take a lot of time but i have a worry which i found it on oracle support and tha is as follows Database Instance Hang at Database Checkpoint With Block Change Tracking Enabled. [ID 1326886.1]

View 2 Replies View Related

Backup & Recovery :: RMAN Full Backup Failing When Backing Up Temp File?

Jan 28, 2011

I am tryign to run a split onlike full backup from the os useign the sap command which is linked to rman..Command that i am useing is ...

brbackup -u / -c force -t online_split -m full -p initBR1_onlinefull.sap

The backup goes thru but i get this erro on the end...

BR0522I 57 of 57 files/save sets processed by RMAN
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.26
BR0505I Full database backup (level 0) using RMAN successful
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.28

[code]...

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

RMAN>
connected to target database: BR1 (DBID=2250873886)
using target database control file instead of recovery catalog
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28>
29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42

[code]...

Recovery Manager complete.
ERR_RC: 1
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.32
BR0279E Return code from 'brtools -f printcmd -U /oracle/BR1/sapbackup/..befcdgxn..cmd -C
/oracle/BR1/sapbackup/.befcdgxn.cmd | rsh scrbdefrmr207 /bin/sh -c "'LANG=C SHELL=/bin/sh/oracle/BR1/102_64/bin/rman

[code]...

I have check on the system .. There is not file like that but thwre on on the db i,e

eshtsm20:orabr1 88> pwd
/oracle/BR1/sapdata1/perfman_1
eshtsm20:orabr1 89> ls -ltr
total 102408
-rw-r----- 1 orabr1 dba 104865792 Aug 30 09:05 perfman.data1

View 13 Replies View Related

Backup & Recovery :: Can A Control File Backed Up Be Present In Multiple Backup Pieces

Sep 27, 2011

Suppose I take a multi stream backup, say 3 streams.

So if a control file is backed up in say backup set 1, so is the whole control file is backed up in one backup piece or it may span multiple pieces?

A backup set may have multiple backup pieces.

View 2 Replies View Related

Backup & Recovery :: Restoring Later Backup Control File And Recovering Till Past Scn

Jul 11, 2012

I want to ask if I restore a control file from backup of say day2 and I recover till day1 using RMAN script, then what will be the state of my database? I mean day2 control file may be having SCN-Day2, and I am instructing RMAN to recover till past point in time that is SCN-Day1.

View 3 Replies View Related

Backup & Recovery :: Configuration Can't Be Changed For BACKUP Or STANDBY Control File

Sep 18, 2012

On my stand by DB when I run the following command I get this error:

Is this line really needed based on my run block?

run
{
sql 'ALTER DATABASE BACKUP CONTROLFILE TO TRACE';
allocate channel t1 type 'SBT_TAPE'

[Code]....

View 4 Replies View Related

Backup & Recovery :: RMAN Backup Fails On Windows When Using Batch File?

May 3, 2011

I am trying to setup incremental backup on my windows OS based server using RMAN command in batch file. When I use batch file in OS scheduler it is working fine, when I am calling same batch file from my LOCAL desktop PC it throws errors as below.

D:> \3.193.211.19sgdba
mankp_acressit.bat
D:>rman catalog rman/******@acressit target / cmd
file=E:sgdba
mankp_arch.rcv log E:sgdba
mansit_arch_rman_backup.log
RMAN-00557: could not open MSGLOG "E:sgdba

[code]....

Both single and double quotes (' or ") are accepted for a quoted-string.

Quotes are not required unless the string contains embedded white-space.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00556: could not open CMDFILE "E:sgdba
mankp_arch.rcv"

[code]....

* on my DB server I am login using my administrator account, on my PC I dont have admin account.

* I have checked remote execution using local user as well as admin user.

* I have checked the permission and my local ID & EVERYONE has all permission in that folder.

View 2 Replies View Related

Backup & Recovery :: Identify Particular Archive-log File Have Backup Or Not From RMAN Catalog?

May 30, 2012

How can be identify a particular archive-log file have backup or not from rman catalog?

View 2 Replies View Related

Backup & Recovery :: ORA-01578 - ORACLE Data Block Corrupted

Nov 21, 2012

What i have to do for this error:

ORA-01578: ORACLE data block corrupted (file # 3, block # 42348)
ORA-01110: data file 3: '+DGMETA/metadb/datafile/sysaux.257.783871811'
Wed Nov 21 09:30:00 2012
Corrupt Block Found
TSN = 2, TSNAME = SYSAUX
RFN = 3, BLK = 42348, RDBA = 12625260
OBJN = 50439, OBJD = 50439, OBJECT = MGMT_STRING_METRIC_HISTORY_PK, SUB
OBJECT = SEGMENT OWNER = SYSMAN, SEGMENT TYPE = Index Segment

Database version is :- Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi

View 11 Replies View Related

Backup & Recovery :: Ora-01578 - Oracle Data Block Corruption

Jun 24, 2013

We are facing block corruption error and it's refer to system datafile (SYSTEM01.DBF).Below is the script through it, we can come to know about the extent.

select segment_name, segment_type from dba_extents
where file_id=1 and 134144 between block_id and block_id+blocks-1;

select owner,index_name,index_type, table_name from dba_indexes
where index_name='I_CDEF3';

How to resolve the problem as it is related to system datafile? We tried to drop the index but system is not allowing to do.

ORA-00701 - object necessary for warmstarting database cannot be altered.

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

Backup & Recovery :: ORA-01113 - File 5 Needs Media Recovery

May 11, 2012

I am trying to move my data files from one location to other as i ran out of space.

SQL> alter database rename file 'C:oracleproduct10.2.0oradataSPF433SPF433ADW_DATA.DBF' to 'D:OracleDatafilesSPF433SPF433ADW_DATA.DBF';
Database Altered

SQL> alter database rename file 'C:oracleproduct10.2.0oradataSPF433SPF433ADW_DATATEMP.DBF' to 'D:OracleDatafilesSPF433SPF433ADW_DATATEMP.DBF'
Database Altered

Now when i am trying to run Alter Database open I get ORA-01113: file 5 needs media recovery error

View 11 Replies View Related

Backup & Recovery :: Changing Location Of Data And Temp Files From Auto-backup Of Control-file?

Jan 26, 2012

I have an oracle autoback of controlfile and spfile. I am trying to restore the production database using this backup, into a new server with a different directory structure.

I have completed the following steps in the restore process.

1. Creating a pfile from spfile

2. Changing the the location of cdump, udump, bdump and the control files ( there are three )

3. Then creating a spfile from this pfile

I am stuck on the next step where to rename all the datafiles and tempfile and restore the database. Following is what I did.

After mounting the database in RMAN, tried to run the following.

RMAN> run
2> {
3> allocate channel c1 device type disk
4> ;
5> @/home/oracle/rman_scripts/newloc.rman
6> SET NEWNAME FOR DATAFILE 1 TO '/u02/oradata/dorian/system01.dbf';
7> SET NEWNAME FOR DATAFILE 2 TO '/u02/oradata/dorian/undotbs01.dbf';
8> SET NEWNAME FOR DATAFILE 3 TO '/u02/oradata/dorian/sysaux01.dbf';
9> SET NEWNAME FOR DATAFILE 4 TO '/u02/oradata/dorian/users01.dbf';

[code]....

I am getting the following error message.

Starting restore at 25-JAN-2012 21:26:48
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/25/2012 21:26:49
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of datafile 30
RMAN-06100: no channel to restore a backup or copy of datafile 29
RMAN-06100: no channel to restore a backup or copy of datafile 28

[code]....

View 14 Replies View Related

Backup & Recovery :: Backup Of Control File On Standby Node?

Apr 3, 2013

I am trying to backup my control on a STBBY DB(RAC) and I am getting the ollowing error.

ORA-00245: control file backup failed; target is likely on a local file system

what the issue is? Note the FS is ACFS and can see on all my nodes

show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name PA01INS_IM3L059B are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default

[code]...

ACFS file system

df -h /share/dbbkup/oracle/PA01INS/rman
Filesystem Size Used Avail Use% Mounted on
/dev/asm/pa01ins-33 75G 2.6G 73G 4% /share/dbbkup/oracle/PA01INS
rman cmdfile=control.rman

[code]...

View 2 Replies View Related

Backup & Recovery :: Change Backup Datafile Name Into Its Original File Name?

Dec 16, 2011

how i can change backup datafile name into its original file name,bcoz at time backup datafile name is different and how i can change that name into its original datafile name so i apply recovery command in user managaed recovery..

View 7 Replies View Related

Backup & Recovery :: ORA-01152 / File 1 Was Not Restored From Sufficiently Old Backup

Sep 27, 2011

I am trying to open my Mounted database with

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'F:APPADMINISTRATORORADATATHIRDBSYSTEM01.DBF'

To get rid of this , I tried following,

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1004739 generated at 09/26/2011 10:31:34 needed for thre
ORA-00289: suggestion :
F:APPADMINISTRATORFLASH_RECOVERY_AREATHIRDBARCHIVELOG2011_09_27O1_M

[code].....

View 2 Replies View Related







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