{"id":14721,"date":"2020-09-18T16:30:32","date_gmt":"2020-09-18T14:30:32","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/duplicate-database-on-oda-x4\/"},"modified":"2023-06-15T16:35:35","modified_gmt":"2023-06-15T14:35:35","slug":"duplicate-database-on-oda-x4","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/duplicate-database-on-oda-x4\/","title":{"rendered":"Duplicate Database on ODA X4"},"content":{"rendered":"

By Mouhamadou Diaw<\/strong><\/p>\n

The ODA X4 is still in use for some customers. The last time I was asked to validate the backups . Let me explain the context. Actually the backups are done via RMAN on local in a NFS share. After these backups are backep up by Netback on tape.
\nThe goal was just to validate that the backups done by Netback can be used to restore if needed.<\/p>\n

So the backup teams restored the backups of one database in a directory and then we duplicate this database using these backups.<\/p>\n

The source database is SRCDB
\nThe target database will be named TESTQ
\nThe backup from tape are copied in \/shareback\/backup\/test_restauration
\nBelow the the server characteristics<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n<\/td>\n
\n
\n
[root@ ~]<\/code># oakcli show server<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Power State\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : On<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Open Problems\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : 0<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Model\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : ODA X4-2<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Type\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Rack Mount<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Part Number\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : 32974004+1+1<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Serial Number\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : 1435NMP00A<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Primary OS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Not Available<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>ILOM Address\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : 10.120.128.111<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>ILOM MAC Address\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : 00:10:E0:5F:4D:2E<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Description\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Oracle Database Appliance X4-2 1435NMP00A<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Locator Light\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Off<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Actual Power Consumption : 234 watts<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Ambient Temperature\u00a0\u00a0\u00a0\u00a0\u00a0 : 23.000 degree C<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Open Problems Report\u00a0\u00a0\u00a0\u00a0 : System is healthy<\/code><\/div>\n
<\/div>\n
[root@ ~]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

On the source the datafiles are stored here<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
\/u02\/app\/oracle\/oradata\/datastore\/<\/code>.ACFS<\/code>\/snaps\/SRCDB\/SRCDB\/<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

As for every duplicate we have to prepare the directories for the target database. But there is a problem with the ODA as I connot create any directory under the snaps directory<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n<\/td>\n
\n
\n
oracle@:<\/code>\/u02\/app\/oracle\/oradata\/datastore\/<\/code>.ACFS<\/code>\/snaps\/<\/code> [TESTQ] <\/code>mkdir<\/code> TESTQ<\/code><\/div>\n
mkdir<\/code>: cannot create directory `TT': Permission denied<\/code><\/div>\n
oracle@:<\/code>\/u02\/app\/oracle\/oradata\/datastore\/<\/code>.ACFS<\/code>\/snaps\/<\/code> [TESTQ]<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

As I cannot manually create any directory, I have two solutions
\n1-Create an empty database named TESTQ with oakcli create database and then remove the datafiles after
\n2-Create the storage for the future database TESTQ using oakcli create dbstorage.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n<\/td>\n
\n
\n
[root@srvodap01n1test_restauration]<\/code># oakcli create dbstorage -h<\/code><\/div>\n
Usage:<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>oakcli create dbstorage -db\u00a0 [-cdb]<\/code><\/div>\n
<\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>where:<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>db_name\u00a0\u00a0\u00a0\u00a0\u00a0 -\u00a0 Setup the required ACFS storage structure <\/code>for<\/code> the database <\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>cdb\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 -\u00a0 This needs to be passed <\/code>in<\/code> case<\/code> of cdb database<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>This storage structure can be used <\/code>for<\/code> migrating databases from ASM to ACFS e.t.c<\/code><\/div>\n
<\/div>\n
[root@srvodap01n1test_restauration]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

As we can see create dbstorage will create all required directories for the new database. So we use the 2nd methode. We were using an X4 ODA and the command create storage has to be launched from the first node<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n<\/td>\n
\n
\n
[root@srvodap01n0 snaps]<\/code># oakcli create dbstorage -db TESTQ<\/code><\/div>\n
INFO: 2020-09-17 13:49:47: Please check the logfile\u00a0 <\/code>'\/opt\/oracle\/oak\/log\/srvodap01n0\/tools\/12.1.2.12.0\/createdbstorage_TESTQ_1793.log'<\/code> for<\/code> more<\/code> details<\/code><\/div>\n
<\/div>\n
Please enter the <\/code>'SYSASM'<\/code>\u00a0 password : (During deployment we <\/code>set<\/code> the SYSASM password to <\/code>'welcome1'<\/code>):<\/code><\/div>\n
Please re-enter the <\/code>'SYSASM'<\/code> password:<\/code><\/div>\n
Please <\/code>select<\/code> one of the following <\/code>for<\/code> Database Class\u00a0 [1 .. 3] :<\/code><\/div>\n
1\u00a0\u00a0\u00a0 => odb-01s\u00a0 (\u00a0\u00a0 1 cores ,\u00a0\u00a0\u00a0\u00a0 4 GB memory)<\/code><\/div>\n
2\u00a0\u00a0\u00a0 =>\u00a0 odb-01\u00a0 (\u00a0\u00a0 1 cores ,\u00a0\u00a0\u00a0\u00a0 8 GB memory)<\/code><\/div>\n
3\u00a0\u00a0\u00a0 =>\u00a0 odb-02\u00a0 (\u00a0\u00a0 2 cores ,\u00a0\u00a0\u00a0 16 GB memory)<\/code><\/div>\n
1<\/code><\/div>\n
The selected value is : odb-01s\u00a0 (\u00a0\u00a0 1 cores ,\u00a0\u00a0\u00a0\u00a0 4 GB memory)<\/code><\/div>\n
...SUCCESS: Ran <\/code>\/usr\/bin\/rsync<\/code> -tarqvz <\/code>\/opt\/oracle\/oak\/onecmd\/<\/code> root@192.168.16.28:<\/code>\/opt\/oracle\/oak\/onecmd<\/code> --exclude=*zip --exclude=*gz --exclude=*log --exclude=*trc --exclude=*rpm and it returned: RC=0<\/code><\/div>\n
<\/div>\n
.........<\/code><\/div>\n
SUCCESS: All nodes <\/code>in<\/code> \/opt\/oracle\/oak\/onecmd\/tmp\/db_nodes<\/code> are pingable and alive.<\/code><\/div>\n
INFO: 2020-09-17 13:53:44: Successfully setup the storage structure <\/code>for<\/code> the database <\/code>'TESTQ'<\/code><\/div>\n
INFO: 2020-09-17 13:53:45: Set the following directory structure <\/code>for<\/code> the Database TESTQ<\/code><\/div>\n
INFO: 2020-09-17 13:53:45: DATA: <\/code>\/u02\/app\/oracle\/oradata\/datastore\/<\/code>.ACFS<\/code>\/snaps\/TESTQ<\/code><\/div>\n
INFO: 2020-09-17 13:53:45: REDO: <\/code>\/u01\/app\/oracle\/oradata\/datastore\/TESTQ<\/code><\/div>\n
INFO: 2020-09-17 13:53:45: RECO: <\/code>\/u01\/app\/oracle\/fast_recovery_area\/datastore\/TESTQ<\/code><\/div>\n
SUCCESS: 2020-09-17 13:53:45: Successfully setup the Storage <\/code>for<\/code> the Database : TESTQ<\/code><\/div>\n
[root@srvodap01n0 snaps]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Once the storage created we start the new instance TESTQ on nomount state with a minimum of configuration parameters<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n
40<\/div>\n
41<\/div>\n
42<\/div>\n
43<\/div>\n
44<\/div>\n
45<\/div>\n
46<\/div>\n
47<\/div>\n
48<\/div>\n<\/td>\n
\n
\n
oracle@srvodap01n1:<\/code>\/u01\/app\/oracle\/local\/dmk\/etc\/<\/code> [TESTQ] sqh<\/code><\/div>\n
<\/div>\n
SQL*Plus: Release 12.1.0.2.0 Production on Thu Sep 17 14:11:43 2020<\/code><\/div>\n
<\/div>\n
Copyright (c) 1982, 2014, Oracle.\u00a0 All rights reserved.<\/code><\/div>\n
<\/div>\n
Connected to an idle instance.<\/code><\/div>\n
<\/div>\n
SQL> startup nomount pfile=<\/code>'\/u02\/app\/oracle\/oradata\/datastore\/.ACFS\/snaps\/TESTQ\/TESTQ\/initTESTQ.ora'<\/code><\/div>\n
ORACLE instance started.<\/code><\/div>\n
<\/div>\n
Total System Global Area 4294967296 bytes<\/code><\/div>\n
Fixed Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2932632 bytes<\/code><\/div>\n
Variable Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 889192552 bytes<\/code><\/div>\n
Database Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3372220416 bytes<\/code><\/div>\n
Redo Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 30621696 bytes<\/code><\/div>\n
SQL> show parameter db_uni<\/code><\/div>\n
<\/div>\n
NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE<\/code><\/div>\n
------------------------------------ ----------- ------------------------------<\/code><\/div>\n
db_unique_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 TESTQ<\/code><\/div>\n
SQL> show parameter db_name<\/code><\/div>\n
<\/div>\n
NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE<\/code><\/div>\n
------------------------------------ ----------- ------------------------------<\/code><\/div>\n
db_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 TESTQ<\/code><\/div>\n
SQL> show parameter control_files<\/code><\/div>\n
<\/div>\n
NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE<\/code><\/div>\n
------------------------------------ ----------- ------------------------------<\/code><\/div>\n
control_files\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>\/u01\/app\/oracle\/product\/12<\/code>.1.0<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>.2<\/code>\/dbhome_2\/dbs\/cntrlTESTQ<\/code>.dbf<\/code><\/div>\n
SQL><\/code><\/div>\n
<\/div>\n
SQL> show parameter db_cre<\/code><\/div>\n
<\/div>\n
NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE<\/code><\/div>\n
------------------------------------ ----------- ------------------------------<\/code><\/div>\n
db_create_file_dest\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>\/u02\/app\/oracle\/oradata\/datast<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>ore\/.ACFS<\/code>\/snaps\/TESTQ<\/code><\/div>\n
db_create_online_log_dest_1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>\/u01\/app\/oracle\/oradata\/datast<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>ore<\/code>\/TESTQ<\/code><\/div>\n
db_create_online_log_dest_2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>\/u01\/app\/oracle\/oradata\/datast<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>ore<\/code>\/TESTQ<\/code><\/div>\n
db_create_online_log_dest_3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string<\/code><\/div>\n
db_create_online_log_dest_4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string<\/code><\/div>\n
db_create_online_log_dest_5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string<\/code><\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Once the instance started, we can now lunch the duplicate command. Juste note that the output was truncated<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n
40<\/div>\n
41<\/div>\n
42<\/div>\n
43<\/div>\n
44<\/div>\n
45<\/div>\n
46<\/div>\n
47<\/div>\n
48<\/div>\n
49<\/div>\n
50<\/div>\n
51<\/div>\n
52<\/div>\n
53<\/div>\n
54<\/div>\n
55<\/div>\n
56<\/div>\n
57<\/div>\n
58<\/div>\n
59<\/div>\n
60<\/div>\n
61<\/div>\n
62<\/div>\n
63<\/div>\n
64<\/div>\n
65<\/div>\n
66<\/div>\n
67<\/div>\n
68<\/div>\n
69<\/div>\n
70<\/div>\n
71<\/div>\n
72<\/div>\n
73<\/div>\n
74<\/div>\n
75<\/div>\n
76<\/div>\n
77<\/div>\n
78<\/div>\n
79<\/div>\n
80<\/div>\n
81<\/div>\n
82<\/div>\n
83<\/div>\n
84<\/div>\n
85<\/div>\n
86<\/div>\n
87<\/div>\n
88<\/div>\n
89<\/div>\n
90<\/div>\n
91<\/div>\n
92<\/div>\n
93<\/div>\n
94<\/div>\n
95<\/div>\n
96<\/div>\n
97<\/div>\n
98<\/div>\n
99<\/div>\n
100<\/div>\n
101<\/div>\n
102<\/div>\n
103<\/div>\n
104<\/div>\n
105<\/div>\n
106<\/div>\n
107<\/div>\n
108<\/div>\n
109<\/div>\n
110<\/div>\n
111<\/div>\n
112<\/div>\n
113<\/div>\n
114<\/div>\n
115<\/div>\n
116<\/div>\n
117<\/div>\n
118<\/div>\n
119<\/div>\n
120<\/div>\n
121<\/div>\n
122<\/div>\n<\/td>\n
\n
\n
Recovery Manager: Release 12.1.0.2.0 - Production on Thu Sep 17 14:18:17 2020<\/code><\/div>\n
<\/div>\n
Copyright (c) 1982, 2014, Oracle and<\/code>\/or<\/code> its affiliates.\u00a0 All rights reserved.<\/code><\/div>\n
<\/div>\n
RMAN> connect auxiliary \/<\/code><\/div>\n
<\/div>\n
connected to auxiliary database: TESTQ (not mounted)<\/code><\/div>\n
<\/div>\n
run<\/code><\/div>\n
{<\/code><\/div>\n
ALLOCATE AUXILIARY CHANNEL c1 DEVICE TYPE DISK;<\/code><\/div>\n
ALLOCATE AUXILIARY CHANNEL c2 DEVICE TYPE DISK;<\/code><\/div>\n
DUPLICATE DATABASE TO TESTQ BACKUP LOCATION <\/code>'\/shareback\/backup\/test_restauration'<\/code>;<\/code><\/div>\n
release channel c2;<\/code><\/div>\n
release channel c2;<\/code><\/div>\n
8> }<\/code><\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
allocated channel: c1<\/code><\/div>\n
channel c1: SID=17 device <\/code>type<\/code>=DISK<\/code><\/div>\n
<\/div>\n
allocated channel: c2<\/code><\/div>\n
channel c2: SID=177 device <\/code>type<\/code>=DISK<\/code><\/div>\n
<\/div>\n
Starting Duplicate Db at 17-SEP-2020 14:18:46<\/code><\/div>\n
<\/div>\n
contents of Memory Script:<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>sql clone <\/code>\"create spfile from memory\"<\/code>;<\/code><\/div>\n
}<\/code><\/div>\n
executing Memory Script<\/code><\/div>\n
<\/div>\n
sql statement: create spfile from memory<\/code><\/div>\n
<\/div>\n
contents of Memory Script:<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>shutdown<\/code> clone immediate;<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>startup clone nomount;<\/code><\/div>\n
}<\/code><\/div>\n
executing Memory Script<\/code><\/div>\n
<\/div>\n
Oracle instance shut down<\/code><\/div>\n
<\/div>\n
connected to auxiliary database (not started)<\/code><\/div>\n
Oracle instance started<\/code><\/div>\n
<\/div>\n
Total System Global Area\u00a0\u00a0\u00a0 4294967296 bytes<\/code><\/div>\n
<\/div>\n
Fixed Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2932632 bytes<\/code><\/div>\n
Variable Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 889192552 bytes<\/code><\/div>\n
Database Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3372220416 bytes<\/code><\/div>\n
Redo Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 30621696 bytes<\/code><\/div>\n
allocated channel: c1<\/code><\/div>\n
channel c1: SID=16 device <\/code>type<\/code>=DISK<\/code><\/div>\n
allocated channel: c2<\/code><\/div>\n
channel c2: SID=177 device <\/code>type<\/code>=DISK<\/code><\/div>\n
<\/div>\n
contents of Memory Script:<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>sql clone \"alter system <\/code>set<\/code>\u00a0 control_files =<\/code><\/div>\n
\u00a0\u00a0<\/code>''<\/code>\/u01\/app\/oracle\/oradata\/datastore\/TESTQ\/TESTQ\/controlfile\/o1_mf_hp6o2sb2_<\/code>.ctl<\/code>''<\/code>, <\/code>''<\/code>\/u01\/app\/oracle\/oradata\/datastore\/TESTQ\/TESTQ\/controlfile\/o1_mf_hp6o2sbm_<\/code>.ctl<\/code>''<\/code> comment=<\/code><\/div>\n
\u00a0<\/code>''<\/code>Set by RMAN<\/code>''<\/code> scope=spfile\";<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>sql clone \"alter system <\/code>set<\/code>\u00a0 db_name =<\/code><\/div>\n
\u00a0<\/code>''<\/code>SRCDB<\/code>''<\/code> comment=<\/code><\/div>\n
\u00a0<\/code>''<\/code>Modified by RMAN duplicate<\/code>''<\/code> scope=spfile\";<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>sql clone \"alter system <\/code>set<\/code>\u00a0 db_unique_name =<\/code><\/div>\n
\u00a0<\/code>''<\/code>TESTQ<\/code>''<\/code> comment=<\/code><\/div>\n
\u00a0<\/code>''<\/code>Modified by RMAN duplicate<\/code>''<\/code> scope=spfile\";<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>shutdown<\/code> clone immediate;<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>startup clone force nomount<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>restore clone primary controlfile from\u00a0 <\/code>'\/shareback\/test_restauration\/20200916_214502_c-2736611334-20200916-04'<\/code>;<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>alter clone database <\/code>mount<\/code>;<\/code><\/div>\n
}<\/code><\/div>\n
executing Memory Script<\/code><\/div>\n
<\/div>\n
sql statement: alter system <\/code>set<\/code>\u00a0 control_files =\u00a0\u00a0 <\/code>''<\/code>\/u01\/app\/oracle\/oradata\/datastore\/TESTQ\/TESTQ\/controlfile\/o1_mf_hp6o2sb2_<\/code>.ctl<\/code>''<\/code>, <\/code>''<\/code>\/u01\/app\/oracle\/oradata\/datastore\/TESTQ\/TESTQ\/controlfile\/o1_mf_hp6o2sbm_<\/code>.ctl<\/code>''<\/code> comment= <\/code>''<\/code>Set by RMAN<\/code>''<\/code> scope=spfile<\/code><\/div>\n
<\/div>\n
sql statement: alter system <\/code>set<\/code>\u00a0 db_name =\u00a0 <\/code>''<\/code>SRCDB<\/code>''<\/code> comment= <\/code>''<\/code>Modified by RMAN duplicate<\/code>''<\/code> scope=spfile<\/code><\/div>\n
<\/div>\n
sql statement: alter system <\/code>set<\/code>\u00a0 db_unique_name =\u00a0 <\/code>''<\/code>TESTQ<\/code>''<\/code> comment= <\/code>''<\/code>Modified by RMAN duplicate<\/code>''<\/code> scope=spfile<\/code><\/div>\n
<\/div>\n
Oracle instance shut down<\/code><\/div>\n
<\/div>\n
<\/div>\n
Oracle instance started<\/code><\/div>\n
<\/div>\n
Total System Global Area\u00a0\u00a0\u00a0 4294967296 bytes<\/code><\/div>\n
<\/div>\n
Fixed Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2932632 bytes<\/code><\/div>\n
Variable Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 889192552 bytes<\/code><\/div>\n
Database Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3372220416 bytes<\/code><\/div>\n
Redo Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 30621696 bytes<\/code><\/div>\n
allocated channel: c1<\/code><\/div>\n
channel c1: SID=16 device <\/code>type<\/code>=DISK<\/code><\/div>\n
allocated channel: c2<\/code><\/div>\n
channel c2: SID=177 device <\/code>type<\/code>=DISK<\/code><\/div>\n
<\/div>\n
Starting restore at 17-SEP-2020 14:20:21<\/code><\/div>\n
<\/div>\n
channel c2: skipped, AUTOBACKUP already found<\/code><\/div>\n
channel c1: restoring control <\/code>file<\/code><\/div>\n
channel c1: restore complete, elapsed <\/code>time<\/code>: 00:00:11<\/code><\/div>\n
output <\/code>file<\/code> name=<\/code>\/u01\/app\/oracle\/oradata\/datastore\/TESTQ\/TESTQ\/controlfile\/o1_mf_hp6o2sb2_<\/code>.ctl<\/code><\/div>\n
output <\/code>file<\/code> name=<\/code>\/u01\/app\/oracle\/oradata\/datastore\/TESTQ\/TESTQ\/controlfile\/o1_mf_hp6o2sbm_<\/code>.ctl<\/code><\/div>\n
Finished restore at 17-SEP-2020 14:20:32<\/code><\/div>\n
<\/div>\n
<\/div>\n
...<\/code><\/div>\n
....<\/code><\/div>\n
Executing: alter database force logging<\/code><\/div>\n
<\/div>\n
contents of Memory Script:<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>Alter clone database <\/code>open<\/code> resetlogs;<\/code><\/div>\n
}<\/code><\/div>\n
executing Memory Script<\/code><\/div>\n
<\/div>\n
database opened<\/code><\/div>\n
Executing: alter database flashback on<\/code><\/div>\n
Cannot remove created server parameter <\/code>file<\/code><\/div>\n
Finished Duplicate Db at 17-SEP-2020 14:38:31<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

The duplicate was successful<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n<\/td>\n
\n
\n
oracle@srvodap01n1:<\/code>\/u01\/app\/oracle\/local\/dmk\/etc\/<\/code> [TESTQ] TESTQ<\/code><\/div>\n
********* dbi services Ltd. *********<\/code><\/div>\n
STATUS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : OPEN<\/code><\/div>\n
DB_UNIQUE_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : TESTQ<\/code><\/div>\n
OPEN_MODE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : READ WRITE<\/code><\/div>\n
LOG_MODE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : ARCHIVELOG<\/code><\/div>\n
DATABASE_ROLE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : PRIMARY<\/code><\/div>\n
FLASHBACK_ON\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : YES<\/code><\/div>\n
FORCE_LOGGING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : YES<\/code><\/div>\n
VERSION\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : 12.1.0.2.0<\/code><\/div>\n
CDB Enabled\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : NO<\/code><\/div>\n
*************************************<\/code><\/div>\n
oracle@srvodap01n1:<\/code>\/u01\/app\/oracle\/local\/dmk\/etc\/<\/code> [TESTQ]<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Hope that will help<\/p>\n","protected":false},"excerpt":{"rendered":"

By Mouhamadou Diaw The ODA X4 is still in use for some customers. The last time I was asked to validate the backups . Let me explain the context. Actually the backups are done via RMAN on local in a NFS share. After these backups are backep up by Netback on tape. The goal was […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,42,59],"tags":[2113,2114,79,2115,2116,209],"type_dbi":[],"class_list":["post-14721","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-database-management","category-operating-systems","category-oracle","tag-create-dbstorage","tag-duplicate-oda","tag-oda","tag-oda-ha","tag-oda-x4","tag-oracle-12c"],"acf":[],"yoast_head":"\nDuplicate Database on ODA X4 - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/duplicate-database-on-oda-x4\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Duplicate Database on ODA X4\" \/>\n<meta property=\"og:description\" content=\"By Mouhamadou Diaw The ODA X4 is still in use for some customers. The last time I was asked to validate the backups . Let me explain the context. Actually the backups are done via RMAN on local in a NFS share. After these backups are backep up by Netback on tape. The goal was […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/duplicate-database-on-oda-x4\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-18T14:30:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-15T14:35:35+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/duplicate-database-on-oda-x4\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/duplicate-database-on-oda-x4\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Duplicate Database on ODA X4\",\"datePublished\":\"2020-09-18T14:30:32+00:00\",\"dateModified\":\"2023-06-15T14:35:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/duplicate-database-on-oda-x4\/\"},\"wordCount\":289,\"commentCount\":0,\"keywords\":[\"create dbstorage\",\"Duplicate ODA\",\"ODA\",\"ODA HA\",\"ODA X4\",\"Oracle 12c\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Database management\",\"Operating systems\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/duplicate-database-on-oda-x4\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/duplicate-database-on-oda-x4\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/duplicate-database-on-oda-x4\/\",\"name\":\"Duplicate Database on ODA X4 - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2020-09-18T14:30:32+00:00\",\"dateModified\":\"2023-06-15T14:35:35+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/duplicate-database-on-oda-x4\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/duplicate-database-on-oda-x4\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/duplicate-database-on-oda-x4\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Duplicate Database on ODA X4\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Duplicate Database on ODA X4 - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/duplicate-database-on-oda-x4\/","og_locale":"en_US","og_type":"article","og_title":"Duplicate Database on ODA X4","og_description":"By Mouhamadou Diaw The ODA X4 is still in use for some customers. The last time I was asked to validate the backups . Let me explain the context. Actually the backups are done via RMAN on local in a NFS share. After these backups are backep up by Netback on tape. The goal was […]","og_url":"https:\/\/www.dbi-services.com\/blog\/duplicate-database-on-oda-x4\/","og_site_name":"dbi Blog","article_published_time":"2020-09-18T14:30:32+00:00","article_modified_time":"2023-06-15T14:35:35+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/duplicate-database-on-oda-x4\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/duplicate-database-on-oda-x4\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Duplicate Database on ODA X4","datePublished":"2020-09-18T14:30:32+00:00","dateModified":"2023-06-15T14:35:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/duplicate-database-on-oda-x4\/"},"wordCount":289,"commentCount":0,"keywords":["create dbstorage","Duplicate ODA","ODA","ODA HA","ODA X4","Oracle 12c"],"articleSection":["Database Administration & Monitoring","Database management","Operating systems","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/duplicate-database-on-oda-x4\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/duplicate-database-on-oda-x4\/","url":"https:\/\/www.dbi-services.com\/blog\/duplicate-database-on-oda-x4\/","name":"Duplicate Database on ODA X4 - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2020-09-18T14:30:32+00:00","dateModified":"2023-06-15T14:35:35+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/duplicate-database-on-oda-x4\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/duplicate-database-on-oda-x4\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/duplicate-database-on-oda-x4\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Duplicate Database on ODA X4"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14721","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=14721"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14721\/revisions"}],"predecessor-version":[{"id":25944,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14721\/revisions\/25944"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=14721"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=14721"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=14721"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=14721"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}