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
24 views

RMAN restore from tag

oracle 11.2.0.4 on redhat 6 SERV1 is prod server running database MAZ, SERV2 is developemt server with no databases on it. i have noted the dbid and last SCN, and then taken a backup on SERV1 using ...
2
votes
1answer
132 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 ...
0
votes
0answers
28 views

Rman append archivelog to backup

is it possible to configure RMAN to append archivelogs to backup automatically? I know that it is possible to issue BAKCUP DATABASE PLUS ARCHIVELOG but, is it possible to configure rman to do this ...
0
votes
1answer
50 views

Oracle DB Point In Time Recovery faulted

I'm testing a procedure via RMAN backup to retore/recover at recover-point, but it fails. Exactly I've executed the first time and it works: Backup: RMAN> backup database INCLUDE CURRENT ...
0
votes
1answer
19 views

Backup files not found in ASM

I have an Oracle database 11gr2 and I have installed Oracle Grid on Oracle Linux 5.9. I have two disk groups. /etc/init.d/oracleasm listdisks : flash_recovery_area DATA The first disk group is ...
0
votes
1answer
33 views

Oracle: Create a hidden user for RMAN backups only

It's been a long time since I worked with Oracle and I can't remember whether the following is possible: I'm trying to create a hidden DBA user [ alternatively do this process as root user ] to ...
0
votes
1answer
56 views

Oracle 11.2 restore DB to a specific point

I should execute following tasks: 1. test system and during test change Oracle data and Create New/Remove Old datafiles and tablespace. 2. at the end of test rollback to behviour before of point 1. ...
0
votes
1answer
23 views

How to list files in oracle backupset

I've backupset created with RMAN, and I want to see what this set contains. How to do that?
0
votes
0answers
18 views

RMAN multilple channels

When to use multiple channels in RMAN? Is it effective only when backup is performed to multiple physical disks or tapes? I've found only that every channel is different session opened by RMAN in ...
0
votes
1answer
44 views

Oracle copy DB from one windows server to another

I am not an Oracle DBA but looking for the best approach to copy/clone an Oracle database from one windows server to another, here is my configuration and my requirements: Configuration Server 1 ...
0
votes
1answer
183 views

How to restore 11gR2 fullbackup to 12c database in rman

I need to transfer my database from Oracle 11gR2 to 12c database. It will be in same computer. I took full backup of Oracle 11gR2 database. Then I remove Oracle 11gR2. I installed Oracle 12c and I ...
0
votes
3answers
45 views

Oracle RMAN Back-up files in red hat can be read in windows?

We have performed a cold back-up of a database using Oracle RMAN. The back-up ran on a Red Hat Server and then the files were copied to a mounted external hard-drive. Can this back-up files then be ...
0
votes
1answer
66 views

Oracle: duplicate schema to another database

