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
8
votes
5 answers

Backup/Restore database for oracle 10g testing using sqlplus or rman

Using Oracle 10g with our testing server what is the most efficient/easy way to backup and restore a database to a static point, assuming that you always want to go back to the given point once a backup has been created. A sample use case would be…
crackity_jones
  • 1,077
  • 2
  • 13
  • 16
5
votes
1 answer

rman script with parameters

I was trying to pass the backup location to the rman script dynamically as below. But it fails with syntax errors. Is there a way to pass the "/backup/folder/folder/" to the rman script? If I just pass string without "/" it works but with "/" it…
user1595858
  • 3,700
  • 15
  • 66
  • 109
4
votes
3 answers

Restoring RMAN Oracle 10g Backup in Oracle 11g

I have the RMAN full database backup of oracle 10g (10.2.0.3) on Sun Solaris OS which I want to restore on oracle 11g (11.2.0.3) on Linux OS. The backup pieces were transferred to the oracle 11g server manually in binary mode. The Oracle 11g is…
Harsh
  • 49
  • 1
  • 5
4
votes
4 answers

change database name controlfiles after restore?

I have restored database with the name DB to another database called DB01 it is in STARTED status (not mounted) and it seems I can not change the name if it is not mounts, and I can not mount it because of the name, how to solve this issue if…
Data-Base
  • 8,418
  • 36
  • 74
  • 98
2
votes
3 answers

Oracle Database RMAN Backup not Restoring Tables or Users

I am trying to backup an Oracle 19c Database using RMAN but I seem to be running into a few hiccups. What I did first was create test tables and users in the database before backup. Within RMAN I then ran RMAN> BACKUP DATABASE PLUS…
Bobby Bob
  • 31
  • 1
  • 5
2
votes
2 answers

Bash store result of a command in a variable and print it to the console while using here documents

I'm running rman commands from Bash scripts. I pass my commands to rman using here documents. I want to capture the output but also at the same time print it to the console (real-time). I found this solution, but I don't how to make it to work with…
damian
  • 316
  • 3
  • 7
  • 23
2
votes
2 answers

How to import a Oracle 11g RMAN backupset on a new database server?

I have got a backupset of an Oracle 11g database which was created with RMAN. Now I want to import/restore the backupset onto a new and empty database server. I know that the command to create the backupset was run { backup as compressed backupset…
blerontin
  • 2,892
  • 5
  • 34
  • 60
2
votes
2 answers

How to prevent Oracle archived redo log from filling up database server disk?

My database server's disk is getting full really quickly with archive files. The size of the database is around 60Gb and I have about 30 Gb of free disk. Problem is, the 30Gb get used by archived log in about a week even though my retention policy…
Beto
  • 132
  • 2
  • 12
2
votes
1 answer

RMAN Restore generates an RMAN-06172

First time working with RMAN, and I'm having trouble doing a restore following the backup. Here's what I'm doing: C:\>rman target / First, let's start with a delete backup just to clear the slate... Then I run backup database; Result: …
Adam Blomeke
  • 113
  • 2
  • 10
2
votes
3 answers

Oracle RMAN big-endian to little-endian

I have an Oracle RMAN backup that was created on a Solaris SPARC box and is therefore in big-endian format. I wish to restore this backup to a Windows x86-64 based machine but have hit a roadblock due to the endianness issue. I have read on…
A. Murray
  • 2,761
  • 5
  • 27
  • 40
2
votes
3 answers

RMAN connect error - db reporting incompatible target version

I'm trying to use RMAN to backup an Oracle database without a backup catalog. When attempting to connect to the target database I'm getting an error message that my RMAN version is incompatible with my database version. This seems odd to me as my…
Lee Greco
  • 743
  • 2
  • 11
  • 23
2
votes
2 answers

Oracle SCN clarification

I would like to know why I am getting different SCN number for the below quires SELECT TIMESTAMP_TO_SCN(SYSDATE) FROM DUAL - I USE this for POINT IN TIME RECOVER FOR TABLESPACE . SELECT CURRENT_SCN FROM V$DATABASE. - I use this for Database…
user961532
  • 87
  • 9
2
votes
1 answer

How do I manage automatic backups with oracle?

I'm following the tutorial from oracle docs. And I see that the preferred way to manage the backup/recovery processes is by using RMAN. I've started practicing with it (I mean, by sql*plus cli). But I really don't see how I can automate the…
Endrik
  • 2,238
  • 3
  • 19
  • 33
2
votes
2 answers

Running RMAN Scripts with the job scheduler (Oracle)

Here's a good one for any Oracle gurus out there. I'm working on a web page that dynamically configures Oracle DB backup settings in a closed environment. Right now, I have everything set up to generate scheduled jobs that run pre-determined RMAN…
Raggedtoad
  • 511
  • 2
  • 8
  • 24
1
vote
2 answers

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 ORACLE_HOME from variables. edit: Found some links with…
radu florescu
  • 4,315
  • 10
  • 60
  • 92
1
2 3
…
10 11