RMAN Archive Log Backup

Mar 27, 2013

We are having an intermittent problem related to failing RMAN archive log backups. Normally everything works fine but once every fortnight or so the archive log backup starts to fail with the below message. We run two Oracle instances on this windows box, so they are using same oracle and TSM client binaries, but it is only of the instances that have this problem - the largest instance though. Restarting the Oracle instance solves the problem and everything is back to normal, until next time ...

This is the error message in the rman log file
CODERMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on c1 channel at 03/27/2013 11:00:29
ORA-03113: end-of-file on communication channel

Alert log contains this
CODEWed Mar 27 11:00:27 2013
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x7716324E, 000000007716324E]
Errors in file R:\ORA_DATA\SDC002\diag\rdbms\sdc002\sdc002\trace\sdc002_ora_12328.trc  (incident=523573):
ORA-07445: exception encountered: core dump [PC:0x7716324E] [ACCESS_VIOLATION] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x7716324E] [UNABLE_TO_READ] []
Incident details in: R:\ORA_DATA\SDC002\diag\rdbms\sdc002\sdc002\incident\incdir_523573\sdc002_ora_12328_i523573.trc

Trace file
CODE
Trace file R:\ORA_DATA\SDC002\diag\rdbms\sdc002\sdc002\trace\sdc002_ora_12328.trc
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
Windows NT Version V6.1 Service Pack 1
CPU : 40 - type 8664, 20 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:85656M/147445M, Ph+PgF:96175M/157683M
Instance name: sdc002
Redo thread mounted by this instance: 1
Oracle process number: 57
Windows thread id: 12328, image: ORACLE.EXE (SHAD)

*** 2013-03-27 11:00:27.255
*** SESSION ID:(530.31175) 2013-03-27 11:00:27.255
*** CLIENT ID:() 2013-03-27 11:00:27.255
*** SERVICE NAME:(SYS$USERS) 2013-03-27 11:00:27.255
*** MODULE NAME:(rman.exe) 2013-03-27 11:00:27.255
*** ACTION NAME:(0000001 STARTED1) 2013-03-27 11:00:27.255

Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x7716324E, 000000007716324E]

*** 2013-03-27 11:00:27.473
Incident 523573 created, dump file: R:\ORA_DATA\SDC002\diag\rdbms\sdc002\sdc002\incident\incdir_523573\sdc002_ora_12328_i523573.trc
ORA-07445: exception encountered: core dump [PC:0x7716324E] [ACCESS_VIOLATION] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x7716324E] [UNABLE_TO_READ] []

I have the incident file as well if that is of any use.

Could the problem be related to running two backups in parallel?

We run full backups once a week and both this time and last time the archive log backup failed it was in conjunction to when the full backup also was running.

Is there any other solution to the problem than restarting the oracle instance?

Since this is a busy production instance it is a big problem for us to restart it outside of maintenance windows.

View 4 Replies


ADVERTISEMENT

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 :: RMAN Hot Backup Plus Archive Log Files?

Jan 11, 2008

I had a production db with archive logging enabled

SQL> select name,status
2 from v$archived_log;

NAME STATUS
---------------------------------------- -
D:ORACLEARCHIVE_ORCL11_13.DBF A
D:ORACLEARCHIVE_ORCL11_14.DBF A
D:ORACLEARCHIVE_ORCL11_15.DBF A

[code]...

So i need to restore archivelogs by using sequence

RMAN>RESTORE ARCHIVELOG FROM SEQUENCE 20 UNTIL SEQUENCE 28;
So the restore is completed successfully
So its very hard to monitor archivelog files
i feel i should have included all archivelog files while taking RMAN backup

RMAN >backup database plus archivelog all delete input;

but the problem is my RMAN backup is already 360GB in size and it takes 4-5 hrs to complete .so i need to schedule RMAN backup at one time (e.g sunday) ,delete the archivelog files older than sundayand now schedule the archivelog backup at another day (e.g wed &sat)

my question is where i have to change my script to backup all avaialbe archivelog files if old archivelog files are deleted at os level?

