| vikhardba |
Posted: Jan 04, 2008 12:11:37 AM |
Total Post: 86
Joined: Apr, 2007
|
Hi to One and All,
Installed Oracle 10g on Win 2003 server.
version : 10.2.0.1.0
Can anyone let me know how to take full database cold backup on windows 2003. Also please let me know how to set job scheduler specific for taking database backup.
I also know the location of C/R/D and Archive files, but don't know how to set scheduler for taking this backup.
Regards,
Vikhardba |
|
|
 Murtuja |
| Posted: Jan 04, 2008 12:59:26 AM |  |
|
Total Post: 857
Joined: Jan, 2006
|
Hi,
Cold backup idea is not suitable for any production database.You will get lot of performance related issue if you frequently shutdown your database.
RMAN is the best if you have production database.
Anyway..You have asked about cold backup so you need to write a simple BATCH file which will shutdown database first then you need to copy all files into another location.Archive log is not needed during cold backup.
If you have further questions then please post here
|
|
|
|
|
| Murtuja |
| Posted: Jan 04, 2008 01:03:23 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
I forget to write about job scheduling.
You can schedule jobs in Windows by this way..
Control Panel --> Scheduled Tasks --> Add Scheduled Tasks
It will open wizard and here you have to specify location of your batch file and time when you need to run this job
|
|
|
|
|
| vikhardba |
| Posted: Jan 04, 2008 03:19:00 PM | |
|
Total Post: 86
Joined: Apr, 2007
|
Thanks for your speedy response.
Thanks for giving me this idea of creating bat file. However, can i know what to write into bat file. I am aware of job scheduling wizard and i tried on some other applications but not on taking backup of complete database. Like you told, i have to first write shut down database and then copy c/r/d files into another loc, but let me kow the complete steps need to be written in batch file.
|
|
|
|
|
| MOH_DBA |
| Posted: Jan 04, 2008 05:38:21 PM | |
|
Total Post: 161
Joined: Nov, 2007
|
In the batch file you write the Fowlling:
set ORACLE_SID=database_name
set ORACLE_HOME=the_home
$ORACLE_HOME/bin/sqlplus /nolog @C:\bakcup.sql
------------
In the backup.sql
------------
shutdown immediate;
--write this for all you data file
host copy datafile_name to new_location
alter system archive log current;
alter database backup controlfile to trace;
--for the three control files
alter database backup controlfile to C:\directory\control01.ctl resuse;
startup;
|
|
|
|
|
| Mohammed Taj |
| Posted: Jan 04, 2008 11:48:12 PM | |
|
Total Post: 746
Joined: Jul, 2007
|
http://dbataj.blogspot.com/2007/01/coldbackupscripts.html
|
|
|
|
|
| vikhardba |
| Posted: Jan 06, 2008 10:56:50 AM | |
|
Total Post: 86
Joined: Apr, 2007
|
I've gone through above mentioned steps and web link, it is too good and helpful. Thanks a million!!!
Regards,
Mohammed Vikhar
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
