oracle导入导出学习(6)

devtype varchar2(256); done boolean; begin

devtype :=dbms_backup_restore.deviceallocate(type=>'',ident=>'c1'); dbms_backup_restore.restoresetdatafile;

dbms_backup_restore.restoredatafileto(dfnumber=>5,toname=>'/u01/oracle/oradata/seeddata/example01.dbf');

dbms_backup_restore.restorebackuppiece(done=>done,handle=>'/home/oracle/rmanbk/rmanbk/example01.dfb'); dbms_backup_restore.devicedeallocate; end; /

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

增量备份:

backup incremental level 0 as compressed backupset tablespace users; backup incremental level 3 as compressed backupset tablespace users; backup incremental level 3 as compressed backupset tablespace users; backup incremental level 2 as compressed backupset tablespace users; backup incremental level 2 as compressed backupset tablespace users; backup incremental level 1 as compressed backupset tablespace users; backup incremental level 3 as compressed backupset tablespace users; backup incremental level 3 as compressed backupset tablespace users; backup incremental level 2 as compressed backupset tablespace users; backup incremental level 2 as compressed backupset tablespace users; backup incremental level 0 as compressed backupset tablespace users;

查看块跟踪是否启动:

select filename,status,bytes from v$block_change_tracking; 启用块跟踪:

alter database enable block change tracking using file '/home/alvin/orcl_block_track.log';

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

块级别修复损坏:

SQL> select count(*) from scott.t01;

COUNT(*) ---------- 448

SQL> select count(*) from scott.t02;

COUNT(*)

---------- 1848

块级别修复损坏 :

RMAN> backup validate database;

SQL> select * from v$database_block_corruption; RMAN> blockrecover corruption list;

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 编译bbed： su - oracle

cd $ORACLE_HOME/rdbms/lib

make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed

ln -s $ORACLE_HOME/rdbms/lib/bbed $ORACLE_HOME/bin/bbed

准备参数文件：

--/home/alvin/bbed.par-- blocksize=8192

listfile=/home/alvin/filelist.txt logfile=log.bbed

准备列表文件：

select file_id||' '||file_name||' '||bytes from dba_data_files;

/home/alvin/filelist.txt

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 6 /opt/oracle/oradata/alvin/demo01.dbf 262144

找到有数据的块:

select dbms_rowid.rowid_block_number(rowid),count(*) from scott.t01 group by dbms_rowid.rowid_block_number(rowid);

bbed parfile==/home/alvin/bbed.par BBED> set mode edit BBED> set dba 6,28

BBED> modify 1000 file 6 block 28 BBED> sum apply

alter system flush buffer_cache;

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 清理rman备份: 修改备份保留策略:

CONFIGURE RETENTION POLICY TO REDUNDANCY 3; 查看陈旧的备份:

report obsolete; 删除陈旧的备份: delete obsolete;

delete noprompt obsolete;

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ rman不完全恢复:

backup as compressed backupset database plus archivelog; run{

set until scn 1677624; restore database;

recover database; 1674917

alter database open resetlogs; }

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 回到上一个副本: list incarnation;

reset database to incarnation 2; -->Inc Key

restore database; recover database;

alter database open resetlogs;

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 恢复目录数据库:

conn sys/oracle@catalogdb as sysdba create tablespace rmantbs datafile

'/u01/oracle/oradata/rtt/rmantbs01.dbf' size 200m;

grant connect,resource,recovery_catalog_owner to catalogdb identified by oracle;

alter user catalogdb default tablespace rmantbs;

rman catalog catalogdb/oracle@catalogdb

RMAN> create catalog; RMAN> exit

rman target / catalog catalogdb/oracle@catalogdb RMAN> register databse; RMAN> list backup;

RMAN> backup as compressed backupset database plus archivelog; RMAN> restore spfile;

RMAN> restore controlfile;

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

declare

devtype varchar2(256); done boolean; begin

devtype :=dbms_backup_restore.deviceallocate(type=>'',ident=>'c1'); dbms_backup_restore.restoresetdatafile;

dbms_backup_restore.restoredatafileto(dfnumber=>1,toname=>'/u01/oracle/oradata/ora10g/system01.dbf');

dbms_backup_restore.restoredatafileto(dfnumber=>2,toname=>'/u01/oracle/oradata/ora10g/undotbs01.dbf');

dbms_backup_restore.restoredatafileto(dfnumber=>4,toname=>'/u01/oracle/oradata/ora10g/users01.dbf');

dbms_backup_restore.restoredatafileto(dfnumber=>3,toname=>'/u01/oracle/oradata/ora10g/sysaux01.dbf');

dbms_backup_restore.restorebackuppiece(done=>done,handle=>'/home/oracle/rmanbk/ora10g/ORA10G_4139370672_32_1_20130720.bkp'); dbms_backup_restore.devicedeallocate; end; /