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
Summary of Contents for Database Appliance X6-2-HA
Page 15: ...Index xv...
