Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [rman]

RMAN is Short for Recovery Manager is an Oracle command line tool for doing backup, restore, and recovery operations. Also tag RMAN questions with the appropriate Oracle version tag.

rman or Recovery Manager is a CLI tool for performing backups and recoveries on an Oracle Database.

Oracle Recovery Manager (RMAN) is available as a command-line tool and can be accessed from Oracle Enterprise Manager. It simplifies the tasks of restoring a database from backups due to disk/hardware errors, user errors, and for managing replication. It supports restoring to a point in time, or tablespace, data file, or complete database recovery.

Recommended reading on rman basics:

327 questions
12
votes
2 answers

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 archive logs is so important. Would it be possible…
nonezumi
  • 223
  • 1
  • 2
  • 4
10
votes
5 answers

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 archive generation. Now what is the right way to…
tesla747
  • 1,910
  • 10
  • 42
  • 77
8
votes
2 answers

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 restored them on the server srv2. During recovering…
kupa
  • 1,737
  • 14
  • 39
  • 55
8
votes
3 answers

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 mechanism has been put in place (by an unrelated team)…
Robert Gordon
  • 81
  • 1
6
votes
1 answer

How to change the path of temp file,redo log file when restore an rman backup on another machine?

I am trying to migrate my database (11.2.0.4) A to another machine by using rman backup. At present, in the source machine, the redo log file, temp file is stored under the directory foo (/foo). In the target machine, I would like to store these…
user4535727
  • 85
  • 1
  • 1
  • 7
5
votes
2 answers

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 database will be recoverable after restoring…
kupa
  • 1,737
  • 14
  • 39
  • 55
5
votes
1 answer

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…
Dejan
  • 695
  • 7
  • 20
  • 34
5
votes
1 answer

How do I use RMAN to create a test database from a full recovery backup dataset?

In plain english for a someone whose DBA role is a third or seventh hat, and rarely has to touch Oracle, how do I use RMAN to create a test database from a full recovery backup dataset? I've kept my whining at the end of the question ... Scenario: I…
pojo-guy
  • 187
  • 1
  • 9
4
votes
2 answers

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 EXPIRED commands, I would expect LIST EXPIRED to…
Gaius
  • 11,238
  • 3
  • 32
  • 64
4
votes
2 answers

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 DATABASE PASSWORD FILE SPFILE SET…
Grych
  • 91
  • 1
  • 5
4
votes
1 answer

Not receiving archivelogs from production to remote side

I have a scenario in which we have Designed data guard. Where we have 2 standby sides. One standby is located locally and 2nd standby is located on remote side. The distance between local and remote sides is about 268 KM. we were using 6MB of…
M.AZ
  • 69
  • 1
  • 1
  • 10
4
votes
1 answer

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 from over two months ago although my backup policy…
Silverlock
  • 51
  • 4
4
votes
1 answer

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, via Bacula, to more disks and to tape, but rman…
derobert
  • 205
  • 1
  • 9
4
votes
2 answers

Failure Of Backup Due To Limit Exceeded For Recovery Files Since Cannot Reclaim Disk Space [RMAN-03009,ORA-19809,ORA-19804]

While I try to take incremental backup level 0 by using the command RMAN> backup incremental level 0 database plus archivelog; , encountered this error. RMAN-00571: =========================================================== RMAN-00569:…
Maximin
  • 211
  • 2
  • 4
  • 10
4
votes
1 answer

Altering the location of Oracle-Suggested Backup

On one database, the Oracle-Suggested Backup scheduled from Enterprise Manager always ends up in the recovery area, despite RMAN configuration showing that device type disk format points elsewhere. As far as I can see, the scheduled backup job is…
Roy
  • 1,060
  • 5
  • 16
  • 39
1
2 3
…
21 22