Short for Recovery Manager is an Oracle command line tool for doing backup, restore, and recovery operations.
0
votes
0answers
24 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
0answers
23 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.
...
2
votes
2answers
92 views
Duplicating a Database with RMAN
I would like to duplicate to the same server Oracle Database with RMAN. I've configured flash recovery area for Oracle Database. My database is using SPFILE as shown below.
SQL> SELECT ...
1
vote
1answer
38 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
37 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
123 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:
...
0
votes
1answer
255 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
147 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
630 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
524 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
178 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
439 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
138 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
227 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 ...
0
votes
0answers
130 views
change database name controlfiles after restore?
I have restored database with the name DB to another database called DB01
it is in STARTED status (not mounted) and it seems I can not change the name if it is not mounts, and I can not mount it ...
