基于LInux的Oracle数据库备份

conn sys/db as sysdba
shutdown immediate;
#--控制文件select * from v$controlfile;
!cp /home/dog/oracle/product/10.2.0/oradata/orcl/control01.ctl /mnt/sdb3/backup/disk4/orcl
!cp /home/dog/oracle/product/10.2.0/oradata/orcl/control02.ctl /mnt/sdb3/backup/disk5/orcl
!cp /home/dog/oracle/product/10.2.0/oradata/orcl/control03.ctl /mnt/sdb3/backup/disk6/orcl

#--数据文件select file_name from dba_data_files;
!cp /home/dog/oracle/product/10.2.0/oradata/orcl/users01.dbf /mnt/sdb3/backup/disk3/orcl
!cp /home/dog/oracle/product/10.2.0/oradata/orcl/sysaux01.dbf /mnt/sdb3/backup/disk3/orcl
!cp /home/dog/oracle/product/10.2.0/oradata/orcl/undotbs01.dbf /mnt/sdb3/backup/disk3/orcl
!cp /home/dog/oracle/product/10.2.0/oradata/orcl/system01.dbf /mnt/sdb3/backup/disk3/orcl
!cp /home/dog/oracle/product/10.2.0/oradata/orcl/example01.dbf /mnt/sdb3/backup/disk3/orcl
!cp /mnt/sdb3/database/disk1/orcl/dog_data.dbf /mnt/sdb3/backup/disk1/orcl
!cp /mnt/sdb3/database/disk1/orcl/dog_index.dbf /mnt/sdb3/backup/disk1/orcl
!cp /mnt/sdb3/database/disk3/orcl/orcl_undo.dbf /mnt/sdb3/backup/disk3/orcl

#--重做日志文件select member from v$logfile order by member;
!cp /home/dog/oracle/product/10.2.0/oradata/orcl/redo01.log /mnt/sdb3/backup/disk4/orcl
!cp /home/dog/oracle/product/10.2.0/oradata/orcl/redo02.log /mnt/sdb3/backup/disk5/orcl
!cp /home/dog/oracle/product/10.2.0/oradata/orcl/redo03.log /mnt/sdb3/backup/disk6/orcl

#--参数文件show parameter pfile;
!cp /home/dog/oracle/product/10.2.0/db_1/dbs/spfileorcl.ora /mnt/sdb3/backup/disk10/orcl
conn sys/db as sysdba
starup open;