RMAN> run {
2> allocate channel c1 type disk;
3> sql 'alter system archive log current';
4> backup archivelog all format 'D:oracleackuplog_t%t_s%s_p%p' delete input;
5> release channel c1;
6> }

View 4 Replies View Related

RMAN :: Archive Log Backup

Feb 13, 2013

We have 100 archive log files out of that 20 archive log file are deleted, We want take full Database backup plus archivelog files using RMAN

Is it possible to take backup without 20 archivelog file using RMAN?
Is it possible to take full database backup with 80 archivelog file using RMAN?

View 7 Replies View Related

RMAN :: Incremental Backup - Archive Log?

Jun 6, 2012

We are going to implement oracle 11g. Now I wanna use rman to take the incremental backup in the follwing way:

Level-0 backup weekly, in the way:

run
{
allocate channel c1 type disk;
allocate channel c2 type disk;
BACKUP incremental level 0 DATABASE
TAG 'Weekly_full' FORMAT 'E:RMAN_backupweekly_full_%d_%Y%M%D_s%s_p%p.bak';
backup archivelog all not backed up 1 times delete input
TAG 'Weekly_full_arc' FORMAT 'E:RMAN_backupweekly_full_arc_%d_%Y%M%D_s%s_p%p.bak';

[code].....

and RETENTION POLICY TO RECOVERY WINDOW is set to 10 days, so that there is no chance that i will delete expired backup before taking backup.

Now my question is,

1) Is the way is correct that there is no wrong configuration. My main concern is about archive log, is it correct?

2) As i am deleting archive log files with the backup and after that the expired archive log backup is also deleted, so is there any chance of failure in recovery.

3) here how archive log backup will work with 10 days retention policy.

View 10 Replies View Related

Backup & Recovery :: Archive Log File Using RMAN

Feb 1, 2012

When we see archive log destination is full , in that case how to backup archive log files using RMAN ?

View 1 Replies View Related

RMAN :: How To Backup Archive Logs In Standby Database

Nov 15, 2013

I trying to backup archive logs using rman in standby database. I'm able to backup archive logs using simple command it get's successfully completed. rman > BACKUP  ARCHIVELOG ALL When i'm  trying to do with keep command it's getting failed.I'm trying to do on physical standby databaseBACKUP  ARCHIVELOG ALL KEEP UNTIL TIME 'SYSDATE+100' TAG = 'TEST'.

View 1 Replies View Related

Backup & Recovery :: RMAN - Missing Archive Logs Files

Oct 7, 2012

We have a nightly rman backup that was complete and clean.The backup contains a Data File, Control File and a backup Archive Log file.The database server crashed with all the subsequent archive logs lost.

We are trying to recover from the three backup files.We are bumping into the backup piece missing as all the archive logs are done. how to restore with the exising backup files. the lost archive logs are probably salvageable.

View 9 Replies View Related

Data Guard :: RMAN Archive Log Backup With Delete Input Command

Mar 17, 2012

I have following query in Dataguard ..

If I want to take Rman archive log backup with delete input command , how the archive logs will be copied to standby database

For eg

I am taking archive backup as

RMAN>backup archivelog all delete input;

here consider few archives are not copied to standby database (due to nw issue) then how standby will receives these missing archives as those are deleted by rman backup at primary side.

I am not getting any document related to above query.

View 7 Replies View Related

Backup & Recovery :: How To Get All Archive Logs In Backup Piece

Nov 8, 2008

Is there any way I can get all the archive log files present in a backup piece. I tried following but it always gives me all the log files for each piece:

****
SQL> select s.set_stamp, s.set_count, s.PIECES, s.backup_type,
s.controlfile_included from v$backup_set s, v$backup_piece p where
s.set_stamp=p.set_stamp and s.set_count=p.set_count and
p.handle='5mjv4do0_1_1';

[code]....

View 27 Replies View Related

Backup & Recovery :: How To Apply Archive On Consistent Backup

Feb 15, 2011

Actually, i have test database open in read only and i want to apply archive files carry from production database at daily level.
When i'm going for recovery, since database is already in consistent state, it is not asking for recovery.

View 2 Replies View Related

