| restore issue [message #531681] |
Thu, 17 November 2011 05:11  |
andy huang
Messages: 498
Registered: July 2011
|
Senior Member |
|
|
Dear all,
I was confused my restore command,how does oracle know where the backupsets are store? for example,if the location is 'c:\mybakup' when backup,then i move the backupsets to 'd:\mybackup', how does oracle know the new location?
run
{
allocate channel c1 type for disk;
allocate channel c21 type for disk;
restore database;
recover database;
alter database open resetlogs;
release channel c1;
release channel c2;
}
|
|
|
|
|
|
|
|
|
|
| Re: restore issue [message #531712 is a reply to message #531702] |
Thu, 17 November 2011 07:27  |
andy huang
Messages: 498
Registered: July 2011
|
Senior Member |
|
|
Thanks Michel!
But i have a new issue,if i cope the backupsets from HostA to HostB,and then i want to restore the database using the backupsets in HostB,how to do?
|
|
|
|
|
|
|
|
|
|
| Re: restore issue [message #531726 is a reply to message #531723] |
Thu, 17 November 2011 08:10 |
andy huang
Messages: 498
Registered: July 2011
|
Senior Member |
|
|
Thanks,
Michel,Back to the first issue of my.
if i move the backupset "c:\mybackup\test.bak" to "d:\mybackup\test.bak" as HostA,do i must run the flowing command before restore?
CATALOG BACKUPPIECE 'd:\mybackup\test.bak';
|
|
|
|
|
|
| Re: restore issue [message #531736 is a reply to message #531729] |
Thu, 17 November 2011 08:22 |
andy huang
Messages: 498
Registered: July 2011
|
Senior Member |
|
|
Thanks,
If i cope the backupset from HostA to HostB,and want to restore it in HostB,is it must do the flowing?
1.install oracle software in HostB
2.using the oradim the add a SID in windows, which command in linux?
3.Does the SID must be the same as HostA?
4.how to restore? and how does oracle to know the backupset which copy from HostA?
|
|
|
|
|
|
| Re: restore issue [message #531755 is a reply to message #531749] |
Thu, 17 November 2011 08:50 |
andy huang
Messages: 498
Registered: July 2011
|
Senior Member |
|
|
Thanks,
Michel, Can you please explain the item 3,how to change to sid? I think the sid must be the same, because the backupset have record the SID of HostA.
Quote:3.Does the SID must be the same as HostA?
|
|
|
|
|
|
|
|
|
|
| Re: restore issue [message #531787 is a reply to message #531758] |
Thu, 17 November 2011 11:22 |
 |
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
andy huang wrote on Thu, 17 November 2011 16:01Thanks,
Michel,do it the DBID in target host HostB must be same as source host HostA?
It will be the same after restore (no way to do it other way) but, as gentlebabu said, you can use NID to change it afterwards.
Regards
Michel
[Updated on: Thu, 17 November 2011 11:22] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
