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.
231
questions
2
votes
1answer
23 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
18 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
47 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
60 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
45 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
59 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
29 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
50 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
54 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
173 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
55 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
29 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
43 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
167 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
110 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
63 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
147 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
140 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
37 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
37 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
383 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
354 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, ...
0
votes
2answers
60 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
48 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
33 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
2k 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
227 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
58 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
552 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:
...
0
votes
1answer
840 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
403 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
306 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
301 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 '/...
0
votes
1answer
128 views
RMAN restore error;. expected sequence# 211287 doesn't match 211311 during recover
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
I an mot a DBA, but a UNIX/Linux System Administrator ...
2
votes
1answer
224 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
24 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
304 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
84 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.
0
votes
1answer
370 views
Oracle 11g database archive log got increased suddenly in production server
My production db archivelog got increased suddenly one night. Around 200 MB of archivelog were generating in FRA within a minute. It got into normal condition after 15 hours from the start of this ...
0
votes
1answer
161 views
Oracle 11gR2 (11.2.0.4) RMAN cold backup | Media recovery
I'm planning to setup a test server with production data. The intended actions are, making a cold backup & restoring it in the Test server.
The cold backup routine is
run
{
shutdown immediate;
...
1
vote
1answer
4k views
clean flash recovery area archive logs
I have an Oracle 11g on RHEL server. My /oradata volume reach 95% disk usage :
[ora11g@bocc7-1-qrec-01 ~]$ df -h
/dev/sdb1 689G 571G 84G 95% /oradata
The Flash Recovery Area (FRA) ...
2
votes
1answer
581 views
How to get archive re-do log file name containing the given SCN in Oracle?
Scenario:
Let us consider oracle 3 node RAC. RMAN Managed Recovery is configured between production and standby DBs. Let us assume that the SCNs of 3 nodes are S1, S2, S3 at some point of time ...
3
votes
1answer
566 views
Archivelog file deleted, resulting in 'ORA-01113: file 1 needs media recovery'
(This is not a production database. I'm practicing in a staging enviroment.)
I'm trying to set up RMAN for backup/recovery.
I did a full backup, which seems to be in a good state.
I then did an ...
1
vote
1answer
539 views
Restoring RMAN backup in Oracle 9i to another server
I'm trying to do a restore of a cold backup made with rman in oracle 9i, the question is that I managed to successfully restore the pfile and the controlfile but when I try to give:
RMAN> restore ...
1
vote
1answer
2k views
ORA-01196: file 1 is inconsistent due to a failed media recovery session [closed]
I have 3 database 1 primary and two standby, The storage of one the standby was abruptly removed without shutting down the database.
Few Days later the storage was returned, I restart the whole ...
1
vote
0answers
79 views
RMAN corrupts passwordfile
please, can you clarify this?
My configuration is RAC 12c on ASM on SLES 11 SP 4 on SystemZ.
The nodes rac11 and rac12 are the server nodes of the primary database, named "primdb", uniq_name is "...
1
vote
1answer
1k views
Restore Oracle Database excluding some tablespaces
I want to restore a backup in cold full (without archivelog) made with RMAN in another server and I do not want to do a full restore but partial, that is to restore only some tablespaces ... I have ...
0
votes
1answer
728 views
Restore RMAN Level 0 without any archivelogs?
I have a level 0 backup, and control files, but I don't have the archivelogs. And I'm not using rman catalog.
I found ways to restore a L0 backup, if you have at least the first archivelog after the ...
1
vote
2answers
185 views
In Oracle, why would I not always delete all old archive log files with RMAN?
backup archivelog all delete all input;
I do not understand why you would not always do this. Why would I only want to delete archive log files from one location?
When Oracle saves the archive log ...
0
votes
0answers
863 views
How to restore Oracle 11g database without controlfile and spfile for a new server?
Hello everyone I have made a backup to my Oracle 11g dtabase with SID=ORCL
using the command backup database plus archivelog this my output after performing this command
Starting backup at 10-SEP-17 ...
