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.
246
questions
0
votes
1answer
13 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
34 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
48 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
28 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
58 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
27 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
18 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
56 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
55 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
129 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
77 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
473 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
75 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
43 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
44 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
16 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
221 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
97 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
109 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
46 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, ...
0
votes
0answers
776 views
RMAN restore error to restore archivelogs
I have this backup piece with the archivelogs:
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
54 1.01M DISK ...
1
vote
0answers
170 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:...
1
vote
1answer
406 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
168 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
112 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
923 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
167 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
105 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
97 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
475 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
287 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
143 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
439 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
217 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
808 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
108 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
120 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
48 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
289 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 ...
1
vote
0answers
69 views
How to keep only those archivelogs that are created after a latest db backup in oracle 11g?
I am little confused with oracle db backup.
I have configured my Oracle 11G DB with ARCHIVELOG in Fast Recovery Area (NFS mount).
I only need latest backup to restore in case of failure, but no point-...
3
votes
2answers
867 views
Why are backups of a previous incarnation marked obsolete without regard to redundancy?
After incomplete recovery and opening a 9i database with resetlogs we ran a full backup which completed successfully. The backup includes a command to delete obsolete backups after it finishes:
...
asked Jul 5 '18 at 12:34
Jack says try topanswers.xyz
34.1k13 gold badges88 silver badges163 bronze badges
0
votes
1answer
2k views
error while cataloging rman backup
I'm new in Oracle. When I try to Install Oracle 12c,This Error Appear. How can I fix this?
error screenshot link
this is my trace.log error section:
[RMANUtil.getRMANUtil:133] creating new util ...
0
votes
1answer
655 views
RMAN validate incremental level 1 backups?
I am somewhat new to RMAN, and have taken an Oracle class on it, but I am stumped on validating my backups when using level 0 and 1; in order to save space, I am considering doing a level 0 (full) ...
0
votes
1answer
780 views
Oracle 12c PDB Cloning with RMAN - Aux DB connection issues
I'm trying to run the following to duplicate a PDB using RMAN.
rman target testuser/testuser@PDB01 auxiliary testuser/testuser@PDB02 as sysbackup
I can connect to both the target and aux PDBs ...
4
votes
1answer
686 views
Oracle RMAN - MAXPIECESIZE ignored for Level 0 backups
I'm having issues with Oracle 12.1 rman - specifically the MAXPIECESIZE parameter not being honored by my Level 0 backups.
This value is set in rman as
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/...
2
votes
1answer
378 views
I am trying to restore an Oracle DB, but I am getting strange controlfile errors. What do I do next?
Oracle version = Oracle 8i (817_312) //Yes I know this is old.
Database id = LED
OS = Solaris 8
Oracle USERID = oraled
Oracle DBA group = dba
rman backups to disk.
Sorry this is so long. I am ...
