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

learn more… | top users | synonyms

0
votes
1answer
82 views

Oracle backup and recovery using RMAN

Can some please provide a quick guide for backup and recovery of Oracle 11 DB? I just need to test it very quickly so i don't need something too fancy, but should be scheduled. Thanks in advance.
1
vote
2answers
4k 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
votes
3answers
265 views

Recovering Oracle Database using RMAN [closed]

I am an accidental DBA..I have to restore an oracle database using RMAN utility. I don't know anything about backups and restoration and this is my first assigned task. Are there any good forum(s) ...
3
votes
2answers
13k 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 ...
0
votes
1answer
79 views

How to fix this error Idk?

how to fix it I am new in Oracle? I tried to connect RMAN and it showed me this error...
0
votes
2answers
2k views

why archived log size is small but fast recovery area still has a lot free space

when recovery database I met a strange problem,my recovery script as follow: RUN { SET UNTIL TIME 'DEC 25 2013 09:00:00' ; RESTORE DATABASE; RECOVER DATABASE; } but rman report as ...
1
vote
1answer
69 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? ...
2
votes
2answers
3k 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 ...
0
votes
2answers
195 views

RMAN restore to lower disk space

I have 30.7GB backup file generated from RMAN. The original ./datafile is 950.28GB. According to previous DBA, there is a lot of free space in table space. Now, I have 300GB free disk space in hard ...
1
vote
1answer
867 views

Oracle RMAN substituting variables

I'm playing around with the USING clause in RMAN, but cannot seem to get it to work. Here is my RMAN command: rman target username/password @${RMAN_DIR}/backup.rman using "db1" When I run that ...
1
vote
1answer
248 views

rman cloning rman-20207 error

I am trying to clone a 9i database (C) from a target 9i database (T). On running the rman script, i get the rman-20207 error : UNTIL TIME is before RESETLOGS time. When i do a list backup of ...
0
votes
1answer
401 views

Can I use RMAN to backup and restore data in a certain point in time?

I have an Oracle database over which I have full control. What I am doing is performing load testing on our application, which uses Oracle as a database. To do this, I initially set the database up ...
2
votes
2answers
265 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 ...
1
vote
1answer
2k views

Duplicate database for standby returns error ORA-19625: error identifying file /home/oracle/stdbyctrl.ctl

I'm working on creating duplication scripts for standby purposes. and it's constantly failing even though the backups are located in the exact same folder. DB structure is identical and spfile is ...
1
vote
0answers
9k views

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: ...
0
votes
1answer
719 views

Centralize Oracle RMAN scripts in one server

I want to centralize all my Oracle's DB backup shell scripts in one server, and all of them are in different servers, architectures and DB versions. For this purpose I'm going to use the same server ...
0
votes
3answers
268 views

Oracle DB Recovery

Before I start, I just want to mention that I am not a DBA, I am a programmer/developer who also happens to look after the database. So if I say something wrong, my apologies in advance. We recently ...
1
vote
1answer
447 views

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. ...
1
vote
2answers
63 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 ...
0
votes
0answers
272 views

Delete backup directories using RMAN

Is there any way RMAN can delete empty backup directories?
2
votes
1answer
198 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 ...
1
vote
0answers
431 views

rman 'delete archivelog all’ very slow

On our automated test system we use flashback all the time to reset our Oracle 11g database to a state before a test run. We noticed some of the scripts involved, started to become slower and slower. ...
3
votes
1answer
1k 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
1answer
88 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, ...
1
vote
1answer
217 views

Mistake during Oracle 11g PITR [closed]

I tried using set time until.. and mis-typed the date. Can anyone help me understand how to get my backups into a manageable state? After the accidental recover, most of my backupset disappeared. I ...
0
votes
0answers
371 views

Duplication Oracle Database to remote host

I have two scenarios. 1 ) Let's say , I have the same file system and same SID on both nodes. I've created any directories necessary for start the duplicate database. First I used command below. ...
2
votes
2answers
582 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 ...
1
vote
1answer
456 views

Why we need auxiliary instance in TSPITR

Need help! I've read Database Backup and Recovery User's Guide 11g but I can't uderstand why we need auxiliary instance to perform tspitr. We can do complete recovery of tablespace within same ...
0
votes
1answer
700 views

Recommended Approach to Programmatically Backing Up/Restoring Oracle DB

Supposing I have an ever-growing Oracle DB on one server, and I want to duplicate this schema and the data on another server - what would be the best approach to achieving this as part of a bespoke ...
1
vote
1answer
18k 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
6k views

Difference between full and level 0 rman backups?

Suppose we take a full backup, and after that we take a level 0 backup, both using RMAN and Oracle 10g. I'm confused in the use of the level 0 backup and full backup. I found that the difference ...
0
votes
2answers
366 views

RMAN backup script failing

I have a few linux machines and each of them have a few Oracle databases. On each machine we have 2 shell scripts to run the backups. The TSM scheduler calls a script which calls a different backup ...
0
votes
1answer
11k views

db_recovery_file_dest_size issue

RMAN gives me this error how should i resolve this issue: ORA-19815: WARNING: db_recovery_file_dest_size of 7516192768 bytes is 100.00 used, and has 0 remaining bytes available. Thanks in ...
1
vote
1answer
5k views

Delete Archive log file

I am using oracle database 11g. Some day's back we have deleted our Archivelog Manually, and now it's getting full and due to that we are not able to connect to our database. So how should i delete ...
2
votes
1answer
673 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 ...
0
votes
2answers
2k views

RMAN Recovery In Oracle 11g : Backup Database To Tape

On issuing this command: RMAN> backup device type sbt tablespace <tablespace_name>; we are getting the following error: ORA-19554: error allocating device, device type: SBT_TAPE, device ...
2
votes
1answer
601 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 ...
0
votes
2answers
718 views

Row level restore with Oracle Recovery Manager (RMAN)

We're approaching the end of 2012 and I still find myself relying on database exports to maintain the ability to do row level restore operations. While this is a proven method, it sure would be nice ...
1
vote
1answer
3k 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 ...
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 ...
0
votes
1answer
2k views

Incremental level 1 backup with no Incremental level 0?

I have done the following steps: Backed up database with INCREMENTAL LEVEL 0 Delete INCREMENTAL LEVEL 0 backup without telling controlfile. So deleted it by hand. And did not make crosscheck. Backed ...
4
votes
2answers
598 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: ...
2
votes
2answers
103 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
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 ...
0
votes
0answers
1k views

RMAN Error ( 00601, 03004) [closed]

Please help on this RMAN error: RMAN> backup database plus archivelog; Starting backup at 08-MAY-12 current log archived allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=297 devtype=DISK ...
1
vote
1answer
2k views

How can I change default backup location for oracle11g using RMAN?

I want to change to another drive due to lack of disk space. How can I change the default location of backup files used by oracle to another drive using RMAN? By default it's in the folder ...
2
votes
1answer
315 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 ...
3
votes
1answer
738 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
5k 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 ...
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 ...