Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

RMAN compressed backup

2025-03-26 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE' DEFAULT' OPTIMIZE FOR LOAD TRUE; # default

Query the current database data volume

RMAN > select sum (BYTES/1024/1024) from dba_data_files

SUM (BYTES/1024/1024) 2960

RMAN > select sum (BYTES/1024/1024) from dba_free_space

SUM (BYTES/1024/1024) 807

RMAN > select 2960-807 from dual

2960-807 2153

RMAN > show COMPRESSION ALGORITHM

The RMAN configuration parameters of the database for which db_unique_name is NEWTEST are:

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE' DEFAULT' OPTIMIZE FOR LOAD TRUE; # default

RMAN > backup as compressed backupset full database

Starting with backup, which is located in 2005-February-18

Assigned channel: ORA_DISK_1

Channel ORA_DISK_1: SID=48 device type = DISK

Channel ORA_DISK_1: backup set of all compressed data files being started

Channel ORA_DISK_1: specifying data files in the backup set

Enter the data file, file number = 00003 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ SYSAUX01.DBF

Enter the data file, file number = 00001 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ SYSTEM01.DBF

Enter the data file, file number = 00005 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ UNDOTBS01.DBF

Enter the data file, file number = 00007 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ USERS01.DBF

Channel ORA_DISK_1: starting segment 1 in 05-February-18

Channel ORA_DISK_1: completed startup segment 1 from 05-February-18

Fragment handle = E:\ RECOVERYFLASH\ NEWTEST\ BACKUPSET\ 2018'02'05\ O1_MF_NNNDF_TAG20180205T092429F7HDLLR4.BKP tag = TAG20180205T092429 comment = NONE

Channel ORA_DISK_1: backup set completed, time: 00:01:05

Channel ORA_DISK_1: backup set of all compressed data files being started

Channel ORA_DISK_1: specifying data files in the backup set

Enter the data file, file number = 00045 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ CLONEPDB_PLUG\ FDA01.DBF

Enter the data file, file number = 00041 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ CLONEPDB_PLUG\ SYSAUX01.DBF

Enter the data file, file number = 00040 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ CLONEPDB_PLUG\ SYSTEM01.DBF

Enter the data file, file number = 00042 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ CLONEPDB_PLUG\ UNDOTBS01.DBF

Enter the data file, file number = 00043 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ CLONEPDB_PLUG\ USERS01.DBF

Channel ORA_DISK_1: starting segment 1 in 05-February-18

Channel ORA_DISK_1: completed startup segment 1 from 05-February-18

Fragment handle = E:\ RECOVERYFLASH\ NEWTEST\ D4B2FCAAC2B944CC8AF5864EC7CB853C\ BACKUPSET\ 2018'02'05\ O1_MF_NNNDF_TAG20180205T092429F7HDNHY0.BKP tag = TAG20180205T092429 comment = NONE

Channel ORA_DISK_1: backup set completed, time: 00:00:35

Channel ORA_DISK_1: backup set of all compressed data files being started

Channel ORA_DISK_1: specifying data files in the backup set

Enter the data file, file number = 00009 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBTEST\ SYSAUX01.DBF

Enter the data file, file number = 00010 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBTEST\ UNDOTBS01.DBF

Enter the data file, file number = 00008 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBTEST\ SYSTEM01.DBF

Enter the data file, file number = 00011 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBTEST\ USERS01.DBF

Channel ORA_DISK_1: starting segment 1 in 05-February-18

Channel ORA_DISK_1: completed startup segment 1 from 05-February-18

Fragment handle = E:\ RECOVERYFLASH\ NEWTEST\ 24549D14BBEB417BAB312BF19BC5259E\ BACKUPSET\ 2018'02'05\ O1_MF_NNNDF_TAG20180205T092429F7HDOM8M.BKP tag = TAG20180205T092429 comment = NONE

Channel ORA_DISK_1: backup set completed, time: 00:00:35

Channel ORA_DISK_1: backup set of all compressed data files being started

