One good feature flashback of oracle 10g
1. use database as archive log mode and set archive dest location
alter system set LOG_ARCHIVE_DEST_1 = 'LOCATION=/u04/arch/orcl' scope=spfile;
2. configuration retention days/size/distination
ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=43200; --30 days
ALTER SYSTEM SET db_recovery_file_dest_size=10g SCOPE=BOTH;
ALTER SYSTEM SET db_recovery_file_dest='/u04/flash_recovery_area/orcl' SCOPE=BOTH;
3. enalbe database flashback
ALTER DATABASE FLASHBACK ON;
4. create restore pint
CREATE RESTORE POINT before_upgrade GUARANTEE FLASHBACK DATABASE;
SELECT NAME, SCN, TIME, DATABASE_INCARNATION#,GUARANTEE_FLASHBACK_DATABASE,STORAGE_SIZE from V$RESTORE_POINT;
DROP RESTORE POINT BEFORE_UPGRADE;
5. do some changes.
6. rollback database to restore point
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
FLASHBACK DATABASE TO RESTORE POINT 'BEFORE_UPGRADE';
ALTER DATABASE OPEN RESETLOGS;
7. Clear space for flashback database
You can disable Flashback Database with the ALTER DATABASE FLASHBACK OFF command.
As a consequence, all existing Flashback Database logs are deleted automatically.
Ïà¹ØÎĵµ£º
Ñ¡Ôñ10gÊÇÒòΪ¶ÔÍø¸ñ¼¼Êõ±È½ÏºÃÆæ£¬ºÃÏñ»¹Ã»µÃµ½¹ã·ºÓ¦Óã¬Ò²¾ÍÎÞËùνÓëÇ°Ãæ°æ±¾ÓкܴóÇø±ðÁË¡£
ÔÚѸÀ×ÉÏÏÂÁ˸öÈí¼þ£¬ÔËÐÐsqlplusw£¬È»ºóÕÕ×ÅÊ飬¿ñÇÃÁËÒ»·£¬ÓÐÔÚÍøÉÏÏÂÁ˸öÊÓÆµ½Ì³Ì£¨MLDNħÀֿƼ¼_Oracle¿ÎÌã©£¬½²µÃͦºÃµÄ£¬¾ÍÊÇʱ¼ä³¤Á˵㣬²»Èç¿´ÊéÀ´µÃ¿ì¡£·´ÕýÏÖÔÚÖ»ÊÇÏëÊìϤһÏ»ù±¾Óï¾ä¡£
¿´ÁËÁ½ÌìÊéÁË¡£Á˽âÁËÒ» ......
@echo off
REM ###########################################################
REM # Windows Server 2003ÏÂOracleÊý¾Ý¿â×Ô¶¯±¸·ÝÅú´¦Àí½Å±¾
REM ###########################################################
REM È¡µ±Ç°ÏµÍ³Ê±¼ä,¿ÉÄÜÒò²Ù×÷ϵͳ²»Í¬¶øÈ¡Öµ²»Ò»Ñù
set CURDATE=%date:~0,4%%date:~5,2%%date:~8,2%
se ......
ʹÓÃEXP
EXPÃüÁîÐÐÑ¡Ïî
1,BUFFER
¸ÃÑ¡ÏîÓÃÓÚÖ¸¶¨ÌáÈ¡ÐÐÊý¾ÝʱµÄ»º³åÇø³ß´ç.ͨ¹ýÉèÖøÃÑ¡Ïî,¿ÉÒÔÈ·¶¨µ¼³öʱÊý¾ÝÌáÆð³ß´ç.¸ÃÑ¡ÏîÖ»ÊÊÓÃÓÚ³£¹æÑ¡Ïî.
Exp scott/tiger tables=dept,emp file=a.dmp buffer=81920
2,COMPRESS
¸ÃÑ¡ÏîÓÃÓÚÖ¸¶¨µ¼Èë¹ÜÀí³õÊ¼Çø(INITIAL)µÄ·½·¨.ĬÈÏֵΪY.µ±ÉèÖøÃÑ¡ÏîΪYʱ,oracle»á½ ......
Ô¤¶¨Òå½ÇÉ«ÊÇoracleÌṩµÄ½ÇÉ«,ÕâЩ½ÇÉ«ÊÇÔÚ½¨Á¢Êý¾Ý¿â,°²×°Êý¾Ý×ÖµäÊÓͼºÎPL/SQL°üʱ½¨Á¢µÄ,²¢ÇÒÿÖÖ½ÇÉ«¶¼ÓÃÓÚÖ´ÐÐÒ»Ð©ÌØ¶¨¹ÜÀíÈÎÎñ.
1,CONNECT½ÇÉ«
CONNECT½ÇɫʱÔÚ½¨Á¢Êý¾Ý¿âʱ,oracleÖ´Ðнű¾SQL.BSQ×Ô¶¯½¨Á¢µÄ½ÇÉ«,¸Ã½ÇÉ«¾ßÓÐÓ¦Óÿª·¢ÈËÔ±ËùÐèµÄ¶àÊýȨÏÞ.CONNECT½ÇÉ«¾ßÓеÄËùÓÐϵͳȨÏÞÈçÏÂ:
ALTER SESS ......
SQL ServerÊý¾Ý¿âÓëOracleÊý¾Ý¿âÖ®¼ä×î´óµÄÇø±ðÒªÊô±í¿Õ¼äÉè¼Æ¡£OracleÊý¾Ý¿â¿ª´´ÐÔµØÌá³öÁ˱í¿Õ¼äµÄÉè¼ÆÀíÄÕâΪOracleÊý¾Ý¿âµÄ¸ßÐÔÄÜ×ö³öÁ˲»¿ÉÄ¥ÃðµÄ¹±Ïס£¿ÉÒÔÕâô˵£¬OracleÖкܶàÓÅ»¯¶¼ÊÇ»ùÓÚ±í¿Õ¼äµÄÉè¼ÆÀíÄî¶øÊµÏֵġ£
¡¡¡¡µäÐÍÓ¦ÓÃÒ»£º¿ØÖÆÓû§ËùÕ¼Óõıí¿Õ¼äÅä¶î¡£
¡¡¡¡ÔÚһЩ´óÐ͵ÄÊý¾Ý¿âÓ¦ÓÃÖУ¬ÎÒÃÇÐèÒª¿Ø ......