Ajay,
He wanted a Solution for Moving the files.
1. As Ajay told Shutdown Immediate/Transactional do not abort.
2. Copy the controlfiles to the required location.
3. Change the control_files parameter in the init.ora file.
4. Copy all the DATAFILES to the required location.
5. Startup Mount the database.
6. Use Alter Database Rename file to Rename all the data files. This is for
updating your Controlfile entries.
7. use Alter database add logfile to add new Logfile groups to the new
location.
8. Drop the Old Logfile Groups by saying alter database drop logfile group
<no>
[The 7th and 8th steps are necessary because you cannnot modify the
logfiles]
9. Alter database Open
10. Shutdown Immediate and Take a Cold backup.
As Ajay told pls Follow the OFA Standards as mentioned in the oracle
documentation. Do not store every file in the same drive this will lead to a
single point of failure. If you ae not able to afford raid levels and all
you can atleast buy more small size HDD like say 10 9GB ones so that you can
spread the files acorsss the drives. Especially mirror the Redo Logs.
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
============================================
Live to learn... forget... and learn again.
============================================
-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed]
Sent: Wednesday, July 31, 2002 11:08 AM
To: LazyDBA.com Discussion
Subject: Re: Moving Files...
Hi,
As you database is in Nonarchivelog mode, before copying the file, shutdown
you database. Then copy all these files to the alternate location. This will
be a cold backup of your database. As a suggestion I would say that do not
keep all your files on one harddisk only. All your controlfiles and
datafiles are in one directory only. Change their location (atleast of the
controlfiles). It is good for database security in an event of media
failure.
Regards
Ajay Parashar.
Iyyappan
Manivasagam To: "LazyDBA.com
Discussion" <[Email Address Removed]
<[Email Address Removed] cc:
.com> Subject: Moving Files...
31/07/2002 12:18
PM
Dear Gurus,
The Following files avaliable in my directory: /oracle/oradata/dummy
control01.ctl datanxt.dbf redo01.log temp01.dbf
control02.ctl drsys01.dbf redo02.log tools01.dbf
control03.ctl example01.dbf redo03.log undotbs01.dbf
cwmlite01.dbf indx01.dbf system01.dbf users01.dbf
Now i want to move from one directory to other directory(Source to Target).
because my database is Noarchivelog mode and i want to safe all files for my
security.
How to move all files from one directory to other directory,Please explain.
Expecting ur reply,
Thanks,
Iyyappan.M
**************************************************************
M. H. ALSHAYA CO. W.L.L.
I T Division
P. O. Box 181, Safat 13002
Kuwait
Tel: 224 2000 / 224 2262
Fax: 4817885
**************************************************************
--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html
--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page