| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Using Windows' SUBST to avoid ALTER DATABASE RENAME FILEs?
"Jacob Share" <jacobshare_at_yahoo.com> a écrit dans le message de
news:9d4c10f3.0405060228.4f479528_at_posting.google.com...
> Our local deployment strategy uses a standard directory structure for
> each db instance : <Volume:>/Oracle/<SID>/etc. We need a remote site
> to send us backups that we'll validate after local restoration. The
> problem is that they weren't careful and didn't use a standard
> directory structure. In addition, their .DBFs are spread over many
> more logical disk partitions than necessary. We're unwilling to
> replicate this bad practice locally but we want restorations to be as
> quick and easy as possible (who doesn't?).
>
> To get around the need to do many ALTER DATABASE RENAME FILEs at every
> restoration, we're exploring the idea of using the Windows SUBST
> command to create virtual drives locally, and then using symbolic
> links (Win2k's 'junctions') to fill out the structure required by the
> restored dbs. This way the restored databases would find their pieces
> where they expect, but in reality they'll be nicely arranged according
> to our standard.
>
> My questions -
> 1) Will this work?
> 2) If so, will there be a performance hit?
> 3) If so, on what order? The local installation is in a development
> environment, so we'd be willing to accept a certain performance hit if
> it will save time and keep things clean.
>
> We're using Oracle 8.1.7 on Windows 2000 SP3.
>
> Thanks
>
> Jacob Share
I don't answer all your questions just one: you can use subst (Oracle 8.1.7.4, WinNT4):
SVRMGR> host subst o: D:\Oracle\Bases\Mike
SVRMGR> host dir o:
Le volume dans le lecteur O s'appelle Michel bis
Le numéro de série du volume est 2499-EB17
Répertoire de O:\
06/04/04 17:25 <DIR> .
06/04/04 17:25 <DIR> ..
30/04/04 22:36 10 022 912 CTL1.ORA
06/05/04 18:52 131 584 RL_G1_1.ORA
06/05/04 18:52 131 584 RL_G2_1.ORA
06/05/04 18:52 131 584 RL_G3_1.ORA
06/05/04 18:52 131 584 RL_G4_1.ORA
06/04/04 17:25 131 584 RL_G5_1.ORA
30/04/04 22:36 1 052 672 TEST2_01.DBF
30/04/04 22:36 20 975 616 TS_D0101.ORA
30/04/04 22:36 10 489 856 TS_I0101.ORA
30/04/04 22:36 20 975 616 TS_R0101.ORA
30/04/04 22:36 83 890 176 TS_S0101.ORA
30/04/04 22:36 10 489 856 TS_T0101.ORA
14 fichier(s) 158 554 624 octets
628 465 664 octets libres
SVRMGR> create tablespace foo datafile 'o:\foo.dbf' size 10m;
Statement processed.
Répertoire de O:\
06/05/04 18:53 <DIR> .
06/05/04 18:53 <DIR> ..
06/05/04 18:53 10 022 912 CTL1.ORA
06/05/04 18:53 10 489 856 FOO.DBF <------------------
06/05/04 18:52 131 584 RL_G1_1.ORA
06/05/04 18:52 131 584 RL_G2_1.ORA
06/05/04 18:52 131 584 RL_G3_1.ORA
06/05/04 18:52 131 584 RL_G4_1.ORA
06/04/04 17:25 131 584 RL_G5_1.ORA
30/04/04 22:36 1 052 672 TEST2_01.DBF
30/04/04 22:36 20 975 616 TS_D0101.ORA
30/04/04 22:36 10 489 856 TS_I0101.ORA
30/04/04 22:36 20 975 616 TS_R0101.ORA
30/04/04 22:36 83 890 176 TS_S0101.ORA
30/04/04 22:36 10 489 856 TS_T0101.ORA
15 fichier(s) 169 044 480 octets
627 150 848 octets libres
SVRMGR> host dir D:\Oracle\Bases\Mike
Répertoire de D:\Oracle\Bases\Mike
06/05/04 18:53 <DIR> .
06/05/04 18:53 <DIR> ..
06/05/04 18:53 10 022 912 CTL1.ORA
06/05/04 18:53 10 489 856 FOO.DBF <------------------------
06/05/04 18:52 131 584 RL_G1_1.ORA
06/05/04 18:52 131 584 RL_G2_1.ORA
06/05/04 18:52 131 584 RL_G3_1.ORA
06/05/04 18:52 131 584 RL_G4_1.ORA
06/04/04 17:25 131 584 RL_G5_1.ORA
30/04/04 22:36 1 052 672 TEST2_01.DBF
30/04/04 22:36 20 975 616 TS_D0101.ORA
30/04/04 22:36 10 489 856 TS_I0101.ORA
30/04/04 22:36 20 975 616 TS_R0101.ORA
30/04/04 22:36 83 890 176 TS_S0101.ORA
30/04/04 22:36 10 489 856 TS_T0101.ORA
15 fichier(s) 169 044 480 octets
627 150 848 octets libres
SVRMGR> select file_name from dba_data_files where tablespace_name='FOO';
FILE_NAME
0
1 row selected.
SVRMGR> drop table t;
Statement processed.
SVRMGR> drop tablespace foo;
Statement processed.
Regards
Michel Cadot
Received on Thu May 06 2004 - 12:11:10 CDT
 |
 |