RMAN> restore controlfile from autobackup; Starting restore at 2013/10/27 19:12:11 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=17 device type=DISK recovery area destination: /u01/flash_recovery_area database name (or d...
restore controlfile to 'f:\backup\ctl.restore' from autobackup; shutdown immediate; 2.2.2 使用RMAN 和 FRA 从自动备份中恢复控制文件 使用FRA恢复控制文件过程非常简单,首先确保FRA位置参数被正确设置。 然后启动实例,执行: restore controlfile from autobackup; set oracle_sid=orcl rman target sys/pwd star...
RMAN>restore controlfile from autobackup; RMAN>alter database mount; RMAN>recover database; RMAn>alter database open open resetlogs; 如果restore controlfile from autobackup; 失败找不到文件,或不记的dbid,当然直接批定全路径也是可以的如 RMAN> restore controlfile from autobackup; Starting restore at 24...
RESTORE CONTROLFILE FROM AUTOBACKUP; RESTORE CONTROLFILE … TO ‘filename’; RESTORE CONTROLFILE … FROM ‘media_handle’ or TAG ‘user_tag’; 非catalog 数据库处于nomount状态 不可用,需要指定FROM AUTOBACKUP; 将控制文件恢复到CONTROL_FILES指定的路径下。 需要指定FROM AUTOBACKUP;将控制文件恢复到指定路径...
restore controlfile to 'f:/backup/ctl.restore' from autobackup; shutdown immediate; 2、使用RMAN 和 FRA 从自动备份中恢复控制文件 使用FRA恢复控制文件过程非常简单,首先确保FRA位置参数被正确设置。 然后启动实例,执行: restore controlfile from autobackup; ...
RMAN> restore controlfile from autobackup; 2.从指定备份片中还原控制文件 RMAN> restore controlfile from '/tmp/piece_name'; 3.从最近可用的控制文件备份中还原控制文件 RMAN> restore controlfile; 如果没有使用fast recovery area或recovery catalog,在还原控制文件前,要先设置dbid ...
发现CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; 后面的default没有的,但是值还是不变,在执行一次备份: RMAN> run 2> { 3> allocate channel c1 device type disk; 4> backup tablespace system format '/storage/database/oracle/backupset/online/backup_%U.bkp'; ...
Starting restore at 2017/06/1308:39:04 using target database control fileinstead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=19 devicetype=DISK channel ORA_DISK_1: restoring spfilefrom AUTOBACKUP /u01/backup/INITBAK_CEBPM_20170612_38_1 ...
SQL> select dbid from v$database; DBID --- 1024701925 启动数据库到NOMOUNT状态: RMAN> STARTUP NOMOUNT; 从自动备份中恢复控制文件,恢复至默认路径下: RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP; 执行上述语句后,备份集中的控制文件会被恢复到初始化参数CONTROL_FILES指定的路径下。 恢复至指定路径...
1、spfile和controlfile的自动备份 当configure controlfile autobackup off时,仅当备份system01.dbf时才会自动备份controlfile和spfile; 当configure controlfile autobackup on时,当任意文件备份时,都会自动备份controlfile和spfile; 2、备份整个库 backup database; ...