Optimizer 15.4 free instal9/22/2023 ![]() For example, you can view the retention policy and default device type as follows: You can also use the SHOW command with the name of a particular configuration. ![]() RMAN configuration parameters for database with db_unique_name PROD1 are:ĬONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS ĬONFIGURE DEFAULT DEVICE TYPE TO DISK # defaultĬONFIGURE CONTROLFILE AUTOBACKUP ON # defaultĬONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F' # defaultĬONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F' # defaultĬONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET ĬONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET # defaultĬONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1 # defaultĬONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1 # defaultĬONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1 # defaultĬONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1 # defaultĬONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_DEVICE=tape1)' ĬONFIGURE MAXSETSIZE TO UNLIMITED # defaultĬONFIGURE ENCRYPTION FOR DATABASE OFF # defaultĬONFIGURE ENCRYPTION ALGORITHM 'AES128' # defaultĬONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE # defaultĬONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS # defaultĬONFIGURE ARCHIVELOG DELETION POLICY TO NONE # defaultĬONFIGURE SNAPSHOT CONTROLFILE NAME TO '/disk1/oracle/dbs/snapcf_ev.f' # default You can save the output in a text file and use this command file to re-create the configuration on the same or a different database. ![]() The configuration is displayed as the series of RMAN commands required to re-create the configuration. ![]() The output includes both parameters that you have changed and those that are set to the default. For example, run SHOW ALL as shown in the following example (sample output included). ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |