Tagged Questions
1
vote
0answers
23 views
Is it possible to use 'restore UNTIL SCN' with rman and Oracle 9i in NOCATALOG mode?
I'm trying to do a hot backup with rman that I can copy to a USB drive so I can recover it on a new server.
The backup was done two days ago and the restore database command was working on the same ...
1
vote
1answer
168 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:
...
2
votes
1answer
186 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 ...
2
votes
1answer
139 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
232 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
131 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 ...
1
vote
1answer
353 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
...
0
votes
1answer
406 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
194 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
78 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 ...
1
vote
1answer
451 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 ...
3
votes
1answer
2k 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 ...
1
vote
1answer
288 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
3k 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
1answer
9k 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 ...
