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.
302
questions
0
votes
0answers
10 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 ...
0
votes
0answers
14 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 ...
-1
votes
1answer
28 views
Cannot recover Pluggable Database
hello i new to rman and im trying to recover A pluggable database with "recover pluggable database "
before i issue a recover pluggable database command i do these following steps:
1.backup ...
0
votes
1answer
14 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
0answers
14 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 ...
0
votes
0answers
64 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
0answers
15 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
1answer
36 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
0answers
37 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 ...
0
votes
0answers
38 views
Restore PDB with rman
I have a DB running in NOARCHIVELOG mode with some users and their schemas.
I'm creating a backup of my PDB using the following commands in rman (I'm connected to the PDB):
SHUTDOWN IMMEDIATE;
STARTUP ...
0
votes
1answer
65 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
1answer
128 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 ...
0
votes
1answer
48 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-...
0
votes
2answers
43 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 ...
0
votes
1answer
21 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 "...
0
votes
1answer
39 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
116 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
34 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
47 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
57 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
2answers
344 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
156 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
153 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
62 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
140 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
100 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
131 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
36 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
50 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
36 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
92 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
64 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
30 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
803 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
33 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
12 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
112 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
150 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
60 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
126 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
31 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
55 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
50 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
47 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
387 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
194 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
225 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
206 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 ...
1
vote
0answers
374 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 ...
