| restoring rman backup to test database from live db (merged) [message #264417] |
Mon, 03 September 2007 04:40  |
aboodlardy
Messages: 80
Registered: November 2006
Location: India
|
Member |
|
|
Hello ,
friends i hve two databases one(one) is exact copy of another(two)
the database one is same as 'two', with even sid and dbid.
Now the 'one' is copied some time ago, now it is not synchronized with two. one's log seq no number is 1000
and two's log seg no is 2000.
My question is how i can update or syncronized my 'one' database with my 'two'. i have archivelog file from two.
Please help me.
|
|
|
|
|
|
|
|
|
|
| Re: updating copied database. Please Help [message #264436 is a reply to message #264427] |
Mon, 03 September 2007 05:33  |
lecorr
Messages: 17
Registered: October 2006
Location: Courbevoie, France
|
Junior Member |
|
|
Hi,
as said by Michel, if you started up this database, even one time, for oracle, it is now a different database.
Depending your oracle version, starting with 9i, and IF you did not modify the data during your tests, you could try to load the archivelogs via the logical standby mechanism (with some limitations in 9i and far less in 10g).
Then Oracle will read the archive logs of your production database and 'replay' the transactions in your test database.
BUT this CANNOT give you any warranty that the data will be the same. All depend of the data you already have in your test database.
I use LS for this kind of purpose, and it works.
This said, if you have RMAN backups, why not simply restore your production database?
Regards,
Christian
|
|
|
|
| Re: updating copied database. Please Help [message #264648 is a reply to message #264436] |
Tue, 04 September 2007 02:07 |
aboodlardy
Messages: 80
Registered: November 2006
Location: India
|
Member |
|
|
Sorry for late reply.
Michael you said i should restore the backup of 'two' in 'one'.
But as i said it is rman backup , and it was taken using rman which was without catalog , so please tell me how can i use these rman backups to restore in test (one) database.
OR
can i export the full database.
and import into test database but records may get duplicated.
if this is true can u write proper syntax for it.
Thanks in advance.
[Updated on: Tue, 04 September 2007 02:09] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: updating copied database. Please Help [message #264718 is a reply to message #264674] |
Tue, 04 September 2007 05:24 |
aboodlardy
Messages: 80
Registered: November 2006
Location: India
|
Member |
|
|
Hello
Michel
Thanks for a valuable link.
I have gone through this link and hve undtood ,and even tried,
But my only one doubt is that if two machines are not connected with each other in any way, how can we take rman back from source database. If we take it on to floppy or any device and copy on to the target server, rman here , not taking this backup but the backup taken on the same (target where we r tring to restore) machine.
So please show me the way to it.
|
|
|
|
|
|
| Re: updating copied database. Please Help [message #265043 is a reply to message #264737] |
Wed, 05 September 2007 05:36 |
aboodlardy
Messages: 80
Registered: November 2006
Location: India
|
Member |
|
|
hello
Michal
As u said to copy the backups to same location, i have done that,
and even change 'configure channel "to my location"' but it is taking rman backups of old backup ,means host database rman's backup, not the backupset to store from live database.
Please help
|
|
|
|
| restoring rman backup to test database from live db.. [message #265055 is a reply to message #264417] |
Wed, 05 September 2007 05:55 |
aboodlardy
Messages: 80
Registered: November 2006
Location: India
|
Member |
|
|
hello friends
I have backupsets taken using rman on live database, and i want to restore these backups in test.
i hve copied bkpsets from live to my test in the sam locn as in live.
i have change 'configure channel device type disk format to this locn' .
and copied control file using rman on test.
But rman on test is not taking backupsets from this loactin where i hve copied the live rman's backup.
rman on test is taking its on backups .
i hav set dbid, then copied controlfile form autobackup then mount
then
restore.
but this restore is from rman' on test which it took on test database.
my question is how to make rman on test database to take backups copied from live database using live database's rman.
please help
|
|
|
|
|
|
|
|
| Re: restoring rman backup to test database from live db.. [message #265080 is a reply to message #265066] |
Wed, 05 September 2007 06:31 |
aboodlardy
Messages: 80
Registered: November 2006
Location: India
|
Member |
|
|
i have two databases, one is live and second is test.
i had copied the live database some time earlier with some data on test machine now it is test database.
NOw, after few weeks i want to update that test database.
so, i have backups of live database taken using rman.
i have copied that backup to my test machine to the same location as it was in
the live database using rman. Now whan i try to restore this backup using rman on test database.
this rman on test database is not takin backup to restore from the location where i have copied the live backup
but taking its own backup taken on test machine.
i want ,test rman to take backp from live database rman's backup.
|
|
|
|
|
|
| Re: restoring rman backup to test database from live db.. [message #265160 is a reply to message #265080] |
Wed, 05 September 2007 10:09 |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
| aboodlardy wrote on Wed, 05 September 2007 05:31 |
i have two databases, one is live and second is test.
i had copied the live database some time earlier with some data on test machine now it is test database.
NOw, after few weeks i want to update that test database.
so, i have backups of live database taken using rman.
i have copied that backup to my test machine to the same location as it was in
the live database using rman. Now whan i try to restore this backup using rman on test database.
this rman on test database is not takin backup to restore from the location where i have copied the live backup
but taking its own backup taken on test machine.
i want ,test rman to take backp from live database rman's backup.
|
easy and simple way again run export on LIVE and EXPORT that on TEST ,NO OTHER WAY.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
