【若泽大数据】一致性备份（冷备份）

最新推荐文章于 2023-03-20 01:39:51 发布

强悍de巨人

最新推荐文章于 2023-03-20 01:39:51 发布

阅读量380

点赞数

分类专栏：【若泽大数据】Oracle

本文链接：https://blog.csdn.net/qq_24073707/article/details/80078383

版权

10 篇文章 0 订阅

订阅专栏

 
 一致性备份（冷备份） 

 
 首先创建两个备份的路径 

 
 mdirk /home/oracle/orcl_bak/cold_bak/ 

 
 mkdir /home/oracle/orcl_bak/hot_bak/ 

 
 创建手工冷备份脚本 

  SQL> @/home/oracle/orcl_bak/cold_bak/cold_bak.sql 

  vi 
 /home/oracle/ 
 orcl_bak 
 /cold_bak/cold_bak.sql (备份路径) 

 
 （备份脚本编辑） 

 
 ——编写生成备份脚本的脚本 

  #cold backcup 

  remark set sql*plus variable to manipulate output         // 
 注释 

  set feedback off heading off verify  off trimspool off  echo off time off 

  set pagesize 0  linesize 200 

  remark set sql*plus user variable used  in this script                // 
 注释 

  define bakdir=' 
 /home/oracle/orcl_bak/cold_bak'                            //备份文件的存放位置 

  define bakscp=' 
 /home/oracle/orcl_bak/cold_cmd.sql'              //执行备份的脚本，自动生成 

  prompt *** Spooling to &bakscp                        // 
 输出提示语 

  remark  create a command file with  file backup commands 

  spool &bakscp 

    select 'host cp '|| name ||' &bakdir ' from v$datafile order by 1; 

    select 'host cp '|| name ||' &bakdir ' from v$controlfile order by 1; 

   spool off; 

  remark   shutdown the database cleanly 

  shutdown immediate; 
 ——冷备份需要关库执行 

  remark run the copy file commands form the operating system 

  @&bakscp 

  remark start the database again 

  startup; 

 
 ——执行该脚本生成了一个脚本cold_cmd.sql，并执行该脚本进行冷备份 

  SQL> conn /as sysdba 

  Connected. 

  SQL> @/export/home/oracle/sqlplus/anny_cold_bak 

  SP2-0734: unknown command beginning "cold backc..." - rest of line ignored. 

  *** Spooling to /disk1/backup/anny/cold_bak/cold_cmd.sql        
 ——一下是脚本内容 

  host cp /u01/app/oracle/oradata/anny/index01.dbf /disk1/backup/anny/cold_bak 

  host cp /u01/app/oracle/oradata/anny/lx01.dbf /disk1/backup/anny/cold_bak 

  host cp /u01/app/oracle/oradata/anny/lx02.dbf /disk1/backup/anny/cold_bak 

  host cp /u01/app/oracle/oradata/anny/lx03.dbf /disk1/backup/anny/cold_bak 

  host cp /u01/app/oracle/oradata/anny/lx04.dbf /disk1/backup/anny/cold_bak 

  host cp /u01/app/oracle/oradata/anny/sysaux01.dbf /disk1/backup/anny/cold_bak 

  host cp /u01/app/oracle/oradata/anny/system01.dbf /disk1/backup/anny/cold_bak 

  host cp /u01/app/oracle/oradata/anny/text01.dbf /disk1/backup/anny/cold_bak 

  host cp /u01/app/oracle/oradata/anny/undotbs01.dbf /disk1/backup/anny/cold_bak 

  host cp /u01/app/oracle/oradata/anny/user01.dbf /disk1/backup/anny/cold_bak 

  host cp /disk1/oradata/anny/control02.ctl /disk1/backup/anny/cold_bak 

  host cp /disk2/oradata/anny/control03.ctl /disk1/backup/anny/cold_bak 

  host cp /u01/app/oracle/oradata/anny/control01.ctl /disk1/backup/anny/cold_bak 

  Database closed. 

  Database dismounted. 

  ORACLE instance shut down. 

  ORACLE instance started. 

  Total System Global Area  314572800 bytes 

  Fixed Size                  1279964 bytes 

  Variable Size              58722340 bytes 

  Database Buffers          251658240 bytes 

  Redo Buffers                2912256 bytes 

  Database mounted. 

  Database opened. 

 
 备份完后的东西 

  SQL> set echo on trimspool on heading on feedback on verify on 

  SQL> select file_id,file_name,tablespace_name,bytes/1024/1024 m from dba_data_files; 

  FILE_ID FILE_NAME TABLESPACE_NAME M 

  ---------- -------------------- -------------------- ---------- 

  4 /u01/app/oracle/orad USERS 5 

  ata/orcl/users01.dbf 

  3 /u01/app/oracle/orad UNDOTBS1 410 

  ata/orcl/undotbs01.d 

bf

  2 /u01/app/oracle/orad SYSAUX 640 

  ata/orcl/sysaux01.db 

f

  1 /u01/app/oracle/orad SYSTEM 700 

  ata/orcl/system01.db 

f

关注