关于RESTORE CONTROLFILE命令使用限制

官方文档地址：http://docs.oracle.com/cd/B19306_01/backup.102/b14194/rcmsynta051.htm#BGBJJGCB

 

Restrictions and Usage Notes for RESTORECONTROLFILE

 

• After you restore a backup control file, you must runRECOVER DATABASE and then open thedatabase with the RESETLOGS option.

Table 2-27 indicates the restrictions that apply in differentsituations involving the RESTORECONTROLFILE command.

Table 2-27 RESTORE CONTROLFILE Scenarios

	RESTORE CONTROLFILE;	RESTORE CONTROLFILE FROMAUTOBACKUP;	RESTORE CONTROLFILE ... TO'filename';	RESTORE CONTROLFILE ... FROM'media_handle' or TAG 'user_tag';
No catalog, target started in NOMOUNT state	Error. Must specify FROMAUTOBACKUP.	First run SET DBID. Restores to CONTROL_FILESlocations.	First run SET DBID. Must specify FROMAUTOBACKUP. Restores only to filename.	First run SET DBID. Restores from specified file (cannotrestore from TAG). If TO'filename' not used, restores toall CONTROL_FILES locations.
No catalog, target mounted or open	Error. Must use TO 'filename', wherefilenameis not in CONTROL_FILES list.	Error. Must use TO 'filename', wherefilenameis not in CONTROL_FILES list.	Restores only to filename, wherefilenameis not in CONTROL_FILES list.	Restores from specified file. If TO'filename' not used, restores toall CONTROL_FILES locations.
Catalog, target started in NOMOUNT state --必须处在 nomount模式下，而且需要进入恢复目录才行。	Restores to CONTROL_FILES locations.Run SET DBID only ifDB_NAME not unique in catalog. --如果在恢复目录中 DB_NAME不唯一，还要设置DBID。	Only use with catalog for testing purposes.	Restores only to filename, wherefilenameis not in CONTROL_FILES list.	Restores from specified file. If TO'filename' not used, restores toall CONTROL_FILES locations.
Catalog, target mounted or open	Error. Must use TO 'filename', wherefilenameis not in CONTROL_FILES list.	Do not use with catalog.	Restores only to filename, wherefilenameis not in CONTROL_FILES list.	Restores from specified file. If TO'filename' not used, restores toall CONTROL_FILES locations.