Change drive lettere during system copy based on backup/restore

[Ganimede-Dignan]

Hi,

system copy based on backup/restore for a NW04s system on Otacle 10.2.0.2 X86 32 bit ... can I change drive letter on control.sql file ... source system has got different drive letter name then target.

Is it a problem ?

Regards.

Ganimede Dignan.

[Former Member · Accepted solution]

hi Ganimede,

You can very well change the drive letters as per the physical file present on the system and then run the control.sql file which was create using alter database backup controlfile to trace.

You should take care of the SID.

Regards

Prashant

[Ganimede-Dignan · Accepted solution]

Thank all for your post,

I use the same <SID> for source and target ... but source system use one only drive N:\Oracle\<SID>\... and in the target I must use several:

F:\Oracle\<SID>\sapdata1

G:\Oracle\<SID>\sapdata2

H:\Oracle\<SID>\sapdata3

I:\Oracle\<SID>\sapdata4

L:\Oracle\<SID>\sapdata5

M:\Oracle\<SID>\sapdata5

X:\Oracle\<SID>\sapdata...

So I edit control.sql file to split in several drive letter... is it OK ?

Example:

SOURCE control.sql

...

'N:\ORACLE\SID\SAPDATA1\SIDFACT_1\SIDFACT.DATA1',

'N:\ORACLE\SID\SAPDATA2\SIDODS_1\SIDODS.DATA1',

...

TARGET control.sql

...

'F:\ORACLE\SID\SAPDATA1\SIDFACT_1\SIDFACT.DATA1',

'G:\ORACLE\SID\SAPDATA2\SIDODS_1\SIDODS.DATA1',

...

Regards.

Ganimede Dignan

[former_member204746 · Accepted solution]

you wrote: So I edit control.sql file to split in several drive letter... is it OK ?

yes, this is exactly what you can do and it is the easiest method.

I used this strategy many times in the past and it works well.

[Former Member]

I have not done on Win system (got it to work on Unix systems with change in path). As long as you are careful with drive letter and path being consistent and then run the control.sql, I don't see any issue.

thanks

BMG