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.
318
questions
1
vote
1
answer
47
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 ...
0
votes
1
answer
262
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 ...
0
votes
0
answers
13
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 ...
0
votes
0
answers
58
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. ...
- 1
0
votes
2
answers
100
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 ...
- 23
0
votes
1
answer
57
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 ...
- 101
0
votes
0
answers
175
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 ...
1
vote
2
answers
345
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 ...
- 113
0
votes
0
answers
49
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 ;
...
- 103
2
votes
2
answers
248
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
...
- 21
-1
votes
1
answer
285
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?
- 54
0
votes
1
answer
48
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 ...
William Glover
0
votes
1
answer
181
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 ...
- 630
1
vote
1
answer
429
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 ...
- 11
0
votes
0
answers
52
views
use incremental backups for Oracle standby forward roll on a regular basis?
My boss asked me to create a copy of a production database that lags for one day. Well, it's not a complex task, just have a standby with a 24 hour delay. But it comes with a cost of storing a lot of ...
- 163
0
votes
1
answer
662
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 ...
- 3
0
votes
1
answer
163
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 ...
0
votes
1
answer
134
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 ...
- 3
-2
votes
1
answer
54
views
RMAN ORACLE issue
I have the issue when I run the command RMAN as mentioned below :
Please any help
- 1
0
votes
0
answers
822
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 ...
- 29
2
votes
1
answer
651
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 ...
1
vote
1
answer
415
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/...
- 13
0
votes
0
answers
31
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 ...
- 1
0
votes
1
answer
376
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,
...
- 1
1
vote
1
answer
1k
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 ...
- 111
0
votes
2
answers
1k
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 ...
- 1
0
votes
0
answers
244
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 ...
- 1
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 ...
Color Senz
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 ...
- 103
0
votes
2
answers
452
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:
...
- 13
0
votes
2
answers
634
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 ...
- 141
0
votes
0
answers
359
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 ...
- 141
0
votes
0
answers
2k
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
------------------------...
3
votes
1
answer
763
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 ...
- 31
1
vote
0
answers
234
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 ...
- 11
0
votes
1
answer
419
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,...
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 ...
- 3
0
votes
1
answer
61
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-...
- 11
0
votes
2
answers
106
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 ...
- 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 "...
- 1
0
votes
1
answer
310
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 ...
- 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 ...
- 630
1
vote
0
answers
46
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 ...
- 135
0
votes
1
answer
595
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 ...
- 11
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 ...
- 11
0
votes
0
answers
504
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 ...
- 11
0
votes
1
answer
689
views
Data Guard 12.2 without Force Logging
I would like to know your opinion and experience in a specific setup I want to apply to a Production Database that is configured in Oracle Data Guard with one Standby. It is not an active data guard ...
0
votes
0
answers
231
views
RMAN archive logs are no longer automatically being generated?
To preface... I have mentioned this before in a previous question, but I'll add it again: Our Senior Oracle DBA has just recently passed away, and I've been taking over. My level of experience is just ...
- 11
0
votes
2
answers
590
views
Precautions before relocating the RMAN backups?
To preface... I have mentioned this before in a previous question, but I'll add it again: Our Senior Oracle DBA has just recently passed away, and I've been taking over. My level of experience is just ...
- 11
0
votes
3
answers
432
views
RMAN configuration suggestions to help save our storage space?
To preface...
Our Senior Oracle DBA has just recently passed away, and I've been taking over. My level of experience is just a junior level. So there is a lot I still don't understand. So I appreciate ...
- 11