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
Ïà¹ØÎĵµ£º
ÓÐÈçϱíTest
City People Make
¹ãÖÝ 1 A
¹ãÖÝ 2 B
¹ãÖÝ 3 C
ÉϺ£ 4 A
ÉϺ£ 5 ......
ÓÉÓÚÊý¾Ý¿âÔʼ°²×°µÄÔÒòÔì³ÉÊý¾Ý¿â»òÕû¸ö²Ù×÷ϵͳµÄ²»°²È«»òÕßÓÉÓÚ´ÅÅ̿ռä±ä»¯ÔÙ»òÕßÓÉÓÚÒµÎñ±ä»¯Ôì³ÉµÄI/OÐÔÄÜÐèÒªµ÷ÕûµÈµÈÔÒòÐèÒªÊý¾Ý¿â¹ÜÀíÔ±½øÐÐÊý¾Ý¿âÎļþλÖõĵ÷Õû.ÏÂÃæÍ¨¹ýÒ»¸öWINDOWSƽ̨µÄORACLEÊý¾ÝÎļþÒÆ¶¯ÎªÀý×ÓÌÖÂÛÒ»ÏÂÊý¾Ý¿âÎļþÒÆ¶¯µÄ·½·¨,Çë´ó¼ÒÖ¸Õý.
Ò».ÒÆ¶¯Êý¾ÝÎļþ
ÒÆ¶¯Êý¾ÝÎļþ±ÊÕßĿǰʹÓõÄÓÐ ......
OracleÊý×éÒ»°ã¿ÉÒÔ·ÖΪ¹Ì¶¨Êý×éºÍ¿É±äÊý×é
¹Ì¶¨Êý×é
Sql´úÂë
declare
type v_ar is varray(10) of varchar2(30);
my_ar v_ar:=v_ar('g','m','d','¹¨','˧');
begin
for ......
Ê×ÏÈÐèÒªµÄÈí¼þÓУº
1¡¢
linux_11gR1_database.zip
//¿ÉÔÚOracleµÄ
¹Ù·½ÍøÕ¾
ÏÂÔØµÃµ½£¬ÓÐ1.71GB¹»´ó°É¡£
2¡¢ ±ðÍüÁË×¼±¸Ò»·ÝOracleµÄ¹Ù·½°ïÖúÎĵµ
£¬ÊÇ×îȨÍþµÄ¡£
3¡¢
CentOS-5.2-i386-bin-DVD.iso
//¿ÉÔÚCentOS
¹Ù·½ÍøÕ¾
ÏÂÔØµÃµ½£¬Ó ......
--==================================== Ò».sqlÓï¾ä·½Ãæ ====================================================
--========================================================================================================
1.Ôö¼ÓÖ÷¼ü
alter table TABLE_NAME add constraint KEY_NAME primary key ......