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 show error RMAN on replication

When I started run this RMAN script run { allocate channel prmy1 type disk; allocate channel prmy2 type disk; allocate channel prmy3 type disk; allocate channel prmy4 type disk; allocate auxiliary channel stby type disk; …
Meqenaneri Vacharq
  • 99
  • 1
  • 1
  • 12
0
votes
1 answer

Execute an RMAN script via PL/SQL

For the last few Oracle versions, I've launched RMAN scripts via PL/SQL using "PA_UTIL.pr_ExecOsCommand". Now, I wonder, is there a more efficient way? I see some people are recommending to use PIPE, but I've haven't found a usable example so…
Eli Abramson
  • 119
  • 1
  • 11
0
votes
1 answer

restoring rman backed up files on windows machine

I have rman backup database in oracle 10.2.0.1. I took this back up on linux machine. After backup is done, I have got 4 files for my database including log files etc. I copied those files on my windows machine. Their, on windows machine, I want to…
Vallabh Naik
  • 1
  • 1
0
votes
1 answer

Oracle DB: Convert String(Time stamp) into number(minutes)

So, I am trying to build a query in RMAN Catalogue ( using RC_RMAN_BACKUP_JOB_DETAILS) to compare the most recent backup duration (TIME_TAKEN_DISPLAY) for each database (DB_NAME) with its historical average AVG backup duration…
shubhammakharia
  • 147
  • 1
  • 2
  • 10
0
votes
1 answer

incremental RMAN backups not rolling forward

We just switched from using datapumps over to using incremental backups with RMAN. I've been having issues with the incremental backup pieces rolling forward. Here are my scripts for the backup: BACKUP device type disk incremental level=1…
Adam Blomeke
  • 113
  • 2
  • 10
0
votes
1 answer

How to connect to RMAN in Java?

I don't know how to connect to RMAN in Java. Simple request don't work when I use command non-SQL, like RMAN etc... I'm gonna to make program like "ORACLE Secure BackUP", but how they connected to RMAN??
Mario Tim
  • 1
  • 1
0
votes
1 answer

RMAN error during auxillary backup

I am getting ORA error while doing Auxillary cloning for database from two different server using RMAN backup while using below command:- duplicate database to "HFSDBRED" backup location '/orabackup/RMAN/HFSDBRED_BKP' nofilenamecheck set…
Abhinav
  • 314
  • 2
  • 12
0
votes
1 answer

multiple control files to restore in oracle

I should restore oracle backup to my host, I have three control files as you can see blow : c-1295819063-20170920-00 c-1295819063-20170920-01 c-1295819063-20170920-02 I will be pleased if you could help me to select correct control file to…
user188927
  • 13
  • 1
  • 6
0
votes
1 answer

for db recover process testing, unable obtain the query o/p using shell script

I have written shell script as: #!/bin/bash #shell script for recovery testing $ORACLE_HOME/bin/rman target/ <rman.log shutdown immediate; startup mount; run { recover database; } …
Gyan Bahadur Tamang
  • 21
  • 2
0
votes
1 answer

RMAN log update in real time

I am using below code in a script and running them in automated fashion #!/bin/bash rman "user"/"xxx"d@rman target=/ | tee run1.restore.log run { allocate channel ch1; restore database; switch datafile all; recover database; } Now the problem is…
Ajay Singh
  • 125
  • 1
  • 1
  • 11
0
votes
0 answers

Oracle rman archive aren't deleted

I created a physical standby to our primary. I used duplicate from backup to preform this duplicate. The duplication process took rman 12 hours. After the duplicate finished I configured the broker. Then I realized that I have a transfer lag because…
JeyJ
  • 3,582
  • 4
  • 35
  • 83
0
votes
1 answer

Retention Policy with RMAN Incremental Backups

I've configured RMAN Incremental Backups on my Oracle 11gR2 test database machine running on windows environment. I've set retention policy to recovery window of 7 days. On Sunday I take level zero incremental backup as follows: run { HOST…
Ahmed Faraz
  • 118
  • 1
  • 16
0
votes
1 answer

Finding DB information from RMAN catalog database Recovery Catalog views

I need to find the following 4 pieces of information about a target DB (version 11.2.0.4) from the RMAN database RC views: Number of DB datafiles Number of DB tempfiles Oracle Version of the registered DB The host that the registered DB resides…
Franco
  • 23
  • 1
  • 8
0
votes
1 answer

oracle database 12cR1: Tablespace point in time recovery is failing on the export metadata level

I have a problem using TSPITR to restore a single tablespace. the error stack showed the following: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS…
Wissam HANNA
  • 63
  • 14
0
votes
1 answer

RMAN backups error while creating full & incremental backups

We have our oracle instance running on windows server & when configured RMAN to take the backups we are seeing following error in the logs, Error Details: channel ch1: starting piece 1 at 07-MAY-17 channel ch1: finished piece 1 at 07-MAY-17 piece…
Siva Dasari
  • 1,059
  • 2
  • 19
  • 40
1 2 3
…
10 11