Oracle恢复至不同的SID实例(一)

测试：
oracle源实例  SID=orcl
oracle 目标实例  SID=yoyo
目标恢复实例 SID=orcl数据库到实例SID=yoyo中

1.查看源实例 SID=ORCL 备份结果：

​RMAN> list backupset;

List of Backup Sets
===================
BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1       34.06M     DISK        00:00:00     20-JUN-20      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20200620T112823
        Piece Name: /home/oracle/bak/full_ORCL_20200620_1

  List of Archived Logs in backup set 1
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    6       1618275    20-JUN-20 1624439    20-JUN-20
  1    7       1624439    20-JUN-20 1624444    20-JUN-20
  1    8       1624444    20-JUN-20 1624541    20-JUN-20
  1    9