Home » RDBMS Server » Backup & Recovery » backup problem
backup problem [message #59323] Wed, 12 November 2003 01:43 Go to next message
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 #59324 is a reply to message #59323] Wed, 12 November 2003 03:14 Go to previous messageGo to next message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Hi,

Which OS u r using script vary according to the diff OS.
Re: backup problem [message #59325 is a reply to message #59324] Wed, 12 November 2003 03:35 Go to previous messageGo to next message
Sudeep
Messages: 17
Registered: March 2002
Junior Member
i am using windows 2k server
pls help and any other sites except orafaq
sudeep
Re: backup problem [message #59327 is a reply to message #59325] Wed, 12 November 2003 05:22 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: backup
Next Topic: Oracle Hot backup
Goto Forum:
  


Current Time: Fri Mar 29 01:48:44 CDT 2024