Friday, August 12, 2022
RMAN DUPLICATE STANDBY
run
{
allocate channel tgt1 device type disk ;
allocate channel tgt2 device type disk ;
allocate channel tgt3 device type disk ;
allocate channel tgt4 device type disk ;
allocate channel tgt5 device type disk ;
allocate channel tgt6 device type disk ;
allocate channel tgt7 device type disk ;
allocate channel tgt8 device type disk ;
allocate channel tgt9 device type disk ;
allocate channel tgt10 device type disk ;
allocate channel tgt11 device type disk ;
allocate channel tgt12 device type disk ;
allocate channel tgt13 device type disk ;
allocate channel tgt14 device type disk ;
allocate channel tgt15 device type disk ;
allocate channel tgt16 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 ;
allocate auxiliary channel aux9 device type disk ;
allocate auxiliary channel aux10 device type disk ;
allocate auxiliary channel aux11 device type disk ;
allocate auxiliary channel aux12 device type disk ;
allocate auxiliary channel aux13 device type disk ;
allocate auxiliary channel aux14 device type disk ;
allocate auxiliary channel aux15 device type disk ;
allocate auxiliary channel aux16 device type disk ;
DUPLICATE TARGET DATABASE
FOR STANDBY
FROM ACTIVE DATABASE
DORECOVER
SPFILE
SET db_unique_name=‘cvs19qas_stby’ COMMENT ‘Is standby’
set DB_CREATE_FILE_DEST = ‘+DATAC1’
set DB_CREATE_ONLINE_LOG_DEST_1 = ‘+DATAC1’
set DB_RECOVERY_FILE_DEST = ‘+RECOC1’
set diagnostic_dest=‘/u02/app/oracle’
set DB_RECOVERY_FILE_DEST_SIZE=‘1500G’
set audit_file_dest=‘/u02/app/oracle/product/19.0.0.0/dbhome_1/admin/cvs19qas/adump’
SET job_queue_processes=‘0’
SET LOCAL_LISTENER=‘’
SET REMOTE_LISTENER=‘’
set cluster_database=‘false’
NOFILENAMECHECK;
}
Subscribe to:
Post Comments (Atom)
Database Options/Management Packs Usage Reporting for Oracle Databases 11.2 and later (Doc ID 1317265.1)
Database Options/Management Packs Usage Report You can determine whether an option is currently in use in a database by running options_pa...
-
In this Document Goal Ask Questions, Get Help, And Share Your Experiences With This Article Solution 12c TDE FAQ documentation Quick...
-
This document describes how to develop and deploy customizations in an Oracle E-Business Suite Release 12.2 environment. Follow thes...
-
This document also provides links to two presentations on the subject: Oracle OpenWorld presentation "Technical Upgrade Best Practice...
No comments:
Post a Comment