In this article, we will do Duplicate from active database using rman, we can do rman duplicate database using rman in oracle database. Duplicating oracle database from active database doesn’t require RMAN backup.
Steps to restore database using duplicate from active database.
RMAN can easily duplicate/restore/clone database to target database over the network without any backup. Ensure archive log enable on source database.
| Type | Source (192.168.11.10) | Target (192.168.11.20) |
|---|---|---|
| SID Name | INDPRD | INDDEV |
| Database version | 12.1.0.2.0 | 12.1.0.2.0 |
| OS version | OEL7 | OEL7 |
Using following steps, we can easily duplicate database from active database 19c and duplicate target database for standby as well with same procedure.
We have source database as INDPRD and Target database as INDDEV. Using following steps, we can duplicate database on same host or different host.
Source database:- INDPRD
IP:- 192.168.11.10
Target database:- INDDEV
IP:- 192.168.11.20
Source DB server: –
Step 1:- Copy the password from source to target database server.
$scp orapwindprd [email protected]:$ORACLE_HOME/dbs/orapwinddev
orapwinddev 100% 3974 3.9KB/s 00:00
Step 2:- Create pfile from SOURCE database for TARGET database
SQL> create pfile from spfile;
Copy pfile to target database $ORACLE_HOME/dbs/
Step 3:- Copy the ORACLE_HOME from Source database to Target database ORACLE_HOME.
$scp -rp $ORACLE_HOME [email protected]:/inddev/app/
Note:- In case no Oracle binary available on Target database home, You should copy the complete Oracle Binary file from PROD (Source) to INDDEV(Target). If already binary at place, you may ignore this step.
Target DB Server:-
Step 4:-Create directories in the TARGET DB server
We need to create directory for datafiles,logfiles,cdump & adump etc.
mkdir -p /inddev/app/oracle/admin/clone
mkdir -p /inddev/app/oracle/admin/clone/adump
Step 5:- Prepare pfile (update db_name,directory etc).
vi initinddev.ora (PFILE Target Database inddev)
*.db_file_name_convert=’/indprd/app/oracle/oradata/indprd’,’/inddev/app/oracle/oradata/inddev’
*.log_file_name_convert=’/indprd/app/oracle/arch/indprd’,’/inddev/app/oracle/arch/indev’
*.audit_file_dest=’/inddev/app/oracle/admin/clone/adump’*.
control_files=’/indprd/app/oracle/oradata/indprd/control01.ctl’,’/inddev/app/oracle/oradata/inddev/control02.ctl’
*.db_name=’inddev’
Step 6: – Set the Environment for Target database.
Before start duplicate from active, we need to set the proper environment for target database for smooth cloning.
ORACLE_HOME=/inddev/app/oracle/product/12.2.0.1/db_1
export ORACLE_HOME
ORACLE_BASE=/inddev/app/oracle
export ORACLE_BASE
ORACLE_SID=INDDEV
export ORACLE_SID
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:.
export LD_LIBRARY_PATH
LIBPATH=$ORACLE_HOME/lib32:$ORACLE_HOME/lib:/usr/lib:/lib
export LIBPATH
TNS_ADMIN=${ORACLE_HOME}/network/admin
export TNS_ADMIN
PATH=$ORACLE_HOME/bin:$PATH:.
export PATH
Step 7:-Open the Target database in NOMOUNT state using modified pfile,
SQL>startup pfile nomount=’$ORACLE_HOME/dbs/initinddev.ora’;
ORACLE instance started.
Total System Global Area 56106145678 bytes
Fixed Size 96212328 bytes
Variable Size 3040188440 bytes
Database Buffers 853648334 bytes
Redo Buffers 71551342 bytesStep 8:-Configure the listener & ifile.ora
Listener file located under /inddev/oracle/12.1.0/network/admin/INDDEV_inddevsrv
Make sure below details in listener.ora file on target database.
INDDEV =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = inddevsrv.com)(PORT = 1561))
)
)
SID_LIST_INDDEV =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME= /inddev/oracle/12.1.0)
(SID_NAME = INDDEV)
)
)
STARTUP_WAIT_TIME_INDDEV = 0
CONNECT_TIMEOUT_INDDEV = 10
TRACE_LEVEL_INDDEV = OFF
LOG_DIRECTORY_INDDEV = /inddev/oracle/12.1.0/network/admin
LOG_FILE_INDDEV = INDDEV
TRACE_DIRECTORY_INDDEV = /inddev/oracle/12.1.0/network/admin
TRACE_FILE_INDDEV = INDDEV
ADMIN_RESTRICTIONS_INDDEV = ON
SUBSCRIBE_FOR_NODE_DOWN_EVENT_INDDEV = OFF
LOG_STATUS_INDDEV = ON
INBOUND_CONNECT_TIMEOUT_INDDEV = 60
# ADR is only applicable for 11gDB
DIAG_ADR_ENABLED_INDDEV = ON
ADR_BASE_INDDEV = /inddev/oracle/12.1.0/admin/INDDEV_inddevsrv
IFILE=/inddev/oracle/12.1.0/network/admin/INDDEV_inddevsrv/listener_ifile.ora
[inddev@inddevsrv INDDEV_inddevsrv]$
[inddev@inddevsrv
Make sure you have under $TNS_ADMIN. In case of doesn’t exist, pls create the same as below and make entry for PROD(INDPROD tns details).
$ cat INDDEV_inddevsrv_ifile.ora
INDPRD=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=indprdsrv.com)(PORT=1524))(CONNECT_DATA=(SERVICE_NAME=INDPRD)(INSTANCE_NAME=INDPRD)))
On Source database server:-
To database refresh using rman duplicate make sure your source database tns details will be mentioned in below file.
INPRD_indprdsrv_ifile.ora
INDDEV =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = inddevsrv.com)(PORT = 1560))(CONNECT_DATA =(SERVICE_NAME =INDDEV)(INSTANCE_NAME=INDDEV)))
Just check the tnsping from INPRD. It should be as below.
[[email protected]$ tnsping inddev
TNS Ping Utility for Linux: Version 12.1.0.2.0 – Production on 05-SEP-2022 03:23:37
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
/indprd/oracle/12.1.0/network/admin/INDPRD_indprdsrv/sqlnet_ifile.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = inddevsrv.com)(PORT = 1524))(CONNECT_DATA =(SERVICE_NAME =INDDEV)(INSTANCE_NAME=INDDEV)))
OK (50 msec)
Check the tnsping from source database node as below.
$tnsping indprd
TNS Ping Utility for Linux: Version 12.1.0.2.0 – Production on 05-SEP-2022 03:27:45
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
/inddev/oracle/12.1.0/network/admin/INDDEV_inddevsrv/sqlnet_ifile.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=indprdsrv.com)(PORT=1524))(CONNECT_DATA=(SERVICE_NAME=INDPRD)(INSTANCE_NAME=INDPRD)))
OK (50 msec)
Here we have checked that, we are able to tnsping from source to destination and vice versa.
Step 9:- Prepare and execute duplicate script to restore database.
Create active duplicate script as clone_active_from_prod.sh to execute. Below we are just doing rman duplicate from active database allocate channel to restore oracle database. In below script we are using rman duplicate nofilenamecheck.
SYSDATE=`date '+%y%m%d%H%M%S'`
export NLS_DATE_FORMAT='Mon DD YYYY HH24:MI:SS'
$ORACLE_HOME/bin/rman nocatalog msglog /home/indrldev/clone/INDRLDEV_CLONE_${SYSDATE}.log << !
connect target sys/******@indprd
connect auxiliary sys/******
run
{
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
allocate channel ch3 device type disk;
allocate channel ch4 device type disk;
allocate channel ch5 device type disk;
allocate channel ch6 device type disk;
allocate channel ch7 device type disk;
allocate channel ch8 device type disk;
allocate auxiliary channel aux1 device type disk;
allocate auxiliary channel aux2 device type disk;
allocate auxiliary channel aux3 device type disk;
allocate auxiliary channel aux4 device type disk;
allocate auxiliary channel aux5 device type disk;
allocate auxiliary channel aux6 device type disk;
allocate auxiliary channel aux7 device type disk;
allocate auxiliary channel aux8 device type disk;
duplicate target database to INDRLDEV FROM ACTIVE DATABASE nofilenamecheck;
release channel ch1;
release channel ch2;
release channel ch3;
release channel ch4;
release channel ch5;
release channel ch6;
release channel ch7;
release channel ch8;
release channel aux1;
release channel aux2;
release channel aux3;
release channel aux4;
release channel aux5;
release channel aux6;
release channel aux7;
release channel aux8;
}
!Note: – We can also duplicate target database for standby from active database nofilenamecheck by just using script as below.
duplicate target database for standby for active database;
Execute the script using nohup :- Usin rman backup script we will rman duplicate from active database 12c on same server or different server as requirement.
$nohup sh clone_active_from_prod.sh &
tail the INDRLDEV_CLONE_${SYSDATE}.log to monitor, if any error.
After completion of restoration, log file will as blow.
After completion of restoration, need to verify.
Recovery Manager: Release 12.1.0.2.0 - Production on Mon Feb 6 00:07:44 2022
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
RMAN>
connected to target database: INDPRD(DBID=2104816890)
using target database control file instead of recovery catalog
RMAN>
connected to auxiliary database: INDDEV (not mounted)
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44>
allocated channel: ch1
channel ch1: SID=765 device type=DISK
allocated channel: ch2
channel ch2: SID=2168 device type=DISK
allocated channel: ch3
channel ch3: SID=2290 device type=DISK
allocated channel: ch4
channel ch4: SID=2572 device type=DISK
allocated channel: ch5
channel ch5: SID=2664 device type=DISK
allocated channel: ch6
channel ch6: SID=2793 device type=DISK
allocated channel: ch7
channel ch7: SID=2908 device type=DISK
allocated channel: ch8
channel ch8: SID=165 device type=DISK
allocated channel: ch9
channel ch9: SID=2666 device type=DISK
allocated channel: ch10
channel ch10: SID=269 device type=DISK
allocated channel: aux1
channel aux1: SID=1248 device type=DISK
allocated channel: aux2
channel aux2: SID=1337 device type=DISK
allocated channel: aux3
channel aux3: SID=2 device type=DISK
allocated channel: aux4
channel aux4: SID=91 device type=DISK
allocated channel: aux5
channel aux5: SID=181 device type=DISK
allocated channel: aux6
channel aux6: SID=270 device type=DISK
allocated channel: aux7
channel aux7: SID=359 device type=DISK
allocated channel: aux8
channel aux8: SID=448 device type=DISK
Starting Duplicate Db at Sep 05 2022 00:08:25
current log archived
contents of Memory Script:
{
sql clone "create spfile from memory";
}
executing Memory Script
sql statement: create spfile from memory
contents of Memory Script:
{
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 6442450944 bytes
Fixed Size 5298088 bytes
Variable Size 5855250520 bytes
Database Buffers 570425344 bytes
Redo Buffers 11476992 bytes
allocated channel: aux1
channel aux1: SID=1248 device type=DISK
allocated channel: aux2
channel aux2: SID=1337 device type=DISK
allocated channel: aux3
channel aux3: SID=2 device type=DISK
allocated channel: aux4
channel aux4: SID=91 device type=DISK
allocated channel: aux5
channel aux5: SID=181 device type=DISK
allocated channel: aux6
channel aux6: SID=270 device type=DISK
allocated channel: aux7
channel aux7: SID=359 device type=DISK
allocated channel: aux8
channel aux8: SID=448 device type=DISK
allocated channel: aux9
channel aux9: SID=537 device type=DISK
allocated channel: aux10
channel aux10: SID=626 device type=DISK
contents of Memory Script:
{
sql clone "alter system set db_name =
''INDPRD'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''INDDEV'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone from service 'indprd' primary controlfile;
alter clone database mount;
}
executing Memory Script
sql statement: alter system set db_name = ''INDPRD'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''INDDEV'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 3442450944 bytes
Fixed Size 3298088 bytes
Variable Size 4855250520 bytes
Database Buffers 370425344 bytes
Redo Buffers 11476992 bytes
allocated channel: aux1
channel aux1: SID=1248 device type=DISK
allocated channel: aux2
channel aux2: SID=1337 device type=DISK
allocated channel: aux3
channel aux3: SID=2 device type=DISK
allocated channel: aux4
channel aux4: SID=91 device type=DISK
allocated channel: aux5
channel aux5: SID=181 device type=DISK
allocated channel: aux6
channel aux6: SID=270 device type=DISK
allocated channel: aux7
channel aux7: SID=359 device type=DISK
allocated channel: aux8
channel aux8: SID=448 device type=DISK
Starting restore at Sep 05 2022 00:09:49
channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service indprd
channel aux1: restoring control file
channel aux1: restore complete, elapsed time: 00:00:08
output file name=+DATA01/INDDEV/controlfile/ctrl11.ctl
output file name=+REC01/INDDEV/controlfile/ctrl22.ctl
Finished restore at Sep 05 2022 00:09:58
database mounted
contents of Memory Script:
{
set newname for datafile 1 to
"+DATA01/INDDEV/datafile/system01.dbf";
set newname for datafile 2 to
"+DATA01/INDDEV/datafile/system02.dbf";
set newname for datafile 3 to
"+DATA01/INDDEV/datafile/system03.dbf";
set newname for datafile 4 to
"+DATA01/INDDEV/datafile/system04.dbf";
set newname for datafile 5 to
"+DATA01/INDDEV/datafile/system05.dbf";
set newname for datafile 6 to
"+DATA01/INDDEV/datafile/system06.dbf";
set newname for datafile 7 to
"+DATA01/INDDEV/datafile/system07.dbf";
set newname for datafile 8 to
"+DATA01/INDDEV/datafile/undo01.dbf";
set newname for datafile 9 to
"+DATA01/INDDEV/datafile/undo02.dbf";
set newname for datafile 10 to
"+DATA01/INDDEV/datafile/undo03.dbf";
set newname for datafile 11 to
"+DATA01/INDDEV/datafile/undo04.dbf";
set newname for datafile 12 to
"+DATA01/INDDEV/datafile/undo06.dbf";
set newname for datafile 13 to
"+DATA01/INDDEV/datafile/undo07.dbf";
set newname for datafile 14 to
"+DATA01/INDDEV/datafile/undo05.dbf";
set newname for datafile 15 to
"+DATA01/INDDEV/datafile/undo09.dbf";
set newname for datafile 16 to
"+DATA01/INDDEV/datafile/undo10.dbf";
set newname for datafile 17 to
"+DATA01/INDDEV/datafile/undo08.dbf";
set newname for datafile 18 to
"+DATA01/INDDEV/datafile/apps_ts_tx_data21.dbf";
set newname for datafile 19 to
"+DATA01/INDDEV/datafile/apps_ts_tx_data22.dbf";
set newname for datafile 20 to
"+DATA01/INDDEV/datafile/apps_ts_tx_data23.dbf";
set newname for datafile 21 to
"+DATA01/INDDEV/datafile/apps_ts_tx_data24.dbf";
set newname for datafile 22 to
"+DATA01/INDDEV/datafile/apps_ts_tx_data25.dbf";
set newname for datafile 23 to
"+DATA01/INDDEV/datafile/apps_ts_tx_idx17.dbf";
set newname for datafile 24 to
"+DATA01/INDDEV/datafile/apps_ts_tx_idx18.dbf";
set newname for datafile 25 to
"+DATA01/INDDEV/datafile/apps_ts_tx_idx19.dbf";
set newname for datafile 26 to
"+DATA01/INDDEV/datafile/apps_ts_tx_idx20.dbf";
set newname for datafile 27 to
"+DATA01/INDDEV/datafile/apps_ts_tx_idx21.dbf";
set newname for datafile 28 to
"+DATA01/INDDEV/datafile/apps_ts_summary02.dbf";
set newname for datafile 29 to
"+DATA01/INDDEV/datafile/apps_ts_tx_data26.dbf";
set newname for datafile 30 to
"+DATA01/INDDEV/datafile/apps_ts_tx_data27.dbf"
restore
from service 'indprd' clone database
;
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at Sep 05 2022 00:11:30
channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service indprd
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00001 to +DATA01/INDDEV/datafile/system01.dbf
channel aux2: starting datafile backup set restore
channel aux2: using network backup set from service indprd
channel aux2: specifying datafile(s) to restore from backup set
channel aux2: restoring datafile 00002 to +DATA01/INDDEV/datafile/system02.dbf
channel aux3: starting datafile backup set restore
channel aux3: using network backup set from service indprd
channel aux3: specifying datafile(s) to restore from backup set
channel aux3: restoring datafile 00003 to +DATA01/INDDEV/datafile/system03.dbf
channel aux4: starting datafile backup set restore
channel aux4: using network backup set from service indprd
channel aux4: specifying datafile(s) to restore from backup set
channel aux4: restoring datafile 00004 to +DATA01/INDDEV/datafile/system04.dbf
channel aux5: starting datafile backup set restore
channel aux5: using network backup set from service indprd
channel aux5: specifying datafile(s) to restore from backup set
channel aux5: restoring datafile 00005 to +DATA01/INDDEV/datafile/system05.dbf
channel aux6: starting datafile backup set restore
channel aux6: using network backup set from service indprd
channel aux6: specifying datafile(s) to restore from backup set
channel aux6: restoring datafile 00006 to +DATA01/INDDEV/datafile/system06.dbf
channel aux7: starting datafile backup set restore
channel aux7: using network backup set from service indprd
channel aux7: specifying datafile(s) to restore from backup set
channel aux7: restoring datafile 00007 to +DATA01/INDDEV/datafile/system07.dbf
channel aux8: starting datafile backup set restore
channel aux8: using network backup set from service indprd
channel aux8: specifying datafile(s) to restore from backup set
channel aux8: restoring datafile 00008 to +DATA01/INDDEV/datafile/undo01.dbf
channel aux9: starting datafile backup set restore
channel aux9: using network backup set from service indprd
channel aux9: specifying datafile(s) to restore from backup set
channel aux9: restoring datafile 00009 to +DATA01/INDDEV/datafile/undo02.dbf
channel aux10: starting datafile backup set restore
channel aux10: using network backup set from service indprd
channel aux10: specifying datafile(s) to restore from backup set
channel aux10: restoring datafile 00010 to +DATA01/INDDEV/datafile/undo03.dbf
channel aux7: restore complete, elapsed time: 00:00:09
channel aux7: starting datafile backup set restore
channel aux7: using network backup set from service indprd
channel aux7: specifying datafile(s) to restore from backup set
channel aux7: restoring datafile 00011 to +DATA01/INDDEV/datafile/undo04.dbf
channel aux5: restore complete, elapsed time: 00:00:11
channel aux5: starting datafile backup set restore
channel aux5: using network backup set from service indprd
channel aux5: specifying datafile(s) to restore from backup set
channel aux5: restoring datafile 00012 to +DATA01/INDDEV/datafile/undo06.dbf
channel aux6: restore complete, elapsed time: 00:00:27
channel aux6: starting datafile backup set restore
channel aux6: using network backup set from service indprd
channel aux6: specifying datafile(s) to restore from backup set
channel aux6: restoring datafile 00013 to +DATA01/INDDEV/datafile/undo07.dbf
channel aux1: restore complete, elapsed time: 00:01:25
channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service indprd
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00014 to +DATA01/INDDEV/datafile/undo05.dbf
channel aux2: restore complete, elapsed time: 00:01:25
channel aux2: starting datafile backup set restore
channel aux2: using network backup set from service indprd
channel aux2: specifying datafile(s) to restore from backup set
channel aux2: restoring datafile 00015 to +DATA01/INDDEV/datafile/undo09.dbf
channel aux4: restore complete, elapsed time: 00:01:25
channel aux4: starting datafile backup set restore
channel aux4: using network backup set from service indprd
channel aux4: specifying datafile(s) to restore from backup set
channel aux4: restoring datafile 00016 to +DATA01/INDDEV/datafile/undo10.dbf
channel aux6: restore complete, elapsed time: 00:00:58
channel aux6: starting datafile backup set restore
channel aux6: using network backup set from service indprd
channel aux6: specifying datafile(s) to restore from backup set
channel aux6: restoring datafile 00017 to +DATA01/INDDEV/datafile/undo08.dbf
channel aux3: restore complete, elapsed time: 00:01:27
channel aux3: starting datafile backup set restore
channel aux3: using network backup set from service indprd
channel aux3: specifying datafile(s) to restore from backup set
channel aux3: restoring datafile 00018 to +DATA01/INDDEV/datafile/apps_ts_tx_data21.dbf
channel aux10: restore complete, elapsed time: 00:01:39
channel aux10: starting datafile backup set restore
channel aux10: using network backup set from service indprd
channel aux10: specifying datafile(s) to restore from backup set
channel aux10: restoring datafile 00019 to +DATA01/INDDEV/datafile/apps_ts_tx_data22.dbf
channel aux7: restore complete, elapsed time: 00:01:46
channel aux7: starting datafile backup set restore
channel aux7: using network backup set from service indprd
channel aux7: specifying datafile(s) to restore from backup set
channel aux7: restoring datafile 00020 to +DATA01/INDDEV/datafile/apps_ts_tx_data23.dbf
channel aux9: restore complete, elapsed time: 00:02:02
channel aux9: starting datafile backup set restore
channel aux9: using network backup set from service indprd
channel aux9: specifying datafile(s) to restore from backup set
channel aux9: restoring datafile 00021 to +DATA01/INDDEV/datafile/apps_ts_tx_data24.dbf
channel aux8: restore complete, elapsed time: 00:02:11
channel aux8: starting datafile backup set restore
channel aux8: using network backup set from service indprd
channel aux8: specifying datafile(s) to restore from backup set
channel aux8: restoring datafile 00022 to +DATA01/INDDEV/datafile/apps_ts_tx_data25.dbf
channel aux2: restore complete, elapsed time: 00:00:51
channel aux2: starting datafile backup set restore
channel aux2: using network backup set from service indprd
channel aux2: specifying datafile(s) to restore from backup set
channel aux2: restoring datafile 00023 to +DATA01/INDDEV/datafile/apps_ts_tx_idx17.dbf
channel aux6: restore complete, elapsed time: 00:00:51
channel aux6: starting datafile backup set restore
channel aux6: using network backup set from service indprd
channel aux6: specifying datafile(s) to restore from backup set
channel aux6: restoring datafile 00024 to +DATA01/INDDEV/datafile/apps_ts_tx_idx18.dbf
channel aux5: restore complete, elapsed time: 00:02:20
channel aux5: starting datafile backup set restore
channel aux5: using network backup set from service indprd
channel aux5: specifying datafile(s) to restore from backup set
channel aux5: restoring datafile 00025 to +DATA01/INDDEV/datafile/apps_ts_tx_idx19.dbf
channel aux4: restore complete, elapsed time: 00:01:15
channel aux4: starting datafile backup set restore
channel aux4: using network backup set from service indprd
channel aux4: specifying datafile(s) to restore from backup set
channel aux4: restoring datafile 00026 to +DATA01/INDDEV/datafile/apps_ts_tx_idx20.dbf
channel aux1: restore complete, elapsed time: 00:01:42
channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service indprd
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00027 to +DATA01/INDDEV/datafile/apps_ts_tx_idx21.dbf
channel aux2: restore complete, elapsed time: 00:03:25
channel aux2: starting datafile backup set restore
channel aux2: using network backup set from service indprd
channel aux2: specifying datafile(s) to restore from backup set
channel aux2: restoring datafile 00028 to +DATA01/INDDEV/datafile/apps_ts_summary02.dbf
channel aux6: restore complete, elapsed time: 00:03:25
channel aux6: starting datafile backup set restore
channel aux6: using network backup set from service indprd
channel aux6: specifying datafile(s) to restore from backup set
channel aux6: restoring datafile 00029 to +DATA01/INDDEV/datafile/apps_ts_tx_data26.dbf
channel aux5: restore complete, elapsed time: 00:03:17
channel aux5: starting datafile backup set restore
channel aux5: using network backup set from service indprd
channel aux5: specifying datafile(s) to restore from backup set
channel aux5: restoring datafile 00030 to +DATA01/INDDEV/datafile/apps_ts_tx_data27.dbf
channel aux5: restore complete, elapsed time: 00:02:04
channel aux5: starting datafile backup set restore
channel aux5: using network backup set from service indprd
channel aux5: specifying datafile(s) to restore from backup set
channel aux5: restoring datafile 00040 to +DATA01/INDDEV/datafile/apps_ts_tx_idx24.dbf
channel aux8: restore complete, elapsed time: 00:02:26
channel aux8: starting datafile backup set restore
channel aux8: using network backup set from service indprd
channel aux8: specifying datafile(s) to restore from backup set
channel aux9: restore complete, elapsed time: 00:05:18
channel aux9: starting datafile backup set restore
channel aux9: using network backup set from service indprd
channel aux9: specifying datafile(s) to restore from backup set
Finished restore at Sep 05 2022 01:45:36
sql statement: alter system archive log current
current log archived
contents of Memory Script:
{
restore clone force from service 'indprd'
archivelog from scn 15918724322267;
switch clone datafile all;
}
executing Memory Script
Starting restore at Sep 05 2022 01:45:39
channel aux1: starting archived log restore to default destination
channel aux1: using network backup set from service indprd
channel aux1: restoring archived log
archived log thread=1 sequence=162408
channel aux2: starting archived log restore to default destination
channel aux2: using network backup set from service indprd
channel aux2: restoring archived log
archived log thread=1 sequence=162409
channel aux3: starting archived log restore to default destination
channel aux3: using network backup set from service indprd
channel aux3: restoring archived log
archived log thread=1 sequence=162410
channel aux4: starting archived log restore to default destination
channel aux4: using network backup set from service indprd
channel aux4: restoring archived log
archived log thread=1 sequence=162411
channel aux4: restore complete, elapsed time: 00:00:01
channel aux3: restore complete, elapsed time: 00:00:08
channel aux1: restore complete, elapsed time: 00:00:27
channel aux2: restore complete, elapsed time: 00:00:26
Finished restore at Sep 05 2022 01:46:08
datafile 1 switched to datafile copy
input datafile copy RECID=291 STAMP=1114566368 file name=+DATA01/INDDEV/datafile/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=292 STAMP=1114566368 file name=+DATA01/INDDEV/datafile/system02.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=293 STAMP=1114566368 file name=+DATA01/INDDEV/datafile/system03.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=294 STAMP=1114566368 file name=+DATA01/INDDEV/datafile/system04.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=295 STAMP=1114566368 file name=+DATA01/INDDEV/datafile/system05.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=296 STAMP=1114566368 file name=+DATA01/INDDEV/datafile/system06.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=297 STAMP=1114566369 file name=+DATA01/INDDEV/datafile/system07.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=298 STAMP=1114566369 file name=+DATA01/INDDEV/datafile/undo01.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=299 STAMP=1114566369 file name=+DATA01/INDDEV/datafile/undo02.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=300 STAMP=1114566369 file name=+DATA01/INDDEV/datafile/undo03.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=301 STAMP=1114566369 file name=+DATA01/INDDEV/datafile/undo04.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=302 STAMP=1114566369 file name=+DATA01/INDDEV/datafile/undo06.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=303 STAMP=1114566369 file name=+DATA01/INDDEV/datafile/undo07.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=304 STAMP=1114566369 file name=+DATA01/INDDEV/datafile/undo05.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=305 STAMP=1114566369 file name=+DATA01/INDDEV/datafile/undo09.dbf
datafile 16 switched to datafile copy
input datafile copy RECID=306 STAMP=1114566369 file name=+DATA01/INDDEV/datafile/undo10.dbf
datafile 17 switched to datafile copy
input datafile copy RECID=307 STAMP=1114566370 file name=+DATA01/INDDEV/datafile/undo08.dbf
datafile 18 switched to datafile copy
input datafile copy RECID=308 STAMP=1114566370 file name=+DATA01/INDDEV/datafile/apps_ts_tx_data21.dbf
datafile 19 switched to datafile copy
input datafile copy RECID=309 STAMP=1114566370 file name=+DATA01/INDDEV/datafile/apps_ts_tx_data22.dbf
datafile 20 switched to datafile copy
input datafile copy RECID=310 STAMP=1114566370 file name=+DATA01/INDDEV/datafile/apps_ts_tx_data23.dbf
datafile 21 switched to datafile copy
input datafile copy RECID=311 STAMP=1114566370 file name=+DATA01/INDDEV/datafile/apps_ts_tx_data24.dbf
datafile 22 switched to datafile copy
input datafile copy RECID=312 STAMP=1114566370 file name=+DATA01/INDDEV/datafile/apps_ts_tx_data25.dbf
datafile 23 switched to datafile copy
input datafile copy RECID=313 STAMP=1114566370 file name=+DATA01/INDDEV/datafile/apps_ts_tx_idx17.dbf
datafile 24 switched to datafile copy
input datafile copy RECID=314 STAMP=1114566370 file name=+DATA01/INDDEV/datafile/apps_ts_tx_idx18.dbf
datafile 25 switched to datafile copy
input datafile copy RECID=315 STAMP=1114566370 file name=+DATA01/INDDEV/datafile/apps_ts_tx_idx19.dbf
datafile 26 switched to datafile copy
input datafile copy RECID=316 STAMP=1114566370 file name=+DATA01/INDDEV/datafile/apps_ts_tx_idx20.dbf
datafile 27 switched to datafile copy
input datafile copy RECID=317 STAMP=1114566371 file name=+DATA01/INDDEV/datafile/apps_ts_tx_idx21.dbf
datafile 28 switched to datafile copy
input datafile copy RECID=318 STAMP=1114566371 file name=+DATA01/INDDEV/datafile/apps_ts_summary02.dbf
datafile 29 switched to datafile copy
input datafile copy RECID=319 STAMP=1114566371 file name=+DATA01/INDDEV/datafile/apps_ts_tx_data26.dbf
datafile 30 switched to datafile copy
contents of Memory Script:
{
set until scn 15918737511670;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at Sep 05 2022 01:47:14
starting media recovery
archived log for thread 1 with sequence 162408 is already on disk as file /oradata/INDDEV/archive/INDDEV/archivelog/2022_09_05/o1_mf_1_162408_kkc385nc_.arc
archived log for thread 1 with sequence 162409 is already on disk as file /oradata/INDDEV/archive/INDDEV/archivelog/2022_09_05/o1_mf_1_162409_kkc3863k_.arc
archived log for thread 1 with sequence 162410 is already on disk as file /oradata/INDDEV/archive/INDDEV/archivelog/2022_09_05/o1_mf_1_162410_kkc386jo_.arc
archived log for thread 1 with sequence 162411 is already on disk as file /oradata/INDDEV/archive/INDDEV/archivelog/2022_09_05/o1_mf_1_162411_kkc386xo_.arc
archived log file name=/oradata/INDDEV/archive/INDDEV/archivelog/2022_09_05/o1_mf_1_162408_kkc385nc_.arc thread=1 sequence=162408
archived log file name=/oradata/INDDEV/archive/INDDEV/archivelog/2022_09_05/o1_mf_1_162409_kkc3863k_.arc thread=1 sequence=162409
archived log file name=/oradata/INDDEV/archive/INDDEV/archivelog/2022_09_05/o1_mf_1_162410_kkc386jo_.arc thread=1 sequence=162410
archived log file name=/oradata/INDDEV/archive/INDDEV/archivelog/2022_09_05/o1_mf_1_162411_kkc386xo_.arc thread=1 sequence=162411
media recovery complete, elapsed time: 00:00:22
Finished recover at Sep 05 2022 01:48:43
Oracle instance started
Total System Global Area 6442450944 bytes
Fixed Size 5298088 bytes
Variable Size 5855250520 bytes
Database Buffers 570425344 bytes
Redo Buffers 11476992 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''INDDEV'' comment=
''Reset to original value by RMAN'' scope=spfile";
sql clone "alter system reset db_unique_name scope=spfile";
}
executing Memory Script
sql statement: alter system set db_name = ''INDDEV'' comment= ''Reset to original value by RMAN'' scope=spfile
sql statement: alter system reset db_unique_name scope=spfile
Oracle instance started
Total System Global Area 6442450944 bytes
Fixed Size 5298088 bytes
Variable Size 5855250520 bytes
Database Buffers 570425344 bytes
Redo Buffers 11476992 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "INDDEV" RESETLOGS ARCHIVELOG
MAXLOGFILES 64
MAXLOGMEMBERS 2
MAXDATAFILES 700
MAXINSTANCES 1
MAXLOGHISTORY 16336
LOGFILE
GROUP 1 ( '+REC01/INDDEV/onlinelog/log01b.dbf', '+REC01/INDDEV/onlinelog/log01a.dbf' ) SIZE 2 G REUSE,
GROUP 2 ( '+REC01/INDDEV/onlinelog/log02a.dbf', '+REC01/INDDEV/onlinelog/log02b.dbf' ) SIZE 2 G REUSE,
GROUP 3 ( '+REC01/INDDEV/onlinelog/log03a.dbf', '+REC01/INDDEV/onlinelog/log03b.dbf' ) SIZE 2 G REUSE,
GROUP 4 ( '+REC01/INDDEV/onlinelog/log04a.dbf', '+REC01/INDDEV/onlinelog/log04b.dbf' ) SIZE 2 G REUSE,
GROUP 5 ( '+REC01/INDDEV/onlinelog/log05b.dbf', '+REC01/INDDEV/onlinelog/log05a.dbf' ) SIZE 2 G REUSE,
GROUP 6 ( '+REC01/INDDEV/onlinelog/log06b.dbf', '+REC01/INDDEV/onlinelog/log06a.dbf' ) SIZE 2 G REUSE
DATAFILE
'+DATA01/INDDEV/datafile/system01.dbf'
CHARACTER SET WE8ISO8859P1
contents of Memory Script:
{
set newname for tempfile 1 to
"+DATA01/INDDEV/datafile/temp01.dbf";
set newname for tempfile 2 to
"+DATA01/INDDEV/datafile/temp02.dbf";
set newname for tempfile 3 to
"+DATA01/INDDEV/datafile/temp03.dbf";
set newname for tempfile 4 to
"+DATA01/INDDEV/datafile/temp04.dbf";
set newname for tempfile 5 to
"+DATA01/INDDEV/datafile/temp05.dbf";
set newname for tempfile 6 to
"+DATA01/INDDEV/datafile/temp06.dbf";
set newname for tempfile 7 to
"+DATA01/INDDEV/datafile/temp07.dbf";
set newname for tempfile 8 to
"+DATA01/INDDEV/datafile/temp08.dbf";
set newname for tempfile 9 to
"+DATA01/INDDEV/datafile/temp09.dbf";
set newname for tempfile 10 to
"+DATA01/INDDEV/datafile/temp10.dbf";
set newname for tempfile 11 to
"+DATA01/INDDEV/datafile/temp11.dbf";
set newname for tempfile 12 to
"+DATA01/INDDEV/datafile/temp12.dbf";
set newname for tempfile 13 to
"+DATA01/INDDEV/datafile/temp13.dbf";
set newname for tempfile 14 to
"+DATA01/INDDEV/datafile/temp14.dbf";
set newname for tempfile 15 to
"+DATA01/INDDEV/datafile/temp15.dbf";
set newname for tempfile 16 to
"+DATA01/INDDEV/datafile/temp16.dbf";
set newname for tempfile 17 to
"+DATA01/INDDEV/datafile/temp17.dbf";
set newname for tempfile 18 to
"+DATA01/INDDEV/datafile/temp18.dbf";
set newname for tempfile 19 to
"+DATA01/INDDEV/datafile/temp19.dbf";
set newname for tempfile 20 to
"+DATA01/INDDEV/datafile/temp20.dbf";
set newname for tempfile 21 to
"+DATA01/INDDEV/datafile/temp21.dbf";
set newname for tempfile 22 to
"+DATA01/INDDEV/datafile/temp22.dbf";
set newname for tempfile 23 to
"+DATA01/INDDEV/datafile/temp23.dbf";
set newname for tempfile 24 to
"+DATA01/INDDEV/datafile/temp24.dbf";
set newname for tempfile 25 to
"+DATA01/INDDEV/datafile/temp25.dbf";
set newname for tempfile 26 to
"+DATA01/INDDEV/datafile/temp27.dbf";
set newname for tempfile 27 to
"+DATA01/INDDEV/datafile/temp28.dbf";
set newname for tempfile 28 to
"+DATA01/INDDEV/datafile/temp30.dbf";
set newname for tempfile 29 to
"+DATA01/INDDEV/datafile/temp31.dbf";
set newname for tempfile 30 to
switch clone tempfile all;
catalog clone datafilecopy "+DATA01/INDDEV/datafile/system02.dbf",
"+DATA01/INDDEV/datafile/system03.dbf",
"+DATA01/INDDEV/datafile/system04.dbf",
"+DATA01/INDDEV/datafile/system05.dbf",
"+DATA01/INDDEV/datafile/system06.dbf",
"+DATA01/INDDEV/datafile/system07.dbf",
"+DATA01/INDDEV/datafile/undo01.dbf",
"+DATA01/INDDEV/datafile/undo02.dbf",
"+DATA01/INDDEV/datafile/undo03.dbf",
"+DATA01/INDDEV/datafile/undo04.dbf",
"+DATA01/INDDEV/datafile/undo06.dbf",
"+DATA01/INDDEV/datafile/undo07.dbf",
"+DATA01/INDDEV/datafile/undo05.dbf",
"+DATA01/INDDEV/datafile/undo09.dbf",
"+DATA01/INDDEV/datafile/undo10.dbf",
"+DATA01/INDDEV/datafile/undo08.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data21.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data22.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data23.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data24.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data25.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_idx17.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_idx18.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_idx19.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_idx20.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_idx21.dbf",
"+DATA01/INDDEV/datafile/apps_ts_summary02.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data26.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data27.dbf",
"+DATA01/INDDEV/datafile/amsrd01.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data28.dbf",
"+DATA01/INDDEV/datafile/apps_ts_media05.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data29.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data30.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data31.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data32.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_idx22.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_idx23.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_idx24.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data33.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data34.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_idx125.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_idx26.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_idx27.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_idx28.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_idx29.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_idx30.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data35.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data36.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data37.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data38.dbf",
"+DATA01/INDDEV/datafile/apps_ts_media06.dbf",
"+DATA01/INDDEV/datafile/sabrix_data.dbf",
"+DATA01/INDDEV/datafile/sabrix_idx.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_idx31.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data39.dbf",
"+DATA01/INDDEV/datafile/apps_ts_media07.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_idx32.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data40.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data41.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_idx33.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_idx34.dbf",
"+DATA01/INDDEV/datafile/apps_ts_media08.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data42.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_idx35.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data51.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_idx36.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_idx37.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data43.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data44.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data45.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data46.dbf",
"+DATA01/INDDEV/datafile/atcd08.dbf",
"+DATA01/INDDEV/datafile/apps_ts_media09.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_idx42.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data47.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data48.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data49.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data50.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data52.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_idx38.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_idx39.dbf",
"+DATA01/INDDEV/datafile/atcd09.dbf",
"+DATA01/INDDEV/datafile/apps_ts_media10.dbf",
"+DATA01/INDDEV/datafile/apps_ts_interface02.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_idx40.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data53.dbf",
"+DATA01/INDDEV/datafile/ctxd02.dbf",
"+DATA01/INDDEV/datafile/customapps.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data55.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data56.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_idx41.dbf",
"+DATA01/INDDEV/datafile/apps_ts_media11.dbf",
"+DATA01/INDDEV/datafile/apps_ts_seed02.dbf",
"+DATA01/INDDEV/datafile/apps_ts_tx_data57.dbf",
"+DATA01/INDDEV/datafile/atcd03.dbf",
"+DATA01/INDDEV/datafile/atcd07.dbf",
"+DATA01/INDDEV/datafile/atcd02.dbf",
"+DATA01/INDDEV/datafile/atcd04.dbf",
"+DATA01/INDDEV/datafile/atcd01.dbf",
"+DATA01/INDDEV/datafile/atcd05.dbf",
"+DATA01/INDDEV/datafile/atcd06.dbf",
"+DATA01/INDDEV/datafile/atcx02.dbf",
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
renamed tempfile 1 to +DATA01/INDDEV/datafile/temp01.dbf in control file
renamed tempfile 2 to +DATA01/INDDEV/datafile/temp02.dbf in control file
renamed tempfile 3 to +DATA01/INDDEV/datafile/temp03.dbf in control file
renamed tempfile 4 to +DATA01/INDDEV/datafile/temp04.dbf in control file
renamed tempfile 5 to +DATA01/INDDEV/datafile/temp05.dbf in control file
renamed tempfile 6 to +DATA01/INDDEV/datafile/temp06.dbf in control file
renamed tempfile 7 to +DATA01/INDDEV/datafile/temp07.dbf in control file
renamed tempfile 8 to +DATA01/INDDEV/datafile/temp08.dbf in control file
renamed tempfile 9 to +DATA01/INDDEV/datafile/temp09.dbf in control file
renamed tempfile 10 to +DATA01/INDDEV/datafile/temp10.dbf in control file
renamed tempfile 11 to +DATA01/INDDEV/datafile/temp11.dbf in control file
renamed tempfile 12 to +DATA01/INDDEV/datafile/temp12.dbf in control file
renamed tempfile 13 to +DATA01/INDDEV/datafile/temp13.dbf in control file
renamed tempfile 14 to +DATA01/INDDEV/datafile/temp14.dbf in control file
renamed tempfile 15 to +DATA01/INDDEV/datafile/temp15.dbf in control file
renamed tempfile 16 to +DATA01/INDDEV/datafile/temp16.dbf in control file
renamed tempfile 17 to +DATA01/INDDEV/datafile/temp17.dbf in control file
renamed tempfile 18 to +DATA01/INDDEV/datafile/temp18.dbf in control file
renamed tempfile 19 to +DATA01/INDDEV/datafile/temp19.dbf in control file
renamed tempfile 20 to +DATA01/INDDEV/datafile/temp20.dbf in control file
renamed tempfile 21 to +DATA01/INDDEV/datafile/temp21.dbf in control file
renamed tempfile 22 to +DATA01/INDDEV/datafile/temp22.dbf in control file
renamed tempfile 23 to +DATA01/INDDEV/datafile/temp23.dbf in control file
renamed tempfile 24 to +DATA01/INDDEV/datafile/temp24.dbf in control file
renamed tempfile 25 to +DATA01/INDDEV/datafile/temp25.dbf in control file
renamed tempfile 26 to +DATA01/INDDEV/datafile/temp27.dbf in control file
renamed tempfile 27 to +DATA01/INDDEV/datafile/temp28.dbf in control file
renamed tempfile 28 to +DATA01/INDDEV/datafile/temp30.dbf in control file
renamed tempfile 29 to +DATA01/INDDEV/datafile/temp31.dbf in control file
renamed tempfile 30 to +DATA01/INDDEV/datafile/temp32.dbf in control file
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/system02.dbf RECID=1 STAMP=1114566581
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/system03.dbf RECID=2 STAMP=1114566581
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/system04.dbf RECID=3 STAMP=1114566581
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/system05.dbf RECID=4 STAMP=1114566581
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/system06.dbf RECID=5 STAMP=1114566581
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/system07.dbf RECID=6 STAMP=1114566582
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/undo01.dbf RECID=7 STAMP=1114566582
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/undo02.dbf RECID=8 STAMP=1114566582
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/undo03.dbf RECID=9 STAMP=1114566582
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/undo04.dbf RECID=10 STAMP=1114566582
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/undo06.dbf RECID=11 STAMP=1114566582
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/undo07.dbf RECID=12 STAMP=1114566582
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/undo05.dbf RECID=13 STAMP=1114566582
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/undo09.dbf RECID=14 STAMP=1114566582
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/undo10.dbf RECID=15 STAMP=1114566582
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/undo08.dbf RECID=16 STAMP=1114566582
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/apps_ts_tx_data21.dbf RECID=17 STAMP=1114566582
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/apps_ts_tx_data22.dbf RECID=18 STAMP=1114566582
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/apps_ts_tx_data23.dbf RECID=19 STAMP=1114566582
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/apps_ts_tx_data24.dbf RECID=20 STAMP=1114566583
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/apps_ts_tx_data25.dbf RECID=21 STAMP=1114566583
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/apps_ts_tx_idx17.dbf RECID=22 STAMP=1114566583
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/apps_ts_tx_idx18.dbf RECID=23 STAMP=1114566583
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/apps_ts_tx_idx19.dbf RECID=24 STAMP=1114566583
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/apps_ts_tx_idx20.dbf RECID=25 STAMP=1114566583
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/apps_ts_tx_idx21.dbf RECID=26 STAMP=1114566583
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/apps_ts_summary02.dbf RECID=27 STAMP=1114566583
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/apps_ts_tx_data26.dbf RECID=28 STAMP=1114566583
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/apps_ts_tx_data27.dbf RECID=29 STAMP=1114566583
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/amsrd01.dbf RECID=30 STAMP=1114566583
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/apps_ts_tx_data28.dbf RECID=31 STAMP=1114566583
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/apps_ts_media05.dbf RECID=32 STAMP=1114566583
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/apps_ts_tx_data29.dbf RECID=33 STAMP=1114566583
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/apps_ts_tx_data30.dbf RECID=34 STAMP=1114566583
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/apps_ts_tx_data31.dbf RECID=35 STAMP=1114566584
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/apps_ts_tx_data32.dbf RECID=36 STAMP=1114566584
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/apps_ts_tx_idx22.dbf RECID=37 STAMP=1114566584
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/apps_ts_tx_idx23.dbf RECID=38 STAMP=1114566584
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/apps_ts_tx_idx24.dbf RECID=39 STAMP=1114566584
cataloged datafile copy
datafile copy file name=+DATA01/INDDEV/datafile/apps_ts_tx_data33.dbf RECID=40 STAMP=1114566584
Reenabling controlfile options for auxiliary database
Executing: alter database add supplemental log data
Executing: alter database force logging
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Cannot remove created server parameter file
Finished Duplicate Db at Sep 05 2022 01:51:18
released channel: ch1
released channel: ch2
released channel: ch3
released channel: ch4
released channel: ch5
released channel: ch6
released channel: ch7
released channel: ch8
Step 10: – Verify the status of TARGET database status,
After completion of restore and recovery, here we have verified as below.
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
—— — ——–
INDDEV READ WRITERelated/References: –