Tagged Questions

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

learn more… | top users | synonyms

1
vote
1answer
266 views

Why we need auxiliary instance in TSPITR

Need help! I've read Database Backup and Recovery User's Guide 11g but I can't uderstand why we need auxiliary instance to perform tspitr. We can do complete recovery of tablespace within same ...
0
votes
1answer
468 views

Recommended Approach to Programmatically Backing Up/Restoring Oracle DB

Supposing I have an ever-growing Oracle DB on one server, and I want to duplicate this schema and the data on another server - what would be the best approach to achieving this as part of a bespoke ...
1
vote
1answer
11k views

ORACLE restore - how to restore specific .bkp file?

I just started working with oracle and I have some issue. My database is NONARCHIVELOG mode. I made two backups: they are at locations: ...
1
vote
1answer
4k views

Difference between full and level 0 rman backups?

Suppose we take a full backup, and after that we take a level 0 backup, both using RMAN and Oracle 10g. I'm confused in the use of the level 0 backup and full backup. I found that the difference ...
0
votes
2answers
257 views

RMAN backup script failing

I have a few linux machines and each of them have a few Oracle databases. On each machine we have 2 shell scripts to run the backups. The TSM scheduler calls a script which calls a different backup ...
0
votes
1answer
7k views

db_recovery_file_dest_size issue

RMAN gives me this error how should i resolve this issue: ORA-19815: WARNING: db_recovery_file_dest_size of 7516192768 bytes is 100.00 used, and has 0 remaining bytes available. Thanks in ...
1
vote
1answer
4k views

Delete Archive log file

I am using oracle database 11g. Some day's back we have deleted our Archivelog Manually, and now it's getting full and due to that we are not able to connect to our database. So how should i delete ...
2
votes
1answer
481 views

Which backup files are needed for a successful restore?

Considering the built-in 'Backup Database' script (backup.bat) that comes with a new installation of the Oracle Express 11g Edition, after finishing the script execution, what folders/files should be ...
0
votes
2answers
1k views

RMAN Recovery In Oracle 11g : Backup Database To Tape

RMAN> backup device type sbt tablespace <tablespace_name>; On Issuing this command following is the error which I am getting: ORA-19554: error allocating device, device type: SBT_TAPE, ...
2
votes
1answer
383 views

Restore database from individual datafile backups

I had a script that backs up all the individual datafiles like: RMAN> BACKUP AS COMPRESSED BACKUPSET DATAFILE 'datafile<1>.dbf' So i have backupsets of all the datafiles. I'm confused as ...
0
votes
2answers
493 views

Row level restore with Oracle Recovery Manager (RMAN)

We're approaching the end of 2012 and I still find myself relying on database exports to maintain the ability to do row level restore operations. While this is a proven method, it sure would be nice ...
1
vote
1answer
2k views

Oracle backup with RMAN Options?

I'm trying to learn RMAN but getting confused everytime I read Oracle docs! Can someone help me what are the differences and when to use the following? BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT ...
3
votes
1answer
2k views

How do I have RMAN treat my restored data files like they are originals?

I am planning a migration for this ancient-but-critical Oracle database from one Windows Server 2003 cluster to another. The database has many data files and they are all getting new paths on the ...
0
votes
1answer
1k views

Incremental level 1 backup with no Incremental level 0?

I have done the following steps: Backed up database with INCREMENTAL LEVEL 0 Delete INCREMENTAL LEVEL 0 backup without telling controlfile. So deleted it by hand. And did not make crosscheck. Backed ...
4
votes
2answers
441 views

Change Location of VALIDATE RECOVERY FILES work area

Is there a way to tell the VALIDATE RECOVERY FILES command to use a different location with more available disk space? When I run the command in RMAN, it fails with the following error stack: ...
2
votes
2answers
99 views

Incremental backups - differences

What is the differene between: BACKUP INCREMENTAL LEVEL 0 DATABASE; and BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; ? I read some manuals, but I don't get the idea beacuse of my poor ...
2
votes
1answer
1k views

Can RMAN duplicate be used to “replace” an existing database?

I have an unused database B, not valuable. I'd like to make a copy of database A, but do not want to go through all the manual steps RMAN requires to set up the auxiliary database. Can I use RMAN ...
0
votes
0answers
954 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 ...
1
vote
1answer
1k views

How can I change default backup location for oracle11g using RMAN?

I want to change to another drive due to lack of disk space. How can I change the default location of backup files used by oracle to another drive using RMAN? By default it's in the folder ...
2
votes
1answer
274 views

Rman not replacing logs with same name on networked drive

Historically, rman saved logs by replacing files of the same name so that the most recent set was always there, and logs from backup of older than the most recent set simply went away. Rman is ...
3
votes
1answer
629 views

In a two-server dataguard setup, can I store the recovery catalog in the same database?

We currently have an Oracle 11gR2 database that is backed up with rman, with the rman records stored in the control files. Control file auto-backup is turned on. Backups are to disk (and, ultimately, ...
3
votes
1answer
4k views

RMAN-06054: media recovery requesting unknown archived log, Where is SCN kept?

I have the following situation: Backups of DB1(located on srv1 server) database are taken everyday at 1:00 AM. I took backed up files(datafile,archivelog,controlfile,spfile) of 24/10/2011 and ...
2
votes
2answers
755 views

Oracle 11.1.0 Autobackup going to wrong location

I am running Oracle 11.1.0 on Win Server 2008. My autobackups used to go to flash_recovery_area\myDB\autobackup\*yyyy_mm_dd*. Then I added a prefix to the file name in front of %F and they started ...
0
votes
1answer
420 views

What network access do I need when I restoring files using RMAN?

I am restoring files from one server to another server using Oracle RMAN, what network accesses do I need?(between these servers) ftp? port 1521 should be open? or what? I appreciate your answer ...
1
vote
1answer
496 views

Oracle Backup and Recovery

My backed up archivelog file format is 'al_%U'. During recovery it shows the following error: RMAN-06054: media recovery requesting unknown log: thread 1 seq 17 lowscn 671075 How to determine which ...
5
votes
2answers
6k views

Why do we need to backup Oracle archive logs along with datafiles

Oracle® Database Backup and Recovery Basics 10g Release 2 (10.2) says that Archived redo logs are the key to successful media recovery. Back them up regularly. But, I wonder, why backups of ...
3
votes
2answers
19k views

Expired archived logs not deleted from RMAN catalogue

If I issue a LIST EXPIRED command in RMAN, I see a list of files with expired status, that is, they exist in the catalogue, but not on the disk (verified by ls). After issuing CROSSCHECK and DELETE ...