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

learn more… | top users | synonyms

1
vote
2answers
413 views

RMAN 11g/12c Client compatibility

I'm having a Recovery catalog database 12c version. While I'm trying to register the target database (11g) with the catalog I get the following error: Recovery Manager: Release 12.1.0.2.0 - ...
1
vote
2answers
60 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> ...
1
vote
2answers
2k 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
2answers
2k 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 ...
0
votes
1answer
40 views

Backup and Restore with RMAN Oracle 12c

I'm trying using RMAN to create and restore backups. I'm getting an error stack trace when trying to restore to one of the backups that I have made. The error is RMAN-00571: ...
1
vote
1answer
2k 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 ...
0
votes
1answer
229 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 ...
4
votes
2answers
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 ...
0
votes
0answers
41 views

ORA-01180 when restoring the database [duplicate]

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> ...
1
vote
3answers
58 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 ...
3
votes
2answers
67 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 ...
5
votes
1answer
34 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 ...
0
votes
1answer
26 views

Restoring ORACLE 11gR2 database with Flash Recovery Area Only

I was succeded in making backup using RMAN in Archivelog mode in my host server and this is the screenshot when i list the backup, and the next step, i copy content from Flash Recovery Area folder ...
1
vote
3answers
136 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
55 views

unable to connect to specific instance ORacle RAC

I did several operations by connecting successfully to all 4 instances but suddenly during one of the jobs, it failed with a TNS error. I checked the connect from SQL and one of the nodes is giving an ...
0
votes
1answer
64 views

Oracle 11 rman db restore file corruption

First to mention that I came to the need of asking help after furious research I reattempts for about 3 weeks. I checked previous threads in Oracle community but nothing works for me. I am trying to ...
0
votes
1answer
50 views

Oracle rman db restore [duplicate]

First to mention that I came to the need of asking help after furious research I reattempts for about 3 weeks. I checked previous threads in Oracle community but nothing works for me. I am trying to ...
0
votes
1answer
60 views

Backup an Oracle database to NAS

I have an Oracle database (11.2.0.4) on Oracle Linux 6.7. I want to backup this database with rman to a folder on a NAS (network attach storage). How can I do this?
1
vote
1answer
97 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
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.
0
votes
2answers
536 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 ...
1
vote
2answers
134 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 ...
3
votes
1answer
68 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 ...
0
votes
1answer
47 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
2answers
210 views

Drop datafile without dropping a tablespace in Oracle 11g

I was trying to take backup of database in Oracle 11g by using RMAN $ rman target / Recovery Manager: Release 11.2.0.1.0 - Production on Fri Sep 11 10:14:37 2015 Copyright (c) 1982, ...
1
vote
1answer
113 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 ...
0
votes
1answer
433 views

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

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
37 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 ...
3
votes
1answer
52 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 ...
0
votes
2answers
90 views

Understanding RMAN Backupset

I feel a bit confused when I read about RMAN! what are the differences between: RMAN> backup as backupset RMAN> backup database; RMAN> backup database plus archivelog; RMAN> backup ...
3
votes
3answers
129 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 ...
0
votes
1answer
2k 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
1answer
43 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
50 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
81 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
50 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
98 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
386 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 ...
1
vote
1answer
367 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 ...
0
votes
0answers
304 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
45 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
851 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 ...
2
votes
1answer
725 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 ...
1
vote
1answer
221 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
34 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
201 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
73 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
46 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
23 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
244 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 ...