也可以show指定的配置,如 RMAN> show retention policy; RMAN configuration parameters for database with db_unique_name TEST are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default RMAN> show controlfile autobackup; RMAN configuration parameters for database with db_unique_name TEST are: CONFIGURE ...
使用SHOW ALL命令查看RMAN的配置 RMAN>showall;RMAN configuration parametersfordatabasewithdb_unique_name DEVDB are: CONFIGURE RETENTION POLICYTOREDUNDANCY1;# defaultCONFIGUREBACKUPOPTIMIZATIONOFF;# defaultCONFIGUREDEFAULTDEVICETYPETODISK;# defaultCONFIGURE CONTROLFILE AUTOBACKUPON;CONFIGURE CONTROLFILE AUTOBACKUP F...
RMAN>show all //总配置参数,具体看configure模块 RMAN>showall; RMAN configuration parametersfordatabasewithdb_unique_name ORCL are: CONFIGURE RETENTION POLICYTOREDUNDANCY1; #defaultCONFIGUREBACKUPOPTIMIZATIONOFF; #defaultCONFIGUREDEFAULTDEVICE TYPETODISK; #defaultCONFIGURE CONTROLFILE AUTOBACKUPOFF; #defaultCON...
1. RMAN的默认配置 1RMAN>showall;23using targetdatabasecontrolfileinsteadofrecovery catalog4RMAN configuration parametersfordatabasewithdb_unique_name OCP12C are:5CONFIGURE RETENTION POLICYTOREDUNDANCY1; #default6CONFIGUREBACKUPOPTIMIZATIONOFF; #default7CONFIGUREDEFAULTDEVICE TYPETODISK; #default8CONFIGURE CON...
SHOWDEFAULT DEVICE TYPE; 例子: RMAN> SHOW DEFAULT DEVICE TYPE; RMAN configuration parameters for database with db_unique_name ORCL are: CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default 三、清除rman的配置恢复到默认值 CONFIGURE BACKUP OPTIMIZATION CLEAR; ...
Oracle 9i可以配置一些参数如通道,备份保持策略等信息,通过一次设定可以多次使用,而且,设置中的信息不影响脚本中的重新设置。RMAN 默认的配置参数,通过show all 就可以看出来。 RMAN> show all; RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; ...
RMAN> show device type; RMAN configuration parameters for database with db_unique_name MAA are: CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default – 表示默认为备份集备份 backup其实更正确的命令为backup as backupset。执行该命令的时候数据库必须在MOUNT或是OPEN状态,如果是OPE...
connected to target database: CDBP (DBID=3886807746) RMAN> show all; using target database control file instead of recovery catalog RMAN configuration parameters for database with db_unique_name CDBP are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # ...
--查询目前DG部署DGMGRL>show configuration Configuration-LHR11GProtection Mode:MaxPerformanceDatabases:LHR11G-Primary databaseLHR11GDG-Physical standby database Fast-Start Failover:DISABLEDConfiguration Status:SUCCESS--主库SYS@LHR11G>select flashback_on,db_unique_name,database_role from v$database;FLASHBAC...
使用SHOW ALL命令查看默认值 代码语言:javascript 复制 RMAN>show all;RMANconfiguration parametersfordatabasewithdb_unique_namePRODare:CONFIGURERETENTIONPOLICYTOREDUNDANCY1;#defaultCONFIGUREBACKUPOPTIMIZATIONOFF;#defaultCONFIGUREDEFAULTDEVICETYPETODISK;#defaultCONFIGURECONTROLFILEAUTOBACKUPOFF;#defaultCONFIGURECONTROLFILEAUT...