db19迁移到新的机器上

hostnamectl set-hostname test

 

 ps -ef | grep pmon

env|grep ORA

 env|grep ORA

ps -ef | grep pmon

vim listener.ora

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.31.0.113)(PORT = 1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (ORACLE_HOME = /u01/app/oracle/product/19.0.0/db_1)
      (SID_NAME = cdb1)
    )
  )

 

cdb1_clone =
 (DESCRIPTION = 
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 172.31.0.113)(PORT = 1521))
   )
 (CONNECT_DATA =
   (SERVICE_NAME = cdb1)
 )
)

tnsping cdb1_clone

 

create pfile from spfile;

 scp initcdb1.ora test:$ORACLE_HOME/dbs

scp orapwcdb1 test:$ORACLE_HOME/dbs

 

 mkdir -p /u01/app/oracle/admin/cdb1/adump

mkdir -p /u01/app/oracle/oradata/cdb1/

mkdir -p /u01/app/oracle/fast_recovery_area/CDB1/

 mkdir -p /u01/app/oracle/oradata/cdb1/pdb1

mkdir -p /u01/app/oracle/oradata/cdb1/pdbseed

select name from v$datafile;

select member from v$logfile;

export NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"

export ORACLE_SID=cdb1

sqlplus / as sysdba

startup nomount;

 rman target sys auxiliary sys@cdb1_clone

Password1

duplicate target database to 'cdb1' from active database nofilenamecheck;

 select name,open_mode from v$database;

 select name from v$datafile;

select member from v$logfile;

show parameter control