在12.1.0.2之后,oracle就提供了使用dbca直接创建物理备库的方法
The DBCA commandqualifier used to create the physical standby databaseis createDuplicateDB . DBCA can only be used to create standbydatabases for non-multitenant primary databases. In addition, this capability createsonly single instance standby databases, not Oracle Real Application Clusters(Oracle RAC) databases. If required, the standby can then beconverted to an Oracle RAC standby database, either manually or using OracleEnterprise Manager Cloud Control. Thebasic createDuplicateDB command has the following syntax: dbca -createDuplicateDB -gdbName global_database_name -primaryDBConnectionString easy_connect_string_to_primary -sid database_system_identifier [-createAsStandby [-dbUniqueName db_unique_name_for_standby]] [-customScriptsscripts_list]
可参考官方文档的例子:
dbca –silent -createDuplicateDB-primaryDBConnectionString myprimary.domain:1523/chicago.domain -gdbName chicago.domain -sidboston -initParams instance_name=boston –createAsStandby
|