Home » RDBMS Server » Server Administration » compress
compress [message #56094] Wed, 05 March 2003 13:34 Go to next message
Sergio Jurbarg
Messages: 1
Registered: March 2003
Junior Member
I want to make a hot backup Oracle on disk, I don't have much space. Can I make a cp+compress in one stage?
Thanks
Sergio Jurbarg
Re: compress [message #56107 is a reply to message #56094] Thu, 06 March 2003 05:54 Go to previous message
Oskar
Messages: 26
Registered: May 2002
Junior Member
Something like that should work setting appropiated variables first and ALTER TABLESPACE tablespace_name BEGIN BACKUP:

mknod $BACKUP_DIR/$DATAFILE_NAME.dbf p
compress < $BACKUP_DIR/$DATAFILE_NAME.dbf > $BACKUP_DIR/$DATAFILE_NAME.dbf.Z &
cp $ORACLE_DBFS/$DATAFILE_NAME.dbf $BACKUP_DIR/$DATAFILE_NAME.dbf

Hope this helps.
Previous Topic: calling Java methods from Oracle
Next Topic: ORA-03114 Not connected to ORacle Urgent..!!!!
Goto Forum:
  


Current Time: Fri Sep 20 01:58:38 CDT 2024