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
1
vote
1 answer

RMAN backups only get larger and don't delete

I’m having some problems with my RMAN backups. Sorry if this is a basic question but I have little experience of RMAN backups. The RMAN script and backup process was set up by the person who originally installed the DB. It is supposed to do an…
Joe
  • 11
  • 1
  • 3
1
vote
0 answers

Restore Oracle with RMAN for unknown database

I was given a set of files (one file with extension .arc and others with .bas). These are Oracle backup files produced by RMAN utility. Now I need to restore these files to a new Oracle instance. Got no idea how to do that after searching for…
Hillman Li
  • 63
  • 5
1
vote
2 answers

rman : how to only restore a tablespace (without recovering)?

I have 2 tablespaces which I want to backup when they are in a consistent state (let's say T0). When problems occur (T1), I want to be able to restore both tablespaces to their state at T0 without recovering all changes that occured between T0 and…
user3488996
  • 1,339
  • 2
  • 10
  • 13
1
vote
1 answer

specification does not match any backup in the repository

i want to delete arhcivelog on my DB oracle. RMAN> list backup of archivelog all; specification does not match any backup in the repository it seems there is not any of them. but the recovery area is not empty. SELECT * FROM…
Ron
  • 553
  • 2
  • 10
  • 30
1
vote
1 answer

if an oracle datafile gets too big for the directory what does one do

if I have a datafile in a directory and it is getting too big for the directory what command in Oracle can I use to move that file, or do I make another datafile into another directory? ALTER TABLESPACE users ADD DATAFILE …
Mark
  • 31
  • 1
  • 2
  • 5
1
vote
1 answer

What do I need to apply an RMAN backup from one server to another

Right now I have been givin a controlfile some backupfiles and an spfile.ora How do I apply these to a database on a server that is not the one they were created from. If further info is needed please let me know. I am eager to get this process…
Werbel
  • 113
  • 1
  • 2
  • 15
1
vote
1 answer

RMAN not working in Crontab

I have a cronjob scheduled to be executed every morning at 1.25 am. The script suppose to delete the archive logs created in Oracle DB for the previous day. But it is not executing as expected. But when I execute it manually in the command prompt…
user1793864
  • 241
  • 2
  • 6
  • 13
1
vote
1 answer

Oracle: changing the DB_RECOVERY_FILE_DEST without pre-existing folder?

I'm working on a web interface for modifying Oracle database backup settings. One of the options I want to give users is where to set the flash recovery area. As far as I know, the only way to change this is by executing something like: ALTER SYSTEM…
Raggedtoad
  • 511
  • 2
  • 8
  • 24
1
vote
2 answers

Linux Cronjob scheduling issue

I have a cron job scheduled as below.what it will do is invoke RMAN in Oracle and then clear all the achivelogs in the oracle database which are 1 day old. But the issue is that it is not getting executed through the cron job. but if I execute the…
user1793864
  • 241
  • 2
  • 6
  • 13
1
vote
2 answers

Unable to Recover Corrupt Oracle Datafile Block In SysAux

Oracle 10g on Suse 9.1 I'm looking after an Oracle DB. I have good SQL skills but I'm no DBA, (a diffence in job roles I have difficulty explaining to my non-IT savvy bosses!) I know enough to get Oracle up and running and put in place it's…
javadeveloper
  • 49
  • 2
  • 6
1
vote
1 answer

Oracle 10g XE: rman shows all datafiles need backup after successful full backup

I'm having a problem with Oracle 10g XE, version 10.2.0.1 running on openSuSE 11.2. RMAN is showing that all datafiles need to be backed up, even after a successful full backup: RMAN> report need backup; using target database control file instead…
ajchace
  • 11
  • 2
1
vote
1 answer

How to SNAP before RMAN in deCarta DDS?

Some of my routes don't work because the deCarta DDS doesn't find any arc near OLL and/or DLL and the server answers: RMAN|%S=Cannot find path origin%N=0|| How to make the server search a nearby arc (SNAP) and do the route (RMAN) in a single…
Jader Dias
  • 88,211
  • 155
  • 421
  • 625
0
votes
1 answer

What is the data layout of an RMAN file?

I would like to know the on disk format of an RMAN backup file. Is this documented anywhere?
user605957
  • 2,489
  • 6
  • 25
  • 33
0
votes
1 answer

save rman backup log files to networked location

Have tried spooling, have tried command line notation: log \\networked_location\rman.log Nothing works to get rman to save its own log files to a networked location. can save them online within the db it is backing up, but want to save then with…
Michelle Daniel
  • 165
  • 2
  • 12
0
votes
0 answers

Error: RMAN-06172- Failed to recover oracle DB from RMAN backup files of another oracle DB

I'm trying to recover oracle DB (v11.2) in ubuntu server using rman backup that is taken from the database in the old host but failed with error: RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece. The RMAN backup has…
Ahmed Adel
  • 1
  • 2
1 2
3
…
10 11