ORACLE11G 数据库冷备份

最新推荐文章于 2024-02-28 16:01:32 发布

思考v

最新推荐文章于 2024-02-28 16:01:32 发布

阅读量2.6k

点赞数

分类专栏： Oracle备份与恢复

本文链接：https://blog.csdn.net/xiegh2014/article/details/52254140

版权

Oracle备份与恢复专栏收录该内容

20 篇文章 0 订阅

订阅专栏

冷备份数据库
ogg-node1-> mkdir /home/oracle/bk

SQL> set pagesize 200
SQL> set linesize 160
select 'cp -v '||name||' /home/oracle/bk/'
from
(select name from v$controlfile
union all
select name from v$datafile
union all
select member from v$logfile);


'CP-V'||NAME||'/HOME/ORACLE/BK/'
----------------------------------------------------------------------------------------------------------------------------
cp -v /u02/app/oracle/oradata/gdb1/control01.ctl /home/oracle/bk/
cp -v /u02/app/oracle/oradata/gdb1/system01.dbf /home/oracle/bk/
cp -v /u02/app/oracle/oradata/gdb1/sysaux01.dbf /home/oracle/bk/
cp -v /u02/app/oracle/oradata/gdb1/undotbs01.dbf /home/oracle/bk/
cp -v /u02/app/oracle/oradata/gdb1/users01.dbf /home/oracle/bk/
cp -v /u02/app/oracle/oradata/gdb1/ggs.dbf /home/oracle/bk/
cp -v /u02/app/oracle/oradata/gdb1/example.dbf /home/oracle/bk/
cp -v /u02/app/oracle/oradata/gdb1/redo01.log /home/oracle/bk/
cp -v /u02/app/oracle/oradata/gdb1/redo03.log /home/oracle/bk/
cp -v /u02/app/oracle/oradata/gdb1/redo02.log /home/oracle/bk/

10 rows selected.

SQL> exit

ogg-node1-> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Aug 19 20:27:15 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
将参数文件、数据库文件、控制文件、日志文件进行冷备
ogg-node1-> cp -v /u02/app/oracle/oradata/gdb1/control01.ctl /home/oracle/bk/
ogg-node1-> cp -v /u02/app/oracle/oradata/gdb1/system01.dbf /home/oracle/bk/
ogg-node1-> cp -v /u02/app/oracle/oradata/gdb1/sysaux01.dbf /home/oracle/bk/
ogg-node1-> cp -v /u02/app/oracle/oradata/gdb1/undotbs01.dbf /home/oracle/bk/
ogg-node1-> cp -v /u02/app/oracle/oradata/gdb1/users01.dbf /home/oracle/bk/
ogg-node1-> cp -v /u02/app/oracle/oradata/gdb1/ggs.dbf /home/oracle/bk/
ogg-node1-> cp -v /u02/app/oracle/oradata/gdb1/example.dbf /home/oracle/bk/
ogg-node1-> cp -v /u02/app/oracle/oradata/gdb1/redo01.log /home/oracle/bk/
ogg-node1-> cp -v /u02/app/oracle/oradata/gdb1/redo03.log /home/oracle/bk/
ogg-node1-> cp -v /u02/app/oracle/oradata/gdb1/redo02.log /home/oracle/bk/
ogg-node1-> cp -v /u01/app/oracle/product/11.2.0.4/db_1/dbs/orapwgdb1 /home/oracle/bk/
ogg-node1-> cp -v /u01/app/oracle/product/11.2.0.4/db_1/dbs/spfilegdb1.ora /home/oracle/bk/
备份成功之后校验备份文件的有效性:
ogg-node1-> dbv file=/home/oracle/bk/system01.dbf blocksize=8192
DBVERIFY: Release 11.2.0.4.0 - Production on Fri Aug 19 20:43:04 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
DBVERIFY - Verification starting : FILE = /home/oracle/bk/system01.dbf
DBVERIFY - Verification complete
Total Pages Examined : 96000
Total Pages Processed (Data) : 63732
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 13141
Total Pages Failing (Index): 0
Total Pages Processed (Other): 3439
Total Pages Processed (Seg) : 1
Total Pages Failing (Seg) : 0
Total Pages Empty : 15688
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Total Pages Encrypted : 0
Highest block SCN : 1142772 (0.1142772)

批量执行备份成功之后校验备份文件的有效性:
ogg-node1-> for i in $(find /home/oracle/bk/ -name "*.dbf");do dbv file=$i blocksize=8192;done
DBVERIFY: Release 11.2.0.4.0 - Production on Fri Aug 19 20:43:29 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
DBVERIFY - Verification starting : FILE = /home/oracle/bk/example.dbf
DBVERIFY - Verification complete
Total Pages Examined : 192000
Total Pages Processed (Data) : 10
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 2
Total Pages Failing (Index): 0
Total Pages Processed (Other): 139
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 191849
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Total Pages Encrypted : 0
Highest block SCN : 1092786 (0.1092786)
DBVERIFY: Release 11.2.0.4.0 - Production on Fri Aug 19 20:43:34 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
DBVERIFY - Verification starting : FILE = /home/oracle/bk/sysaux01.dbf
DBVERIFY - Verification complete
Total Pages Examined : 70400
Total Pages Processed (Data) : 12207
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 8544
Total Pages Failing (Index): 0
Total Pages Processed (Lob) : 9350
Total Pages Failing (Lob) : 0
Total Pages Processed (Other): 18980
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 21319
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Total Pages Encrypted : 0
Highest block SCN : 1142745 (0.1142745)
DBVERIFY: Release 11.2.0.4.0 - Production on Fri Aug 19 20:43:36 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
DBVERIFY - Verification starting : FILE = /home/oracle/bk/ggs.dbf
DBVERIFY - Verification complete
Total Pages Examined : 1280
Total Pages Processed (Data) : 0
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing (Index): 0
Total Pages Processed (Other): 127
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 1153
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Total Pages Encrypted : 0
Highest block SCN : 1036489 (0.1036489)
DBVERIFY: Release 11.2.0.4.0 - Production on Fri Aug 19 20:43:36 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
DBVERIFY - Verification starting : FILE = /home/oracle/bk/users01.dbf
DBVERIFY - Verification complete
Total Pages Examined : 640
Total Pages Processed (Data) : 30
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 4
Total Pages Failing (Index): 0
Total Pages Processed (Other): 593
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 13
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Total Pages Encrypted : 0
Highest block SCN : 1049906 (0.1049906)
DBVERIFY: Release 11.2.0.4.0 - Production on Fri Aug 19 20:43:37 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
DBVERIFY - Verification starting : FILE = /home/oracle/bk/system01.dbf
DBVERIFY - Verification complete
Total Pages Examined : 96000
Total Pages Processed (Data) : 63732
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 13141
Total Pages Failing (Index): 0
Total Pages Processed (Other): 3439
Total Pages Processed (Seg) : 1
Total Pages Failing (Seg) : 0
Total Pages Empty : 15688
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Total Pages Encrypted : 0
Highest block SCN : 1142772 (0.1142772)
DBVERIFY: Release 11.2.0.4.0 - Production on Fri Aug 19 20:43:39 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
DBVERIFY - Verification starting : FILE = /home/oracle/bk/undotbs01.dbf
DBVERIFY - Verification complete
Total Pages Examined : 10880
Total Pages Processed (Data) : 0
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing (Index): 0
Total Pages Processed (Other): 10879
Total Pages Processed (Seg) : 10
Total Pages Failing (Seg) : 0
Total Pages Empty : 1
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Total Pages Encrypted : 0
Highest block SCN : 1142770 (0.1142770)