:

RSSRMAN

RMAN Performance – Block Change Tracking

A new feature within Oracle 10g is the ability to improve the performance of your RMAN incremental backups by using BLOCK CHANGE  TRACKING. The block change tracking feature uses a file stored on the file system to record which blocks have changed since the last backup. Then, when RMAN starts its backup, it can read the file […]

Continue Reading

Oracle 10g RMAN Compression

If you have large databases and you use RMAN to back them up, and you are a little concerned with how much space they currently take up, this could be just the tool for you. Previously, it was not possible to backup your database with RMAN and conserve space using compression; this had to be done afterwards using some […]

Continue Reading

RMAN – A Cumulative Incremental Backup Problem?

We were using a cumulative incremental backup strategy in Oracle version 9.2.0.8, patchset 21. We thought that each cumulative level 1 backup plus the level 0 which was taken prior to it, would be sufficient to restore the database. However, we found out while restoring the database to a DEV environment that this is not […]

Continue Reading

Change the RMAN Date Format

Question: I’m using Oracle’s RMAN and when I run scripts the date format is truncated, but I want to know the exact time my script started and stopped. Answer: Follow one of the below, depending upon which platform you are using. RMAN Date Format on UNIX Use the SETENV command to set the NLS_DATE_FORMAT variable […]

Continue Reading

Useful Commands in RMAN

Note: If you want the date in RMAN to be formatted in a specific way, different to the default, have a read of my other article on how to change the RMAN date format. # Find out the tag for the backup set that you want RMAN> LIST BACKUP SUMMARY COMPLETED BETWEEN ’25-04-2013 21:00:00′ AND ’25-04-2013 22:00:00′; # List the backup […]

Continue Reading

Use RMAN to Recover a Physical Standby Database

Read section 12.7.1 in the the Oracle documenttion first. I used this for a slightly different reason than is documented in that link, but it gives good details about what you need to do. I had attempted to flashback the database but after flashing back the DBs (one OLTP and one DataWarehouse) from being in a read/write state on our physical standby DBs, they […]

Continue Reading

RMAN-00554: initialization of internal recovery manager package failed

The Problem I wanted to check out some of the RMAN parameters on a database and make sure that they were configured properly and I received the error below: Recovery Manager: Release 11.2.0.2.0 – Production on Tue Jan 18 16:28:06 2011 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. target database Password: […]

Continue Reading

RMAN-06059: expected archived log not found

RMAN-06059: expected archived log not found

The Problem One of our regularly scheduled jobs on PROD which backs up the archivelogs each day failed with the error message below: RMAN-03002: failure of backup command RMAN-06059: expected archived log not found, loss of  archived log compromises recoverability ORA-19625: error identifying file  M:\ORACLE\LOGS\LOG_246800_1.ARC ORA-27041: unable to open file OSD-04002: unable to open file The […]

Continue Reading