第56次：2015-05-28星期四

botang

physical-block.sh

1. #!/bin/sh
   
2. v_dbname=orcl
   
3. su - oracle -c "/u01/app/oracle/product/11.2.0/dbhome_1/bin/srvctl stop database -d $v_dbname"
   
4. su - oracle -c "/u01/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus /nolog" <<EOF
   
5. conn / as sysdba
   
6. startup mount exclusive
   
7. EOF
   
8. 
   
9. rm -f /home/oracle/example01.dbf 2>/dev/null
   
10. 
    
11. su - oracle -c "/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target /" <<EOF
    
12. backup as copy datafile 5 format '/home/oracle/example01.dbf';
    
13. EOF
    
14. 
    
15. dd if=/dev/zero of=/home/oracle/example01.dbf bs=8192 count=1 seek=175 conv=notrunc
    
16. 
    
17. su - oracle -c "export ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid ; export ORACLE_SID=+ASM ; /u01/app/oracle/product/11.2.0/grid/bin/asmcmd" <<EOF
    
18. rm -f +data/$v_dbname/DATAFILE/example*
    
19. EOF
    
20. 
    
21. su - oracle -c "/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target /" <<EOF
    
22. run {
    
23. set maxcorrupt for datafile 5 to 1;
    
24. backup as copy  datafilecopy '/home/oracle/example01.dbf' format '+data';
    
25. }
    
26. EOF
    
27. 
    
28. sleep 3
    
29. 
    
30. su - oracle -c "/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target /" <<EOF
    
31. delete noprompt datafilecopy '/home/oracle/example01.dbf';
    
32. switch datafile 5 to copy;
    
33. EOF
    
34. 
    
35. 
    
36. su - oracle -c "/u01/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus /nolog" <<EOF
    
37. conn / as sysdba
    
38. alter database open;
    
39. EOF

复制代码

逻辑坏块：

Recovery Manager complete.
[oracle@station90 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Thu May 28 21:31:11 2015

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn / as sysdba
Connected.
SQL> create tablespace tbslogical  datafile size 10M nologging;

Tablespace created.

SQL> conn hr/oracle_4U
ERROR:
ORA-28002: the password will expire within 7 days


Connected.
SQL> create table tlogical( a  number , b varchar(20))   tablespace tbslogical;

Table created.

SQL> create index ilogical_a on tlogical(a) ;

Index created.

SQL> create index ilogical_b on tlogical(b) ;

Index created.

SQL> insert into tlogical values ( 23255,'logical block');

1 row created.

SQL> commit;

Commit complete.

SQL>
备份

insert /*+ append */ into tlogical select * from tlogical ;