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

Two Oracle RMAN Backup between an EOB

I need to take two backups before and after the day end process. If the EOD process starts at 10.00 p.m. The backup should contain all the data right at 10.00 p.m. before starting the EOD and the backup process should not impact the EOD process as…
DB-Newbie
  • 25
  • 4
0
votes
2 answers

Rman bash script with cronjob

i have a rman bash script which works when i execute it (./backup.sh). but when i use cronjob, it doesn't work. My scripts is as follows backup.sh rman target / @backup.rcv log=rman.log backup.rcv backup format '/backup/rman/backup/%U.arch.rman'…
nagixoj508
  • 25
  • 6
0
votes
0 answers

RMAN does not delete archive logs not applied on GG Downstream

There is an issue in a topology of 3 hosts. Primary has a scheduled OS-task (every hour) to delete archive logs older 3 hours with RMAN. Archivelog deletion policy is configured to "Applied on all standby". There are 2 remote log_archive_dest…
WareNick
  • 1
  • 2
0
votes
0 answers

Migrate the database from the windows server to the Linux server from different versions 11g to 19c

We need to migrate the database from the windows server to the Linux server from different versions 11g to 19c. Source: Oracle Product Version:11.2.0.4 Operating System: Microsoft Windows x64 2012 R2 Database Size:1.5TB Target: Oracle Product…
ram kumar
  • 7
  • 3
0
votes
0 answers

Recovery of audit trail in Oracle database

If Audit_trail parameter is enabled and location of the auditing has been set to a different tablespace which was manually created. someone mistakenly dropped that tablespace. Is there any way to recreate the db objects like aud$ table…
Satyam Kulshreshtha
  • 5
  • 2
0
votes
1 answer

Is it possible to apply archivelogs from standby DB to Production DB?

I've lost two hard disks yesterday . One contains an Oracle Datafile and another contains part of archive logs generated in the past 2 days. (say, arch_5.dbf and arch_6.dbf are lost, in the set of arch_1 to arch_10). I have switched over to my…
Sundar Kannan
  • 41
  • 3
0
votes
0 answers

backup copy of Oracle DB-server

Dears, I manage an Oracle DB with multiple tables that contains hundreds of millions of records with limited retention time ( telco-CDRs ). I plan to make a backup copy of the DB-server but I don't need to include the records in the backup. this…
Abdulla Ibrahim
  • 1
0
votes
2 answers

How to completely restore Oracle DB using RMAN

I have an oracle 19C database I needed to upgrade for a test application. Before I ran my database upgrade scripts, I used RMAN to make a backup using the following steps: shutdown immediate; startup mount; alter database archivelog; alter database…
MansaSeyi
  • 11
  • 2
0
votes
1 answer

RMAN - Extra Item Created in Backup

For development purposes, I have started to use RMAN to take backups of an XE database I have. When I back the database up using RMAN, it is adding an additional item onto my backups. In the images attached, you can see that my intended backups are…
TMcMaster
  • 3
  • 2
0
votes
2 answers

Oracle RMAN can I configure retention policy per database?

I want to know if I can configure retention policy per database? I have several databases, about 100 and I need a different retention policy for each database. Is that possible? If possible, How do is see the retention policies per database? SELECT…
sachin at tekbuds
  • 1
  • 3
0
votes
1 answer

Is there a way to run a .NET Core Service that uses OS authentication to run RMAN backups as systemd?

I have a service set up in C#/.NET Core and part of its functionality is to launch RMAN for Oracle at a specified time each day. These functionalities all work perfectly running as the Oracle user but not as root or running as systemd(even if I…
joshua parshall
  • 1
0
votes
0 answers

Oracle Change Backupset Command

I am trying to enable a backupset. This backupset physically exists on disk along with other backupsets. I am issuing following command which results in a error: RMAN> change backupset 4882 available; using channel ORA_DISK_1 using channel…
Arvind Mishra
  • 11
  • 3
0
votes
1 answer

Temp and Undo in Cloned RMAN database are not changing according to the new database

I cloned a Database using RMAN from one to Another. The clone was successful but the issue is that the temp file and location of tempfile is not changing according to the new database. Same is the issue happening with Undo datafile. What is the…
Ravish Ranjan
  • 11
  • 1
  • 3
0
votes
2 answers

RMAN backup is failing with write error on file

I am trying to take a level 0 incremental backup of my database on a linux server. backup incremental level 0 database; When I run it I get RMAN-00571: =========================================================== RMAN-00569: =============== ERROR…
olivia.dayaram
  • 59
  • 12
0
votes
1 answer

oracle online recovery does not change archived db

created db with dbca choosing asm, fast recovery area, archived mode. Now I want to backup it preform some tests that would change the content of the db and If need comes then recover it from the backup. I know of export/import utilities but need…
jackInTheBox
  • 62
  • 1
  • 8
1 2 3
…
10 11