Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [rman]

RMAN is Short for Recovery Manager is an Oracle command line tool for doing backup, restore, and recovery operations. Also tag RMAN questions with the appropriate Oracle version tag.

Filter by
Sorted by
Tagged with
0 votes
0 answers
14 views

PDB restoration on other server

I want to restore only 1 pdb to another server, how can I do that? the rman backup which i have taken from another server has a different control file, and the server on which i am restoring the pdb ...
datascinalyst's user avatar
0 votes
1 answer
88 views

RMAN: restore not done; all files read only, offline, excluded, or already restored

I did a hot RMAN backup of a server running Oracle 19c database, then moved the backup to a new server. This is the backupscript BACKUP AS compressed BACKUPSET INCREMENTAL LEVEL=0 FORMAT '...
datascinalyst's user avatar
0 votes
1 answer
77 views

Why a consistent backup still requery recovery in Oracle?

My database was in mount state and we perfomed a backup of the database. backup database format '/backup/db_full%U.bkp'; So, when restoring it, I can't simple use: Restore database; alter database ...
Astora's user avatar
  • 723
0 votes
1 answer
216 views

ORA-19504: failed to create file "bh2jk0h7_1_1"

I want to create a script to get incremental backup of the remote Oracle database every week. I save this command in rman_command.sh and give permission to it: BACKUP INCREMENTAL LEVEL 0 DATABASE ...
M_Gh's user avatar
  • 101
0 votes
1 answer
57 views

Duplicating from active database fails at connection

