Oracle X6-2-HA

4. Display the database storage details, including the DATA, RECO and REDO
locations, for each database storage ID.
For example, use the odacli describe-dbstorage command to display
information about the ACFS storage for ID 9fe39332-
cc1a-4b4b-8393-165524a6ef6b.
# odacli describe-dbstorage -i ff2023d9-338d-4cff-8bb4-e73a89e32ce4
DBStorage details
----------------------------------------------------------------
ID: ff2023d9-338d-4cff-8bb4-e73a89e32ce4
DB Name: PRODDB
DBUnique Name: PRODDB
DB Resource ID: c5b77384-634e-4dc8-b10b-fa2831d2c59b
Storage Type: Acfs
DATA Location: /u02/app/oracle/oradata/PRODDB
RECO Location: /u03/app/oracle/fast_recovery_area/
REDO Location: /u03/app/oracle/redo/
State: ResourceState(status=Configured)
Created: November 22, 2016 12:07:12 PM SGT
UpdatedTime: November 22, 2016 12:26:39 PM SGT
5. Duplicate the database.
Use the RMAN duplicate database command to duplicate the database.
rman target sys/Welcome__12@source database hostname:PORT
(Continued)
/Service Name auxiliary sys/Welcome_12@Hostname of the target database:
1521/service name
RUN {
SET NEWNAME FOR DATABASE TO NEW;
duplicate target database to PRODDB from active database
SPFILE
SET cluster_database 'false'
SET audit_file_dest '/u01/app/oracle/admin/PRODDB/adump'
SET db_create_file_dest '/u02/app/oracle/oradata/PRODDB'
SET db_create_online_log_dest_1 '/u03/app/oracle/redo'
SET db_recovery_file_dest '/u03/app/oracle/fast_recovery_area'
SET control_files '/tmp/control_PRODDB.ctl' nofilenamecheck;
}
Registering a Database
Use the odacli register-database command to register the migrated database
with the appliance.
The dbclass , dbshape , servicename and password are mandatory for registering the
database. The dbclass and dbshape determine the sga_target and pga_target
settings. The database init.ora parameters are reset as part of the odacli
register-database command. Review the init.ora parameters after registration
and ensure that the parameters set correctly.
Chapter 9
Migrating Databases
9-16