-
Hi all!
I have this query:
WE are into Development stage and working on Oracle v8i with NT as OS.
1.I take cold backups of the following DB Files by shutting down the DB:
a).Control01.ctl,Control02.ctl,Control03.ctl Files
b).Users01.dbf
c).Temp01.dbf
d).Indx01.dbf
e).Tools01.dbf
f).Parameter File INIT.ORA.
g).Password File.
The above DB files are on d:\> drive.
Cold Backups I store on E:> drive.
In case the DB crashes,do I have to put the Db in ArchiveLog Mode
and recover upto a certain point in time.
As when the Db is shutdown to take cold backups,Db goes into the default NoArchivelog Mode.
Is it OK!
2.How could I make my Application Developers make use and run TKPROF,AUTOTRACE utility from their client machines to tune their sql queries.
Thanks&Regards,
Amit.
-
backup
please do a back up a trace file which will help you in creating new control files in case of db crash.
if db crashes you only have to give the parameter file.
startup nomount pfile='where you saved the pfile'
then create the new control file(if you have change the destination ie c:\ to d:\
then make the system in archive log but be sure you have entries in init.ora file uncomented.
Saurabh Garg
OCP 9i
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|