Stack Overflow
Stack Overflow

Questions tagged [rman]

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

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:

153 questions
0
votes
1 answer

Oracle rman simple backup on 11g

This question is almost exaclty like oracle rman simple backup but there isn't an acceptable answer there, and this question is about 11g. So I'll ask: I'd like to do some table initialization DDL tests on an oracle shema, and I'd like to revert…
Chris Knoll
  • 391
  • 2
  • 13
0
votes
2 answers

How to over come error on RMAN

I am getting following error in RMAN:- Starting backup at 18-NOV-15 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile copy input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf RMAN-03009: failure of backup…
Sanjeev
  • 21
  • 1
  • 7
0
votes
2 answers

Restore Backup with RMAN Oracle11g

after a crash of my database, i try to restore my backupset. 1. Create a new Database with the same name as the old database 2. Set the flash_recovery_area to the folder where the backupset from the old database is stored 3. rman -> connect target /…
Kohli
  • 5
  • 3
0
votes
1 answer

run Oracle RMAN scripts as a single entry

I want to run an oracle online backup through the rman setup in 12c. I have 3 scripts that need to be run and they are: rman target sys@[db_name]/[db_password] nocatalog configure channel device type disk clear; RUN {   ALLOCATE CHANNEL c1 DEVICE…
B-M
  • 1,231
  • 1
  • 19
  • 41
0
votes
1 answer

Oracle: cannot start DB becuase DB name in control file came from restored source DB

Oracle version 11.2.0.3. I restored a dev DB from Prod, then i got the following error after partially restored the DB. I cannot open the DB even in mount. ORA-01103: database name 'PROD_DB' in control file is not 'DEV_DB' The restore errors are…
dave
  • 296
  • 1
  • 12
  • 26
0
votes
0 answers

Scheduling a backup recovery in oracle 11g

I'm trying to schedule a backup recovery to my oracle 11g Database, I use the above script with the windows task scheduler : rman target/ run { shutdown immediate; startup mount; backup incremental level 0 database plus archivelog delete…
Amine
  • 225
  • 3
  • 13
0
votes
1 answer

RMAN Restore backupset from tape to disk

I am trying to restore a backupset tag from tape to disk, because I need to recover on another location (development environment). The datacenter backups are made using Netbackup and I dont have access to it. So, I am trying to restore through…
dpreviatti
  • 1
  • 1
  • 1
0
votes
1 answer

Different backup location for DUPLICATE command

I am trying to clone a database from one machine to another using the DUPLICATE command in RMAN. For both machines the OS is Windows 2003 and the database software is 10.2.0.3. The problem is that my clone only has a C:\ drive and my hosts backups…
Leigh Riffel
  • 6,381
  • 3
  • 34
  • 47
0
votes
1 answer

Generating RMAN scripts using Enterprise Manager and automating them using chron jobs

I am newbie to Oracle DBA, the programming world in general. I have been exploring some database backup and recovery options for my databases and despite the wealth of information there is available for Oracle, I am quite lost. Background: I have…
Pkhimsara
  • 1
  • 1
0
votes
2 answers

Error while duplicating Oracle database after failover, using 11.2.0.4

I've recently updated oracle from 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 state where it is possible to install them as a redundant…
Magnus
  • 198
  • 1
  • 1
  • 11
0
votes
0 answers

ORA-29532: Java call terminated by uncaught Java exception: java.lang.IllegalThreadStateException: process hasn't exited

I am executing a stored procedure in order to perform some nightly maintenance on the database. Which is Oracle 11.2.0.3.0. The procedure uses RMAN to perform a daily backup, the backup finishes but I get the error: ORA-29532: Java call terminated…
David Faizulaev
  • 4,651
  • 21
  • 74
  • 124
0
votes
1 answer

RMAN full backup until specific SCN

Is it possible to do a full database backup with until specific SCN using RMAN? For example, I know there are SCNs numbered 10002, 10003, 10004, 10005, and so forth. Can I take a database backup until SCN 10004 using RMAN?
mao
  • 11
  • 2
0
votes
1 answer

RMAN duplicate Target

I would like to know if RMAN DUPLICATE DATABASE command restore a database on another host to the most recent time of source? Or while Duplicating it freezes source database datafile headers and then start duplicating and if I would be missing few…
AdOracle
  • 1
  • 1
0
votes
1 answer

Oracle Rman configuration parameter

i was backing up the control file though RMAN. i put the database in mount mode and take the backup of controlfile . i configure the controlfile autobackup on.by default it was off. after taking the backup. when i open the sqlprompt and put…
prateek
  • 41
  • 1
  • 3
0
votes
0 answers

Backup oracle 11g XE user

I'm using Oracle 11g XE and I want to make a backup for the database that I'm working on it using RMAN, the command "Backup Database" backing up the whole database, with all its users. Is there a way to backup only the user that I'm working on,…
MedYasser.alkahf
  • 215
  • 4
  • 14
1 2 3
…
10 11