-
编辑 删除
Using Fullbackup recovery one tablespace
9月份新公司以来的第一篇文章，有关数据恢复需求的记录： 用户需求查询2012年9月份的2笔数据，DBA需要从1.7TB的RMAN备份集中还原出2012-09年的数据。1，目前所有的可利用的设备存储空间为700GB，需还原的DB_SIZE=1.8TB； &nbs...
-
编辑 删除
alter database open resetlogs;
Recovery through RESETLOGS and reset of the incarnation of the databasePrior to Oracle 10g, the redo log files generated after opening the database with RESETLOGS could not be used with the backups ...
-
编辑 删除
pfile spfile
[oracle@RAC01 bdump]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 13 03:34:21 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to...
-
编辑 删除
Rman backup step
1、切換伺服器歸檔模式，如果已經是歸檔模式可跳過此步：sqlplus /nolog (啟動sqlplus)SQL> conn / as sysdba (以DBA身份連接資料庫)SQL> shutdown immediate; (立即關閉資料庫)SQL> startup mount (啟動實例並載入...
-
编辑 删除
RMAN Manager
oracle 之rman备份数据库(File system)1、备份整个数据库backup database format '/home/oracle/backup/rmandatabase_%U.bak';2、备份表空间backup tablespace abc format '/home/oracle/backuprmantablespace_%...
-
编辑 删除
11g Active Standby Database Automatic Block Corruption Repair
Block recovery is faster because no redo needs to be applied to the block that is taken from the physical standby database. 11g Active Standby Database Automatic Block Corruption RepairIn a...
-
编辑 删除
11g RMAN Compression
11g Release 2 RMAN Backup CompressionOracle 11g Release 2 introduced compression algorithm levels which can be used for compressing table data, Data Pump exports and RMAN backups as well.The compr...
-
编辑 删除
Linux異機備份
umount /mntmount -t smbfs -o username=dbadmin,password=Oracle123 //10.203.194.101/d$ /mntcp -Rf /backup/fullback/*.dmp /mnt/ap3backup/ # rm -rf /mnt/backupdata/mysqlbackup/# cp -Rf /backup/mysqlba...
-
编辑 删除
利用Log還原數據庫到某一時間點
/*利用log還原到時間點*/-- 第一部分_創建數據庫PrimaryDB01use master;go create database PrimaryDB01on primary ( name =PrimaryDB01_data01, &nb...
-
编辑 删除
Flashback data
set time oncreate table ygzhou.flash(id int); beginfor i in 1..20 loopinsert into ygzhou.flash values(i);end loop;commit;end;/ delete from ygzhou.flash where id>8 or id <5;...
-
编辑 删除
How to recover from missing datafile
11g Data Recovery A...
