µ±Ç°Î»ÖãºÊ×Ò³ > 技术资æ–? > ORCLÃüÁî¼°Ïà¹Ø×ÊÁÏ
ORCLÃüÁî¼°Ïà¹Ø×ÊÁÏ
·¢²¼Ê±¼ä£º2015/8/24 µã»÷´ÎÊý£º9249´Î
1¡¢´´½¨»Ö¸´Ä¿Â¼
sqlplus>connect sys/admin as sysdba
>archive log list ²é¿´ÈÕ־ģʽ,±£Ö¤ÊǴ浵ģʽ
>create tablespace recovery_tbs ´´½¨»Ö¸´±í¿Õ¼ä
>datafile 'g:\data\rman\recovery_tbs.dbf' size 10M
>autoexetend on next 5M
>extent management local;
>create user rman_admin identified by admin123 ´´½¨Óû§
>default tablespace recovery_tbs
>grant connect,resource,recovery_catalog_owner to rman_admin
´´½¨»Ö¸´Ä¿Â¼£¬´ò¿ªÒ»¸öcmd´°¿Ú
cmd>rman µÇ½±¸·Ý¹ÜÀíÆ÷
rman>connect catalog rman_admin/admin123
rman>create catalog
2¡¢Á¬½ÓÄ¿±êÊý¾Ý¿â£¬cmdÖÐ
cmd>rman target sys/admin catalog rman_admin/admin123 ʹÓûָ´Ä¿Â¼Á¬½Ó
rman>register database; ×¢²áÄ¿±êÊý¾Ý¿â£¬½«Ä¿±êÊý¾Ý¿âµÄ¿ØÖÆÎļþͬ²½µ½»Ö¸´Ä¿Â¼
rman>resync catalog ͬ²½Ä¿Â¼
-----È¡Ïûunregister Í˳öexit
3¡¢ÍêÈ«±¸·ÝÊý¾Ý¿â
rman>run {
rman>allocate chnanel ch1 type disk;
rman>backup full
rman>tag full_db_backup format "G:\data\backup\db_t%t_s%s_p%p"
rman>release channel ch1; }
rman>list backup of database ¿ÉÒԲ鿴Òѱ¸·ÝÇé¿ö
3.1 ²îÒìÔöÁ¿±¸·Ý(ÏÈ×ö0¼¶±¸·Ý£¬ÊÇÈ«²¿±¸·Ý£©
run{
allocate channel ch1 type disk;
backup incremental level 0 as compressed backupset database;
release channel ch1;}
ĬÈϱ£´æÄ¿Â¼£ºapp\administrator\flash_recovery_area\orclĿ¼ÏÂ
Íê³ÉºóÈκÎʱ¿Ì¿ÉÒÔ½øÐÐÔöÁ¿Îª1»ò2¡¢3¡¢4µÄ²îÒ챸·Ý
backup incremental level 1 as compressed backupset database;
3.2 ÀÛ¼ÆÔöÁ¿±¸·Ý
backup incremental level 1 cumulative as compressed backupset database;
3.5 ¾µÏñ¸´ÖÆ copy ʵÏÖÎļþ±¸·Ý
rman>report schema »õÇø¿ÉÒÔ±¸·ÝµÄÐÅÏ¢
rman>copy full/incremental level 1 input_file£¨datafile 5 »òÎļþ·¾¶£© to 'g:\data\**.dbf'
,datafile 6 to 'g:\data\**1.dbf' ¿ÉÒÔ¶à¸öÎļþ£¬¶ººÅ¸ô¿ª
4 »Ö¸´Êý¾Ý¿â
ÐÞ¸´Êý¾Ý¿ârestore£¬ÎïÀíÎļþ¸´ÖÆ£¬²¢ÐÞ¸´¿ØÖÆÎļþ¡¢Êý¾ÝÎļþ¡¢ÈÕÖ¾µÈ
»Ö¸´Êý¾Ý¿ârecover£¬Êý¾ÝÎļþ½éÖʻָ´
4.1·Ç¹éµµÄ£Ê½Ï£¬Ñ¡×î½üµÄÍêÈ«±¸·Ý¿â£¬Ö´ÐÐrestore¼´¿É»Ö¸´£¬²»ÓÃrecover£»
sqlplus>dbaµÇ½£¬È·¶¨Îª·Ç¹éµµÄ£Ê½
rman>Á¬½Óµ½Ä¿±êÊý¾Ý¿â
rman>±¸·ÝÕû¸öÊý¾Ý¿â
rman>shutdown¹Ø±Õ£¬É¾³ýij¸öÊý¾ÝÎļþ£¬ÕâÊÇÔÙÆô¶¯Êý¾Ý¿â£¬»á±¨Îļþ¶ªÊ§£¬¿ÉÒÔ»Ö¸´ÁË
rman>startup mount
sqlplus>alter database datafile 'g:\app...dbf' offline drop; ɾ³ý´íÎóµÄÊý¾ÝÎļþ
sqlplus>alter database open
rman>run{ restore database; } oracle×Ô¶¯ÕÒÓÐЧµÄ±¸·Ý¿â
4.2¹éµµÄ£Ê½ÏÂ
sqlplus>dbaµÇ½£¬È·¶¨Îª¹éµµÄ£Ê½
rman>Á¬½Óµ½Ä¿±êÊý¾Ý¿â
rman>±¸·ÝÕû¸öÊý¾Ý¿â
rman>ÖÆÔì´íÎó£¬É¾³ýij¸öÊý¾ÝÎļþ
rman>run{ allocate channel ch1 type disk;
rman> restore database;
rman>sql "alter database mount";
rman>recover database;
rman>sql "alter database open resetlogs";
rman>release channel ch1;
rman>}
sql>alter database open
------------------
Ð޸Ĺ鵵ģʽ£ºsqlplus,ÏÈshutdown£¬È»ºóstartup mount²»´ò¿ªÊý¾Ý¿â£¬alter database archivelog/noarchivelog
ÔöÁ¿±¸·Ý£º
²îÒ챸·Ý£º±¸·ÝÉÏÒ»´Î½øÐеÄͬ¼¶»òµÍ¼¶±¸·ÝÒ»À´µÄËùÓб仯Êý¾Ý¿é£»Èç2ÍùǰÕÒµÈÓÚ2»òСÓÚ2µÄ±ä»¯
ÀۼƱ¸·Ý£º±¸·ÝÉÏÒ»´ÎµÍ¼¶±¸·ÝÒ»À´µÄËùÓÐÊý¾Ý¿é£¬Èç2ÍùǰССÓÚ2µÄ±ä»¯
sqlplus>connect sys/admin as sysdba
>archive log list ²é¿´ÈÕ־ģʽ,±£Ö¤ÊǴ浵ģʽ
>create tablespace recovery_tbs ´´½¨»Ö¸´±í¿Õ¼ä
>datafile 'g:\data\rman\recovery_tbs.dbf' size 10M
>autoexetend on next 5M
>extent management local;
>create user rman_admin identified by admin123 ´´½¨Óû§
>default tablespace recovery_tbs
>grant connect,resource,recovery_catalog_owner to rman_admin
´´½¨»Ö¸´Ä¿Â¼£¬´ò¿ªÒ»¸öcmd´°¿Ú
cmd>rman µÇ½±¸·Ý¹ÜÀíÆ÷
rman>connect catalog rman_admin/admin123
rman>create catalog
2¡¢Á¬½ÓÄ¿±êÊý¾Ý¿â£¬cmdÖÐ
cmd>rman target sys/admin catalog rman_admin/admin123 ʹÓûָ´Ä¿Â¼Á¬½Ó
rman>register database; ×¢²áÄ¿±êÊý¾Ý¿â£¬½«Ä¿±êÊý¾Ý¿âµÄ¿ØÖÆÎļþͬ²½µ½»Ö¸´Ä¿Â¼
rman>resync catalog ͬ²½Ä¿Â¼
-----È¡Ïûunregister Í˳öexit
3¡¢ÍêÈ«±¸·ÝÊý¾Ý¿â
rman>run {
rman>allocate chnanel ch1 type disk;
rman>backup full
rman>tag full_db_backup format "G:\data\backup\db_t%t_s%s_p%p"
rman>release channel ch1; }
rman>list backup of database ¿ÉÒԲ鿴Òѱ¸·ÝÇé¿ö
3.1 ²îÒìÔöÁ¿±¸·Ý(ÏÈ×ö0¼¶±¸·Ý£¬ÊÇÈ«²¿±¸·Ý£©
run{
allocate channel ch1 type disk;
backup incremental level 0 as compressed backupset database;
release channel ch1;}
ĬÈϱ£´æÄ¿Â¼£ºapp\administrator\flash_recovery_area\orclĿ¼ÏÂ
Íê³ÉºóÈκÎʱ¿Ì¿ÉÒÔ½øÐÐÔöÁ¿Îª1»ò2¡¢3¡¢4µÄ²îÒ챸·Ý
backup incremental level 1 as compressed backupset database;
3.2 ÀÛ¼ÆÔöÁ¿±¸·Ý
backup incremental level 1 cumulative as compressed backupset database;
3.5 ¾µÏñ¸´ÖÆ copy ʵÏÖÎļþ±¸·Ý
rman>report schema »õÇø¿ÉÒÔ±¸·ÝµÄÐÅÏ¢
rman>copy full/incremental level 1 input_file£¨datafile 5 »òÎļþ·¾¶£© to 'g:\data\**.dbf'
,datafile 6 to 'g:\data\**1.dbf' ¿ÉÒÔ¶à¸öÎļþ£¬¶ººÅ¸ô¿ª
4 »Ö¸´Êý¾Ý¿â
ÐÞ¸´Êý¾Ý¿ârestore£¬ÎïÀíÎļþ¸´ÖÆ£¬²¢ÐÞ¸´¿ØÖÆÎļþ¡¢Êý¾ÝÎļþ¡¢ÈÕÖ¾µÈ
»Ö¸´Êý¾Ý¿ârecover£¬Êý¾ÝÎļþ½éÖʻָ´
4.1·Ç¹éµµÄ£Ê½Ï£¬Ñ¡×î½üµÄÍêÈ«±¸·Ý¿â£¬Ö´ÐÐrestore¼´¿É»Ö¸´£¬²»ÓÃrecover£»
sqlplus>dbaµÇ½£¬È·¶¨Îª·Ç¹éµµÄ£Ê½
rman>Á¬½Óµ½Ä¿±êÊý¾Ý¿â
rman>±¸·ÝÕû¸öÊý¾Ý¿â
rman>shutdown¹Ø±Õ£¬É¾³ýij¸öÊý¾ÝÎļþ£¬ÕâÊÇÔÙÆô¶¯Êý¾Ý¿â£¬»á±¨Îļþ¶ªÊ§£¬¿ÉÒÔ»Ö¸´ÁË
rman>startup mount
sqlplus>alter database datafile 'g:\app...dbf' offline drop; ɾ³ý´íÎóµÄÊý¾ÝÎļþ
sqlplus>alter database open
rman>run{ restore database; } oracle×Ô¶¯ÕÒÓÐЧµÄ±¸·Ý¿â
4.2¹éµµÄ£Ê½ÏÂ
sqlplus>dbaµÇ½£¬È·¶¨Îª¹éµµÄ£Ê½
rman>Á¬½Óµ½Ä¿±êÊý¾Ý¿â
rman>±¸·ÝÕû¸öÊý¾Ý¿â
rman>ÖÆÔì´íÎó£¬É¾³ýij¸öÊý¾ÝÎļþ
rman>run{ allocate channel ch1 type disk;
rman> restore database;
rman>sql "alter database mount";
rman>recover database;
rman>sql "alter database open resetlogs";
rman>release channel ch1;
rman>}
sql>alter database open
------------------
Ð޸Ĺ鵵ģʽ£ºsqlplus,ÏÈshutdown£¬È»ºóstartup mount²»´ò¿ªÊý¾Ý¿â£¬alter database archivelog/noarchivelog
ÔöÁ¿±¸·Ý£º
²îÒ챸·Ý£º±¸·ÝÉÏÒ»´Î½øÐеÄͬ¼¶»òµÍ¼¶±¸·ÝÒ»À´µÄËùÓб仯Êý¾Ý¿é£»Èç2ÍùǰÕÒµÈÓÚ2»òСÓÚ2µÄ±ä»¯
ÀۼƱ¸·Ý£º±¸·ÝÉÏÒ»´ÎµÍ¼¶±¸·ÝÒ»À´µÄËùÓÐÊý¾Ý¿é£¬Èç2ÍùǰССÓÚ2µÄ±ä»¯