Home » RDBMS Server » Backup & Recovery » Urgent (Script )
Urgent (Script ) [message #124811] Tue, 21 June 2005 11:30 Go to next message
rudolfguth
Messages: 2
Registered: June 2005
Junior Member
Hi,

Thank you for answer me... But I need the scriptso I can set a time and date to start the Oracle 9 backup... If anyone know anything about this script please send it to me!!!!

Thank You again..
Re: Urgent (Script ) [message #124813 is a reply to message #124811] Tue, 21 June 2005 11:42 Go to previous messageGo to next message
rsone
Messages: 7
Registered: June 2005
Location: Jacksonville
Junior Member
To have current Date and time appended to your backup file you can have spool file file for your backup log which can be showed as filename with Date and Time to track Date and Time.

Here is how you do it


column filedate new_value filedate noprint;
select to_char(sysdate,'yyyymmddhh24miss') filedate from dual;

spool <urspoolfilename>&filedate..log

Can you try this method?
Re: Urgent (Script ) [message #126114 is a reply to message #124811] Fri, 01 July 2005 01:41 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


Hey try this link :

http://www.dbasupport.com/oracle/scripts/

So many scripts r thr for backup & recovery.

Check it out

Tarun
Previous Topic: ORA-04030 error while taking backup using RMAN
Next Topic: How to Export & Import a Tablespace and part of a table
Goto Forum:
  


Current Time: Thu Mar 28 04:50:46 CDT 2024