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.
253
questions
0
votes
1answer
13 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
11 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
27 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
28 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
31 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
95 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
23 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
16 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
29 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
41 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
123 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
86 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
70 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
19 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 ...
0
votes
0answers
87 views
How to mount current control file in ORACLE 12C1 RAC
I am trying to take a backup of my ORACLE 12C1 RAC setup and faced following error:
RMAN> BACKUP CURRENT CONTROLFILE FORMAT '+FRA/RMAN/cold/ORCL/cntrl_%s_%p_%t';
Starting backup at 16-DEC-19
...
1
vote
1answer
93 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
219 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
105 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
786 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
86 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
59 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 ...
0
votes
0answers
17 views
RMAN restore / recover
this is probably a simple question, but I'm not finding an answer which I deem correct.
So at this organization, they take a weekly backup using RMAN, ship those to a standby server, and perform a ...
1
vote
2answers
266 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
110 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
149 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
62 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
216 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
483 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
294 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
121 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
179 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
118 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
111 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
568 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 ...
0
votes
2answers
345 views
Restore or reset Oracle database (No Flashback features)
I am running
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
Seem it not Enterprise edition, so I not able to use flashback features
SQL> ALTER DATABASE FLASHBACK ON;
ALTER DATABASE ...
0
votes
1answer
175 views
Does an ad hoc, full backup, using Oracle RMAN, flag files, so they are not backed up by the regular backup?
If I run a simple RMAN full backup, ad hoc, outside of the regular backup scheduled, does that flag files so when the regular backup runs, that regular backup won't get some of the log files?
For ...
2
votes
1answer
534 views
How to copy a tablespace to another database without using Data Pump in Oracle 11G
I have a database on a legacy system that has some data that needs to be exported to another environment. Everything I need is contained in one tablespace. Unfortunately, I am unable to use Data Pump ...
1
vote
1answer
234 views
ORA-19815, ORA-01031 and ORA-12514 error
I have Linux RedHat Enteprise with Oracle 11g database and I've stumbled upon a circle of errors and I can not find a way out.
First error in alert_XE.log:
ORA-19815: WARNING: ...
0
votes
0answers
41 views
RMAN restore up to current
Oracle 11.2.0.3 restoring to 11.2.0.4
Without going full blown Data Guard, how can I get Oracle to restore to a fairly current (within the last hour or two) state? Moving the datafiles over takes ...
1
vote
3answers
43 views
How can I find the backup that requires the least amount of archivelogs to restore?
Oracle 11.2.0.3 with daily full backup and hourly archivelog backup. RMAN with a catalog.
If I take a backup at 11pm at night and it finishes 5am the next day and I want to restore a backup to a ...
1
vote
1answer
938 views
Missing archivelogs when restoring duplicate
We restore backups to our test systems from production via a point in time RMAN Duplicate with an online full backup and hourly archivelog. Every blue moon something goes wrong (working to resolve ...
1
vote
1answer
1k views
Problems with connecting to a remote Oracle 12c database
tl;dr
RMAN failing to connect to standby database with correct credentials.
RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied
Password file is correct, ...
1
vote
2answers
124 views
How to make a backup of an Oracle database that does not mess up the regular backup cycle?
Goal
I want to move a database from server A to server B. Both server have the same technology so one way is to shutdown the source database, copy data files,control file, redo logs, parameter file ...
1
vote
1answer
137 views
Oracle RMAN encryption
I would like to know if it is possible given a certain backup made with RMAN in Oracle 12c is encrypted without having to restore said backup, is there any or some queries that verify if an RMAN ...
0
votes
1answer
51 views
Backup data base in oracle 12C
We have 12c database. we had create a pdb. Now i want to take a backup through
RMAN. Could you please share the steps to configure this backup.
I know to configure backup in 11g..For 12c Please share ...
2
votes
1answer
5k views
How can I configure RMAN to delete crontrol files automatically?
I am using Oracle Release 12.2.0.1.0 Standard Edition on ODA (Oracle Database Appliance, running linux). My instance "xyz" is running in archivelog mode. RMAN performs backup and unnecessary datafiles ...
4
votes
0answers
301 views
RMAN-06169, but only when backing up via OEM 13c
When running a Level 1 or Level 0 backup via OEM 13c, the following RMAN error causes the run to fail. (The RMAN script is being ran with proper sysdba credentials from OEM 13c.)
RMAN-06169: could ...
