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

Location of RMAN backup

I have two servers. One is DB server another is RMAN Catalog DB server. From my RMAN Catalog, I connect to my remote DB server and I run the backup. Where will the backup files be stored? Will it be ...
0
votes
1answer
11 views

RMAN archivelog backup in Oracle 11gR2

I use below command to do RMAN backups on rhel 5.9, but archivelog backups always ends up in $ORACLE_HOME/dbs Backup as compressed backupset database plus archivelog format '/path' How to use ...
0
votes
1answer
16 views

ASM RMAN BACKUP FAILED

I'm trying to migrate a filesystem to ASM but when I start with RMAN backup, I face the following error, which is weird because I haven't performed any backups before on the same database. RMAN> ...
0
votes
1answer
29 views

what exactly does an RMAN backup do?

I have a database with multiple schemas and data in the tables. I create an rman backup and backup archivelogs. I drop 90% of the tables. I do rman restore and recovery with controfile from ...
0
votes
1answer
23 views

RMAN catalog database

I'm about to create a RMAN catalog database for my setup, what are the general precautions or major pre-requisites as in DB parameters, compatibility,etc that I should take care while creating the ...
0
votes
1answer
28 views

restoring database using RMAN [closed]

if i have new data like new users and tables created after backing up database with RMAN , in case of restoring database will the operation affect my new data made after taking the backup ?
0
votes
0answers
64 views

scipt for rman configuration & database backup in dataguard environment

environment Oracle Solaris 10 -> 5.10 Generic_147147-26 sun4v sparc Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit production Oracle Solaris Cluster 3.3u2 for Solaris 10 sparc ...
0
votes
1answer
49 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
286 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
31 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
67 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
30 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
83 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
63 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
32 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
82 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
537 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
68 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
141 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
46 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
56 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
279 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
718 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
564 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 ...
1
vote
1answer
193 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
143 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
392 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
128 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
173 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
271 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
489 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
88 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
227 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
57 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
80 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
112 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
54 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
1answer
249 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
1k 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
2k 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
188 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
588 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
170 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
621 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
272 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
2k 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
57 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.