I have a scenario in which we have Designed data guard. Where we have 2 standby sides. One standby is located locally and 2nd standby is located on remote side. The distance between local and remote ...

I am using windows server 2003 and Oracle database 10g R2 and i have taken the backup using RMAN of my primary database in Drive label E. The size of backup is 1.5TB. In my standby database i don't ...

I want to know can we migrate Linux based oracle database 10gR2 (10.2.0.1.0) to windows server 2003 with oracle database 10gR2 (10.2.0.3.0). I have seen the documentation related to database migration ...

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 ...

I am trying to scrape together some space in my Oracle 11g backup directory in AIX. I have deleted obsolete files using RMAN's "DELETE OBSOLETE" command, but I see many (just under 200) files dated ...

I'm trying to take backup by RMAN.
I want to know can we take backup of database on disk and tape at same time by using RMAN?
If yes then please share some documentation Or if no then please give the ...

(main question is 4th)
1.
We today have almost all databases running with Oracle 11.2.0.2.
Actually we have an RMAN database created (in 11.2.0.2) and a Catalog with user (called RMAN112)
2.
We are ...

Disclaimer: I'm not a DBA nor did I fully read the RMAN docs cover to cover, so this may be well covered, but I couldn't find it.
The question is very simple, what is the difference between these two ...

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, ...

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 ...

1- Does Oracle RMAN support Incremental Update/Merge option for device type SBT ? Or its only supported for Disk ?
2 - During an update/merge operation during the incremental backup, does RMAN write ...

I'm trying to restore an Oracle database (11.2.0.4.0) to a test system with a different file layout. The production database is being backed up using RMAN, no catalog. We do a full backup of all the ...

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

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 ...

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 ...

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 ...

I've taken backup of datafiles in 31.12.2013. It completed datafile backups successfully, but archivelog backups failed.
Now, I want to determine what archivelogs should I backup to be sure that my ...

I have 30.7GB backup file generated from RMAN. The original ./datafile is 950.28GB. According to previous DBA, there is a lot of free space in table space. Now, I have 300GB free disk space in hard ...

I have an Oracle database over which I have full control. What I am doing is performing load testing on our application, which uses Oracle as a database. To do this, I initially set the database up ...

If RMAN copy copies the archived redo logs when they are full, what happens to the current redo log in the event of a failure (hardware failure, etc.)? Isn't there always an active redo log that is ...