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.

Filter by
Sorted by
Tagged with
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 ...