Backups - 10g R1

To backup the Oracle database on fts:

• login as oracle@fts
• Do the following:
  $ cd /oradata1/backup/tmp
  $ ls -l
  lrwxrwxrwx    1 oracle    13 Nov 17 10:34 backup.sql -> ../backup.sql
  $ sqlplus / as sysdba
  SQL> @backup
  $ mkdir MonDD
  $ mv *.dbf *.log *.cmd MonDD
  $ tar zcf MonDD.tgz MonDD
  $ rm -rf MonDD
  $ scp -p MonDD.tgz user@host:/path/to/backup/location/
  $ mv MonDD.tgz ../tarballs/
• Eventually clean up the archive redo log files in /oradata[23]/archive/
  $ pwd
  /oradata2/archive
  $ find . -daystart -name '*.dbf' -mtime +1 -ls | less
  $ find . -daystart -name '*.dbf' -mtime +1 -exec rm {} \;