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 LazyDBA home page