在通过duplicate 命令创建physical standby库时,遇到这个问题:
[oracle@beijing dbs]$ rman target / auxiliary sys/oracle@prodx
Recovery Manager: Release 11.2.0.3.0 - Production on Wed Sep 4 01:20:10 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: PROD (DBID=237046118)
connected to auxiliary database: PROD (not mounted)
RMAN> duplicate target database
2> for standby
3> from active database
4> DORECOVER nofilenamecheck
5> spfile
6> set db_unique_name='prodx'
7> set log_archive_dest_1='location=/arch142 VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=prodx'
8> set log_archive_dest_2='SERVICE=prodb ASYNC LGWR VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=prodb'
9>