Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracle flashback


1£¬ÉÁ»ØÊý¾Ý¿âµ½Ö®Ç°Ä³Ê±¼äµã£¨ÔÚ°²×°Ê±ÐèÒª¿ª·ÅÉÁ»Ø¹¦ÄÜ£©
²»Ö§³Ö±í¿Õ¼äɾ³ý
 select name from v$database;
 --¿´ÊÇ·ñ´ò¿ªÉÁ»Ø¹¦ÄÜ
 select flashback_on,name from v$database;
 select name from v$bgprocess where paddr<>'00' order by 1;
´ò¿ªÉÁ»Ø¹¦ÄÜ
SQL> shutdown immediat(¸ÃÃüÁî±ØÐëÔÚsqlplusÏÂÖ´ÐÐ)
SQL> startup mount (Êý¾Ý¿âËùÔÚÖ÷»ú£ºcmd-->conn / as sysdba-->)
SQL> alter database flashback on(Èç¹ûÓÐ´í£¬Ö´ÐÐ-->archive log list-->alter database archivelog-->);
SQL> alter database open;
ÐÞ¸ÄÉÁ»ØÊ±¼ä(ĬÈÏÊÇÒ»Ìì1440)
SQL> alter system set db_flashback_retention_target=2880
RMAN> backup recovery files;--Ö´Ðд˳ÌÐò£¬±ØÐëÒªÓдŴø
Ö´ÐÐÊý¾Ý¿âÉÁ»Ø£¬±ØÐëÊÇÔÚmount,readonly״̬
Èç¹ûÖØ½¨ÁË¿ØÖÆÎļþ£¬ÔòÐ޸ĿØÖÆÎļþÒÔǰµÄÊý¾ÝÊDz»¿ÉÒÔÉÁ»ØµÄ¡£
Àý×Ó£»
create table t2( a int);
insert into t2 values(1);
insert into t2 values(2);
insert into t2 values(5);
alter system switch logfile;
t2 10:35
insert into t2 values(100);
alter system switch logfile;
insert into t2 values(200);
ÉÁ»Øµ½Ä³Ê±¼äµã
FLASHBACK DATABASE TO TIME = TO_DATE('2004-05-27 16:00:00','YYYY-MM-DD HH24:MI:SS'); 
FLASHBACK DATABASE   2  TO TIMESTAMP(SYSDATE-1/24); 
²éÈÕÖ¾½ø³Ì
select * from v$log;
»Ö¸´µ½Ä³¹ý³ÌsequenceΪ²éѯµÄsequence,THREAD
°Ñ״̬ÖÃΪmount״̬
flashback database to sequence=58 thread=1;
´ò¿ªÊý¾Ý¿â
alter database open resetlogs;
2£¬ÉÁ»Ødrop±í,Êý¾Ý(ÆÕͨÓû§¶¼¿ÉÒÔ²Ù×÷)
Ô­Àí£ºÊǰѷŵ½Êý¾Ý¿â»ØÊÕÕ¾µÄ¶ÔÏó£¬Êý¾ÝÀ­»ØÀ´
·²²»·Å»ØÊÕÕ¾µÄ¶ÔÏó¶¼²»ÄÜÉÁ»Ø.
SQL>create table t1(a int);
SQL>drop table t1;
ÉÁ»Øºó£¬°Ñɾ³ýµÄ±í£¬¼°Ë÷Òý¶¼»á»Ö¸´
SQL>flashback table t1 to before drop; 
Óï·¨£ºFLASHBACK TABLE <table_name> TO BEFORE DROP [RENAME TO <new_name>]
¿ÉÒÔÓÃÏÂÃæµÄÃüÁî»ò²éѯ²é¿´É¾³ýµÄ±í£»
show recyclebin;
select * from recyclebin --where ORIGINAL_NAME='T1';
DBAµÄ»ØÊÕÕ¾
SELECT owner, original_name, object_name,
        type, ts_name, droptime, related


Ïà¹ØÎĵµ£º

Oracle²»Í¬ÐеÄijÁÐ×Ö·û´®Ïà¼Ó,È¥³ýÖØ¸´Öµ

ÓÐÈçϱíTest
City People Make
¹ãÖÝ  1        A
¹ãÖÝ  2        B
¹ãÖÝ  3        C
ÉϺ£  4        A
ÉϺ£  5     ......

oracleÊý¾Ý¿âλÖÃÇ¨ÒÆ

ÓÉÓÚÊý¾Ý¿âԭʼ°²×°µÄÔ­ÒòÔì³ÉÊý¾Ý¿â»òÕû¸ö²Ù×÷ϵͳµÄ²»°²È«»òÕßÓÉÓÚ´ÅÅ̿ռä±ä»¯ÔÙ»òÕßÓÉÓÚÒµÎñ±ä»¯Ôì³ÉµÄI/OÐÔÄÜÐèÒªµ÷ÕûµÈµÈÔ­ÒòÐèÒªÊý¾Ý¿â¹ÜÀíÔ±½øÐÐÊý¾Ý¿âÎļþλÖõĵ÷Õû.ÏÂÃæÍ¨¹ýÒ»¸öWINDOWSƽ̨µÄORACLEÊý¾ÝÎļþÒÆ¶¯ÎªÀý×ÓÌÖÂÛÒ»ÏÂÊý¾Ý¿âÎļþÒÆ¶¯µÄ·½·¨,Çë´ó¼ÒÖ¸Õý.
Ò».ÒÆ¶¯Êý¾ÝÎļþ
ÒÆ¶¯Êý¾ÝÎļþ±ÊÕßĿǰʹÓõÄÓÐ ......

OracleÊý×éÈëÃÅ

OracleÊý×éÒ»°ã¿ÉÒÔ·ÖΪ¹Ì¶¨Êý×éºÍ¿É±äÊý×é
¹Ì¶¨Êý×é
Sql´úÂë
   declare 
   type v_ar is varray(10) of varchar2(30); 
   my_ar v_ar:=v_ar('g','m','d','¹¨','˧'); 
   begin 
          for ......

CentOS 5ϰ²×°Oracle 11g

Ê×ÏÈÐèÒªµÄÈí¼þÓУº
1¡¢  
linux_11gR1_database.zip
     //¿ÉÔÚOracleµÄ
¹Ù·½ÍøÕ¾
ÏÂÔØµÃµ½£¬ÓÐ1.71GB¹»´ó°É¡£
2¡¢  ±ðÍüÁË×¼±¸Ò»·ÝOracleµÄ¹Ù·½°ïÖúÎĵµ
£¬ÊÇ×îȨÍþµÄ¡£
3¡¢  
CentOS-5.2-i386-bin-DVD.iso
 
  //¿ÉÔÚCentOS
¹Ù·½ÍøÕ¾
ÏÂÔØµÃµ½£¬Ó ......

oracle³£¼ûÓï¾ä(×ªÔØ)

--==================================== Ò».sqlÓï¾ä·½Ãæ ====================================================
--========================================================================================================
1.Ôö¼ÓÖ÷¼ü
   alter table TABLE_NAME add constraint KEY_NAME primary key ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