Short for Recovery Manager is an Oracle command line tool for doing backup, restore, and recovery operations.

learn more… | top users | synonyms

8
votes
2answers
12k views

Why do we need to backup Oracle archive logs along with datafiles

Oracle® Database Backup and Recovery Basics 10g Release 2 (10.2) says that Archived redo logs are the key to successful media recovery. Back them up regularly. But, I wonder, why backups of ...
5
votes
1answer
38 views

Are there any potential problems with running distinct Oracle rman archivelog backups of the same database at the same time?

The scenario is that RMAN archivelog backups are scheduled to tape (TSM) every 2 hours. The scheduling ensures that such backups are run in a mutually exclusive fashion. A separate crontab based ...
4
votes
2answers
6k views

RMAN-06054: media recovery requesting unknown archived log, Where is SCN kept?

I have the following situation: Backups of DB1(located on srv1 server) database are taken everyday at 1:00 AM. I took backed up files(datafile,archivelog,controlfile,spfile) of 24/10/2011 and ...
4
votes
2answers
634 views

Duplicate database leaves orphan archivelog files

I am cloning the production database to another one, lets say CLONEDB, in a regular basis. I am using rman duplicate database script like: run { duplicate target database to CLONEDB FROM ACTIVE ...
4
votes
1answer
331 views

Possible RMAN orphan files in backup directory

I am trying to scrape together some space in my Oracle 11g backup directory in AIX. I have deleted obsolete files using RMAN's "DELETE OBSOLETE" command, but I see many (just under 200) files dated ...
4
votes
2answers
716 views

Change Location of VALIDATE RECOVERY FILES work area

Is there a way to tell the VALIDATE RECOVERY FILES command to use a different location with more available disk space? When I run the command in RMAN, it fails with the following error stack: ...
3
votes
3answers
120 views

Restore data from an old rman backup - ORA-01152

I have some trouble restoring some data from an old backup. Original machine was lost and my mission is to restore data. This is not a critical machine, but some data is still useful. Oracle on ...
3
votes
2answers
213 views

Database not able to startup showing control file is inconsistent with another

Our windows server 2008 R2 is shutdown due to power failure. When I am trying to startup Oracle 11g database its shows an error. SQL> startup ORA-01081: cannot start already-running ORACLE - shut ...
3
votes
2answers
21k views

RMAN list archivelogs that are needed for to recover specified backup

I've taken backup of datafiles in 31.12.2013. It completed datafile backups successfully, but archivelog backups failed. Now, I want to determine what archivelogs should I backup to be sure that my ...
3
votes
3answers
222 views

Putting the database in backup mode before making file system changes

We are planning to make a small change in the Linux file system. To be on the safe side, I thought I would take a SAN-level snapshot of all the drives beforehand. I was thinking I should put the ...
3
votes
1answer
2k views

How do I have RMAN treat my restored data files like they are originals?

I am planning a migration for this ancient-but-critical Oracle database from one Windows Server 2003 cluster to another. The database has many data files and they are all getting new paths on the ...
3
votes
1answer
846 views

In a two-server dataguard setup, can I store the recovery catalog in the same database?

We currently have an Oracle 11gR2 database that is backed up with rman, with the rman records stored in the control files. Control file auto-backup is turned on. Backups are to disk (and, ultimately, ...
3
votes
1answer
104 views

cannot understand why restore database preview fails (missing archive logs)

I am fully backing up my standby database every night with following statement. (please note that I do not use rman catalog but control file) backup AS COMPRESSED BACKUPSET full database tag ...
3
votes
2answers
34k views

Expired archived logs not deleted from RMAN catalogue

If I issue a LIST EXPIRED command in RMAN, I see a list of files with expired status, that is, they exist in the catalogue, but not on the disk (verified by ls). After issuing CROSSCHECK and DELETE ...
3
votes
1answer
57 views

loss of all redologs scenario

I'm having this question regarding a restore scenario in RMAN: A database is running in Archivelog mode. Full RMAN hot backups are taken, redologs are backed up with RMAN to tape. The application ...
3
votes
1answer
2k views

Is it possible to use 'restore UNTIL SCN' with rman and Oracle 9i in NOCATALOG mode?

I'm trying to do a hot backup with rman that I can copy to a USB drive so I can recover it on a new server. The backup was done two days ago and the restore database command was working on the same ...
2
votes
2answers
288 views

Does RMAN in Oracle only copy the archive logs? What happens to the active redo log in case of failure?

If RMAN copy copies the archived redo logs when they are full, what happens to the current redo log in the event of a failure (hardware failure, etc.)? Isn't there always an active redo log that is ...
2
votes
2answers
656 views

Duplicating a Database with RMAN

I would like to duplicate to the same server Oracle Database with RMAN. I've configured flash recovery area for Oracle Database. My database is using SPFILE as shown below. SQL> SELECT ...
2
votes
2answers
105 views

Incremental backups - differences

What is the differene between: BACKUP INCREMENTAL LEVEL 0 DATABASE; and BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; ? I read some manuals, but I don't get the idea beacuse of my poor ...
2
votes
1answer
115 views

can rman backup a subset of a table

I have been asked to make incremental backups of a table based on the value of one of the fields in the table (called groupid). They want a separate incremental backup for groupid=1, groupid=2, ...
2
votes
2answers
1k views

Oracle 11.1.0 Autobackup going to wrong location

I am running Oracle 11.1.0 on Win Server 2008. My autobackups used to go to flash_recovery_area\myDB\autobackup\*yyyy_mm_dd*. Then I added a prefix to the file name in front of %F and they started ...
2
votes
1answer
66 views

Can I use an RMAN Backup of DB1 to replace DB2

I have a backup of an Oracle 11g database on Linux, that is a version that is 'prescrub' needed by other users. This is for an ACTIVE database that is now scrubbed, so I do not want to use it as the ...
2
votes
2answers
3k views

Delete backups from old incarnation in rman

I did a refresh on a non-production database and these are the incarnations: List of Database Incarnations DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time 1 1 ...
2
votes
2answers
5k views

Why is important to write down the DBID in Oracle DB?

I've always heard that one of the first things you should do in Oracle DB is to write down the DBID, so in case you lost the controlfile you'll need to set it in RMAN, and then you will be able to ...
2
votes
1answer
801 views

Restore database from individual datafile backups

I had a script that backs up all the individual datafiles like: RMAN> BACKUP AS COMPRESSED BACKUPSET DATAFILE 'datafile<1>.dbf' So i have backupsets of all the datafiles. I'm confused as ...
2
votes
1answer
1k views

RMAN backup is stuck/taking a long time

I am trying to run an RMAN backup that is either hung or is taking a very long time. Some background: I inherited this database, and I am unfamiliar with Oracle, as I am an SQL Server guy, so please ...
2
votes
2answers
3k views

Restoring an Oracle Backup Properly

I've been trying to do a proper restore of a database for weeks now and I'm convinced that I'm doing something simple wrong. I took a cold backup of the database before an update to an application ...
2
votes
1answer
276 views

Protocol used by Oracle RMAN to communicate with auxiliary

What protocol is used by RMAN to communicate with the server used for backing up/restoring data? I searched everywhere but couldn't find any docs with this information. Background: I am developing ...
2
votes
1answer
904 views

Which backup files are needed for a successful restore?

Considering the built-in 'Backup Database' script (backup.bat) that comes with a new installation of the Oracle Express 11g Edition, after finishing the script execution, what folders/files should be ...
2
votes
1answer
2k views

Can RMAN duplicate be used to “replace” an existing database?

I have an unused database B, not valuable. I'd like to make a copy of database A, but do not want to go through all the manual steps RMAN requires to set up the auxiliary database. Can I use RMAN ...
2
votes
1answer
368 views

Rman not replacing logs with same name on networked drive

Historically, rman saved logs by replacing files of the same name so that the most recent set was always there, and logs from backup of older than the most recent set simply went away. Rman is ...
2
votes
2answers
139 views

ORA-01180 when restoring the database

I get the following error message when trying to restore the database from backup using RMAN. rman target / RMAN> set dbid=130474031 RMAN> configure device type 'sbt_tape' clear; RMAN> ...
2
votes
0answers
960 views

Why OEM RMAN backup jobs fail after changing the preferred credentials?

In an Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production, Running on Oracle Linux 6.5, we configured full RMAN backup schedule using OEM (Oracle Enterprise Manager 11g ...
1
vote
3answers
102 views

Oracle 11g ORA-01190: control file or data file 1 is from before the last RESETLOGS

I am running Oracle 11GR2, Enterprise Edition Release 11.2.0.3.0. I got one of my Test DBs corrupted today. Luckily, I have 2 weeks of backups in the Net Backup server, so I thought, "This is easy, ...
1
vote
3answers
2k views

Is RMAN backup platform independent?

I have RMAN backup from AIX server and want to restore on Linux OS. Could you please let me know if there is a way to do it? Thanks a lot for help in this regard.
1
vote
2answers
3k views

How to restore operational Oracle 11g Database from full backup?

Imagine that things gone bad and all we have is a fresh Windows Server and full cold backup of our Oracle database. In case of SQL Server 2000/2005/2008/2012 it was really a matter of few mouse ...
1
vote
1answer
4k views

Oracle backup with RMAN Options?

I'm trying to learn RMAN but getting confused everytime I read Oracle docs! Can someone help me what are the differences and when to use the following? BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT ...
1
vote
3answers
67 views

DB cloning on daily basis

I have a requirement from one of my teams which is database copy (cloning) from production to my test server on daily basis at a particular time. I know this is a very simple process which every DBA ...
1
vote
1answer
74 views

RMAN backup copy - read once and write many?

I am trying to find out what happens in this scenario: BACKUP COPIES 2 What actually happens in the BACKUP COPIES above? Does Oracle RMAN read the data files each time for each separate copy? ...
1
vote
1answer
658 views

Oracle Backup and Recovery

My backed up archivelog file format is 'al_%U'. During recovery it shows the following error: RMAN-06054: media recovery requesting unknown log: thread 1 seq 17 lowscn 671075 How to determine which ...
1
vote
1answer
50 views

Duplicate fails with no copy of datafile nnn found to restore

I've duplicated our production to our UAT environment several times in the past but due to various reason, this time has been a serious PITA. Oracle 11.2.0.3. We have a recovery catalog setup. This ...
1
vote
1answer
220 views

Move PDB to a new host

We're using Oracle 12c, and have two separate servers running Oracle, with a CDB with 2 PDBs. What is the easiest way of getting the data from server A to server B, as a one-time job (not ...
1
vote
2answers
60 views

RMAN backup set, nothing else, how can I duplicate?

I have what appears to be an RMAN backup set, it has been multiplexed in 32 files, each containing 2-3 dbf's inside. The backupset refers to an SPFILE file, but it was not included in the set, the ...
1
vote
1answer
355 views

Oracle RMAN Incremental update or merge questions

1- Does Oracle RMAN support Incremental Update/Merge option for device type SBT ? Or its only supported for Disk ? 2 - During an update/merge operation during the incremental backup, does RMAN write ...
1
vote
2answers
8k views

Extract Archived Log Files from RMAN Backupset

I have an RMAN backup that is taken on 19th january with: BACKUP DATABASE PLUS ARCHIVELOG command. Now I need to restore Archived logs from that backupset to some other OS directory. Is there any way ...
1
vote
2answers
66 views

Need advice regarding RMAN's working

I have configured a RMAN script which first takes the backup of the database and then deletes the obsolete backupsets according to the present retention policy.Now is there any possibility of the ...
1
vote
1answer
25k views

ORACLE restore - how to restore specific .bkp file?

I just started working with oracle and I have some issue. My database is NONARCHIVELOG mode. I made two backups: they are at locations: ...
1
vote
1answer
178 views

RMAN backup of RAC database failing

Backup goes through if I don’t have any explicit connection to any instance : RUN { ALLOCATE CHANNEL ch1 TYPE DISK FORMAT '\\192.168.2.11\test\DF_CH00_%U'; ALLOCATE CHANNEL ch2 TYPE DISK FORMAT ...
1
vote
2answers
329 views

Right way to delete the archive - Oracle

So I have an Oracle database (standalone) running in RHEL and I have scheduled RMAN for backups on daily and weekly basis. Sometimes my file system (archive mount-point) becomes full because of high ...
1
vote
1answer
40 views

RMAN archives deletion

I have a file system for my archives which gets full in a short span of time. I want RMAN to backup all the archives automatically and delete the archives after backing it up when the archives ...