I want to copy an Oracle schema from a production database to a validation database. Both databases are Oracle 11g R1 standard edition and need less interrupting time as I can (but I can do if it ...
0
votes
0answers
24 views

RMAN Performance Problems following Platinum Patching on Exadata DB

I backup my dev,tst and prod databases (9 in all) to ZFS on two RAC servers on an Exadata 1/8 rack machine. Prior to quarterly patching, our backups were set up in 30 minute intervals and each ...
1
vote
2answers
51 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 ...
4
votes
2answers
221 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 ...
0
votes
1answer
358 views

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 ...
1
vote
2answers
214 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 ...
0
votes
1answer
119 views

Rman controlfile and rotation

I got an Oracle 10g server with a bash script running every night which extract each datafile and create an rman script, which is launched from the bash script itself and make backups. CONFIGURE ...
1
vote
1answer
132 views

Can we restore backup for standby from external hard drive with differnet drive labels

I am using windows server 2003 and Oracle database 10g R2 and i have taken the backup using RMAN of my primary database in Drive label E. The size of backup is 1.5TB. In my standby database i don't ...
1
vote
1answer
308 views

Can we migrate oracle database 10gR2 to cross platform

I want to know can we migrate Linux based oracle database 10gR2 (10.2.0.1.0) to windows server 2003 with oracle database 10gR2 (10.2.0.3.0). I have seen the documentation related to database migration ...
1
vote
1answer
99 views

Error while duplicating Oracle database after failover, using 11.2.0.4

I've recently updated oracle from version 11.2.0.1 to 11.2.0.4 and my redundant system is no longer able to recover from failover. I'm using scripts both on primary and standby node to get back to a ...
3
votes
1answer
115 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 ...
0
votes
2answers
195 views

Can we take Backup on Disk and Tape at same time by RMAN?

I'm trying to take backup by RMAN. I want to know can we take backup of database on disk and tape at same time by using RMAN? If yes then please share some documentation Or if no then please give the ...
1
vote
1answer
368 views

can't backup 11.2.0.2 database after catalog upgrade to 11.2.0.4

(main question is 4th) 1. We today have almost all databases running with Oracle 11.2.0.2. Actually we have an RMAN database created (in 11.2.0.2) and a Catalog with user (called RMAN112) 2. We are ...
0
votes
1answer
72 views

Exadata RMAN vs. Non-Exadata RMAN - any differences?

Can you please let me know the differences, if any, in the architecture of the non-Exadata RMAN vs. that of the Exadata-RMAN from an SBT plugin perspective? Have you observed from your vast ...
0
votes
1answer
150 views

What does “copy of” mean when doing “delete archivelog”?

Disclaimer: I'm not a DBA nor did I fully read the RMAN docs cover to cover, so this may be well covered, but I couldn't find it. The question is very simple, what is the difference between these two ...
0
votes
0answers
50 views

Error While Restoring Standby Database from RMAN Backup of Primary Database

My Standby Database was corrupted. So i took primary database backup using RMAN. Transferred to my standby database. On standby, on startup nomount, restored standby control file then on mount stage, ...
0
votes
0answers
74 views

Error While Restoring Standby Database from RMAN Backup of Primary Database

On standby database i got error while restoring rman backup of primary database. Some targets not found. ORA 06100 no channel to restore a backup or copy of datafile datafile_number
0
votes
0answers
89 views

duplicate/restore a prod database to a test with RMAN

we have RMAN using RMAN CATALOG and takes backup to TSM Tape! what is the standard method to clone/copy/restore a database to a new host with a new instance name? I just need the RMAN script, I ...
0
votes
2answers
2k 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 ...
0
votes
2answers
49 views

Reinstall Oracle 11G2

Running Oracle 11GR2 instance (non-ASM). Plan to set it up again from the scratch(this time using ASM, Grid infrastructure). And I need the present database. I am thinking of the simple plan: 1) ...
0
votes
0answers
211 views

RMAN error RMAN-06207,RMAN-06208,RMAN-06210,RMAN-06211,RMAN-06212,RMAN-06213,RMAN-06214

I have this issue with around 7 servers, we have an RMAN job that takes backup and validate the backup ... here is RMAN settings: RMAN> show all; RMAN configuration parameters for database with ...
0
votes
2answers
761 views

How should I use RMAN clone refresh using set until time?

I am using this technique to refresh dev. environments with production data. The business process is to request a tape hold for the full backup I want to use for a clone refresh to dev. Once this is ...
1
vote
2answers
1k 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 ...
0
votes
1answer
174 views

Does restoring an Oracle backup of the whole database restore schema objects?

I used RMAN with, RMAN>backup database archivelogs all; After that I truncated a table. I then tried to restore with, RMAN>restore database; RMAN>recover database; RMAN>alter database ...
0
votes
1answer
499 views

RMAN backups, incremental, not compressed: estimate size?

We´re setting up RMAN to backup a database over NFS and ZFS, for which I have to create shares and mounting points (4 shares in my case). I am trying to anticipate the size of the shares, which ...
1
vote
1answer
131 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 ...
2
votes
0answers
534 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 ...
0
votes
0answers
221 views

Archive log backup error and backup completed with errors

My prod DB backup completed with errors stating the below error. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ...
1
vote
1answer
1k views

RMAN rename datafile created in an archivelog

I'm trying to restore an Oracle database (11.2.0.4.0) to a test system with a different file layout. The production database is being backed up using RMAN, no catalog. We do a full backup of all the ...
0
votes
1answer
50 views

What is meant by the RMAN Duplicate “noncurrent point in time”?

When doing a RMAN DUPLICATE from backup connected to the target, how current does the duplication make the database when no until time is set? The closest thing I can find in the documentation is the ...
0
votes
2answers
1k 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.
0
votes
1answer
3k views

ORA-15081: failed to submit an I/O operation to a disk

I have a test environment for Oracle single instance on ASM 11.2.0.3. I have restored database from tape and during the recovery, the system crashed by some I/O error. I restarted the server, ...
0
votes
1answer
382 views

Recover data from bak Oracle 9i file

Our customer gave us a .bak archive with name file_decrypted_379299.bak which we know was created with Oracle 9i in "hot" style. We tried to recover the bak file with Oracle 9i RMAN but we don't know ...
1
vote
0answers
3k views

Oracle restore backup on other server

I have following situation: One server with Oracle has to be backed up and recovered on other Oracle server. Second Oracle DB has the same user/schemas, but with a different older data. I intend to ...
0
votes
1answer
77 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
3k 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
238 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
11k 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 ...