Backup & Recovery :: How To Extract Archive Log Backup Set

Jun 1, 2012

There is a archive log backupset,and the backup set contains many archive log file,and now i want extract to a directory,how can i do?

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
3 86.20M DISK 00:00:21 02-JUN-12
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20120602T113622
Piece Name: /u02/rman_bak/20120602/archive_log_t784899382_s4_p1

View 6 Replies View Related

Backup & Recovery :: Backup Archive Log Files

Aug 4, 2011

I have one question to clarify regarding backup.

There is an incident that in production database 1000 archive log files generated.From 1000 files, 100 archive log files have been removed.When i take incremental backup next day , what will happen in database?

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

Rman Catalog / Archive Log

Jun 30, 2010

How after a re-catalog of an archivelog, RMAN knows that the archivelog will be needed and in the right order?

If the re-catalog and subsequent crosscheck has changed the path of the archivelog will RMAN ignore the path and just recognize the archivelog name and format?

View 2 Replies View Related

RMAN :: No Archive Log Mode

May 6, 2013

resolving the below issue.

environment:
DB version:11.2.0.3.0
OS : IBM/AIX RISC System/6000
backup tool : Symantec net backup.

When I start RMAN backup through Symantec net backup tool same is failing. when I see in log file below error message is recorded in the same.

################################################################################

Starting backup at 06-MAY-13
channel ch00: starting compressed incremental level 0 datafile backup set
channel ch00: specifying datafile(s) in backup set
RMAN-03009: failure of backup command on ch00 channel at 05/06/2013 07:09:16

[Code]....

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch00 channel at 05/06/2013 07:09:16
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

RMAN> RMAN>

Recovery Manager complete.

####################################################################################

But, DB is up and operating fine with ARCHIVELOG mode at that movement not even restart also.

how to resolve.

View 14 Replies View Related

Delete Archive Log Files Using RMAN

Jul 26, 2013

I am trying to remove archive log file on my standby site but I am getting the following message. There are lots of archive logs are present on the storage but rman is unable to displaying that.

RMAN> list archivelog all;

specification does not match any archived log in the repositoryRMAN> 

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

RMAN :: Delete Archive Logs On Standby

Aug 30, 2012

My oracle database is 11.2.0.2 RAC RDBMS on RHEL 5.6

We recently created physical standby database. How do we delete standby archive logs from physical standby?

View 2 Replies View Related

Recovery Manager (RMAN) :: Not Deleting Archive Logs

Aug 6, 2012

I have Oracle 10gR2 database on a windows server, I have scheduled rman backup for this database from Solaris server

set echo onrun {
crosscheck archivelog all;
backup check logical database plus archivelog;
delete noprompt obsolete device type DISK;
}
exit;

It is deleting the obsolete backup pieces but it is not deleting old archive logs (obsolete archive logs) and it is not even showing old archives as obsolete when I check thru report obsolete

View 7 Replies View Related

Recovery Manager (RMAN) :: Archive Logs Group By Dates

Apr 30, 2013

10.2.0.4
SLES 11

This is the folder groupings of our archivelog folder:

oracle@sdb51:/u01/app/oracle/flash_recovery_area/PROD/archivelog> ls -lt
total 32
drwxr-x--- 2 oracle oinstall 4096 2013-04-30 12:42 2013_04_30
drwxr-x--- 2 oracle oinstall 4096 2013-04-29 12:35 2013_04_29
drwxr-x--- 2 oracle oinstall 4096 2013-04-28 23:42 2013_04_28
drwxr-x--- 2 oracle oinstall 4096 2013-04-24 12:20 2013_04_24
drwxr-x--- 2 oracle oinstall 4096 2013-04-23 22:00 2013_04_23
drwxr-x--- 2 oracle oinstall 4096 2013-04-21 02:01 2013_04_21
drwxr-x--- 2 oracle oinstall 4096 2013-04-19 22:00 2013_04_19
drwxr-x--- 2 oracle oinstall 4096 2013-04-18 18:46 2013_04_18

Are there supposedly complete folder by dates each day? So I am missing archivelogs of 27th, 26th,25th, etc?

