You want to replicate the production database to anther host,SHOST2,for testing new applications.
After you ensured that the backups of the target database are accessible on the new host,what must you do to restore and recover the backup for the test environment?
A. Restoring the control file from the backup by using the NOCATALOG option to restore,and recovering the data files
B. Restoring the data files by using the NOCATALOG option and using the SET NEWNAME command to change the location
C. Restoring the server parameter file from the backup by using the recovery catalog to restore,and recovering the data files
D. Restoring the data files from the backup by using the recovery catalog to recover the files,and using the SWITCH command to change the location.
答案:(D)
解析:
把备份的数据库恢复到另外一台主机,可以使用recovery catalog恢复数据文件,然后使用switch命令修改数据文件的位置
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/17013648/viewspace-1346723/ ,如需转载,请注明出处,否则将追究法律责任。