Channel ORA_DISK_1: specifying data files in the backup set

Enter the data file, file number = 00004 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBSEED\ SYSAUX01.DBF

Enter the data file, file number = 00002 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBSEED\ SYSTEM01.DBF

Enter the data file, file number = 00006 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBSEED\ UNDOTBS01.DBF

Channel ORA_DISK_1: starting segment 1 in 05-February-18

Channel ORA_DISK_1: completed startup segment 1 from 05-February-18

Fragment handle = E:\ RECOVERYFLASH\ NEWTEST\ 32CAC9A05E614355926257BE671D9AFC\ BACKUPSET\ 2018'02'05\ O1_MF_NNNDF_TAG20180205T092429F7HDPPJC.BKP tag = TAG20180205T092429 comment = NONE

Channel ORA_DISK_1: backup set completed, time: 00:00:25

Completed backup in 05-February-18

RMAN > CONFIGURE COMPRESSION ALGORITHM 'LOW'

New RMAN configuration parameters:

CONFIGURE COMPRESSION ALGORITHM 'LOW' AS OF RELEASE' DEFAULT' OPTIMIZE FOR LOAD TRUE

New RMAN configuration parameters have been successfully stored

RMAN > backup as compressed backupset full database

Starting with backup, which is located in 2005-February-18

Use channel ORA_DISK_1

Channel ORA_DISK_1: backup set of all compressed data files being started

Channel ORA_DISK_1: specifying data files in the backup set

Enter the data file, file number = 00003 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ SYSAUX01.DBF

Enter the data file, file number = 00001 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ SYSTEM01.DBF

Enter the data file, file number = 00005 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ UNDOTBS01.DBF

Enter the data file, file number = 00007 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ USERS01.DBF

Channel ORA_DISK_1: starting segment 1 in 05-February-18

Channel ORA_DISK_1: completed startup segment 1 from 05-February-18

Fragment handle = E:\ RECOVERYFLASH\ NEWTEST\ BACKUPSET\ 2018'02'05\ O1_MF_NNNDF_TAG20180205T093247F7HF1ZXL.BKP tag = TAG20180205T093247 comment = NONE

Channel ORA_DISK_1: backup set completed, time: 00:00:46

Channel ORA_DISK_1: backup set of all compressed data files being started

Channel ORA_DISK_1: specifying data files in the backup set

Enter the data file, file number = 00045 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ CLONEPDB_PLUG\ FDA01.DBF

Enter the data file, file number = 00041 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ CLONEPDB_PLUG\ SYSAUX01.DBF

Enter the data file, file number = 00040 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ CLONEPDB_PLUG\ SYSTEM01.DBF

Enter the data file, file number = 00042 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ CLONEPDB_PLUG\ UNDOTBS01.DBF

Enter the data file, file number = 00043 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ CLONEPDB_PLUG\ USERS01.DBF

Channel ORA_DISK_1: starting segment 1 in 05-February-18

Channel ORA_DISK_1: completed startup segment 1 from 05-February-18

Fragment handle = E:\ RECOVERYFLASH\ NEWTEST\ D4B2FCAAC2B944CC8AF5864EC7CB853C\ BACKUPSET\ 2018'02'05\ O1_MF_NNNDF_TAG20180205T093247F7HF3G8L.BKP tag = TAG20180205T093247 comment = NONE

Channel ORA_DISK_1: backup set completed, time: 00:00:25

Channel ORA_DISK_1: backup set of all compressed data files being started

Channel ORA_DISK_1: specifying data files in the backup set

Enter the data file, file number = 00009 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBTEST\ SYSAUX01.DBF

Enter the data file, file number = 00010 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBTEST\ UNDOTBS01.DBF

Enter the data file, file number = 00008 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBTEST\ SYSTEM01.DBF

Enter the data file, file number = 00011 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBTEST\ USERS01.DBF

Channel ORA_DISK_1: starting segment 1 in 05-February-18

Channel ORA_DISK_1: completed startup segment 1 from 05-February-18

Fragment handle = E:\ RECOVERYFLASH\ NEWTEST\ 24549D14BBEB417BAB312BF19BC5259E\ BACKUPSET\ 2018'02'05\ O1_MF_NNNDF_TAG20180205T093247F7HF47N9.BKP tag = TAG20180205T093247 comment = NONE

Channel ORA_DISK_1: backup set completed, time: 00:00:25

Channel ORA_DISK_1: backup set of all compressed data files being started

Channel ORA_DISK_1: specifying data files in the backup set

Enter the data file, file number = 00004 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBSEED\ SYSAUX01.DBF

Enter the data file, file number = 00002 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBSEED\ SYSTEM01.DBF

Enter the data file, file number = 00006 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBSEED\ UNDOTBS01.DBF

Channel ORA_DISK_1: starting segment 1 in 05-February-18

Channel ORA_DISK_1: completed startup segment 1 from 05-February-18

Fragment handle = E:\ RECOVERYFLASH\ NEWTEST\ 32CAC9A05E614355926257BE671D9AFC\ BACKUPSET\ 2018'02'05\ O1_MF_NNNDF_TAG20180205T093247F7HF50XL.BKP tag = TAG20180205T093247 comment = NONE

Channel ORA_DISK_1: backup set completed, time: 00:04:28

Completed backup in 05-February-18

RMAN > CONFIGURE COMPRESSION ALGORITHM 'MEDIUM'

Old RMAN configuration parameters:

CONFIGURE COMPRESSION ALGORITHM 'LOW' AS OF RELEASE' DEFAULT' OPTIMIZE FOR LOAD TRUE

New RMAN configuration parameters:

CONFIGURE COMPRESSION ALGORITHM 'MEDIUM' AS OF RELEASE' DEFAULT' OPTIMIZE FOR LOAD TRUE

New RMAN configuration parameters have been successfully stored

RMAN > backup as compressed backupset full database

Starting with backup, which is located in 2005-February-18

Use channel ORA_DISK_1

Channel ORA_DISK_1: backup set of all compressed data files being started

Channel ORA_DISK_1: specifying data files in the backup set

Enter the data file, file number = 00003 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ SYSAUX01.DBF

Enter the data file, file number = 00001 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ SYSTEM01.DBF

Enter the data file, file number = 00005 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ UNDOTBS01.DBF

Enter the data file, file number = 00007 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ USERS01.DBF

Channel ORA_DISK_1: starting segment 1 in 05-February-18

Channel ORA_DISK_1: completed startup segment 1 from 05-February-18

Fragment handle = E:\ RECOVERYFLASH\ NEWTEST\ BACKUPSET\ 2018'02'05\ O1_MF_NNNDF_TAG20180205T094059F7HFKD2Q.BKP tag = TAG20180205T094059 comment = NONE

Channel ORA_DISK_1: backup set completed, time: 00:00:46

Channel ORA_DISK_1: backup set of all compressed data files being started

Channel ORA_DISK_1: specifying data files in the backup set

Enter the data file, file number = 00045 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ CLONEPDB_PLUG\ FDA01.DBF

Enter the data file, file number = 00041 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ CLONEPDB_PLUG\ SYSAUX01.DBF

Enter the data file, file number = 00040 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ CLONEPDB_PLUG\ SYSTEM01.DBF

Enter the data file, file number = 00042 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ CLONEPDB_PLUG\ UNDOTBS01.DBF

Enter the data file, file number = 00043 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ CLONEPDB_PLUG\ USERS01.DBF

Channel ORA_DISK_1: starting segment 1 in 05-February-18

Channel ORA_DISK_1: completed startup segment 1 from 05-February-18

Fragment handle = E:\ RECOVERYFLASH\ NEWTEST\ D4B2FCAAC2B944CC8AF5864EC7CB853C\ BACKUPSET\ 2018'02'05\ O1_MF_NNNDF_TAG20180205T094059F7HFLSRD.BKP tag = TAG20180205T094059 comment = NONE

Channel ORA_DISK_1: backup set completed, time: 00:00:25

Channel ORA_DISK_1: backup set of all compressed data files being started

Channel ORA_DISK_1: specifying data files in the backup set

Enter the data file, file number = 00009 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBTEST\ SYSAUX01.DBF

Enter the data file, file number = 00010 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBTEST\ UNDOTBS01.DBF

Enter the data file, file number = 00008 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBTEST\ SYSTEM01.DBF

Enter the data file, file number = 00011 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBTEST\ USERS01.DBF

Channel ORA_DISK_1: starting segment 1 in 05-February-18

Channel ORA_DISK_1: completed startup segment 1 from 05-February-18

Fragment handle = E:\ RECOVERYFLASH\ NEWTEST\ 24549D14BBEB417BAB312BF19BC5259E\ BACKUPSET\ 2018'02'05\ O1_MF_NNNDF_TAG20180205T094059F7HFMM3P.BKP tag = TAG20180205T094059 comment = NONE

Channel ORA_DISK_1: backup set completed, time: 00:00:25

Channel ORA_DISK_1: backup set of all compressed data files being started

Channel ORA_DISK_1: specifying data files in the backup set

Enter the data file, file number = 00004 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBSEED\ SYSAUX01.DBF

Enter the data file, file number = 00002 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBSEED\ SYSTEM01.DBF

Enter the data file, file number = 00006 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBSEED\ UNDOTBS01.DBF

Channel ORA_DISK_1: starting segment 1 in 05-February-18

Channel ORA_DISK_1: completed startup segment 1 from 05-February-18

Fragment handle = E:\ RECOVERYFLASH\ NEWTEST\ 32CAC9A05E614355926257BE671D9AFC\ BACKUPSET\ 2018'02'05\ O1_MF_NNNDF_TAG20180205T094059F7HFNDCJ.BKP tag = TAG20180205T094059 comment = NONE

Channel ORA_DISK_1: backup set completed, time: 00:00:15

Completed backup in 05-February-18

Starting with Control File and SPFILE Autobackup, which is located in 2005-February-18

Fragment handle = E:\ CONTROLBACKUP\ CF-C-1779551310-20180205-02 comment = NONE

Completed Control File and SPFILE Autobackup in 05-February-18

RMAN > CONFIGURE COMPRESSION ALGORITHM 'HIGH'

Old RMAN configuration parameters:

CONFIGURE COMPRESSION ALGORITHM 'MEDIUM' AS OF RELEASE' DEFAULT' OPTIMIZE FOR LOAD TRUE

New RMAN configuration parameters:

CONFIGURE COMPRESSION ALGORITHM 'HIGH' AS OF RELEASE' DEFAULT' OPTIMIZE FOR LOAD TRUE

New RMAN configuration parameters have been successfully stored

RMAN > backup as compressed backupset full database

Starting with backup, which is located in 2005-February-18

Use channel ORA_DISK_1

Channel ORA_DISK_1: backup set of all compressed data files being started

Channel ORA_DISK_1: specifying data files in the backup set

Enter the data file, file number = 00003 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ SYSAUX01.DBF

Enter the data file, file number = 00001 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ SYSTEM01.DBF

Enter the data file, file number = 00005 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ UNDOTBS01.DBF

Enter the data file, file number = 00007 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ USERS01.DBF

Channel ORA_DISK_1: starting segment 1 in 05-February-18

Channel ORA_DISK_1: completed startup segment 1 from 05-February-18

Fragment handle = E:\ RECOVERYFLASH\ NEWTEST\ BACKUPSET\ 2018'02'05\ O1_MF_NNNDF_TAG20180205T094348F7HFPNLV.BKP tag = TAG20180205T094348 comment = NONE

Channel ORA_DISK_1: backup set completed, time: 00:02:55

Channel ORA_DISK_1: backup set of all compressed data files being started

Channel ORA_DISK_1: specifying data files in the backup set

Enter the data file, file number = 00045 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ CLONEPDB_PLUG\ FDA01.DBF

Enter the data file, file number = 00041 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ CLONEPDB_PLUG\ SYSAUX01.DBF

Enter the data file, file number = 00040 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ CLONEPDB_PLUG\ SYSTEM01.DBF

Enter the data file, file number = 00042 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ CLONEPDB_PLUG\ UNDOTBS01.DBF

Enter the data file, file number = 00043 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ CLONEPDB_PLUG\ USERS01.DBF

Channel ORA_DISK_1: starting segment 1 in 05-February-18

Channel ORA_DISK_1: completed startup segment 1 from 05-February-18

Fragment handle = E:\ RECOVERYFLASH\ NEWTEST\ D4B2FCAAC2B944CC8AF5864EC7CB853C\ BACKUPSET\ 2018'02'05\ O1_MF_NNNDF_TAG20180205T094348F7HFW4DJ.BKP tag = TAG20180205T094348 comment = NONE

Channel ORA_DISK_1: backup set completed, time: 00:01:15

Channel ORA_DISK_1: backup set of all compressed data files being started

Channel ORA_DISK_1: specifying data files in the backup set

Enter the data file, file number = 00009 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBTEST\ SYSAUX01.DBF

Enter the data file, file number = 00010 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBTEST\ UNDOTBS01.DBF

Enter the data file, file number = 00008 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBTEST\ SYSTEM01.DBF

Enter the data file, file number = 00011 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBTEST\ USERS01.DBF

Channel ORA_DISK_1: starting segment 1 in 05-February-18

Channel ORA_DISK_1: completed startup segment 1 from 05-February-18

Fragment handle = E:\ RECOVERYFLASH\ NEWTEST\ 24549D14BBEB417BAB312BF19BC5259E\ BACKUPSET\ 2018'02'05\ O1_MF_NNNDF_TAG20180205T094348F7HFYJ6O.BKP tag = TAG20180205T094348 comment = NONE

Channel ORA_DISK_1: backup set completed, time: 00:01:05

Channel ORA_DISK_1: backup set of all compressed data files being started

Channel ORA_DISK_1: specifying data files in the backup set

Enter the data file, file number = 00004 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBSEED\ SYSAUX01.DBF

Enter the data file, file number = 00002 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBSEED\ SYSTEM01.DBF

Enter the data file, file number = 00006 name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ORADATA\ NEWTEST\ PDBSEED\ UNDOTBS01.DBF

Channel ORA_DISK_1: starting segment 1 in 05-February-18

Channel ORA_DISK_1: completed startup segment 1 from 05-February-18

Fragment handle = E:\ RECOVERYFLASH\ NEWTEST\ 32CAC9A05E614355926257BE671D9AFC\ BACKUPSET\ 2018'02'05\ O1_MF_NNNDF_TAG20180205T094348F7HG0L2S.BKP tag = TAG20180205T094348 comment = NONE

Channel ORA_DISK_1: backup set completed, time: 00:02:15

Completed backup in 05-February-18

Starting with Control File and SPFILE Autobackup, which is located in 2005-February-18

Fragment handle = E:\ CONTROLBACKUP\ CF-C-1779551310-20180205-03 comment = NONE

Completed Control File and SPFILE Autobackup in 05-February-18

It is not necessary to use compressed backup, the backup time will be longer. In an environment where the capacity of Icano is not very good, compressed backup can reduce IBO, thus increasing the backup rate. Of course, it is necessary to choose the most suitable compression level according to different environments.

RMAN > CONFIGURE COMPRESSION ALGORITHM CLEAR

Old RMAN configuration parameters:

CONFIGURE COMPRESSION ALGORITHM 'HIGH' AS OF RELEASE' DEFAULT' OPTIMIZE FOR LOAD TRUE

RMAN configuration parameters have been successfully reset to their default values

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report