| Mehul |
Posted: May 01, 2008 08:02:33 AM |
Total Post: 1
Joined: May, 2008
|
I have two different database running simultaneously on a server with SCO Unixware 711 and Oracle 8.0.4. The two databases are not inter-linked. Both database are Identified by two different ORACLE_SID, say SALARY and ACCOUNTS.
The Database is always left running by the users at night though not required . I have another server with similar setup. I want to write an sql script that can shutdown any open database and transfer all database files to another server through ftp. This activity can be carried out at night unattended, thus requiring cron usage.
Can anyone guide me? I need to write an SQL script, ftp script and an cron configuration.
Thanks. |
|
|
 Murtuja |
| Posted: May 01, 2008 08:16:02 AM |  |
|
Total Post: 814
Joined: Jan, 2006
|
Hi,
http://www.adp-gmbh.ch/ora/admin/backup_recovery/coldbackup_sh.html
HTH
|
|
|
|
|
| Mohammed Taj |
| Posted: May 01, 2008 09:04:38 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
With Crontab Example
http://dbataj.blogspot.com/2007/03/coldbackuplinuxscript.html
|
|
|
|
|
| Gitesh |
| Posted: May 05, 2008 05:11:18 AM | |
|
Total Post: 322
Joined: May, 2005
|
Hi Taj,
Your coldbackup script contains following entries..
sqlplus -s sys/oracle as sysdba @/home/oracle/shutdown.sql
sqlplus -s sys/oracle as sysdba @/home/oracle/coldbackup.sql
sqlplus -s sys/oracle as sysdba @/home/oracle/startup.sql
Can you tell me how you make coldbackup.sql? Before shutdown database? Or it is static? If static then it needs fresh whenever we are adding new datafile in database.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
