基于LInux的Oracle数据库备份

最新推荐文章于 2023-04-15 11:42:57 发布

原创最新推荐文章于 2023-04-15 11:42:57 发布 · 371 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #操作系统

本文详细介绍了如何在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;