Re: How can I allocate database files to another hard disks

"Ursula Lee" <ursula.lee_at_thales-is.com> a écrit dans le message news: br6ir9$klc82_at_imsp212.netvigator.com...
> Thanks. But I still have couple of questions:
>
> 1. How should I name the mount point and path and calculate the size
> for data files store in the new hard disks? Should I use symbolic link?
> The current dbf files distribution is listed below. (see below : First
> part show distribution of dbf files, second part is the bdf of our
> current harddisk )

Oracle dedicated FS are usually named /u0[0-n] Never use symblinks for dbf, rdo or ctl files.

> 2. I have to physically move the datafiles to the new location or I can
> just type : alter tablespace <tablespace_name>...... in sqlplus?
> Is it required to delete the original .dbf files?

I suggest you to read The Administrator's Guide, Chapter 10 It'll be worth the time spent, trust me.

> 3. Do I have to recreate the tablespace again, as I have the CreateDB
> file scripts?

Absolutely not.
The main purpose of tablespace is to provide a logical abstract layer. You'll simply add new datafiles to an existing tablespace.

> 4. For existing Oracle instance, like rollback segment, any changes
> required? Does that mean I just need to alter the database files, and
> nothing else?

Without any firther informations about how your DB works, I'd say no changes required in rollback segments unless they're undersized.

> 5. Should I move all the database files to the new hard disks, or just
> some of them?

Why do you want to move them ? Are your "old" disks near to crash ?

> 6. If I need to mirror the controlfiles and multiplex the redo logs,
> how should I handle this? I can see our CreateDB.sql script contains
> the setup on 'redo log', should I handle this here? I need to recreate
> the log files?

Read the manual (see above)
Chapter 5 (control files)
Chapter 6 (redolog)

I don't know what is your role maintaining the application and its DB but I strongly recommend (and I won't be the only one) that you take a course of DBA if you intend to get into this kind of tasks you've mentionned above.

--
Cheers,
Alkos

mail me at slouchart.ext_at_NOSPAMfrancetelecom.com
(remove NOSPAM)