使用SHOW ALL命令查看RMAN的配置 RMAN>showall;RMAN configuration parametersfordatabasewithdb_unique_name DEVDB are: CONFIGURE RETENTION POLICYTOREDUNDANCY1;# defaultCONFIGUREBACKUPOPTIMIZATIONOFF;# defaultCONFIGUREDEFAULTDEVICETYPETODISK;# defaultCONFIGURE CONTROLFILE AUTOBACKUPON;CONFIGURE CONTROLFILE AUTOBACKUP F...
也可以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 ...
RMAN常用命令 一、默认配置 show命令 1.查看当前配置参数 RMAN> show all; using target database control file instead of recovery catalog RMAN configuration parameters for database with db_unique_name TEST are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # ...
vflashrecoveryareausage:按照对象类型给出闪回恢复区中已用空间的百分比vrecovery_file_dest:闪回恢复区的文件数量,以使用的空间,可以回收的空间,已经空间限制 v$rman_configuration:数据库采用的非默认值的rman配置参数。
SHOW ALL; RMAN configuration parameters for database with db_unique_name PROD1 are: CONFIGURERETENTION POLICYTO RECOVERY WINDOW OF 3 DAYS; CONFIGUREBACKUP OPTIMIZATIONON; CONFIGUREDEFAULT DEVICE TYPETO DISK; # default CONFIGURECONTROLFILE AUTOBACKUPON; ...
RMAN> show all; RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default ...
RMAN> show all; RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default ...
show all; SQL下执行语句,查询RMAN中的非默认值 select * from v$rman_configuration; 具体配置如下: 1、configure retention policy to redundancy 1;舍弃备份原则,共三种,分别是:(1)CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; 保持所有足够的备份,可以将数据库系统恢复到最近七天内的任意时刻。
Show all 命令显示了默认的配置。 我们也可以使用查看v$rman_configuration 视图,它列出了非默认的RMAN 配额。 3.4.2 配置多种RMAN 配置 我们可以采用不同的方法来配置通道: 使用configure channel device type 命令可以配置用于所有通道的默认值;使用configure ...
1.备份数据库 RMAN> show all; RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYP ...