In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.