I'm trying to duplicate a database from active database, but it seems like my connection is blocked on my auxiliary. I'm using ASM just4info. Target DB: listener.ora: LISTENER = (DESCRIPTION_LIST = ...
paganini's user avatar
  • 118
1 vote
1 answer
231 views

RMAN backup restoration

I am trying to restore a RMAN backup to a different server. I needed some clarifications/guidance. This is the location for datafiles in database 1: /u01/app/oracle/oradata/db1/datafile This is the ...
datascinalyst's user avatar
0 votes
1 answer
1k views

ORA-19914: unable to encrypt backup and ORA-28365: wallet is not open

I have been taking backup of my database daily, and for some reason, I suddenly got this error ORA-19914: unable to encrypt backup ORA-28365: wallet is not open this is my databases's current ...
datascinalyst's user avatar
0 votes
0 answers
18 views

Restoring PDBs on a new server

I am trying to restore a 19c database on a new server using RMAN. What are the prerequisites? Do I have to first create PDBs which are supposed to be restored? Or should I just restore from ...
datascinalyst's user avatar
0 votes
0 answers
225 views

How to restore backup of Oracle Database unto same server where original database is running (and not allowed to shutdown original database)

I'm using RMAN, it's Oracle 19c and non-CDB (stand-alone). The problem is that the restored database has to have a different name, since the original database is already running on that server. ...
baffy's user avatar
  • 1
0 votes
2 answers
211 views

SYS password has expired and cannot be changed due to ORA-00257: Archiver error

In the past : When I had once the error ORA-00257: Archiver error, I had resolved it using the RMAN command: rman target sys/1234 delete archivelog all; This time , when I try to connect to rman ...
eathan's user avatar
  • 23
0 votes
1 answer
91 views

Is this enough/proper data to restore an Oracle database?

I was handed some data and was told it was a backup of an Oracle database created by RMAN and stored using Avamar. The owner would like access to the data. It is a folder named like a date, and it ...
mikato's user avatar
  • 101
0 votes
0 answers
546 views

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 ...
Ahmed Adel's user avatar
1 vote
2 answers
1k views

Oracle: how to specify non-default backup location during RMAN restore

Oracle 19c on Windows. RMAN scheduled backups go to FRA here: D:\oracle\recovery. I have another backup in D:\backup\ which I want to restore. I need to be able to "tell" Rman to look into ...
epipko's user avatar
  • 113
0 votes
0 answers
54 views

after restroring tablespace table or view not exists

I've Oracle CDB with PDB In the PDB I created a tablespace then I created a table over this tablespace after that, I login into RMAN for the CDB database then I make a backup using backup database ; ...
Tariq Hajeer's user avatar
2 votes
2 answers
532 views

Why recover database request archived log from the future

It suddenly throw error when I trying to do our monthly backup verification, it failed on recover database command with : ORA-00279: change 26378396150 generated at 05/31/2023 03:52:48 needed for ...
Agung SV's user avatar
-1 votes
1 answer
1k views

I want to change the location of redo files on standby db

my db is generating redofiles to a certain path, lets call it 'old/path', and i want to move it to a new path, lets call it 'new/path' in oracle can somebody help?
dbafix's user avatar
  • 62
0 votes
1 answer
59 views

Recovering RMAN Backup Into a New Database

I have a RMAN backup from an old oracle DB that I need to open on a new PC with a new instance of oracle installed. I am unsure how to go about this as from what I can see in the documentation ...
user avatar
0 votes
1 answer
364 views

Does an Oracle incremental level 1 backup need archive logs to identify the differences since the last incremental level 0 (full) backup?

Let's say we do a full incremental level 0 backup (full database backup) and then, for some reason, we need to delete some archive logs (generated after the full database backup) and then run an ...
Astora's user avatar
  • 723
1 vote
1 answer
630 views

What are the ways to recover Oracle database that has corrupted data file, very old RMAN full backup, and incomplete/corrupted archived logs?

For an Oracle 10g/11g database that refuses to start due to datafile (SYSTEM01.DBF) corruption, does RMAN restore command immediately overwrite all current datafiles from the last found full RMAN ...
clj's user avatar
  • 11
0 votes
1 answer
1k views

RMAN Control File backup failed. [ORA-00245: control file backup failed;]

I have daily backup on my Oracle 12c database on linux. My RMAN failed to take backup control file. But not every day. Its failed 1 or 2 time in a week. Database and archivelog backup is fine. My ...
OKA's user avatar
  • 3
0 votes
1 answer
246 views

How do we recover archivelogs which are deleted by rman but on disk?

We have have rman which keeps only the current day backup. In asm we have a directory in +RECO/db1/ARCHIVELOG/ which stores the archive logs for the last couples of months. Our archivelog path is the ...
Kristi Nanza_'s user avatar
0 votes
1 answer
149 views

RMAN backup data of specific DB only

For an ORACLE_SID (service?) there is a backup using RMAN configured and scheduled. At the SID are multiple DBs but only one of those needs backup of the data. For the rest backup of the definitions ...
fero's user avatar
  • 3
-2 votes
1 answer
59 views

RMAN ORACLE issue

I have the issue when I run the command RMAN as mentioned below : Please any help
Ora_en's user avatar
  • 1
0 votes
0 answers
1k views

Oracle 19c / Rman-10038: Database Session For Channel channel_name Terminated Unexpectedly

I am getting this error while database restore. This is the first time such an error has been getting from a process that has had no problems for a long time. Backup files are on NFS mount. Total ...
jrdba123's user avatar
2 votes
1 answer
895 views

RMAN decrypted backup of Oracle TDE encrypted table

I have a Database with Transparent Data Encryption enabled across tablespaces. We have a storage appliance we're using RMAN to backup to which has native encryption, deduplication and compression ...
whentimeslows's user avatar
1 vote
1 answer
712 views

Oracle 19 - RMAN can't connect to database

I have troubles with starting RMAN and connecting to target database. I start RMAN ($ORACLE_HOME & $ORACLE_SID env variables are set) [oracle@MY_MACHINE /]$ /u01/app/oracle/product/19.0.0/dbhome_1/...
MBi's user avatar
  • 13
0 votes
0 answers
37 views

Missing file after adding multiple files to the tablespace in Oracle

I ran a series of 100 commands in SQL Developer: alter tablespace RRODTBL add datafile '/oradb/PRODDB/data4/prodtbl_171.dbf' size 10M autoextend on next 128M maxsize 31G; alter tablespace RRODTBL add ...
Karol's user avatar
  • 1
0 votes
1 answer
556 views

How do I handle an I/O error when restoring an RMAN backup?

I'm using Oracle XE i.e. a subset of 11.2 version. I have below archivelogs folders having one or multiple archivelog files. 2022-05-20, 2022-05-21, 2022-05-22, 2022-05-25, 2022-05-26, 2022-05-27, ...
Sukhen's user avatar
  • 1
1 vote
2 answers
2k views

Troubleshooting RMAN-03009: failure of delete command on d1 channel

I don't have many experience about RMAN backup. I'm running backup daily level 1 incremental backup and weekly Level 0 incremental. Backup files will kept at 2 difference locations (each location one ...
Blue Sky's user avatar
  • 111
0 votes
2 answers
2k views

Restoring an RMAN backup

Good morning, reading the documentation from Oracle I found a way that I feel comfortable with when taking a backup of a database, but I can't find satisfying informations about restoring them... In ...
Alex's user avatar
  • 1
0 votes
0 answers
332 views

How do i disable Oracle Unified Auditing for RMAN?

I currently have Oracle's Unified Auditing enabled, but I noticed that RMAN is also listed in the Unified_Audit_Trail. The value RMAN_AUDIT is displayed in the Audit_Type instead of Standard when i ...
Beniben's user avatar
0 votes
0 answers
1k views

Oracle Rman recovery to another database on different location

We had production user facing data loss from production Oracle database and only wanted to recover just one schema in the test database from a week ago. Backup team was able to retrieve the physical ...
user avatar
0 votes
1 answer
2k views

RMAN archive logs not deleted

I am working on an Oracle11gR2 database. The database is in DataGuard mode, even though the dataguard is set to DEFER. I want to delete all archive logs that have been backed up at least 2 times to ...
user2465039's user avatar
0 votes
2 answers
596 views

Cannot recover Pluggable Database

I am new to RMAN and I'm trying to recover a pluggable database with recover pluggable database <pdbname> Before issuing the recover pluggable database command, I perform the following steps: ...
Damnedson's user avatar
0 votes
2 answers
872 views

RMAN Duplicate with new SID / Path

We are running Oracle 12c SE. I need to duplicate an instance from the RMAN backups. However, this instance will be on a different server, with a different SID. And, the pathnames have the SID in ...
Landon Statis's user avatar
0 votes
0 answers
436 views

Oracle Incrementally Updated Backups - does "recover copy of database" makes all datafiles consistent?

I would like to use Oracle Incrementally Updated Backups on 19c. Using this script to achieve it: RUN { BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'mybackup' DATABASE; RECOVER COPY OF ...
Michael's user avatar
  • 141
0 votes
0 answers
3k views

RMAN-08138: WARNING: archived log not deleted - must create more backups

I have a primary oracle database and a logical standby. Primary database information BANNER CON_ID ------------------------...
Gonzalo Gil's user avatar
3 votes
1 answer
901 views

How to list backups when not connected to target DB in Oracle RMAN

I'm trying to list backups in RMAN completed within a certain date range. This works fine when I can connect to the target database and recovery catalog. However, I'm assuming a situation where I am ...
Josh Smith's user avatar
1 vote
0 answers
294 views

RMAN: not Connected to Database

While issuing the Restore Database command, the RMAN utility says Not Connected to ORACLE, but When I try connecting Oracle using the command Connect Target it says Already connected to ORACLE. All I ...
xajid's user avatar
  • 11
0 votes
1 answer
520 views

RMAN Duplicate PITR without connection to Target database

I would like to understand which network requirements are needed following the least privilege needed policy in order to perform a DUPLICATE DATABASE UNTIL SCN in this scenario My environment is Azure,...
Roberto Hernandez's user avatar
0 votes
1 answer
1k views

RMAN - Archivelog deletion policy ignored

After a full backup on an Oracle 12.1 database with retention policy set to 1 and ARCHIVELOG DELETION POLICY BACKED UP 2 TIMES TO DISK, if a run delete obsolete device type disk, all archivelogs are ...
scH's user avatar
  • 3
0 votes
1 answer
63 views

Production filesystem is at 100%. Move the datafiles to a new filesystem?

As the title states our file system reached 100% capacity and I want to try moving the tablespaces datafiles to a new filesystem. I'm attempting to follow the steps from this link: http://www.dba-...
Phillip's user avatar
  • 11
0 votes
2 answers
136 views

Oracle: Corrupt datafile will not turn back online?

need immediate assistance on an issue... Oracle Support is taking way too long to respond back on. We have a corrupt datafile in one of our tablespaces, I attempted to shut the datafile offline, and ...
Phillip's user avatar
  • 11
0 votes
1 answer
23 views

How do I start RMAN over with a DB that has the same name as an older DB?

in RMAN, i unregister the DB and all iterations of it disappear, but then I re-register and it all comes back. This is a clone restore of a production DB to a dev DB that used to exist but has "...
glenD's user avatar
  • 1
0 votes
1 answer
470 views

Changed DB_RECOVERY_FILE_DEST path, but RMAN still backs up to the old path?

I just recently changed the DB_RECOVERY_FILE_DEST parameter to point to a new directory path. However, I noticed only some archivelogs and backup sets are going to this new directory path and some are ...
Phillip's user avatar
  • 11
0 votes
2 answers
2k views

Is DB_FILE_NAME_CONVERT just needed when in the same machine?

I am a little confuse. I have created a primary database with DG names +DADOS AND +DGARC, and the standby (in another server) with DG names +DATA and +FRA. I don't have configured the ...
Astora's user avatar
  • 723
1 vote
0 answers
55 views

Successful RMAN restored database contains very old data

I have an Oracle 12.1.0.2.0 database that I am doing an RMAN test restore to a separate machine as part of DR preparedness test. This same process has been done with no issues every few months for ...
Dave Smylie's user avatar
0 votes
1 answer
749 views

Oracle database 12C restore script

i'm trying to create backup restore script . in short my backup script creating new directory every day from the operating system level and then backup the database using the directory created i tried ...
Seif Hassan's user avatar
0 votes
2 answers
2k views

Restore oracle database 12C incremental backup on daily basis

i need to restore my backup at different database server with following sequence on daily basis level 0 incremental only once level 1 incremental everyday i did the level 0 restore successfully ...
Seif Hassan's user avatar
0 votes
0 answers
530 views

Changed RMAN backup location, but still seeing the FULL DB backup going to the old location?

I just recently changed the db_recovery_file_dest value to our new directory location. I can see the archive logs going to the new location and the backupsets. However, our FULL DB backup is still ...
Phillip's user avatar
  • 11

1
2 3 4 5
7