| restoring database in other server after disaster [message #309679] |
Fri, 28 March 2008 07:53  |
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
|
Senior Member |
|
|
Hi,
If we have a disaster ,where the Database server has gone and we can not use it again.
1) We do not have dataguard.
2) We have rman backup file of 2 days before (Full database backup). Rman backup with nocatalogue
3) Flashback log files
3) Archive log till yesterday
4) Export file of morning.
Can we be able to restore and recover our database in new server
if yes then how.
Because RMAN Backup has its DBID and the new Oracle software which i install on new server will be installed with new ID.
Please help me understand this thing (About target database)
Regards
|
|
|
|
| Re: restoring database in other server after disaster [message #309685 is a reply to message #309679] |
Fri, 28 March 2008 08:06  |
Frank Naude
Messages: 4579
Registered: April 1998
|
Senior Member |
|
|
You cannot restore (assuming you are using on-line backups - and, you don't backup your archive logs). The backup is 48 hours old, but you only have 12 hours of archive logs.
Fire your DBA and get someone who would be able to manage it properly.
PS: Oracle has a utility called DUL which can extract data from a "dead" database. Log a SR and ask them for it.
|
|
|
|
| Re: restoring database in other server after disaster [message #309711 is a reply to message #309679] |
Fri, 28 March 2008 09:35 |
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
|
Senior Member |
|
|
I mentioned that we have archive till yesterday from six month.
Do we need to backup archive log with whole database backup in rman to lessen our pain.
If we have backup of whole database(it consists of spfile and control file) + archive in rman then we will be able to restore certaibn data or not.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: restoring database in other server after disaster [message #310100 is a reply to message #309752] |
Mon, 31 March 2008 05:24 |
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
|
Senior Member |
|
|
I am asssuming, if disaster happens.
It is not actual scenario.
The problem is that rman backup is of target database with specific DBID.
The new server with oracle installation will have different DBID.
So when i restore database by using rman it wil be looking for different Database identifier.
Another question at this point in time can i use Export dump file of previous day or it will be better to use RMAN.
|
|
|
|
|
|
| Re: restoring database in other server after disaster [message #310133 is a reply to message #310106] |
Mon, 31 March 2008 06:44 |
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
|
Senior Member |
|
|
When i connect to rman in target database (in New server) it will have different DBID.
I will place the rman bakcup of old database in flash_recovery folder of new host, so that the rman can pick that database backup, but the rman backup i am using does not belong to the current target database.
Controlfile of new host will also be different.
|
|
|
|
|
|
| Re: restoring database in other server after disaster [message #310431 is a reply to message #310139] |
Tue, 01 April 2008 04:41 |
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
|
Senior Member |
|
|
Thanks for your help, i just wanted to have steps regarding the restorationa and recovery of database when production database is no more and i have BACKUPSET of rman, which consists of controlfile as well as spfile, secondly i also have backup of archive log till previous day.
i wanted to know it beacause, previously i have been using RMAN to restore and recover production database datafile when production database is alive.
If i go to the new server with backup only RMAN will belong to new server, when i write target the target server will be new server but how rman look for the backup to restore file when this database already have controlfile and redo logfile and datafile.
In document they were saying we neeed to have Auto back FOR CONTROLFILE ON in RMAN, so that whenever there is a disaster, first we restore spfile from Auto back and then controlfile and then database.
But in above approach it is not clear that when i have full database RMAN backup controlfile will already be backup, why do i need AUTOBACKUP.
I just want to find out the step wise approach
If you could help me, i will be very thankful to you
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
