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.
243
questions
0
votes
1answer
21 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
10 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
27 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
29 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
47 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
43 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
159 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
46 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
41 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
32 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
13 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
136 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
64 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
63 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
34 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
198 views
Can I to clear v$archived_log where name is null?
I have noticed that when I exclude some archivelogs with rman the view v$archived_log still keep the registers and when I gonna restore I receive this errors:
RMAN-00571: =============================...
0
votes
0answers
576 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
117 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
304 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
65 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
104 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
0answers
66 views
Rman, Create two Incrementally Updating Backups
I am using the following rman (Oracle11gR2) commands to create an Incrementally Updating Backup Copy
RUN {
RECOVER COPY OF DATABASE WITH TAG 'incr_update;
BACKUP INCREMENTAL LEVEL 1 FOR RECOVER ...
0
votes
1answer
615 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
150 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
76 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
82 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
362 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
194 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
128 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
313 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
183 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
42 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
655 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
817 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
80 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
89 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
41 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
4k 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
275 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
65 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
779 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
33.4k13 gold badges86 silver badges161 bronze badges
0
votes
1answer
1k 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
581 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
624 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
495 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
304 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 ...
1
vote
1answer
26 views
Oracle 11gR2, duplicating and refreshing cloned database
Assume I've cloned PROD database to TEST with RMAN "duplicate target database to CLONE from active database;". After several days I need to refresh CLONE. Will RMAN transfer all the datafiles from ...
0
votes
1answer
454 views
How to instruct Oracle 11g Standby database MRP to bring down as soon as applying the given archive log file?
Scenario:
Let us consider the following:
Oracle 3 node RAC.
RMAN Managed Recovery and Dataguard are configured between production and standby DBs.
The SCNs of 3 nodes are S1, S2, S3 at some point of ...
0
votes
1answer
98 views
MOVING TO ORACLE 12c
I have an rman backup of 11.2.0.2. Also I have installed 12c on a separate server. Can I move my backup to 12c. if yes?
Please guide me how to do it?
Appreciate your comments and answer.
