PreparationofPrimary
1. Configurelistenerandtnsnames.ora
2.
Checkconnectivityusingtnsping&loginusingtns
[grid@asr-host-dbprimaryadmin]$sqlplus'sys/primarypass'@DGASRPDB_DBMAIN_DGMGRLassysdba
SQL*Plus:Release19.0.0.0.0-ProductiononThuDec2804:42:422023
Version19.21.0.0.0
Copyright(c)1982,2022,Oracle.Allrightsreserved. Connected to:
OracleDatabase19cEnterpriseEditionRelease19.0.0.0.0 -Production Version 19.21.0.0.0
SQL>exit
DisconnectedfromOracleDatabase19cEnterpriseEditionRelease19.0.0.0.0 -Production Version 19.21.0.0.0
[grid@asr-host-dbprimaryadmin]$sqlplus'sys/asrdb2pass'@ASRDB2_DBMAIN_DGMGRLassysdba
SQL*Plus:Release19.0.0.0.0-ProductiononThuDec2804:45:182023
Version19.21.0.0.0
Copyright(c)1982,2022,Oracle.Allrightsreserved. Connected to:
OracleDatabase19cEnterpriseEditionRelease19.0.0.0.0 -Production Version 19.21.0.0.0
SQL>exit
DisconnectedfromOracleDatabase19cEnterpriseEditionRelease19.0.0.0.0 -Production Version 19.21.0.0.0
3. Createsymlinksforlistener,tnsnamesandsqlnetfororacle user
[grid@asr-host-dbprimaryadmin]$chmod755sqlnet.oralistener.oratnsnames.ora
[oracle@asr-host-dbprimaryadmin]$ln–s/u01/app/grid/19.0.0/gridhome_1/network/admin/tnsnames.ora
/u01/app/oracle/database/19.0.0/dbhome_1/network/admin/tnsnames.ora
[oracle@asr-host-dbprimaryadmin]$ln-s/u01/app/grid/19.0.0/gridhome_1/network/admin/listener.ora
/u01/app/oracle/database/19.0.0/dbhome_1/network/admin/listener.ora
[oracle@asr-host-dbprimaryadmin]$ln-s/u01/app/grid/19.0.0/gridhome_1/network/admin/sqlnet.ora
/u01/app/oracle/database/19.0.0/dbhome_1/network/admin/sqlnet.ora
[oracle@asr-host-dbprimary admin]$ ls
-ltr
total4
-rw-r--r--1oracleoinstall1536Feb142018 shrept.lst
drwxr-xr-x2oracleoinstall64Apr172019 samples
lrwxrwxrwx1oracleoinstall58Dec2805:02tnsnames.ora->
/u01/app/grid/19.0.0/gridhome_1/network/admin/tnsnames.ora
lrwxrwxrwx1oracleoinstall58Dec2805:02listener.ora->
/u01/app/grid/19.0.0/gridhome_1/network/admin/listener.ora
lrwxrwxrwx1oracleoinstall56Dec2805:03sqlnet.ora->
/u01/app/grid/19.0.0/gridhome_1/network/admin/sqlnet.ora
4. ChangetheparamtersinprimaryDB
SQL>alterdatabaseflashbackon;
Databasealtered.
SQL>alterdatabaseforcelogging;
Databasealtered.
5. AddStandbyredologfiles
SQL>alterdatabaseaddstandbylogfile'+DGDATA'size200M;
Databasealtered.
SQL>alterdatabaseaddstandbylogfile'+DGDATA'size200M;
Databasealtered.
SQL>alterdatabaseaddstandbylogfile'+DGDATA'size200M;
Databasealtered.
6. Changefilemanagementtoauto
SQL>altersystemsetstandby_file_management=AUTOscope=both;
Systemaltered.
PreparationofStandby
Environmentdetails:
grid@asr-host-dbstandby~]$whoami
grid
grid@asr-host-dbstandby~]$hostname
asr-host-dbstandby
grid@asr-host-dbstandby~]$echo$ORACLE_HOME
/app/grid/19.0.0/gridhome_1
grid@asr-host-dbstandby~]$echo$ORACLE_SID
+ASM
1. Configurelistenerandtnsnames.ora
[grid@asr-host-dbstandbyadmin]$lsnrctlstatus
lsnrctlforLinux:Version19.0.0.0.0 -Productionon28-DEC-202305:20:38 copyright (c) 1991, 2023, Oracle.All rights reserved.
connectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=asr-host-dbstandby)(PORT=1521))) status of the LISTENER
alias LISTENER
version TNSLSNRforLinux:Version19.0.0.0.0-Production start Date 25-DEC-2023 08:31:21
uptime 2 days20hr.49min.16sec
traceLevel off
security ON:LocalOSAuthentication
snmp OFF
listenerParameterFile/u01/app/grid/19.0.0/gridhome_1/network/admin/listener.ora
listener Log File /u01/app/grid/gridbase/diag/tnslsnr/asr-host-dbstandby/listener/alert/log.xml listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=asr-host-dbstandby.local)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
servicesSummary...
service"+ASM"has1instance(s).
Instance"+ASM",statusREADY,has1handler(s)forthisservice... service "+ASM_DGDATA" has 1 instance(s).
Instance"+ASM",statusREADY,has1handler(s)forthisservice... service "+ASM_DGREDO" has 1 instance(s).
Instance"+ASM",statusREADY,has1handler(s)forthisservice... service "STANDBY.DGASRPDB.LOCAL" has 1 instance(s).
Instance"DGASRPDB",statusUNKNOWN,has1handler(s)forthisservice... service "STANDBY.ASRDB2.LOCAL" has 1 instance(s).
Instance"ASRDB2",statusUNKNOWN,has1handler(s)forthisservice... the command completed successfully
2. Copythetnsnames.orafilefromprimarysite
[grid@asr-host-dbstandby admin]$ scp
dbprimary:/u01/app/grid/19.0.0/gridhome_1/network/admin/tnsnames.ora.
Theauthenticityofhost'dbprimary(192.168.22.15)'can'tbeestablished.
ECDSAkeyfingerprintisSHA256:1uYX4e/68kz4tMbA8gv4wkYtcH+EIPmBIGrvQLVAaKY.
Are you sure you want to continue connecting (yes/no/[fingerprint])? yes
Warning:Permanentlyadded'dbprimary,192.168.22.15'(ECDSA)tothelistofknownhosts. grid@dbprimary's password:
tnsnames.ora 100%
1595 1.7MB/s00:00
[grid@asr-host-dbstandbyadmin]$ls-ltr
total20
-rw-r--r--1gridoinstall1536Feb142018 shrept.lst
drwxr-xr-x2gridoinstall64Apr172019samples
-rwxrwxr-x1gridoinstall187Dec2508:31 sqlnet.ora
-rwxrwxr-x1gridoinstall840Dec2805:20 listener.ora
-rwxrwxr-x1gridoinstall1595Dec2805:24tnsnames.ora
3. Createsymlinksfororacleuserforsqlnet.ora,tnsnames.ora,listener.ora
[oracle@asr-host-dbstandby~]$ln–s/u01/app/grid/19.0.0/gridhome_1/network/admin/tnsnames.ora
/u01/app/oracle/database/19.0.0/dbhome_1/network/admin/tnsnames.ora
[oracle@asr-host-dbstandby~]$ln-s/u01/app/grid/19.0.0/gridhome_1/network/admin/listener.ora
/u01/app/oracle/database/19.0.0/dbhome_1/network/admin/listener.ora
[oracle@asr-host-dbstandby~]$ln-s/u01/app/grid/19.0.0/gridhome_1/network/admin/sqlnet.ora
/u01/app/oracle/database/19.0.0/dbhome_1/network/admin/sqlnet.ora
[oracle@asr-host-dbstandby~]$ls-ltr/u01/app/oracle/database/19.0.0/dbhome_1/network/admin/
total4
-rw-r--r--1oracleoinstall1536Feb142018 shrept.lst
drwxr-xr-x2oracleoinstall64Apr172019 samples
lrwxrwxrwx1oracleoinstall58Dec2805:27tnsnames.ora->
/u01/app/grid/19.0.0/gridhome_1/network/admin/tnsnames.ora
lrwxrwxrwx1oracleoinstall58Dec2805:27listener.ora->
/u01/app/grid/19.0.0/gridhome_1/network/admin/listener.ora
lrwxrwxrwx1oracleoinstall56Dec2805:27sqlnet.ora->
/u01/app/grid/19.0.0/gridhome_1/network/admin/sqlnet.ora
4. Setprofile(environmentvariables)fordatabase
# .bash_profile
#Getthealiasesandfunctions
if[-f~/.bashrc]; then
.~/.bashrc
fi
#Userspecificenvironmentandstartupprograms export TMP=/tmp
exportTMPDIR=$TMP
exportORACLE_HOSTNAME=asr-host-dbprimary export ORACLE_UNQNAME=DGASRPDBS
exportORACLE_BASE=/u01/app/oracle
export DB_HOME=/u01/app/oracle/database/19.0.0/dbhome_1 exportORACLE_HOME=/u01/app/oracle/database/19.0.0/dbhome_1
exportORACLE_SID=DGASRPDB
exportORACLE_TERM=xterm
exportPATH=/usr/sbin:/usr/local/bin:$PATH export ORACLE_TERM=xterm
exportPATH=/usr/sbin:/usr/local/bin:$PATH export PATH=$ORACLE_HOME/bin:$PATH
exportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
exportCLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
5. Checkconnectivityfromstandbytoprimary
[oracle@asr-host-dbstandby~]$sqlplus'sys/asrdb2pass'@ASRDB2_DBMAIN_DGMGRLassysdba
SQL*Plus:Release19.0.0.0.0-ProductiononThuDec2806:23:222023
Version19.21.0.0.0
Copyright(c)1982,2022,Oracle.Allrightsreserved. Connected to:
OracleDatabase19cEnterpriseEditionRelease19.0.0.0.0 -Production Version 19.21.0.0.0
SQL>exit
DisconnectedfromOracleDatabase19cEnterpriseEditionRelease19.0.0.0.0 -Production Version 19.21.0.0.0
[oracle@asr-host-dbstandby~]$sqlplus'sys/primarypass'@DGASRPDB_DBMAIN_DGMGRLassysdba
SQL*Plus:Release19.0.0.0.0-ProductiononThuDec2806:23:312023
Version19.21.0.0.0
Copyright(c)1982,2022,Oracle.Allrightsreserved. Connected to:
OracleDatabase19cEnterpriseEditionRelease19.0.0.0.0-Production
Version19.21.0.0.0
SQL>exit
DisconnectedfromOracleDatabase19cEnterpriseEditionRelease19.0.0.0.0 -Production Version 19.21.0.0.0
6. Copypasswordfiletostandby
[oracle@asr-host-dbstandbydbs]$scpdbprimary:/u01/app/oracle/database/19.0.0/dbhome_1/dbs/orapw*.
Theauthenticityofhost'dbprimary(192.168.22.15)'can'tbeestablished.
ECDSAkeyfingerprintisSHA256:1uYX4e/68kz4tMbA8gv4wkYtcH+EIPmBIGrvQLVAaKY.
Are you sure you want to continue connecting (yes/no/[fingerprint])? yes
Warning:Permanentlyadded'dbprimary,192.168.22.15'(ECDSA)tothelistofknownhosts. oracle@dbprimary's password:
orapwDGASRPDB 100%2048
2.0MB/s00:00
orapwASRDB2 100%
2048 2.5MB/s00:00
[oracle@asr-host-dbstandbydbs]$ls-ltr
total12
-rw-r--r--1oracleoinstall3079May142015 init.ora
-rw-r----- 1oracleoinstall2048Dec2806:25orapwDGASRPDB
-rw-r----- 1oracleoinstall2048Dec2806:25orapwASRDB2
7. Createtemppfiletostartthedbinnomount mode
[oracle@asr-host-dbstandbydbs]$echo"*.db_name='DGASRPDB'">/tmp/initdb.ora
[oracle@asr-host-dbstandby~]$cat/tmp/initdb.ora
*.db_name='DGASRPDB'
8. StartupDatabaseinnomount mode
[oracle@asr-host-dbstandby~]$sqlplus/assysdba
SQL*Plus:Release19.0.0.0.0-ProductiononThuDec2806:29:032023
Version19.21.0.0.0
Copyright(c)1982,2022,Oracle.Allrightsreserved. Connected to an idle instance.
SQL>startupnomountpfile='/tmp/initdb.ora';
ORACLEinstancestarted.
TotalSystemGlobalArea675282320bytes Fixed Size 8928656 bytes
Variable Size 457179136 bytes Database Buffers 201326592bytes Redo Buffers 7847936 bytes
9. CreateADUMPDirectory
*checkinprimaryandcreatethesame location
[oracle@asr-host-dbstandby~]$mkdir-p/u01/app/oracle/admin/DGASRPDB/adump/
10. Connecttormantargetandauxdbforactiveduplicate
[oracle@asr-host-dbstandby~]$rmantarget'sys/primarypass'@DGASRPDB_DBMAIN_DGMGRLauxiliary
'sys/primarypass'@DGASRPDB_STANDBY_DGMGRL
RecoveryManager:Release19.0.0.0.0-ProductiononThuDec2806:32:382023
Version19.21.0.0.0
Copyright(c)1982,2019,Oracleand/oritsaffiliates.Allrightsreserved. connected to target database: DGASRPDB (DBID=1461211867) connected to auxiliary database: DGASRPDB (not mounted)
11. Runtheactiveduplicatescript
12. Setthefollowingparameterin Standby
SQL>alter database flashback on; Database altered. standby_file_management-->auto
13. ShutdowntheDBfromsqlplusprompt
SQL>shuimmediate;
ORA-01109:databasenotopen Database dismounted.
ORACLEinstanceshut down.
14. Addthedatabaseinsrvctl
[oracle@asr-host-dbstandby~]$srvctladddatabase-dbDGASRPDBS–oraclehome
/u01/app/oracle/database/19.0.0/dbhome_1-domainDGASRPDB.local-spfile
/u01/app/oracle/database/19.0.0/dbhome_1/dbs/spfileDGASRPDB.ora-rolePHYSICAL_STANDBY- startoption MOUNT -dbname DGASRPDB -policy AUTOMATIC -instance DGASRPDB
[oracle@asr-host-dbstandby~]$srvctlconfigdatabase
DGASRPDBS
[oracle@asr-host-dbstandby~]$srvctlconfigdatabase-dDGASRPDBS
Databaseuniquename:DGASRPDBS Database name: DGASRPDB
Oraclehome:/u01/app/oracle/database/19.0.0/dbhome_1 Oracle user: oracle
Spfile:/u01/app/oracle/database/19.0.0/dbhome_1/dbs/spfileDGASRPDB.ora Password file:
Domain:DGASRPDB.local Start options: mountStop options: immediate
Databaserole:PHYSICAL_STANDBY Management policy: AUTOMATIC Disk Groups:
Services:
OSDBAgroup:
OSOPERgroup:
Databaseinstance:DGASRPDB
15. AddServicetotheStandbyDB:
[oracle@asr-host-dbstandby~]$srvctlstatusservice-dDGASRPDBS-sDGASRPDB_ha.local
ServiceDGASRPDB_ha.localisnotrunning.
16. StartthestandbyDBusingsrvctl
[oracle@asr-host-dbstandby ~]$ srvctl start db -d DGASRPDBS [oracle@asr-host-dbstandby~]$srvctlstatusdb-dDGASRPDBS Database is running.
17. Changethefollowingparametersinprimary
SQL>altersystemsetstandby_file_management=AUTOscope=both;
Systemaltered.
SQL>altersystemsetdg_broker_start=truescope=both;
Systemaltered.
18. CreateDGMGRLConfigurationforstandby
[oracle@asr-host-dbprimary~]$dgmgrl'sys/primarypass'assysdba
DGMGRLforLinux:Release19.0.0.0.0-ProductiononThuDec2806:59:312023
Version19.21.0.0.0
Copyright(c)1982,2019,Oracleand/or itsaffiliates.Allrightsreserved. Welcome to DGMGRL, type "help" for information.
Connectedto"DGASRPDB" Connected as SYSDBA.
DGMGRL>createconfiguration'DGASRPDB_dg_config'asprimarydatabaseis'DGASRPDB' connectidentifieris DGASRPDB_DBMAIN_DGMGRL;
Configuration"DGASRPDB_dg_config"createdwithprimarydatabase"DGASRPDB"
DGMGRL>adddatabaseDGASRPDBSasconnectidentifierisDGASRPDB_STANDBY_DGMGRL maintainedas physical;
Database"DGASRPDBs"added
DGMGRL>showconfiguration
Configuration-DGASRPDB_dg_config Protection Mode: MaxPerformance Members:
DGASRPDB- Primary database DGASRPDBs-Physicalstandbydatabase
Fast-StartFailover:Disabled Configuration Status:
DISABLED
DGMGRL>enableconfiguration
Enabled.
DGMGRL>showdatabaseDGASRPDBs
Database-DGASRPDBs
Role: PHYSICALSTANDBY
IntendedState: APPLY-ON
Transport Lag: 0seconds(computed0secondsago) Apply Lag: 0 seconds (computed 0 seconds ago) Average Apply Rate: 331.00 KByte/s
RealTimeQuery:ON Instance(s):
DGASRPDB
DatabaseStatus:
SUCCESS
19. AddServicetothePrimaryDB:
[oracle@asr-host-dbprimary
~]$ srvctl start service -d DGASRPDB -s
DGASRPDB_ha.local [oracle@asr-host-dbprimary~]$srvctlstatusservice-dDGASRPDB-sDGASRPDB_ha.local Service DGASRPDB_ha.local is running
----------------------------------------------****---------------------------------------------------
LOGS
[oracle@asr-host-dbstandby~]$rmantarget'sys/primarypass'@DGASRDB_DBMAIN_DGMGRLauxiliary 'sys/standbypass'@DGASRDB_STANDBY_DGMGRL
RecoveryManager:Release19.0.0.0.0-ProductiononThuDec2806:40:38 2023
Version19.21.0.0.0
Copyright(c)1982,2019,Oracleand/oritsaffiliates.Allrightsreserved. connected to target database: DGASRDB (DBID=1461211867)
connectedtoauxiliarydatabase:DGASRDB(notmounted)
RMAN> duplicate target database for standby from active database dorecover spfile set db_unique_name='DGASRDBS' comment 'Is Standby' set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=asr-host-dbstandby)(PORT=1521))'nofilenamecheck;
StartingDuplicateDbat28-DEC-23
usingtargetdatabasecontrolfileinsteadofrecoverycatalog allocated channel: ORA_AUX_DISK_1
channelORA_AUX_DISK_1:SID=130devicetype=DISK current log archived
contentsofMemoryScript:
{
backupascopyreuse
passwordfileauxiliaryformat'/u01/app/oracle/database/19.0.0/dbhome_1/dbs/orapwDGASRDB'; restore clone from service'DGASRDB_DBMAIN_DGMGRL' spfile to '/u01/app/oracle/database/19.0.0/dbhome_1/dbs/spfileDGASRDB.ora';
sqlclone"altersystemsetspfile=''/u01/app/oracle/database/19.0.0/dbhome_1/dbs/spfileDGASRDB.ora''";
}
executingMemoryScript
Starting backup at 28-DEC-23 allocatedchannel:ORA_DISK_1
channelORA_DISK_1:SID=499devicetype=DISK Finished backup at 28-DEC-23
Starting restore at 28-DEC-23 usingchannelORA_AUX_DISK_1
channelORA_AUX_DISK_1:startingdatafilebackupsetrestore
channelORA_AUX_DISK_1:usingnetworkbackupsetfromserviceDGASRDB_DBMAIN_DGMGRL channel ORA_AUX_DISK_1: restoring SPFILE
outputfilename=/u01/app/oracle/database/19.0.0/dbhome_1/dbs/spfileDGASRDB.ora channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finishedrestoreat28-DEC-23
sqlstatement:altersystemsetspfile=''/u01/app/oracle/database/19.0.0/dbhome_1/dbs/spfileDGASRDB.ora''
contentsofMemoryScript:
{
sqlclone"altersystemsetdb_unique_name= ''DGASRDBS'' comment=
''IsStandby''scope=spfile";
sql clone "alter system setlocal_listener = ''(ADDRESS=(PROTOCOL=TCP)(HOST=asr-host-dbstandby)(PORT=1521))''comment= '''' scope=spfile";
shutdowncloneimmediate; startup clone nomount;
}
executingMemoryScript
sqlstatement:altersystemsetdb_unique_name=''DGASRDBS''comment=''IsStandby''scope=spfile
sqlstatement:altersystemsetlocal_listener=''(ADDRESS=(PROTOCOL=TCP)(HOST=asr-host- dbstandby)(PORT=1521))'' comment= '''' scope=spfile
Oracleinstanceshutdown
connectedtoauxiliarydatabase(notstarted) Oracle instance started
TotalSystemGlobalArea20132657264bytes
FixedSize 18372720bytes
Variable Size 2483027968 bytes Database Buffers 17582522368bytes Redo Buffers 48734208 bytes
duplicatingOnlinelogstoOracleManagedFile(OMF)location duplicating Datafiles to Oracle Managed File (OMF) location
contentsofMemoryScript:
{
sql clone "alter system setcontrol_files = ''+DGDATA/DGASRDBS/CONTROLFILE/current.257.1156747271'',
''+DGDATA/DGASRDBS/CONTROLFILE/current.258.1156747271''comment=
''SetbyRMAN''scope=spfile";
restoreclonefromservice'DGASRDB_DBMAIN_DGMGRL'standbycontrolfile;
}
executingMemoryScript
sqlstatement:altersystemsetcontrol_files=''+DGDATA/DGASRDBS/CONTROLFILE/current.257.1156747271'', ''+DGDATA/DGASRDBS/CONTROLFILE/current.258.1156747271'' comment= ''Set by RMAN'' scope=spfile
Starting restore at 28-DEC-23 allocatedchannel:ORA_AUX_DISK_1
channelORA_AUX_DISK_1:SID=1102devicetype=DISK
channelORA_AUX_DISK_1:startingdatafilebackupset restore
channelORA_AUX_DISK_1:usingnetworkbackupsetfromserviceDGASRDB_DBMAIN_DGMGRL channel ORA_AUX_DISK_1: restoring control file
channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:01
outputfilename=+DGDATA/DGASRDBS/CONTROLFILE/current.261.1156747273 outputfilename=+DGDATA/DGASRDBS/CONTROLFILE/current.262.1156747273 Finished restore at 28-DEC-23
contentsofMemoryScript:
{
sqlclone'alterdatabasemountstandbydatabase';
}
executingMemoryScript
sqlstatement:alterdatabasemountstandbydatabase
contentsofMemoryScript:
{
setnewnameforclonetempfile1tonew; switch clone tempfile all;
setnewnameforclonedatafile1tonew; setnewnameforclonedatafile2tonew; setnewnameforclonedatafile3tonew; setnewnameforclonedatafile4tonew; setnewnameforclonedatafile5tonew; setnewnameforclonedatafile7tonew; setnewnameforclonedatafile8tonew; setnewnameforclonedatafile9tonew;
restore
fromnonsparsefrom service 'DGASRDB_DBMAIN_DGMGRL'clonedatabase
;
sql'altersystemarchivelogcurrent';
}
executingMemoryScript
executingcommand:SETNEWNAME
renamedtempfile1to+DGDATAincontrolfile
executingcommand:SETNEWNAME
executingcommand:SETNEWNAME
executingcommand:SETNEWNAME
executingcommand:SETNEWNAME
executingcommand:SETNEWNAME
executingcommand:SETNEWNAME
executingcommand:SETNEWNAME
executingcommand:SETNEWNAME
Starting restore at 28-DEC-23 usingchannelORA_AUX_DISK_1
channelORA_AUX_DISK_1:startingdatafilebackupsetrestore
channelORA_AUX_DISK_1:usingnetworkbackupsetfromserviceDGASRDB_DBMAIN_DGMGRL channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to +DGDATA channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:03 channel ORA_AUX_DISK_1: starting datafile backup set restore
channelORA_AUX_DISK_1:usingnetworkbackupsetfromserviceDGASRDB_DBMAIN_DGMGRL channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00002 to +DGDATA channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:08 channel ORA_AUX_DISK_1: starting datafile backup set restore
channelORA_AUX_DISK_1:usingnetworkbackupsetfromserviceDGASRDB_DBMAIN_DGMGRL channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00003 to +DGDATA channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:03 channel ORA_AUX_DISK_1: starting datafile backup set restore
channelORA_AUX_DISK_1:usingnetworkbackupsetfromserviceDGASRDB_DBMAIN_DGMGRL channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00004 to +DGDATA channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:03 channel ORA_AUX_DISK_1: starting datafile backup set restore
channelORA_AUX_DISK_1:usingnetworkbackupsetfromserviceDGASRDB_DBMAIN_DGMGRL channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00005 to +DGDATA channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:55 channel ORA_AUX_DISK_1: starting datafile backup set restore
channelORA_AUX_DISK_1:usingnetworkbackupsetfromserviceDGASRDB_DBMAIN_DGMGRL channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00007 to +DGDATA channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:01 channel ORA_AUX_DISK_1: starting datafile backup set restore
channelORA_AUX_DISK_1:usingnetworkbackupsetfromserviceDGASRDB_DBMAIN_DGMGRL channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00008 to +DGDATA channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:55 channel ORA_AUX_DISK_1: starting datafile backup set restore
channelORA_AUX_DISK_1:usingnetworkbackupsetfromserviceDGASRDB_DBMAIN_DGMGRL channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00009 to +DGDATA channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:07 Finished restore at 28-DEC-23
sqlstatement:altersystemarchivelogcurrent current log archived
contentsofMemoryScript:
{
restorecloneforcefromservice'DGASRDB_DBMAIN_DGMGRL' archivelog from scn2428756;
switchclonedatafile all;
}
executingMemoryScript
Starting restore at 28-DEC-23 usingchannelORA_AUX_DISK_1
channelORA_AUX_DISK_1:startingarchivedlogrestoretodefaultdestination
channelORA_AUX_DISK_1:usingnetworkbackupsetfromserviceDGASRDB_DBMAIN_DGMGRL channel ORA_AUX_DISK_1: restoring archived log
archivedlogthread=1sequence=21
channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:01
channelORA_AUX_DISK_1:startingarchivedlogrestoretodefaultdestination
channelORA_AUX_DISK_1:usingnetworkbackupsetfromserviceDGASRDB_DBMAIN_DGMGRL channel ORA_AUX_DISK_1: restoring archived log
archivedlogthread=1sequence=22
channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:01 Finished restore at 28-DEC-23
datafile1switchedtodatafilecopy
input datafile copy RECID=9 STAMP=1156747417 file name=+DGDATA/DGASRDBS/DATAFILE/system.263.1156747281
datafile2switchedtodatafilecopy
input datafile copy RECID=10 STAMP=1156747417 file name=+DGDATA/DGASRDBS/DATAFILE/zonos_oss_10240_idx.264.1156747283
datafile3switchedtodatafilecopy
input datafile copy RECID=11 STAMP=1156747417 file name=+DGDATA/DGASRDBS/DATAFILE/sysaux.265.1156747291
datafile4switchedtodatafilecopy
input datafile copy RECID=12 STAMP=1156747417 file name=+DGDATA/DGASRDBS/DATAFILE/undotbs1.266.1156747293
datafile5switchedtodatafilecopy
input datafile copy RECID=13 STAMP=1156747417 file name=+DGDATA/DGASRDBS/DATAFILE/zonos_oss_10240.267.1156747297
datafile7switchedtodatafilecopy
input datafile copy RECID=14 STAMP=1156747417 file name=+DGDATA/DGASRDBS/DATAFILE/users.268.1156747351
datafile8switchedtodatafilecopy
input datafile copy RECID=15 STAMP=1156747417 file name=+DGDATA/DGASRDBS/DATAFILE/customer_10240.269.1156747353
datafile9switchedtodatafilecopy
input datafile copy RECID=16 STAMP=1156747417 file name=+DGDATA/DGASRDBS/DATAFILE/customer_10240_idx.270.1156747407
contentsofMemoryScript:
{
setuntilscn2429078; recover
standby
clone database deletearchivelog
;
}
executingMemoryScript
executingcommand:SETuntilclause
Starting recover at 28-DEC-23 usingchannelORA_AUX_DISK_1
startingmediarecovery
archivedlogforthread1withsequence21isalreadyondiskasfile
+DGDATA/DGASRDBS/ARCHIVELOG/2023_12_28/thread_1_seq_21.271.1156747415
archivedlogforthread1withsequence22isalreadyondiskasfile
+DGDATA/DGASRDBS/ARCHIVELOG/2023_12_28/thread_1_seq_22.272.1156747417
archivedlogfilename=+DGDATA/DGASRDBS/ARCHIVELOG/2023_12_28/thread_1_seq_21.271.1156747415 thread=1 sequence=21
archivedlogfilename=+DGDATA/DGASRDBS/ARCHIVELOG/2023_12_28/thread_1_seq_22.272.1156747417 thread=1 sequence=22
mediarecoverycomplete,elapsedtime:00:00:01 Finished recover at 28-DEC-23
contentsofMemoryScript:
{
deletecloneforcearchivelog all;
}
executingMemoryScript
released channel: ORA_DISK_1 releasedchannel:ORA_AUX_DISK_1 allocated channel: ORA_DISK_1
channelORA_DISK_1:SID=499devicetype=DISK deleted archived log
archivedlogfilename=+DGDATA/DGASRDBS/ARCHIVELOG/2023_12_28/thread_1_seq_21.271.1156747415 RECID=1 STAMP=1156747415
deletedarchived log
archivedlogfilename=+DGDATA/DGASRDBS/ARCHIVELOG/2023_12_28/thread_1_seq_22.272.1156747417 RECID=2 STAMP=1156747416
Deleted2 objects
FinishedDuplicateDbat28-DEC-23
----------------------------------------------****---------------------------------------------------
No comments:
Post a Comment