当前位置:首页 > 开发 > 编程语言 > 编程 > 正文

Oracle远程备份 - Windows

发表于: 2008-06-30   作者:crownquartz   来源:转载   浏览:
摘要: 1,On the machine where you wish to write the files to, create a shared drive granting the user 'Administrator' FULL Control.2,Make sure that the Oracle services for the TARGET DB need to be reconfigur

1,On the machine where you wish to write the files to, create a shared drive granting the user 'Administrator' FULL Control.
2,Make sure that the Oracle services for the TARGET DB need to be reconfigured to logon using an Administrator account (preferably a Domain Administrator).
3,C:\>rman target / nocatalog;
  RMAN> CONFIGURE DEFAULT DEVICE TYPE TO DISK;
  RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET PARALLELISM 2;
  RMAN> configure controlfile autobackup on;
  RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
  RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
   
4, Make sure that the database is running in ARCHIVELOG mode.
   If database is running in NON ARCHIVELOG Mode. run the following command:
   SQL> shutdown immediate;
   SQL> startup mount;
   SQL> alter database archivelog;
   SQL> alter database open;
   
5,Connect to OEM using sysdba and then click the 'Maintenance' link, click 'Schedule Backup'. Configure the 'Schedule Customized Backup' step by step till the last step.
  Modify the RMAN scripts to like the following:
    backup device type disk tag '%TAG' database include current controlfile format 'D:\Oracle\product\10.2.0\backup\R1020CN\%U','\\zhzhao-cn\sharefolder\backup\%U';
    backup device type disk tag '%TAG' archivelog all not backed up;
    delete noprompt obsolete device type disk;

Oracle远程备份 - Windows

  • 0

    开心

    开心

  • 0

    板砖

    板砖

  • 0

    感动

    感动

  • 0

    有用

    有用

  • 0

    疑问

    疑问

  • 0

    难过

    难过

  • 0

    无聊

    无聊

  • 0

    震惊

    震惊

版权所有 IT知识库 CopyRight © 2009-2015 IT知识库 IT610.com , All Rights Reserved. 京ICP备09083238号