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 backup partitions

I have some partitioned tables based on the date of insertion of row. I want to take back up of only a select partitions from the database using RMAN. Is that possible ? After taking the backup, can I delete those partitions from the database.
user2531191
  • 579
  • 10
  • 27
0
votes
1 answer

Oracle: why do I have to connect to target database for backup?

This is possibly a stupid question. I have a "flash recovery area", with a BACKUPSET and a AUTOBACKUP folders containing .bkp files. The rman documentation says that I have to connect to the "target" database, which should be "the database to be…
Pazvante
  • 1
0
votes
2 answers

How to restore via RMAN?

I want to backup via RMAN and delete scott.dept and again restore everything. (this is for testing RMAN mechanism) I wrote like this : 1)rman target sys/manager@db 2)in sql*plus shutdown immediate; startup mount exclusive; ALTER DATABASE…
Freeman
  • 9,464
  • 7
  • 35
  • 58
0
votes
1 answer

how much time does it take to backup 100gb database with RMAN and expdp?

how much time does it take to backup 100 GB database with RMAN and expdp? I want to take backup of the system before applying the partitioning activity. In case of error, backup data restore immediately.
Mayur Sawant
  • 51
  • 1
  • 7
0
votes
2 answers

Restoring RMAN backup to another instance: database name in control file is not instance name

I've been tasked with developing an Oracle 11g backup/restore strategy for some remote instances. My goal is to have one script that will backup the instance, which I will be able to use with an existing instance (possibly on the same server) or…
stackptr
  • 167
  • 1
  • 2
  • 10
0
votes
2 answers

use java to make severals cmd commands

Hi i'm trying to make a backup using rman from java, im trying using a Runtime from java, im able to open the cmd, access rman but after that any other query i try to submit is executed. im able to access rman from cmd window and sqlplus window i…
MaynorSong
  • 630
  • 7
  • 15
0
votes
1 answer

Jenkins job stuck running a .bat file trough on a remote ssh server(windows 2008 R2)

I have a jenkins setup running on solaris. I have configured a job which runs a .bat file, using the jenkins ssh plugin, on a remote Windows 2008 R2 server having an oracle database. The .bat files does an RMAN restore in the oracle Database. I have…
KVD
  • 1
0
votes
2 answers

Is this a valid way to use the Oracle Recovery Manager with the Oracle Job Scheduler?

First, I am creating an executable job: BEGIN DBMS_SCHEDULER.CREATE_JOB(job_name => 'PIPE_JOB', job_type => 'EXECUTABLE', job_action => 'RMAN PIPE TEST_PIPE_1 target / TIMEOUT = 60'); END; Next, I am trying to execute the job with this series of…
Raggedtoad
  • 511
  • 2
  • 8
  • 24
0
votes
1 answer

Refreshing tablespace using RMAN incremental backup from one DB to Other

If I have two DB's having same database structure and every schema has its separate tablespace then can I use RMAN to take tablespace level backups and apply them on other DB's tablespace? Example: say I have DB schema 'scott' which have been…
Ahmed
  • 1
0
votes
2 answers

Oracle and rman recovery catalog

I have been handed an oracle database (10.1.0.5.0) with no documentation and very little rman information and I need to change the existing the backup location drive for rman backups. Before I do that I want to check if the database has a recovery…
sotn
  • 1,833
  • 5
  • 35
  • 65
0
votes
1 answer

error while backing up oracle database using rman

I have a RMAN backup of 11G Release 1; the backup is full backup mean it includes control file, datafiles and archivelogs. The database name is ORCL and OS is windows XP. Now I want to restore this backup on new machine, the new machine is also…
Tanmoy Nandy
  • 1
  • 3
0
votes
1 answer

Hot backup DB script understanding

I'm currently learning what hot backup is on an ORACLE guide which present a generic script for hot backup. I dont understand some point of this script : PROMPT Path to destination directory: ACCEPT repertory PROMPT Path for first file ACCEPT…
WizLiz
  • 2,068
  • 5
  • 25
  • 39
0
votes
2 answers

error while backing up oracle database using rman

This is how i was trying to backup a database without logging in the oracle 10g database.Can anybody please tell me why am I getting this error and how should I try to solve it? Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001…
Apurva Patil
  • 999
  • 1
  • 8
  • 10
-1
votes
1 answer

RMAN Backup Compression

SQL Server has built-in database backup compression. Is there an easy way to compress RMAN backups? Does it work well? Is restoring from a compressed backup straight forward? Is it even recommended? Thanks.
Darrell
  • 3
  • 3
-1
votes
1 answer

how to take incremental backup of 5 specific tables in a oracle database using RMAN

i have to take incremental backup of 5 specific tables in a oracle database...i cannot use data pump api as it doesn't support incremental backup...in recovery manager(RMAN) the backup is taken of whole database but i want to have backup if data…
Missile Man
  • 1
1 2 3
…
10
11