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
1 answer
29 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
52 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
37 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
125 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 ...
2 votes
1 answer
104 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
59 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
18 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
142 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
0 votes
1 answer
529 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 ...
  • 101
0 votes
2 answers
433 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
69 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 ...
0 votes
0 answers
601 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
475 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 ...
0 votes
2 answers
133 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: ...
0 votes
2 answers
277 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 ...
0 votes
0 answers
49 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
963 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 ------------------------...
0 votes
0 answers
23 views

NO delete from old backup

Does anyone have any idea why my old backups are not deleted although I have correctly configured the backup retention for 1 day thank you for your help
2 votes
1 answer
346 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 ...
1 vote
0 answers
82 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
210 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
495 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
53 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
65 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
136 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
634 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 ...
  • 566
1 vote
0 answers
37 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 ...
0 votes
1 answer
242 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 ...
0 votes
2 answers
779 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 ...
0 votes
0 answers
314 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
372 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
86 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
303 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
224 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
0 votes
1 answer
470 views

delete obsolete archivelog

I have an oracle instance aws recently migrated to RDS aws I just noticed that my database is set by default in archivelog mode and that the archivelog are not deleted who has any idea how deleted the ...
0 votes
1 answer
154 views

Force database open after incomplete restore (without archive/redo)

For example, let's assume we need to restore the database, but we also have lost all archive logs. So we issue the following command in RMAN (just restore, without recover). RMAN> run{ 2> set ...
  • 566
0 votes
1 answer
172 views

Oracle Secure Backup + Amazon S3 / RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

I have backup in Amazon S3 that was created without AUTOBACKUP settings. trying to recover parameter file: RUN { SET DBID 3427966416; ALLOCATE CHANNEL ch1 DEVICE TYPE sbt parms 'SBT_LIBRARY=/home/...
0 votes
1 answer
140 views

Oracle 12cR1 - Duplicate Database With No Resetlogs

Database version: Oracle 12cR1 Operating system: Oracle Linux 7.x ASM: yes Duplicate script: cat duplicatetodisaster.sh ORACLE_UNQNAME=xxx ORACLE_SID=xxx ORACLE_HOME=xxx rman target sys/***@PROD ...
0 votes
0 answers
41 views

RMAN Catalog requirement with DataGuard

If you have an 11g or 19c Oracle Standby DB setup using dataguard must you use an RMAN catalog when backing it up? I ask, because it was a requirement in much older versions of Oracle (e.g. 9i) but I ...
  • 41
0 votes
0 answers
2k views

RMAN-08120: warning: archived log not deleted, not yet applied by standby

BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT; In Data Guard environment this command tries to 1.backup archivelog before starting backup 2.delete archivelog before starting backup 3.backup database 4....
1 vote
1 answer
66 views

Does Oracle use rowid to recover from redo log and archives?

I am learning about supplemental logging and this questios has came into my mind. What I have understood is, Oracle just save an image of the modified column in redo logs, that is why we need to ...
  • 566
1 vote
1 answer
182 views

The "unexpected greater" PGA size allocated in rman channel

Environment: RHEL 6.9、 Oracle 11.2.0.4 When we running some rman backup/restore jobs, we found the actual PGA size could greatly exceed the predefined limit value about PGA: Why the following ...
  • 11
0 votes
0 answers
267 views

ORA-7445 kills PMON instance

I restored an Oracle 12.1.0.2 database using RMAN full backup from a RAC+ASM enviroment to single instance enviroment with less memory and cpu (for test purposes) using this document Doc ID 1338193.1. ...
  • 3
0 votes
0 answers
117 views

Oracle 12cR2 - Upgrade Catalog Command Taking Too Much Time

I patched my database (Windows database bundle patch 12.2.0.1.201020 (31654782)). There are 6 instances on the server. After the patch, the UPGRADE CATALOG command I ran on RMAN for the first 5 ...
0 votes
1 answer
45 views

RMAN windows client

can you please explain me - when I run : rman target sys/<sys_PWD>@SRC_DB auxiliary sys/<sys_pwd>@TRGT_DB from MY WINDOWS PC - will it copy data from SRC_DB to TRGT_DB through MY WINDOWS ...
  • 11
1 vote
1 answer
194 views

Is it possible to duplicate a standby database on the fly?

Can I duplicate a standby database on the fly? Currently, I'm getting this error: RMAN-03002: failure of Duplicate Db command at 01/08/2021 01:55:58 RMAN-05501: aborting duplication of target ...
  • 11
0 votes
1 answer
54 views

The doubt about the long_waits column in the V$BACKUP_ASYNC_IO

Why there would always be many non-zero long_waits values in the V$BACKUP_ASYNC_IO, which indicates waiting the O/S blocking I/O completed? Note: as is well-known, the async_io mode cannot be blocking ...
  • 11
2 votes
1 answer
70 views

RMAN Restore control file and SP File

I need to perform an incomplete recovery. We keep 7 days of backups, and I want to restore the database as it was 7 days ago. I've not done this before. My question is: I can use the SET UNTIL TIME ...
0 votes
1 answer
57 views

Oracle 12cR2 - Image Copy Backup Scenario

Backup type: Image copy. Scenario: I want to 1 full db + 6 incremental backup and keep last 7 days backup on storage. Here is my script: RUN { allocate channel c1 device type disk format '/path/%U'; ...

1
2 3 4 5
7