在看duplicate的官方文档:内容如下:
RMAN DUPLICATE DATABASE From File System to ASM: Example
This duplication example assumes the following:
You are using recovery catalog database catdb.
The target database trgt is on host1 and the database files are stored in a non-ASM file system.
You want to duplicate the target to database dupdb on remote host host2.
host2 has diskgroup +DISK1.
You want to store the datafiles for dupdb to +DISK1.
You want to store two controlfiles in +DISK1.
The backups and archivelogs created by host1 are accessible by host2.
Create an initialization parameter for auxiliary instance by copying the target database initialization parameter file. Change the parameters as follows:
Set DB_NAME to the new database name dupdb
Set CONTROL_FILES to store two copies of the control file in +DISK1
Make sure DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT are not set
Set any other initialization parameters that end in _DEST, such as DB_CREATE_FILE_DEST and DB_CREATE_ONLINE_DEST_n, to reference +DISK1
不是很明白为啥 DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT 不能被设置呢????它和parameters that end in _DEST 是有冲突么???
RMAN DUPLICATE DATABASE From File System to ASM: Example
This duplication example assumes the following:
You are using recovery catalog database catdb.
The target database trgt is on host1 and the database files are stored in a non-ASM file system.
You want to duplicate the target to database dupdb on remote host host2.
host2 has diskgroup +DISK1.
You want to store the datafiles for dupdb to +DISK1.
You want to store two controlfiles in +DISK1.
The backups and archivelogs created by host1 are accessible by host2.
Create an initialization parameter for auxiliary instance by copying the target database initialization parameter file. Change the parameters as follows:
Set DB_NAME to the new database name dupdb
Set CONTROL_FILES to store two copies of the control file in +DISK1
Make sure DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT are not set
Set any other initialization parameters that end in _DEST, such as DB_CREATE_FILE_DEST and DB_CREATE_ONLINE_DEST_n, to reference +DISK1
不是很明白为啥 DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT 不能被设置呢????它和parameters that end in _DEST 是有冲突么???
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8497396/viewspace-748666/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8497396/viewspace-748666/
本文档详细介绍了一个使用Oracle RMAN工具从非ASM文件系统到ASM存储的数据库复制案例。目标数据库位于host1上,而复制的目标是host2上的dupdb数据库。文章提供了初始化参数设置的具体步骤,包括如何设置DB_NAME、CONTROL_FILES等关键参数。
2103

被折叠的 条评论
为什么被折叠?



