手工完全恢复(非归档模式下,日志没有被覆盖)
来源:互联网 发布:网络施工资质要求 编辑:程序博客网 时间:2024/04/29 06:21
实验环境:red hat 5.8
oracle环境:11.2.0.3
历史日志没有被覆盖,只坏一个文件。
非归档模式,不能offline数据文件,即不能用高可用模式,只能转储,恢复,开库并进行恢复。
1、确认数据库是否为归档模式,如果是,则改为非归档模式。
sys@TEST0910> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 53
Next log sequence to archive 55
Current log sequence 55
sys@TEST0910> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
sys@TEST0910> startup mount;
ORACLE instance started.
Total System Global Area 2505338880 bytes
Fixed Size 2230952 bytes
Variable Size 587203928 bytes
Database Buffers 1895825408 bytes
Redo Buffers 20078592 bytes
Database mounted.
sys@TEST0910> alter database noarchivelog;
Database altered.
sys@TEST0910> alter database open;
Database altered.
sys@TEST0910> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 53
Current log sequence 55
sys@TEST0910> select log_mode from v$database;
LOG_MODE
------------
NOARCHIVELOG
2、重新备份,非归档模式下,只能做冷备份。
冷备份脚本参考:http://blog.csdn.net/rlhua/article/details/11850445
sys@TEST0910> @/u01/app/oracle/bak/cold_bak.sql
host cp /u01/app/oracle/oradata/test0910/disk1/users01.dbf /u01/app/oracle/bak/cold_bak
host cp /u01/app/oracle/oradata/test0910/example01.dbf /u01/app/oracle/bak/cold_bak
host cp /u01/app/oracle/oradata/test0910/lxtb01.dbf /u01/app/oracle/bak/cold_bak
host cp /u01/app/oracle/oradata/test0910/sysaux01.dbf /u01/app/oracle/bak/cold_bak
host cp /u01/app/oracle/oradata/test0910/system01.dbf /u01/app/oracle/bak/cold_bak
host cp /u01/app/oracle/oradata/test0910/testtb.dbf /u01/app/oracle/bak/cold_bak
host cp /u01/app/oracle/oradata/test0910/undotbs01.dbf /u01/app/oracle/bak/cold_bak
host cp /u01/app/oracle/fast_recovery_area/test0910/control02.ctl /u01/app/oracle/bak/cold_bak
host cp /u01/app/oracle/oradata/test0910/control01.ctl /u01/app/oracle/bak/cold_bak
Database closed.
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 2505338880 bytes
Fixed Size 2230952 bytes
Variable Size 587203928 bytes
Database Buffers 1895825408 bytes
Redo Buffers 20078592 bytes
Database mounted.
Database opened.
3、插入三次数据,分别是提交切换日志,提交不切日志,不提交不切日志。
sys@TEST0910> select count(*) from scott.test5;
COUNT(*)
----------
14
sys@TEST0910> insert into scott.test5 select * from scott.emp;
14 rows created.
sys@TEST0910> commit;
Commit complete.
sys@TEST0910> alter system switch logfile;
System altered.
sys@TEST0910> select count(*) from scott.test5;
COUNT(*)
----------
28
sys@TEST0910> insert into scott.test5 select * from scott.emp;
14 rows created.
sys@TEST0910> commit;
Commit complete.
sys@TEST0910> select count(*) from scott.test5;
COUNT(*)
----------
42
sys@TEST0910> insert into scott.test5 select * from scott.emp;
14 rows created.
sys@TEST0910> select count(*) from scott.test5;
COUNT(*)
----------
56
4、模拟断电
sys@TEST0910> shutdown abort;
ORACLE instance shut down.
5、删除文件
[oracle@rtest ~]$ rm /u01/app/oracle/oradata/test0910/disk1/users01.dbf
[oracle@rtest ~]$ ls /u01/app/oracle/oradata/test0910/disk1/users01.dbf
ls: /u01/app/oracle/oradata/test0910/disk1/users01.dbf: No such file or directory
6、起库,报错,查询丢失的数据文件
sys@TEST0910> startup;
ORACLE instance started.
Total System Global Area 2505338880 bytes
Fixed Size 2230952 bytes
Variable Size 587203928 bytes
Database Buffers 1895825408 bytes
Redo Buffers 20078592 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: '/u01/app/oracle/oradata/test0910/disk1/users01.dbf'
sys@TEST0910> select file#,error from v$recover_file;
FILE# ERROR
---------- -----------------------------------------------------------------
4 FILE NOT FOUND
7、转储数据文件
[oracle@rtest ~]$ cp /u01/app/oracle/bak/cold_bak/users01.dbf /u01/app/oracle/oradata/test0910/disk1/users01.dbf
8、恢复,开库
Media recovery complete.
sys@TEST0910> alter database open;
Database altered.
sys@TEST0910> select count(*) from scott.test5;
COUNT(*)
----------
42
- 手工完全恢复(非归档模式下,日志没有被覆盖)
- 手工完全恢复(非归档模式下,日志没有被覆盖)
- 手工不完全恢复(非归档模式下,日志被覆盖)
- 归档模式下的手工备份及完全恢复
- Oracle手工完全恢复案例(归档模式)
- Oracle手工恢复案例(非归档模式)
- RMAN之非归档日志模式下的数据文件恢复
- Oracle恢复(二)------非归档模式下的恢复
- 非归档模式下恢复数据文件浅析
- 恢复系列3--归档模式下丢失非当前联机日志
- RMAN之归档日志模式下的非关键文件恢复
- RMAN—非归档模式—完全恢复
- Oracle归档模式下恢复-数据库完全恢复方法1
- Oracle归档模式下恢复-数据库完全恢复方法2
- Oracle归档模式下恢复-数据库完全恢复方法3
- Oracle归档模式下恢复-数据库完全恢复方法4
- oracle恢复被覆盖(删除)的视图
- 手工完全恢复(高可用模式,即先开库,后恢复)
- CentOS 6.3(64位)上配置 Redmine
- dp--uva116
- gtest中,TEST_F与TEST的区别
- C#中的IntPtr类型
- linux环境变量(好好看)
- 手工完全恢复(非归档模式下,日志没有被覆盖)
- C工程
- 进程,线程,程序 概念和联系
- java基础语法
- hdu 4751 Divide Groups bfs (2013 ACM/ICPC Asia Regional Nanjing Online 1004)
- C++重载
- Kohana安装配置路由
- MyEclipse10-SSH简单开发应用
- PHP remember me