本文共 3010 字，大约阅读时间需要 10 分钟。

Oracle RMAN?????????????

1. RMAN??

RMAN?Recovery Manager??Oracle?????????????????????????????????????????????????????????????

2. ??????Flash Recovery Area???

??????RMAN?????????????????????????????

2.1 ??????

SQL> show parameter db_recovery_file_dest;NAME              TYPE        VALUE------------------ -------------- ----------------db_recovery_file_dest string /data/app/oracle/recovery_areadb_recovery_file_dest_size big integer 3882M

2.2 ??????

SQL> alter system set db_recovery_file_dest_size=2g;System altered.SQL> show parameter db_recovery_file_dest;NAME              TYPE        VALUE------------------ -------------- ----------------db_recovery_file_dest string /data/app/oracle/recovery_areadb_recovery_file_dest_size big integer 2G

2.3 ???????????

SQL> select name, space_limit, space_used, number_of_files from v$recovery_file_dest;NAME       SPACE_LIMIT SPACE_USED NUMBER_OF_FILES----------- ----------- ----------- ------------/data/app/oracle/recovery_area 2147483648 0 0

3. RMAN????

RMAN??????????????????

3.1 ??RMAN??

RMAN> show all;RMAN configuration parameters for database with db_unique_name ORCL are:CONFIGURE RETENTION POLICY TO REDUNDANCY 1;# defaultCONFIGURE BACKUP OPTIMIZATION OFF;# defaultCONFIGURE DEFAULT DEVICE TYPE TO DISK;# defaultCONFIGURE CONTROLFILE AUTOBACKUP OFF;# defaultCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';# defaultCONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET;# defaultCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;# defaultCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;# defaultCONFIGURE MAXSETSIZE TO UNLIMITED;# defaultCONFIGURE ENCRYPTION FOR DATABASE OFF;# defaultCONFIGURE ENCRYPTION ALGORITHM 'AES128';# defaultCONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;# defaultCONFIGURE ARCHIVELOG DELETION POLICY TO NONE;# defaultCONFIGURE SNAPSHOT CONTROLFILE NAME TO '/data/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f';# default

4. RMAN????

4.1 ??????

RMAN> configure backup optimization on;

4.2 ??????????

RMAN> configure device type disk backup type to copy;

4.3 ??????

RMAN> backup current controlfile;

4.4 ?????

RMAN> backup database;

4.5 ?????

RMAN> backup tablespace users;

5. ????

5.1 ????RMAN

RMAN> rman target rman/oracle

5.2 ?????

SQL> shutdown immediate;SQL> startup mount;

5.3 ????

RMAN> backup as compressed backupset database;

6. ?????

6.1 ???????

SQL> alter system set db_recovery_file_dest='/data/app/oracle/test';SQL> alter system set db_recovery_file_dest_size=10g;

6.2 ???????????

RMAN> configure controlfile autobackup format for device type disk to '/data/app/oracle/test/%F';

7. RMAN????

7.1 ????

RMAN> backup incremental level 0 database;

7.2 ??????1

RMAN> backup incremental level 1 database;

7.3 ????

RMAN> run {    2> backup incremental level 1 for recover of copy with tag 'incr_copy_backup' database;    3> recover copy of database with tag 'incr_copy_backup';    4> }

????????????RMAN???????Oracle????????????????????????

转载地址：http://vspfk.baihongyu.com/