| db_recovery_file_dest parameter issue during restore [message #458237] |
Fri, 28 May 2010 01:12  |
lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi
|
Member |
|
|
Hi Experts,
Yesterday i faced some strange issue.
We used to restore the database from other database backup using "restore database" command and then rename database to another name as per our requirement.
Few days back i restored the database from UAT db(name UAT) and changed the name to TS1. The databases using ASM for the datafile and db_recovery_file storage on diskgroup +DATA05.
so, thats why i can not rename the directory structure to TS1 as i am using 10g.
So, the directory structure remains the same(+DATA05/UAT/datafile/..) after renaming the database to TS1.
Yesterday, i tried to restore the same UAT database backup onto some other diskgroup +DATA01. The restore process picked the datafiles of running database TS1 under the diskgroup +DATA05 instead of the backup pieces. And that is because my db_recovery_file_dest parameter pointing to +DATA05 diskgroup.
(DB_RECOERY_FILE_DEST='+DATA05')
After the restoration, it throw error that your controlfile is before the resetlogs(sorry i didn't have the error code/number now).
I resolved the issue by changing db_recovery_file_dest parameter.
But i have my own confusion, why the restore process tooks the datafiles instead of the backupsets.
And why oracle can not distinguish that these datafiles are under different database name.
Great thanks in advance for your input and knowledge sharing.
Regards
Lalit
|
|
|
|
|
|
|
|
| Re: db_recovery_file_dest parameter issue during restore [message #458390 is a reply to message #458237] |
Sat, 29 May 2010 07:19  |
lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi
|
Member |
|
|
Thanks Mahesh,
But my SID and everything is correct while i am doing restoration of the database. And Rman script uses "/ as sysdba" while connecting to the database and start the restoration of the database UAT on another diskgroup.
But as i said early on, it tries to point the datafiles on the diskgroup +DATA05/UAT/datafile/...
And that is because my parameter db_recovery_file_dest for UAT database was set to +DATA05.
Once i changed this parameter to +DATA01(on the same putty session, without changing SID or anything), it did the restoration correctly from the backupset piece.
Regarding set new name, i guess that might be issue because i have around 210+ datafiles. I have to look into this possibility as well. Thanks for your valuable suggestion 
Regards
Lalit
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
