RMAN> LIST BACKUP OF CONTROLFILE; 一.1.1备份控制文件 控制文件在ORACLE中的重要性是毋庸置疑的,你看,连RMAN都给予特殊的照顾,在RMAN中备份控制文件的方式是最多的。 1.最简单的方式,通过CONFIGURE命令将CONTROLFILE AUTOBACKUP置为ON。 RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; RMAN> CONFIGURE CONTROLFILE AUT...
SQL> ALTER DATABASE BACKUP CONTROLFILE TO '/tmp/control.ctl';--热备份控制文件 SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS '/home/bk/a.ctl';--得到建立控制文件的脚本,备份为文本文件格式 SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE [RESETLOGS|NORESETLOGS]; ② RMAN手动备份控制文件:...
RMAN>CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/ORADATA/controlfile/cf_%F'; new RMAN configuration parameters: CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/ORADATA/controlfile/cf_%F'; new RMAN configuration parameters are successfully stored 查看重新设置的...
The snapshotcontrolfile MUST be accessible by all nodes of a RAC database, if the snapshotcontrolfile does not reside on a shared device error will be raised at the timeof RMAN backup while taking snapshot of controlfile. --快照控制文件必须能被所有节点访问,如果快照控制不是存放在共享设备上...
controlfile does not reside on a shared device error will be raised at the timeof RMAN backup ...
RMAN>showcontrolfile autobackup format; 1. 修改控制文件自动备份路径 RMAN>configure controlfile autobackup formatfordevicetypediskto'/backup/orcl/%F'; 1. 注意%F是DBID+日期,可以用来识别时间及DBID 手动备份控制文件 backupcurrentcontrolfile format'/backup/orcl/control_%d_%T_%s_%p.bak'; ...
RMAN> show all;using target database control file instead of recovery catalog RMAN configuration parameters for database with db_unique_name FIRE are:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default C...
restore controlfile to 'f:/backup/ctl.restore' from autobackup; shutdown immediate; 2、使用RMAN 和 FRA 从自动备份中恢复控制文件 使用FRA恢复控制文件过程非常简单,首先确保FRA位置参数被正确设置。 然后启动实例,执行: restore controlfile from autobackup; ...
RMAN> backup current controlfile; Starting backup at 06-NOV-2012 02:36:50 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=58 device type=DISK channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set ...
--使用`ALTER DATABASE BACKUP CONTROLFILE`命令备份:SQL>ALTERDATABASEBACKUPCONTROLFILETO'/path/to/backup/location1';--推荐使用RMAN备份RMAN>BACKUPCURRENTCONTROLFILETO'/path/to/backup/location2';--如果控制文件损坏或丢失,您可以使用RMAN来恢复它,数据库启动到mount状态RMAN>RESTORECONTROLFILEFROM'/path/to/ba...