-
编辑 删除
块跟踪
创建目录[oracle@hu app]$ mkdir bct [oracle@hu app]$ lltotal 16drwxr-xr-x 2 oracle oinstall 4096 May 15 11:16 backupdrwxr-xr-x 2 oracle oinstall 4096 May 15 12:36 bctdrwxr-xr-x 8 oracle oinstall 4096 Apr 22 18:13 oracledrwxrwx--- 5 oracle oinstall 4096 Apr 22 18:05 oraInventory[oracle@hu...
-
编辑 删除
丢失current状态日志文件
查看当前日志组状态，数据库处于归档模式SQL> select group#,members,archived,status from v$log; GROUP# MEMBERS ARC STATUS---------- ---------- --- ---------------- &nbs...
-
编辑 删除
删除inactive日志组，重启数据库后恢复
-----当前日志组状态SQL> select group#,members,status from v$log; GROUP# MEMBERS STATUS---------- ---------- ---------------- 1 1 CURRENT...
-
编辑 删除
丢失 INACTIVE状态 日志
---查看当前日志组状态SQL> select group#,members,status from v$log; GROUP# MEMBERS STATUS---------- ---------- ---------------- 1 1 INACTIVE...
-
编辑 删除
自动tempfile恢复
一：删除临时表空间数据文件[oracle@hu ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Sun May 7 10:54:18 2017Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:...
-
编辑 删除
控制文件备份到跟踪文件
root@hu ~]# su - oracle [oracle@hu ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Sun May 7 10:08:36 2017Copyright (c) 1982, 2013, Oracle. All rights reserved....
-
编辑 删除
备份控制文件到指定位置
[oracle@hu ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Sun May 7 10:19:24 2017Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Datab...
-
编辑 删除
RMAN 备份全库
登入目标数据库[oracle@hu app]$ rman target /Recovery Manager: Release 11.2.0.4.0 - Production on Fri May 5 16:18:22 2017Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.connected ...
-
编辑 删除
RMAN的完全备份
---#不包括归档日志 ----完全备份（指定目录）RMAN> backup as backupset format '/home/oracle/data_base%U' database;Starting backup at 19-DEC-16using channel ORA_DISK_1channel ORA_DISK_1: starting full datafile backup set...
-
编辑 删除
RMAN备份system表空间
----要查询数据库在归档模式下SQL> archive log list Database log mode Archive ModeAutomatic archival EnabledArchive destination &nb...
