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.
266
questions
0
votes
1answer
28 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
23 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
17 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
39 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
36 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
22 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
61 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
39 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
42 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
39 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
320 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
42 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
22 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
16 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
70 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
59 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
19 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
40 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
34 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
37 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
196 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
29 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
19 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
87 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
46 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
232 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: =============== ...
0
votes
2answers
146 views
RMAN Backup to Disk and to Cloud Parallel
I'm currently working on a backup solution for my company.
One part of the solution would be to write the backup to disk and also send it to an oracle cloud archive storage for long term storage.
In ...
0
votes
1answer
83 views
SELECT TO_NUMBER('MUST_BE_SAME_TIMEZONE_FILE_VERSION')
I upgrade Oracle from 11.1.0.6.0 (32bit version) to 11.2.0.1.0 (64bit version) using RMAN on the same Windows computer (64bit).
After RMAN restored and recovered, I then try to run
SQL> startup ...
0
votes
1answer
28 views
Started backup via RMAN, any way to nohup it?
Backup script was failing, so we started new backup manually through RMAN, is there any way to force RMAN to work after i terminate my ssh session? Ctrl+Z in rman unfortunately does not work.
0
votes
0answers
20 views
Policy of archivelog backup using redundancy politcy?
For example. If I create a policy using configure retention policy to recovery window of 5 days all backups before the 5 days will be obsoletes (datafiles, archivelogs backup etc..)
But, if my policy ...
1
vote
1answer
107 views
RMAN Restore Validate time equals to actual restore time?
I'd like to know if the time to restore the database is equal the time using restore validate database. If not, How can I know how much time the restore will spend?
0
votes
1answer
338 views
RMAN log file with date and name in Oracle 11gR2 in Linux
I have a script and I want to create my log file with datetime and with unique name. It's my script:
.......
.......
rman target/ LOG='/u01/backup/logs/rman.log' <<EOF
.......
.......
.......
...
0
votes
1answer
143 views
Using of delete obsolete in Oracle 11gR2 RMAN on Linux
I'm using crontab for automatic backup (full backup). It works 2 times in a day (8 AM and 23 PM). In my script I use delete obsolete but I have a question. I want to delete old backups without last 2 ...
3
votes
1answer
1k views
RMAN - How to add date in backup tag
I know that the default of the RMAN is to add the date in the following format: TAGYYYYMMDDTHHMMSS, But if I wanted something like this: BKP_FULL_11112019. How I do this? I tried using %T but it does'...
1
vote
1answer
106 views
can I do a restore controlfile from autobackup out FAST RECOVERY AREA?
I know that I can issue the command restore controlfile from "location_here". But there is some config that can I do for issue the command restore controlfile from autobackup even whether the ...
0
votes
1answer
44 views
It's a good practice always restore controlfile before restore the database?
I'm beginner in Oracle, but I'd like know if it's a good practice always restore the control-file of a backup-set before restore the database. I ask this because always when I restore the control-file ...
0
votes
0answers
83 views
Delete files from FAST_recovery_area
I am trying to delete the old files from fast_recovery_area folder inside Oracle on Windows as I am running out of space. The database is not in archivelog mode. I am connecting to RMAN and using the ...
1
vote
2answers
327 views
RMAN restoring datafile out of ASM
Why is RMAN restoring the datafiles out of ASM and how to restore a backup into ASM?
Here is one output. The tablespace triscaltb was restored in /u01/app/oracle/product/12.1.0/dbhome_1/dbs/...
2
votes
2answers
130 views
How is the behaviour of backupset in RMAN?
I found this definition on WEB:
A logical grouping of backup files -- the backup pieces -- that are
created when you issue an RMAN backup command. A backup set is RMAN’s
name for a collection ...
2
votes
1answer
225 views
How to apply TagName for all backup files
I perform oracle database backup using the following rman command:
RUN {
ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT 'C:\Windows\TEMP\%u';
ALLOCATE CHANNEL disk2 DEVICE TYPE DISK FORMAT '...
0
votes
1answer
84 views
How to backup and restore in oracle with RMAN [duplicate]
I want to complete a task of backup and restore using oracle in the simplest way possible because I never did it before and I don't really know how to do it. What I want to do is backup the database, ...
1
vote
0answers
262 views
OCI KBHS-00719: Error 'unknown'; Archived object is not restored
I am encountering below error message from RMAN backup to OCI.
Either the bucket named 'DB_BACKUP' does not exist in the namespace
'UNIcredits' or you are not authorized to access it. KBHS-01404:...
2
votes
1answer
584 views
Incremental level 1 RMAN not being deleted
I am doing a level 0 (full) incremental backup on Sundays, with the following global script:
printing stored global script: weekly_backup
{
allocate channel DISK1 device type disk format '&...
0
votes
1answer
438 views
How to clear all configurations on RMAN
How can I clear all configurations listed with the command show all on RMAN to default? I just found how to clear one unique configuration for exemple: CONFIGURE CHANNEL DEVICE TYPE DISK clear
1
vote
0answers
128 views
rman backup takes too long time on oracle 10g
I have a problem that my RMAN backup on our sl45 tape drive takes 2 days to backup 450GB database. The problem that the log shows is that the backup waits too long between finishing a certain task and ...
0
votes
1answer
1k views
RMAN Duplication - Oracle Data Guard - Syntax error(s) RMAN-01009 / RMAN-01008 / RMAN-01007
New to DB. Interested in Oracle Data Guard. New working with RMAN.
All of this is for testing only and does not involve any kind of production env.
Making use of ORACLE documentation:
Step by Step ...
0
votes
0answers
189 views
Restore database using old control file
Our environment has a full daily DB backup system, including the control file at 11 pm.
We had a case to restore the database in different environments but with maximum data to recover. Archivelogs ...
0
votes
1answer
144 views
How to do a configuration on RMAN with run block without save this configuration on rman
I want to do a run block with this configuration for test:
run {
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 50M;
BACKUP DATABASE;
}
But I don't want that the configuration CONFIGURE CHANNEL ...
-1
votes
1answer
122 views
Oracle RMAN Status
I was just hoping someone could give me home help in understanding this, as I've not found any good information.
There is a view: v$rman_status. After our nightly backup, a report is generated from ...
0
votes
1answer
650 views
Error recover database RMAN-06054
I deleted the test database, and now I want to restore it back, when I try to recover the database I get this error.
Everything I had at the database is there and everything works fine.
How can I fix ...
