| backup problem [message #59323] |
Wed, 12 November 2003 01:43  |
Sudeep
Messages: 17
Registered: March 2002
|
Junior Member |
|
|
i am using physical backup and online. how to exctue automatic backup at each hour using script can any body give an sample script
thanks in advance
sudeep
|
|
|
|
|
|
|
|
| Re: backup problem [message #59327 is a reply to message #59325] |
Wed, 12 November 2003 05:22  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
Well On W2K u can batch prog and schedule it in windows as per ur requirement. If u know batch prog then u will not find any diff.
For ur convenience i m giving an example of batch prog:
SQLPLUS SYS/PASSWORD@CS AS SYSDBA
ALTER TABLESPACE TBS1 BEGIN BACKUP;
$ COPY FILE1 TO FILE2
$ COPY FILE2 TO FILE2
{copy all the files related to the tablespace TBS1}
ALTER TABLESPACE TBS1 END BACKUP;
{Follow the same way for other Tablespaces}
QUIT
Save the above file as ".BAT" extension and put it into the scheduler.
I hope it will help u alot. But for more see oracle doc.
|
|
|
|
| Re: backup problem [message #59338 is a reply to message #59327] |
Wed, 12 November 2003 10:59 |
ctg
Messages: 146
Registered: July 2002
|
Senior Member |
|
|
|
on Windows, make sure you do an OCOPY instead of a COPY. OCOPY is oracle supplied, located in %ORACLE_HOME%bin.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