View 7 Replies View Related

Backup Of Archive Files

Dec 1, 2010

I am running the following command to backup my archive logs and want to keep at least two hours of .arc files on disk.

rman < connect target login/password
connect catalog login/password
show all;
sql "alter system archive log current";
backup filesperset 5 archivelog until time 'sysdate-2/24'
format $FILE_DEST_ARCH
delete input ;
resync catalog;
EOT

On some occassions, there will not be any archive logs that meet this criteria and I get the following error:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 12/01/2010 12:50:58
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specificati
on does not match any archive log in the recovery catalog

Is there anything I can do to the rman command above that will prevent this error from happening but yet keeping same functionality?

View 2 Replies View Related

Backup & Recovery :: Restore With Archive Log Only

Aug 9, 2013

We have a 9.2.8.0 database in archive log mode. We want to restore that db to a specified point in time. What is the fastest way to do it ?

View 3 Replies View Related

Backup & Recovery :: Keep Archive Log All The Time?

Jun 6, 2012

after backup a full database ,the archive log need to keep all the time ?

View 3 Replies View Related

Backup & Recovery :: Archive Log Format

Jun 9, 2012

The log_archive_format parameter is set to %t_%s_%r.dbf,but the archive log is generate as o1_mf_1_10_7x6lby27_.arc, why?

SQL> show parameters log_archive_format;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_format string %t_%s_%r.dbf

[oracle@hxl 2012_06_09]$ ls -lr
total 93468
-rw-r----- 1 oracle oinstall 51229184 Jun 9 10:00 o1_mf_1_9_7x5ckqbv_.arc
-rw-r----- 1 oracle oinstall 43131392 Jun 9 09:01 o1_mf_1_8_7x581vgo_.arc
-rw-r----- 1 oracle oinstall 74240 Jun 9 21:06 o1_mf_1_11_7x6lksyp_.arc
-rw-r----- 1 oracle oinstall 1131008 Jun 9 21:02 o1_mf_1_10_7x6lby27_.arc

View 4 Replies View Related

Backup & Recovery :: Restore Archive Log

Aug 18, 2011

I need to restore few archivelog from one of stage database to refresh dev database.

Stage database got refreshd before try to restore the arch files.

Now stage database does not contain arch sequence information.

I tried to restore arch fiels from tape using catalog connection. Is there any way to restore

channel c1: sid=521 devtype=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 6.5 (2007071006)

Starting restore at 18-AUG-11
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/18/2011 09:20:21
RMAN-06004: ORACLE error from recovery catalog database:
RMAN-20242: specification does not match any archive log in the recovery catalog

View 3 Replies View Related

Backup & Recovery :: RMAN Duplicate Set Until Time Using Wrong Backup Piece Name To Restore?

Feb 26, 2012

We are doing RMAN Duplicate set until time to refresh daily our test database for our developers and it taking long time to finish. We noticed on the restore log that RMAN was using a day old old backup pieces to refresh the test database and don't immediately use the latest backup pieces instead.

For additional details here's the rman duplicate command we are using which we run daily(mon-sat) at 4am once daily full backup on production completed.

RMAN Duplicate commands:
run
{
set until time "to_date(to_char(sysdate,'Mon DD YYYY') || ' 04:00:00', 'Mon DD YYYY HH24:MI:SS')";
allocate auxiliary channel ch1 type disk;
duplicate target database to testdb;
}
exit

Is there a way on how to let RMAN use the latest backup pieces instead?

View 1 Replies View Related

Backup & Recovery :: ORA-01655 On CREATE USER (splitted From RMAN Backup Error)

Dec 22, 2012

I created a tablespace named 'data'.During create a new user with default tablespace 'data',I got following error message:

SQL> create user rman identified by rman default tablespace data
temporary tablespace temp

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01655: unable to extend cluster SYS.C_USER# by 2 in tablespace

OS:Windows XP
Oracle 10g

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 :: Restore Dropped Or Wrongly Updated Table Using RMAN Backup?

Feb 9, 2011

Is it possible to restore dropped table OR wrongly updated table using RMAN backup.

View 18 Replies View Related







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