Short for Recovery Manager is an Oracle command line tool for doing backup, restore, and recovery operations.

learn more… | top users | synonyms

0
votes
2answers
164 views

How should I use RMAN clone refresh using set until time?

I am using this technique to refresh dev. environments with production data. The business process is to request a tape hold for the full backup I want to use for a clone refresh to dev. Once this is ...
0
votes
2answers
1k views

Extract Archived Log Files from RMAN Backupset

I have an RMAN backup that is taken on 19th january with: BACKUP DATABASE PLUS ARCHIVELOG command. Now I need to restore Archived logs from that backupset to some other OS directory. Is there any way ...
1
vote
1answer
1k views

Duplicate database for standby returns error ORA-19625: error identifying file /home/oracle/stdbyctrl.ctl

I'm working on creating duplication scripts for standby purposes. and it's constantly failing even though the backups are located in the exact same folder. DB structure is identical and spfile is ...
1
vote
1answer
188 views

Mistake during Oracle 11g PITR

I tried using set time until.. and mis-typed the date. Can anyone help me understand how to get my backups into a manageable state? After the accidental recover, most of my backupset disappeared. I ...
0
votes
1answer
20 views

Error while duplicating Oracle database after failover, using 11.2.0.4

I've recently updated oracle from version 11.2.0.1 to 11.2.0.4 and my redundant system is no longer able to recover from failover. I'm using scripts both on primary and standby node to get back to a ...
0
votes
1answer
334 views

RMAN backups, incremental, not compressed: estimate size?

We´re setting up RMAN to backup a database over NFS and ZFS, for which I have to create shares and mounting points (4 shares in my case). I am trying to anticipate the size of the shares, which ...
0
votes
1answer
206 views

Recover data from bak Oracle 9i file

Our customer gave us a .bak archive with name file_decrypted_379299.bak which we know was created with Oracle 9i in "hot" style. We tried to recover the bak file with Oracle 9i RMAN but we don't know ...
0
votes
1answer
77 views

How to fix this error Idk?

how to fix it I am new in Oracle? I tried to connect RMAN and it showed me this error...
2
votes
0answers
268 views

Why OEM RMAN backup jobs fail after changing the preferred credentials?

In an Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production, Running on Oracle Linux 6.5, we configured full RMAN backup schedule using OEM (Oracle Enterprise Manager 11g ...
1
vote
0answers
1k views

Oracle restore backup on other server

I have following situation: One server with Oracle has to be backed up and recovered on other Oracle server. Second Oracle DB has the same user/schemas, but with a different older data. I intend to ...
1
vote
0answers
4k views

Failure Of Backup Due To Limit Exceeded For Recovery Files Since Cannot Reclaim Disk Space [RMAN-03009,ORA-19809,ORA-19804]

While I try to take incremental backup level 0 by using the command RMAN> backup incremental level 0 database plus archivelog; , encountered this error. RMAN-00571: ...
1
vote
0answers
343 views

rman 'delete archivelog all’ very slow

On our automated test system we use flashback all the time to reset our Oracle 11g database to a state before a testrun. We noticed some of the scripts involved started to become slower and slower. In ...
0
votes
0answers
22 views

Error While Restoring Standby Database from RMAN Backup of Primary Database

My Standby Database was corrupted. So i took primary database backup using RMAN. Transferred to my standby database. On standby, on startup nomount, restored standby control file then on mount stage, ...
0
votes
0answers
12 views

Error While Restoring Standby Database from RMAN Backup of Primary Database

On standby database i got error while restoring rman backup of primary database. Some targets not found. ORA 06100 no channel to restore a backup or copy of datafile datafile_number
0
votes
0answers
37 views

duplicate/restore a prod database to a test with RMAN

we have RMAN using RMAN CATALOG and takes backup to TSM Tape! what is the standard method to clone/copy/restore a database to a new host with a new instance name? I just need the RMAN script, I ...
0
votes
0answers
116 views

RMAN error RMAN-06207,RMAN-06208,RMAN-06210,RMAN-06211,RMAN-06212,RMAN-06213,RMAN-06214

I have this issue with around 7 servers, we have an RMAN job that takes backup and validate the backup ... here is RMAN settings: RMAN> show all; RMAN configuration parameters for database with ...
0
votes
0answers
109 views

Archive log backup error and backup completed with errors

My prod DB backup completed with errors stating the below error. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ...
0
votes
0answers
38 views

What is meant by the RMAN Duplicate “noncurrent point in time”?

When doing a RMAN DUPLICATE from backup connected to the target, how current does the duplicate make the database when no until time is set? The closest thing I can find in the documentation is the ...
0
votes
0answers
226 views

RMAN restore vs duplicate

I have so far used two options to create a clone of a database from one host to another: RMAN restore and recovery as below RMAN > startup nomount; restore controlfile from .. . shutdown ...
0
votes
0answers
161 views

Delete backup directories using RMAN

Is there any way RMAN can delete empty backup directories?
0
votes
0answers
280 views

Duplication Oracle Database to remote host

I have two scenarios. 1 ) Let's say , I have the same file system and same SID on both nodes. I've created any directories necessary for start the duplicate database. First I used command below. ...
0
votes
0answers
960 views

RMAN Error ( 00601, 03004)

Please help on this RMAN error: RMAN> backup database plus archivelog; Starting backup at 08-MAY-12 current log archived allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=297 devtype=DISK ...