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
1answer
20 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 ...
0
votes
2answers
25 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 ...
1
vote
0answers
31 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
1answer
31 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
0answers
30 views

Best RMAN Strategy for Oracle VLDB 30TB in NOARCHIVELOG mode

I would like to have your ideas regarding how to optimize backup/restore in a VLDB Oracle Database Environment: RAC 19c 4 Nodes Version 19c Size: 32TB Mode: NOARCHIVELOG Let me explain some ...
0
votes
1answer
58 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
0answers
37 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 ...
0
votes
1answer
45 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
0answers
47 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 ...
0
votes
2answers
36 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 ...
0
votes
3answers
48 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 ...
0
votes
1answer
39 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
1answer
31 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 ...
0
votes
0answers
44 views

I can't start an incremental database backup

When I'm trying to parse the following instruction in RMAN: backup incremental level 0 database plus archivelog delete input; It creates the backup properly but when the backup starts, I'm getting ...
0
votes
0answers
25 views

How can I keep ASM groups in Oracle RMAN Duplicate?

Oracle 11.2.0.4 Whenever I issue a DUPLICATE on a Oracle backup, it always places all the files in to the default ASM diskgroup. I usually have the same ASM diskgroup structure at source and ...
0
votes
1answer
55 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
1answer
44 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
0answers
26 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 ...
0
votes
0answers
308 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
1answer
24 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 ...
0
votes
0answers
10 views

Backing up an Oracle Standby database

I have a quick rman Backup question. If I would like to run RMAN backups on my (dataguarded) 11g physical standby database, what status should that standby db be in? At the moment the standby is in ...
1
vote
1answer
69 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 ...
0
votes
0answers
70 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. ...
0
votes
0answers
36 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
1answer
34 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 ...
1
vote
1answer
116 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 ...
0
votes
1answer
28 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 ...
2
votes
1answer
54 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
1answer
45 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'; ...
0
votes
0answers
31 views

Why my oracle BKP script keeps going to $ORACLE_HOME\dbs

I have this script to make a lvl0 BKP of my Oracle database. Also I'm forcing to allocate in a directory it keeps going to the $ORACLE_HOME\dbs and not to the one I pointed in the configuration disk ...
0
votes
2answers
249 views

Oracle 12cR1 - RMAN-11003, ORA-00354, ORA-00353 - Corrupt Redo Log

Oracle 12cR1, disaster database. ORA-00283: recovery session canceled due to errors ORA-00354: corrupt redo log block header ORA-00353: log corruption near block 8 change 80357235718 time 11/01/2020 ...
0
votes
2answers
122 views

RMAN deletes all conrtolfile autobackups

We have Oracle 18c and RMAN with: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; CONFIGURE CONTROLFILE AUTOBACKUP ON; # default CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '+FRA'; We ...
0
votes
1answer
155 views

Oracle 12cR2 RMAN - ORA-01547, ORA-01194, RMAN-06054

Oracle 12cR2. Error: channel default: deleting archived log(s) archived log file name=+RECO/.../thread_1_seq_166200.26582.1054942673 RECID=62 STAMP=1054943183 archived log file name=+RECO/.../...
0
votes
2answers
112 views

we still can't find backup archivelog in local controlfile

Oracle database is Oracle 11.2.0.3 version. Every one hour, archivelog will backup to netbackup tape. But it is strange, even when we use resync catalog command, we still can't find the backed up ...
0
votes
1answer
2k views

RMAN-06023, specification does not match any backup in the repository

I back up the database using the command RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG; Then use the following command to restore, got an error RMAN-00571: ==========================...
1
vote
0answers
230 views

Manually delete AUTOBACKUP of controlfile

My boss has decided to change retention policy to a 31 days period instead of redundancy of 4 copies. One of the side effects is that autobackups get obsolete after 31 days. This is the configuration ...
0
votes
1answer
26 views

Why can't I use FORMAT in Fra?

I have started working with RMAN and I have seen several comments that FORMAT should never be used when saving files to the FRA. Is there a reason for that? For example, I use some powershell to build ...
0
votes
1answer
32 views

Restore rman backup on another server with a higher Oracle release

I would like to know if it is possible to restore a full backup made with rman of an Oracle9i Enterprise Edition Release 9.2.0.6.0 on another server with Oracle9i Enterprise Edition Release 9.2.0.8.0, ...
0
votes
2answers
229 views

Can't create diskgroup in Oracle 19c

I've successfully installed Oracle 19c with this article. Now I need to restore the database from existing backups. I've first restored the control file, then I started to restore the database: rman&...
0
votes
1answer
313 views

RMAN restore of primary database - impact on standby database

I've just restored an 11g primary DB that was destroyed. Restored the controlfile from tape and performed a full restore, recovery, and open resetlogs. Looks fine now. How will my physical standby (...
0
votes
1answer
77 views

Oracle 11g RMAN restore without catalog

I need to restore an Oracle 11.2.0.4 database from Netbackup on to a different host. Is it possible to duplicate the DB with RMAN into an Auxiliary DB but without a recovery catalog? If it’s not ...
0
votes
0answers
98 views

EMC Legato NSR_DATA_VOLUME_POOL in Rman script

How to put the NSR_DATA_VOLUME_POOL parameter in rman in case this parameter has spaces, I mean that I need to put NSR_DATA_VOLUME_POOL = Pool Oracle but it throws an error however with PoolOra it ...
0
votes
1answer
51 views

Oracle 11g migration to AWS

I have an on premise oracle 11g database that i have to migrate to an EC2 instance hosting Oracle 11g in AWS. I have three options to achieve this Use Oracle Data guard to replicate the on premise ...
0
votes
1answer
68 views

RMAN Backups - Can more than one media management software solution be used?

Does anyone know if it's possible for two different backup utilities to be used to backup the same Oracle database? Both utilities would use RMAN. So, for example, take an Oracle 11g standby DB with a ...
1
vote
1answer
568 views

Oracle - MUST_RENAME_THIS_LOGFILE in logfile name

I'm creating a data guard using hot backup from the primary server. In my restore I've used the following commands to restore: run{ set newname for database to '+DADOS'; restore database; switch ...
0
votes
1answer
37 views

RMAN Creating automatic instance fails

I am trying to transport a tablespace in RMAN. The command I'm running is transport tablespace usr_table auxiliary destination '/oracle/rman/auxFiles' tablespace destination '/oracle/rman'; The ...
0
votes
1answer
32 views

RMAN Disk Backups

I have to run RMAN full backups of my 11g Oracle DB to disk. As part of that process the backups will all be changed to have a backup tag of 'UNAVAILABLE'. This is because the filesystem location of ...
0
votes
1answer
365 views

RMAN-03009: failure of backup command due to ORA-27038 and OSD-04010:

I'm running below script in a windows server, this is same script I run across all servers run { configure retention policy to recovery window of 7 days; backup current controlfile format 'F:\...
-1
votes
1answer
62 views

Database not opening, after messing with datafiles [closed]

I was exercising some database recovery exercises First I had made a backup of my datafiles, then I moved them to another directory to test if I could recover them or not. When I was recovering them ...
0
votes
2answers
471 views

Recover database until cancel?

I'm trying to use the command restore database until cancel, but I'm getting the following erro: RMAN-00571: =========================================================== RMAN-00569: =============== ...

1
2 3 4 5 6