##################################### Primary DB Init Parameter ###########################################
F:\Oracle\app\product\11.2.0.4\db_1\database>
F:\Oracle\app\product\11.2.0.4\db_1\database>type INITucas.ORA
*.archive_lag_target=0
*.audit_file_dest='F:\Oracle\app\admin\ucas\adump'
*.audit_trail='NONE'
*.compatible='11.2.0.4.0'
*.control_file_record_keep_time=27
*.control_files='G:\UCASNEW\ucasnew\control01.ctl','G:\UCASNEW\ucasnew\control02.ctl'
*.cursor_sharing='FORCE'
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='G:\UCAS\ORADATA_2','G:\UCAS\ORADATA_2','H:\UCAS\ORADATA_2','H:\UCAS\ORADATA_2'
*.db_flashback_retention_target=10800
*.db_name='ucas'
*.db_recovery_file_dest='I:\FLASH_RECOVERY_AREA'
*.db_recovery_file_dest_size=171798691840
*.db_unique_name='UCAS'
*.diagnostic_dest='F:\Oracle\app'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ucasXDB)'
*.enable_goldengate_replication=TRUE
*.fal_client='ucas'
*.fal_server='ucasdr'
*.fast_start_mttr_target=180
*.log_archive_config='DG_CONFIG=(ucas,ucasdr)'
*.log_archive_dest_1='LOCATION=I:\FLASH_RECOVERY_AREA\UCAS\ARCHIVELOG VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ucas'
*.log_archive_dest_2='SERVICE=ucasdr LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ucasdr'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='log_%s_%t_%r.arc'
*.log_archive_max_processes=5
*.log_archive_min_succeed_dest=1
*.log_checkpoints_to_alert=TRUE
*.log_file_name_convert='G:\UCAS\ORADATA_1','G:\UCAS\ORADATA_1','H:\UCAS\ORADATA_1','H:\UCAS\ORADATA_1'
*.open_cursors=500
*.optimizer_dynamic_sampling=2
*.pga_aggregate_target=4194304000
*.processes=500
*.recyclebin='OFF'
*.remote_login_passwordfile='EXCLUSIVE'
*.resource_manager_plan=''
*.result_cache_max_size=0
*.result_cache_mode='MANUAL'
*.session_cached_cursors=100
*.sessions=500
*.sga_max_size=10485760000
*.sga_target=10502537216
*.standby_file_management='AUTO'
*.streams_pool_size=536870912
*.undo_retention=86400
*.undo_tablespace='UNDOTBS1'
F:\Oracle\app\product\11.2.0.4\db_1\database>
##################################### Standby DB Init Parameter ###########################################
[oracle@test-machine02 dbs]$ cat initucas.ora
*.archive_lag_target=0
*.audit_file_dest='/u01/app/oracle/admin/ucas/adump'
*.audit_trail='NONE'
*.compatible='11.2.0.4.0'
*.control_file_record_keep_time=27
*.control_files='/data01/oradata_1/control01.ctl','/data02/oradata_1/control02.ctl'
*.cursor_sharing='FORCE'
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='G:\UCASNEW\UCASNEW\','/data01/oradata_2/','H:\UCASNEW\ORADATA_2\','/data02/oradata_2/'
*.log_file_name_convert='G:\UCASNEW\ORADATA_1\','/data01/oradata_1/','H:\UCASNEW\ORADATA_1\','/data02/oradata_1/'
*.db_flashback_retention_target=10800
*.db_name='ucas'
*.db_recovery_file_dest='/backup/fast_recovery_area'
*.db_recovery_file_dest_size=171798691840
*.db_unique_name='ucasdr'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ucasdrXDB)'
*.enable_goldengate_replication=TRUE
*.fal_client='ucasdr'
*.fal_server='ucas'
*.fast_start_mttr_target=180
*.log_archive_config='DG_CONFIG=(ucas,ucasdr)'
*.log_archive_dest_1='LOCATION=/backup/fast_recovery_area/ucas/archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ucasdr'
*.log_archive_dest_2='SERVICE=ucas LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ucas'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='log_%s_%t_%r.arc'
*.log_archive_max_processes=5
*.log_archive_min_succeed_dest=1
*.log_checkpoints_to_alert=TRUE
*.open_cursors=500
*.optimizer_dynamic_sampling=2
*.pga_aggregate_target=4194304000
*.processes=500
*.recyclebin='OFF'
*.remote_login_passwordfile='EXCLUSIVE'
*.resource_manager_plan=''
*.result_cache_max_size=0
*.result_cache_mode='MANUAL'
*.session_cached_cursors=100
*.sessions=500
*.sga_max_size=10485760000
*.sga_target=10502537216
*.standby_file_management='AUTO'
*.streams_pool_size=536870912
*.undo_retention=86400
*.undo_tablespace='UNDOTBS1'
##################################### Primary DB ###########################################
C:\Users\jkhan>
C:\Users\jkhan>rman target sys/pass123
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Apr 17 16:44:32 2022
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: UCAS (DBID=2026517590)
RMAN>
RMAN> run {
2> allocate channel ch1 device type disk;
3> allocate channel ch2 device type disk;
4> allocate channel ch3 device type disk;
5> backup
6> tag 'FULL BACKUP'
7> format 'F:\UCAS_Backup\backup_db_%d_S_%s_P_%p_T_%t'
8> as compressed backupset database;
9> release channel ch1;
10> release channel ch2;
11> release channel ch3;
12> }
using target database control file instead of recovery catalog
allocated channel: ch1
channel ch1: SID=762 device type=DISK
allocated channel: ch2
channel ch2: SID=781 device type=DISK
allocated channel: ch3
channel ch3: SID=122 device type=DISK
Starting backup at 17-APR-22
channel ch1: starting compressed full datafile backup set
channel ch1: specifying datafile(s) in backup set
input datafile file number=00005 name=H:\UCASNEW\ORADATA_2\UCAS_01.DBF
input datafile file number=00011 name=H:\UCASNEW\ORADATA_2\UCAS_DATA_02.DBF
input datafile file number=00004 name=G:\UCASNEW\UCASNEW\USERS01.DBF
input datafile file number=00009 name=H:\UCASNEW\ORADATA_2\TELEX_01.DBF
channel ch1: starting piece 1 at 17-APR-22
channel ch2: starting compressed full datafile backup set
channel ch2: specifying datafile(s) in backup set
input datafile file number=00010 name=H:\UCASNEW\ORADATA_2\UCAS_02.DBF
input datafile file number=00012 name=H:\UCASNEW\ORADATA_2\UCAS_INDEX_02.DBF
input datafile file number=00007 name=H:\UCASNEW\ORADATA_2\UCAS_INDEX_01.DBF
input datafile file number=00001 name=G:\UCASNEW\UCASNEW\SYSTEM01.DBF
channel ch2: starting piece 1 at 17-APR-22
channel ch3: starting compressed full datafile backup set
channel ch3: specifying datafile(s) in backup set
input datafile file number=00003 name=G:\UCASNEW\UCASNEW\UNDOTBS01.DBF
input datafile file number=00006 name=H:\UCASNEW\ORADATA_2\UCAS_DATA_01.DBF
input datafile file number=00002 name=G:\UCASNEW\UCASNEW\SYSAUX01.DBF
input datafile file number=00008 name=H:\UCASNEW\ORADATA_2\GGS_DATA_01.DBF
channel ch3: starting piece 1 at 17-APR-22
channel ch3: finished piece 1 at 17-APR-22
piece handle=F:\UCAS_BACKUP\BACKUP_DB_UCAS_S_8719_P_1_T_1102265135 tag=FULL BACKUP comment=NONE
channel ch3: backup set complete, elapsed time: 00:02:35
channel ch3: starting compressed full datafile backup set
channel ch3: specifying datafile(s) in backup set
including current control file in backup set
channel ch3: starting piece 1 at 17-APR-22
channel ch3: finished piece 1 at 17-APR-22
piece handle=F:\UCAS_BACKUP\BACKUP_DB_UCAS_S_8720_P_1_T_1102265290 tag=FULL BACKUP comment=NONE
channel ch3: backup set complete, elapsed time: 00:00:01
channel ch3: starting compressed full datafile backup set
channel ch3: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ch3: starting piece 1 at 17-APR-22
channel ch3: finished piece 1 at 17-APR-22
piece handle=F:\UCAS_BACKUP\BACKUP_DB_UCAS_S_8721_P_1_T_1102265292 tag=FULL BACKUP comment=NONE
channel ch3: backup set complete, elapsed time: 00:00:01
channel ch2: finished piece 1 at 17-APR-22
piece handle=F:\UCAS_BACKUP\BACKUP_DB_UCAS_S_8718_P_1_T_1102265135 tag=FULL BACKUP comment=NONE
channel ch2: backup set complete, elapsed time: 00:04:23
channel ch1: finished piece 1 at 17-APR-22
piece handle=F:\UCAS_BACKUP\BACKUP_DB_UCAS_S_8717_P_1_T_1102265135 tag=FULL BACKUP comment=NONE
channel ch1: backup set complete, elapsed time: 00:04:33
Finished backup at 17-APR-22
released channel: ch1
released channel: ch2
released channel: ch3
RMAN>
RMAN> backup current controlfile for standby format='F:\UCAS_Backup\stby_cfile.%U';
Starting backup at 17-APR-22
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=143 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including standby control file in backup set
channel ORA_DISK_1: starting piece 1 at 17-APR-22
channel ORA_DISK_1: finished piece 1 at 17-APR-22
piece handle=F:\UCAS_BACKUP\STBY_CFILE.G20R57TL_1_1 tag=TAG20220417T054213 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 17-APR-22
RMAN>
RMAN> sql "alter system switch logfile";
using target database control file instead of recovery catalog
sql statement: alter system switch logfile
RMAN> sql "alter system switch logfile";
using target database control file instead of recovery catalog
sql statement: alter system switch logfile
RMAN> sql "alter system switch logfile";
using target database control file instead of recovery catalog
sql statement: alter system switch logfile
RMAN>
C:\Users\jkhan>rman target sys/pass123
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Apr 17 05:44:04 2022
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: UCAS (DBID=2026517590)
RMAN> run {
2> allocate channel ch1 device type disk;
3> allocate channel ch2 device type disk;
4> allocate channel ch3 device type disk;
5> allocate channel ch4 device type disk;
6> backup
7> tag 'ARCHIVE BACKUP'
8> format 'F:\UCAS_Backup\archive_db_%d_S_%s_P_%p_T_%t'
9> as compressed backupset archivelog all;
10> release channel ch1;
11> release channel ch2;
12> release channel ch3;
13> release channel ch4;
14> }
using target database control file instead of recovery catalog
allocated channel: ch1
channel ch1: SID=143 device type=DISK
allocated channel: ch2
channel ch2: SID=162 device type=DISK
allocated channel: ch3
channel ch3: SID=182 device type=DISK
allocated channel: ch4
channel ch4: SID=202 device type=DISK
Starting backup at 17-APR-22
current log archived
channel ch1: starting compressed archived log backup set
channel ch1: specifying archived log(s) in backup set
input archived log thread=1 sequence=10973 RECID=22024 STAMP=1101999929
input archived log thread=1 sequence=10974 RECID=22025 STAMP=1102004334
input archived log thread=1 sequence=10975 RECID=22026 STAMP=1102004337
input archived log thread=1 sequence=10976 RECID=22027 STAMP=1102010179
input archived log thread=1 sequence=10977 RECID=22033 STAMP=1102030225
input archived log thread=1 sequence=10978 RECID=22036 STAMP=1102030253
input archived log thread=1 sequence=10979 RECID=22038 STAMP=1102030274
input archived log thread=1 sequence=10980 RECID=22040 STAMP=1102030286
channel ch1: starting piece 1 at 17-APR-22
channel ch2: starting compressed archived log backup set
channel ch2: specifying archived log(s) in backup set
input archived log thread=1 sequence=10981 RECID=22042 STAMP=1102042497
input archived log thread=1 sequence=10982 RECID=22043 STAMP=1102042497
input archived log thread=1 sequence=10983 RECID=22044 STAMP=1102042497
input archived log thread=1 sequence=10984 RECID=22048 STAMP=1102116619
input archived log thread=1 sequence=10985 RECID=22050 STAMP=1102116639
input archived log thread=1 sequence=10986 RECID=22052 STAMP=1102116654
input archived log thread=1 sequence=10987 RECID=22053 STAMP=1102116669
channel ch2: starting piece 1 at 17-APR-22
channel ch3: starting compressed archived log backup set
channel ch3: specifying archived log(s) in backup set
input archived log thread=1 sequence=10988 RECID=22056 STAMP=1102128899
input archived log thread=1 sequence=10989 RECID=22057 STAMP=1102128899
input archived log thread=1 sequence=10990 RECID=22058 STAMP=1102128900
input archived log thread=1 sequence=10991 RECID=22062 STAMP=1102203019
input archived log thread=1 sequence=10992 RECID=22064 STAMP=1102203042
input archived log thread=1 sequence=10993 RECID=22066 STAMP=1102203056
channel ch3: starting piece 1 at 17-APR-22
channel ch4: starting compressed archived log backup set
channel ch4: specifying archived log(s) in backup set
input archived log thread=1 sequence=10994 RECID=22068 STAMP=1102203074
input archived log thread=1 sequence=10995 RECID=22070 STAMP=1102215299
input archived log thread=1 sequence=10996 RECID=22071 STAMP=1102215299
input archived log thread=1 sequence=10997 RECID=22072 STAMP=1102215299
input archived log thread=1 sequence=10998 RECID=22075 STAMP=1102225346
input archived log thread=1 sequence=10999 RECID=22077 STAMP=1102225382
input archived log thread=1 sequence=11000 RECID=22079 STAMP=1102225419
input archived log thread=1 sequence=11001 RECID=22081 STAMP=1102225420
channel ch4: starting piece 1 at 17-APR-22
channel ch4: finished piece 1 at 17-APR-22
piece handle=F:\UCAS_BACKUP\ARCHIVE_DB_UCAS_S_8714_P_1_T_1102225478 tag=ARCHIVE BACKUP comment=NONE
channel ch4: backup set complete, elapsed time: 00:00:36
channel ch4: starting compressed archived log backup set
channel ch4: specifying archived log(s) in backup set
input archived log thread=1 sequence=11002 RECID=22083 STAMP=1102225420
input archived log thread=1 sequence=11003 RECID=22085 STAMP=1102225478
channel ch4: starting piece 1 at 17-APR-22
channel ch4: finished piece 1 at 17-APR-22
piece handle=F:\UCAS_BACKUP\ARCHIVE_DB_UCAS_S_8715_P_1_T_1102225514 tag=ARCHIVE BACKUP comment=NONE
channel ch4: backup set complete, elapsed time: 00:00:03
channel ch3: finished piece 1 at 17-APR-22
piece handle=F:\UCAS_BACKUP\ARCHIVE_DB_UCAS_S_8713_P_1_T_1102225478 tag=ARCHIVE BACKUP comment=NONE
channel ch3: backup set complete, elapsed time: 00:00:43
channel ch1: finished piece 1 at 17-APR-22
piece handle=F:\UCAS_BACKUP\ARCHIVE_DB_UCAS_S_8711_P_1_T_1102225478 tag=ARCHIVE BACKUP comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:51
channel ch2: finished piece 1 at 17-APR-22
piece handle=F:\UCAS_BACKUP\ARCHIVE_DB_UCAS_S_8712_P_1_T_1102225478 tag=ARCHIVE BACKUP comment=NONE
channel ch2: backup set complete, elapsed time: 00:01:01
Finished backup at 17-APR-22
released channel: ch1
released channel: ch2
released channel: ch3
released channel: ch4
RMAN>
F:\UCAS_Backup>
F:\UCAS_Backup>dir
Volume in drive F is DB GG Soft
Volume Serial Number is 089F-8206
Directory of F:\UCAS_Backup
04/17/2022 05:49 AM
.
04/17/2022 05:49 AM ..
04/26/2016 10:18 AM 193 2.par
12/31/2018 11:28 AM 587 airfi_tables.par
04/17/2022 05:45 AM 489,657,856 BACKUP_ARCHIVE_DB_UCAS_S_8711_P_1_T_1102225478
04/17/2022 05:45 AM 516,775,424 BACKUP_ARCHIVE_DB_UCAS_S_8712_P_1_T_1102225478
04/17/2022 05:45 AM 395,673,600 BACKUP_ARCHIVE_DB_UCAS_S_8713_P_1_T_1102225478
04/17/2022 05:45 AM 183,844,864 BACKUP_ARCHIVE_DB_UCAS_S_8714_P_1_T_1102225478
04/17/2022 05:45 AM 31,232 BACKUP_ARCHIVE_DB_UCAS_S_8715_P_1_T_1102225514
04/17/2022 05:40 AM 2,394,677,248 BACKUP_DB_UCAS_S_8701_P_1_T_1102224961
04/17/2022 05:40 AM 2,142,011,392 BACKUP_DB_UCAS_S_8702_P_1_T_1102224961
04/17/2022 05:38 AM 1,397,006,336 BACKUP_DB_UCAS_S_8703_P_1_T_1102224961
04/17/2022 05:38 AM 1,409,024 BACKUP_DB_UCAS_S_8704_P_1_T_1102225117
04/17/2022 05:38 AM 98,304 BACKUP_DB_UCAS_S_8705_P_1_T_1102225119
04/17/2022 05:42 AM 13,991,936 BACKUP_STBY_CFILE.G20R57TL_1_1
09/06/2019 03:29 PM 12,989 CTL.SQL
06/02/2021 10:34 PM 229 med.par
01/14/2019 06:40 PM 626,744 pscp.exe
01/22/2019 08:25 PM 1,190 Restore.par
07/22/2018 05:32 PM 222 Restore_d.par
18 File(s) 7,535,819,370 bytes
2 Dir(s) 186,392,072,192 bytes free
F:\UCAS_Backup>pscp.exe BACKUP* oracle@test-machine02:/u01/db_pump
oracle@test-machine02's password:
BACKUP_ARCHIVE_DB_UCAS_S_ | 478181 kB | 469.3 kB/s | ETA: 00:00:00 | 100%
BACKUP_ARCHIVE_DB_UCAS_S_ | 504663 kB | 452.2 kB/s | ETA: 00:00:00 | 100%
BACKUP_ARCHIVE_DB_UCAS_S_ | 386400 kB | 517.3 kB/s | ETA: 00:00:00 | 100%
BACKUP_ARCHIVE_DB_UCAS_S_ | 179536 kB | 473.7 kB/s | ETA: 00:00:00 | 100%
BACKUP_ARCHIVE_DB_UCAS_S_ | 30 kB | 30.5 kB/s | ETA: 00:00:00 | 100%
BACKUP_DB_UCAS_S_8701_P_1 | 2338552 kB | 450.5 kB/s | ETA: 00:00:00 | 100%
BACKUP_DB_UCAS_S_8702_P_1 | 2091808 kB | 469.2 kB/s | ETA: 00:00:00 | 100%
BACKUP_DB_UCAS_S_8703_P_1 | 1364264 kB | 439.7 kB/s | ETA: 00:00:00 | 100%
BACKUP_DB_UCAS_S_8704_P_1 | 1376 kB | 275.2 kB/s | ETA: 00:00:00 | 100%
BACKUP_DB_UCAS_S_8705_P_1 | 96 kB | 96.0 kB/s | ETA: 00:00:00 | 100%
BACKUP_STBY_CFILE.G20R57T | 13664 kB | 290.7 kB/s | ETA: 00:00:00 | 100%
F:\UCAS_Backup>
F:\UCAS_Backup>
F:\UCAS_Backup>
##################################### Standby DB ###########################################
[oracle@test-machine02 db_pump]$
[oracle@test-machine02 db_pump]$
[oracle@test-machine02 db_pump]$ pwd
/u01/db_pump
[oracle@test-machine02 db_pump]$ ps -ef|grep pmon
oracle 145921 130381 0 14:31 pts/1 00:00:00 grep --color=auto pmon
[oracle@test-machine02 db_pump]$
[oracle@test-machine02 db_pump]$ . oraenv
ORACLE_SID = [oracle] ? ucas
The Oracle base has been set to /u01/app/oracle
[oracle@test-machine02 db_pump]$
[oracle@test-machine02 db_pump]$
[oracle@test-machine02 db_pump]$ sqlplus sys as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun Apr 17 14:31:55 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter password:
Connected to an idle instance.
SQL> SQL> SQL>
SQL>
SQL> startup nomount
ORACLE instance started.
Total System Global Area 1.0456E+10 bytes
Fixed Size 2262368 bytes
Variable Size 2248149664 bytes
Database Buffers 8187281408 bytes
Redo Buffers 17948672 bytes
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@test-machine02 db_pump]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 17-APR-2022 14:33:09
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test-machine02)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@test-machine02 db_pump]$
[oracle@test-machine02 db_pump]$
[oracle@test-machine02 db_pump]$ lsnrctl staart
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 17-APR-2022 14:33:18
Copyright (c) 1991, 2013, Oracle. All rights reserved.
NL-00853: undefined command "staart". Try "help"
[oracle@test-machine02 db_pump]$
[oracle@test-machine02 db_pump]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 17-APR-2022 14:33:21
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.2.0.4/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0.4/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/test-machine02/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test-machine02)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test-machine02)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 17-APR-2022 14:33:29
Uptime 0 days 0 hr. 0 min. 28 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0.4/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/test-machine02/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test-machine02)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "ucas" has 1 instance(s).
Instance "ucas", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@test-machine02 db_pump]$ rman auxiliary sys/pass123@ucasdr
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Apr 17 14:37:22 2022
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to auxiliary database: UCAS (not mounted)
RMAN> exit
Recovery Manager complete.
[oracle@test-machine02 db_pump]$ tnsping ucasdr
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 17-APR-2022 14:37:33
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = test-machine02)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = ucas) (UR = A)))
OK (0 msec)
[oracle@test-machine02 db_pump]$
[oracle@test-machine02 db_pump]$ rman auxiliary sys/pass123@ucasdr
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Apr 17 14:37:39 2022
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to auxiliary database: UCAS (not mounted)
RMAN> run {
allocate auxiliary channel prmy1 type disk;
allocate auxiliary channel prmy2 type disk;
allocate auxiliary channel prmy3 type disk;
duplicate database 'ucas' for standby backup location '/u01/db_pump' NOFILENAMECHECK;
}2> 3> 4> 5> 6>
allocated channel: prmy1
channel prmy1: SID=197 device type=DISK
allocated channel: prmy2
channel prmy2: SID=391 device type=DISK
allocated channel: prmy3
channel prmy3: SID=586 device type=DISK
Starting Duplicate Db at 17-APR-22
contents of Memory Script:
{
restore clone standby controlfile from '/u01/db_pump/BACKUP_STBY_CFILE.G20R57TL_1_1';
}
executing Memory Script
Starting restore at 17-APR-22
channel prmy2: skipped, AUTOBACKUP already found
channel prmy3: skipped, AUTOBACKUP already found
channel prmy1: restoring control file
channel prmy1: restore complete, elapsed time: 00:00:10
output file name=/data01/oradata_1/control01.ctl
output file name=/data02/oradata_1/control02.ctl
Finished restore at 17-APR-22
contents of Memory Script:
{
sql clone 'alter database mount standby database';
}
executing Memory Script
sql statement: alter database mount standby database
contents of Memory Script:
{
set newname for tempfile 1 to
"/data01/oradata_2/TEMP01.DBF";
switch clone tempfile all;
set newname for datafile 1 to
"/data01/oradata_2/SYSTEM01.DBF";
set newname for datafile 2 to
"/data01/oradata_2/SYSAUX01.DBF";
set newname for datafile 3 to
"/data01/oradata_2/UNDOTBS01.DBF";
set newname for datafile 4 to
"/data01/oradata_2/USERS01.DBF";
set newname for datafile 5 to
"/data02/oradata_2/UCAS_01.DBF";
set newname for datafile 6 to
"/data02/oradata_2/UCAS_DATA_01.DBF";
set newname for datafile 7 to
"/data02/oradata_2/UCAS_INDEX_01.DBF";
set newname for datafile 8 to
"/data02/oradata_2/GGS_DATA_01.DBF";
set newname for datafile 9 to
"/data02/oradata_2/TELEX_01.DBF";
set newname for datafile 10 to
"/data02/oradata_2/UCAS_02.DBF";
set newname for datafile 11 to
"/data02/oradata_2/UCAS_DATA_02.DBF";
set newname for datafile 12 to
"/data02/oradata_2/UCAS_INDEX_02.DBF";
restore
clone database
;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /data01/oradata_2/TEMP01.DBF in control file
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 17-APR-22
channel prmy1: starting datafile backup set restore
channel prmy1: specifying datafile(s) to restore from backup set
channel prmy1: restoring datafile 00001 to /data01/oradata_2/SYSTEM01.DBF
channel prmy1: restoring datafile 00007 to /data02/oradata_2/UCAS_INDEX_01.DBF
channel prmy1: restoring datafile 00010 to /data02/oradata_2/UCAS_02.DBF
channel prmy1: restoring datafile 00012 to /data02/oradata_2/UCAS_INDEX_02.DBF
channel prmy1: reading from backup piece /u01/db_pump/BACKUP_DB_UCAS_S_8702_P_1_T_1102224961
channel prmy2: starting datafile backup set restore
channel prmy2: specifying datafile(s) to restore from backup set
channel prmy2: restoring datafile 00002 to /data01/oradata_2/SYSAUX01.DBF
channel prmy2: restoring datafile 00003 to /data01/oradata_2/UNDOTBS01.DBF
channel prmy2: restoring datafile 00006 to /data02/oradata_2/UCAS_DATA_01.DBF
channel prmy2: restoring datafile 00008 to /data02/oradata_2/GGS_DATA_01.DBF
channel prmy2: reading from backup piece /u01/db_pump/BACKUP_DB_UCAS_S_8703_P_1_T_1102224961
channel prmy3: starting datafile backup set restore
channel prmy3: specifying datafile(s) to restore from backup set
channel prmy3: restoring datafile 00004 to /data01/oradata_2/USERS01.DBF
channel prmy3: restoring datafile 00005 to /data02/oradata_2/UCAS_01.DBF
channel prmy3: restoring datafile 00009 to /data02/oradata_2/TELEX_01.DBF
channel prmy3: restoring datafile 00011 to /data02/oradata_2/UCAS_DATA_02.DBF
channel prmy3: reading from backup piece /u01/db_pump/BACKUP_DB_UCAS_S_8701_P_1_T_1102224961
channel prmy2: piece handle=/u01/db_pump/BACKUP_DB_UCAS_S_8703_P_1_T_1102224961 tag=FULL BACKUP
channel prmy2: restored backup piece 1
channel prmy2: restore complete, elapsed time: 00:04:35
channel prmy1: piece handle=/u01/db_pump/BACKUP_DB_UCAS_S_8702_P_1_T_1102224961 tag=FULL BACKUP
channel prmy1: restored backup piece 1
channel prmy1: restore complete, elapsed time: 00:07:05
channel prmy3: piece handle=/u01/db_pump/BACKUP_DB_UCAS_S_8701_P_1_T_1102224961 tag=FULL BACKUP
channel prmy3: restored backup piece 1
channel prmy3: restore complete, elapsed time: 00:07:25
Finished restore at 17-APR-22
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=1102257933 file name=/data01/oradata_2/SYSTEM01.DBF
datafile 2 switched to datafile copy
input datafile copy RECID=2 STAMP=1102257933 file name=/data01/oradata_2/SYSAUX01.DBF
datafile 3 switched to datafile copy
input datafile copy RECID=3 STAMP=1102257933 file name=/data01/oradata_2/UNDOTBS01.DBF
datafile 4 switched to datafile copy
input datafile copy RECID=4 STAMP=1102257933 file name=/data01/oradata_2/USERS01.DBF
datafile 5 switched to datafile copy
input datafile copy RECID=5 STAMP=1102257933 file name=/data02/oradata_2/UCAS_01.DBF
datafile 6 switched to datafile copy
input datafile copy RECID=6 STAMP=1102257933 file name=/data02/oradata_2/UCAS_DATA_01.DBF
datafile 7 switched to datafile copy
input datafile copy RECID=7 STAMP=1102257933 file name=/data02/oradata_2/UCAS_INDEX_01.DBF
datafile 8 switched to datafile copy
input datafile copy RECID=8 STAMP=1102257933 file name=/data02/oradata_2/GGS_DATA_01.DBF
datafile 9 switched to datafile copy
input datafile copy RECID=9 STAMP=1102257933 file name=/data02/oradata_2/TELEX_01.DBF
datafile 10 switched to datafile copy
input datafile copy RECID=10 STAMP=1102257933 file name=/data02/oradata_2/UCAS_02.DBF
datafile 11 switched to datafile copy
input datafile copy RECID=11 STAMP=1102257933 file name=/data02/oradata_2/UCAS_DATA_02.DBF
datafile 12 switched to datafile copy
input datafile copy RECID=12 STAMP=1102257933 file name=/data02/oradata_2/UCAS_INDEX_02.DBF
Finished Duplicate Db at 17-APR-22
released channel: prmy1
released channel: prmy2
released channel: prmy3
RMAN>
RMAN>
[oracle@test-machine02 db_pump]$
[oracle@test-machine02 db_pump]$ sqlplus sys as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun Apr 17 14:46:57 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select status from v$instance;
STATUS
------------
MOUNTED
SQL>
SQL>
SQL> select name from v$controlfile;
NAME
--------------------------------------------------------------------------------
/data01/oradata_1/control01.ctl
/data02/oradata_1/control02.ctl
SQL>
SQL> set lines 300
SQL> set pages 300
SQL> select name from v$datafile;
NAME
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/data01/oradata_2/SYSTEM01.DBF
/data01/oradata_2/SYSAUX01.DBF
/data01/oradata_2/UNDOTBS01.DBF
/data01/oradata_2/USERS01.DBF
/data02/oradata_2/UCAS_01.DBF
/data02/oradata_2/UCAS_DATA_01.DBF
/data02/oradata_2/UCAS_INDEX_01.DBF
/data02/oradata_2/GGS_DATA_01.DBF
/data02/oradata_2/TELEX_01.DBF
/data02/oradata_2/UCAS_02.DBF
/data02/oradata_2/UCAS_DATA_02.DBF
/data02/oradata_2/UCAS_INDEX_02.DBF
12 rows selected.
SQL> select name from v$tempfile;
NAME
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/data01/oradata_2/TEMP01.DBF
SQL>
SQL> col member for a50
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ ---------
4 1 0 524288000 512 1 YES UNUSED 1.4961E+10 16-APR-22 1.4963E+10 17-APR-22
7 1 0 524288000 512 1 NO CURRENT 1.4963E+10 17-APR-22 2.8147E+14
6 1 0 524288000 512 1 YES UNUSED 1.4963E+10 17-APR-22 1.4963E+10 17-APR-22
5 1 0 524288000 512 1 YES UNUSED 1.4963E+10 17-APR-22 1.4963E+10 17-APR-22
SQL>
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- -------------------------------------------------- ---
8 STANDBY /data02/oradata_1/STDBY_REDO08.LOG NO
9 STANDBY /data02/oradata_1/STDBY_REDO09.LOG NO
10 STANDBY /data01/oradata_1/STDBY_REDO10.LOG NO
4 ONLINE /data02/oradata_1/REDO04.LOG NO
5 ONLINE /data02/oradata_1/REDO05.LOG NO
6 ONLINE /data01/oradata_1/REDO06.LOG NO
7 ONLINE /data01/oradata_1/REDO07.LOG NO
11 STANDBY /data01/oradata_1/STDBY_REDO11.LOG NO
12 STANDBY /data01/oradata_1/STDBY_REDO12.LOG NO
9 rows selected.
SQL>
SQL>
SQL> alter database recover managed standby database using current logfile disconnect from session;
Database altered.
SQL> set lines 200
set pages 200
select inst_id,process,status,client_process,THREAD#,sequence#,block#,active_agents,known_agents from gv$managed_standby where PROCESS like 'MRP%' or client_process like 'LGWR';
SQL> SQL>
INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS
---------- --------- ------------ -------- ---------- ---------- ---------- ------------- ------------
1 MRP0 WAIT_FOR_LOG N/A 1 10998 0 5 5
SQL>
SQL> /
INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS
---------- --------- ------------ -------- ---------- ---------- ---------- ------------- ------------
1 MRP0 WAIT_FOR_LOG N/A 1 10998 0 5 5
[oracle@test-machine02 trace]$ cd /u01/app/oracle/diag/rdbms/ucasdr/ucas/trace
[oracle@test-machine02 trace]$ pwd
/u01/app/oracle/diag/rdbms/ucasdr/ucas/trace
[oracle@test-machine02 trace]$
[oracle@test-machine02 trace]$ vi alert_ucas.log
Parallel Media Recovery started with 4 slaves
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Media Recovery Waiting for thread 1 sequence 10998
Completed: alter database recover managed standby database using current logfile disconnect from session
Sun Apr 17 14:56:40 2022
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
FAL[client, USER]: Error 16191 connecting to ucas for fetching gap sequence
"alert_ucas.log" 1114L, 48509C
##################################### Primary DB ###########################################
SQL>
SQL> alter system set log_archive_dest_state_2=defer;
System altered.
SQL> set lines 300
SQL> col destination for a40
SQL> col error for a20
SQL> select inst_id, dest_id "ID",destination,status,error,target,
2 schedule,process,mountid mid
3 from gv$archive_dest
4 where dest_id < 4
5 order by dest_id;
INST_ID ID DESTINATION STATUS ERROR TARGET SCHEDULE PROCESS MID
---------- ---------- ---------------------------------------- --------- -------------------- ------- -------- ---------- ----------
1 1 I:\FLASH_RECOVERY_AREA\UCAS\ARCHIVELOG VALID PRIMARY ACTIVE ARCH 0
1 2 ucasdr DEFERRED STANDBY ACTIVE LGWR 0
1 3 INACTIVE PRIMARY INACTIVE ARCH 0
SQL>
SQL> alter system set log_archive_dest_state_2=enable;
System altered.
SQL>
##################################### Standby DB ###########################################
SQL>
SQL> alter database recover managed standby database cancel;
Database altered.
SQL> alter database recover managed standby database using current logfile disconnect from session;
Database altered.
SQL> set lines 200
set pages 200
select inst_id,process,status,client_process,THREAD#,sequence#,block#,active_agents,known_agents from gv$managed_standby where PROCESS like 'MRP%' or client_process like 'LGWR';
SQL> SQL>
INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS
---------- --------- ------------ -------- ---------- ---------- ---------- ------------- ------------
1 MRP0 WAIT_FOR_LOG N/A 1 10998 0 5 5
SQL>
##################################### Primary DB ###########################################
F:\Oracle\app\product\11.2.0.4\db_1\database>
F:\Oracle\app\product\11.2.0.4\db_1\database>orapwd file=PWDucas.ora password=pass123 entries=5 ignorecase=Y
F:\Oracle\app\product\11.2.0.4\db_1\database>
##################################### Standby DB ###########################################
SQL> alter database recover managed standby database cancel;
Database altered.
SQL>
[oracle@test-machine02 dbs]$
[oracle@test-machine02 dbs]$ orapwd file=orapwucas password=pass123 entries=5 ignorecase=Y
[oracle@test-machine02 dbs]$
SQL> alter database recover managed standby database using current logfile disconnect from session;
Database altered.
SQL>
[oracle@test-machine02 archivelog]$
[oracle@test-machine02 archivelog]$ cd /u01/app/oracle/diag/rdbms/ucasdr/ucas/trace
[oracle@test-machine02 trace]$
[oracle@test-machine02 trace]$ vi alert_ucas.log
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Media Recovery Waiting for thread 1 sequence 10998
Completed: alter database recover managed standby database using current logfile disconnect from session
Sun Apr 17 15:12:50 2022
RFS[1]: Assigned to RFS process 148293
RFS[1]: Opened log for thread 1 sequence 11001 dbid 2026517590 branch 1019388628
Archived Log entry 1 added for thread 1 sequence 11001 rlc 1019388628 ID 0x78ca2e07 dest 2:
Sun Apr 17 15:12:51 2022
RFS[2]: Assigned to RFS process 148295
RFS[2]: Opened log for thread 1 sequence 11000 dbid 2026517590 branch 1019388628
Sun Apr 17 15:12:51 2022
RFS[3]: Assigned to RFS process 148299
RFS[3]: Opened log for thread 1 sequence 10998 dbid 2026517590 branch 1019388628
Sun Apr 17 15:12:51 2022
RFS[4]: Assigned to RFS process 148297
RFS[4]: Opened log for thread 1 sequence 10999 dbid 2026517590 branch 1019388628
RFS[1]: Opened log for thread 1 sequence 11002 dbid 2026517590 branch 1019388628
Archived Log entry 2 added for thread 1 sequence 11000 rlc 1019388628 ID 0x78ca2e07 dest 2:
Archived Log entry 3 added for thread 1 sequence 10999 rlc 1019388628 ID 0x78ca2e07 dest 2:
RFS[2]: Opened log for thread 1 sequence 11003 dbid 2026517590 branch 1019388628
Archived Log entry 4 added for thread 1 sequence 11002 rlc 1019388628 ID 0x78ca2e07 dest 2:
RFS[4]: Opened log for thread 1 sequence 11004 dbid 2026517590 branch 1019388628
Archived Log entry 5 added for thread 1 sequence 11003 rlc 1019388628 ID 0x78ca2e07 dest 2:
RFS[1]: Opened log for thread 1 sequence 11005 dbid 2026517590 branch 1019388628
RFS[2]: Selected log 8 for thread 1 sequence 11006 dbid 2026517590 branch 1019388628
Sun Apr 17 15:12:53 2022
Primary database is in MAXIMUM PERFORMANCE mode
RFS[5]: Assigned to RFS process 148303
RFS[5]: Selected log 9 for thread 1 sequence 11007 dbid 2026517590 branch 1019388628
Archived Log entry 6 added for thread 1 sequence 11005 rlc 1019388628 ID 0x78ca2e07 dest 2:
Sun Apr 17 15:13:06 2022
Archived Log entry 7 added for thread 1 sequence 11006 ID 0x78ca2e07 dest 1:
"alert_ucas.log" 1203L, 53377C
[oracle@test-machine02 ~]$
[oracle@test-machine02 ~]$ sqlplus sys as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 18 16:48:10 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
SQL>
set lines 200
set pages 200
select inst_id,process,status,client_process,THREAD#,sequence#,block#,active_agents,known_agents from gv$managed_standby where PROCESS like 'MRP%' or client_process like 'LGWR';
SQL> SQL> SQL>
INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS
---------- --------- ------------ -------- ---------- ---------- ---------- ------------- ------------
1 MRP0 WAIT_FOR_LOG N/A 1 10998 0 5 5
1 RFS IDLE LGWR 1 11007 22 0 0
SQL> SQL> /
INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS
---------- --------- ------------ -------- ---------- ---------- ---------- ------------- ------------
1 MRP0 WAIT_FOR_LOG N/A 1 10998 0 5 5
1 RFS IDLE LGWR 1 11007 26 0 0
SQL> /
INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS
---------- --------- ------------ -------- ---------- ---------- ---------- ------------- ------------
1 MRP0 WAIT_FOR_LOG N/A 1 10998 0 5 5
1 RFS IDLE LGWR 1 11007 29 0 0
SQL>
##################################### Primary DB ###########################################
C:\Users\jkhan>rman target sys/pass123
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Apr 17 16:18:12 2022
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: UCAS (DBID=2026517590)
RMAN>
RMAN>
RMAN>
RMAN> backup as compressed backupset archivelog from sequence 10998 until sequence 11014 format 'F:\UCAS_Backup\archive_db_%d_S_%s_P_%p_T_%t';
Starting backup at 17-APR-22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=122 device type=DISK
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=10998 RECID=22075 STAMP=1102225346
input archived log thread=1 sequence=10999 RECID=22077 STAMP=1102225382
input archived log thread=1 sequence=11000 RECID=22079 STAMP=1102225419
input archived log thread=1 sequence=11001 RECID=22081 STAMP=1102225420
input archived log thread=1 sequence=11002 RECID=22083 STAMP=1102225420
input archived log thread=1 sequence=11003 RECID=22085 STAMP=1102225478
input archived log thread=1 sequence=11004 RECID=22088 STAMP=1102258201
input archived log thread=1 sequence=11005 RECID=22089 STAMP=1102258812
input archived log thread=1 sequence=11006 RECID=22096 STAMP=1102259392
input archived log thread=1 sequence=11007 RECID=22099 STAMP=1102259762
input archived log thread=1 sequence=11008 RECID=22101 STAMP=1102260518
input archived log thread=1 sequence=11009 RECID=22103 STAMP=1102260924
input archived log thread=1 sequence=11010 RECID=22105 STAMP=1102261675
input archived log thread=1 sequence=11011 RECID=22107 STAMP=1102262044
input archived log thread=1 sequence=11012 RECID=22109 STAMP=1102262432
input archived log thread=1 sequence=11013 RECID=22111 STAMP=1102262801
input archived log thread=1 sequence=11014 RECID=22113 STAMP=1102263246
channel ORA_DISK_1: starting piece 1 at 17-APR-22
channel ORA_DISK_1: finished piece 1 at 17-APR-22
piece handle=F:\UCAS_BACKUP\ARCHIVE_DB_UCAS_S_8716_P_1_T_1102263513 tag=TAG20220417T161833 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 17-APR-22
RMAN> exit
Recovery Manager complete.
F:\UCAS_Backup>
F:\UCAS_Backup>
F:\UCAS_Backup>pscp.exe ARCHIVE* oracle@test-machine02:/u01/db_pump
oracle@test-machine02's password:
ARCHIVE_DB_UCAS_S_8716_P_ | 44656 kB | 388.3 kB/s | ETA: 00:00:00 | 100%
F:\UCAS_Backup>
F:\UCAS_Backup>
##################################### Standby DB ###########################################
[oracle@test-machine02 archive]$ pwd
/u01/db_pump/archive
[oracle@test-machine02 archive]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Apr 17 16:27:26 2022
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: UCAS (DBID=2026517590, not open)
RMAN>
RMAN> CATALOG BACKUPPIECE '/u01/db_pump/ARCHIVE_DB_UCAS_S_8716_P_1_T_1102263513';
Starting implicit crosscheck backup at 17-APR-22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=391 device type=DISK
Crosschecked 11 objects
Finished implicit crosscheck backup at 17-APR-22
Starting implicit crosscheck copy at 17-APR-22
using channel ORA_DISK_1
Finished implicit crosscheck copy at 17-APR-22
searching for all files in the recovery area
cataloging files...
no files cataloged
cataloged backup piece
backup piece handle=/u01/db_pump/ARCHIVE_DB_UCAS_S_8716_P_1_T_1102263513 RECID=12 STAMP=1102264055
RMAN> run {
set archivelog destination to '/u01/db_pump/archive';
restore archivelog from logseq=10998 until logseq=11014 thread=1;
}2> 3> 4>
executing command: SET ARCHIVELOG DESTINATION
Starting restore at 17-APR-22
using channel ORA_DISK_1
archived log for thread 1 with sequence 10999 is already on disk as file /backup/fast_recovery_area/ucas/archivelog/log_10999_1_1019388628.arc
archived log for thread 1 with sequence 11000 is already on disk as file /backup/fast_recovery_area/ucas/archivelog/log_11000_1_1019388628.arc
archived log for thread 1 with sequence 11001 is already on disk as file /backup/fast_recovery_area/ucas/archivelog/log_11001_1_1019388628.arc
archived log for thread 1 with sequence 11002 is already on disk as file /backup/fast_recovery_area/ucas/archivelog/log_11002_1_1019388628.arc
archived log for thread 1 with sequence 11003 is already on disk as file /backup/fast_recovery_area/ucas/archivelog/log_11003_1_1019388628.arc
archived log for thread 1 with sequence 11005 is already on disk as file /backup/fast_recovery_area/ucas/archivelog/log_11005_1_1019388628.arc
archived log for thread 1 with sequence 11006 is already on disk as file /backup/fast_recovery_area/ucas/archivelog/log_11006_1_1019388628.arc
archived log for thread 1 with sequence 11007 is already on disk as file /backup/fast_recovery_area/ucas/archivelog/log_11007_1_1019388628.arc
archived log for thread 1 with sequence 11008 is already on disk as file /backup/fast_recovery_area/ucas/archivelog/log_11008_1_1019388628.arc
archived log for thread 1 with sequence 11009 is already on disk as file /backup/fast_recovery_area/ucas/archivelog/log_11009_1_1019388628.arc
archived log for thread 1 with sequence 11010 is already on disk as file /backup/fast_recovery_area/ucas/archivelog/log_11010_1_1019388628.arc
archived log for thread 1 with sequence 11011 is already on disk as file /backup/fast_recovery_area/ucas/archivelog/log_11011_1_1019388628.arc
archived log for thread 1 with sequence 11012 is already on disk as file /backup/fast_recovery_area/ucas/archivelog/log_11012_1_1019388628.arc
archived log for thread 1 with sequence 11013 is already on disk as file /backup/fast_recovery_area/ucas/archivelog/log_11013_1_1019388628.arc
archived log for thread 1 with sequence 11014 is already on disk as file /backup/fast_recovery_area/ucas/archivelog/log_11014_1_1019388628.arc
channel ORA_DISK_1: starting archived log restore to user-specified destination
archived log destination=/u01/db_pump/archive
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=10998
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=11004
channel ORA_DISK_1: reading from backup piece /u01/db_pump/ARCHIVE_DB_UCAS_S_8716_P_1_T_1102263513
channel ORA_DISK_1: piece handle=/u01/db_pump/ARCHIVE_DB_UCAS_S_8716_P_1_T_1102263513 tag=TAG20220417T161833
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
Finished restore at 17-APR-22
RMAN> run {
set archivelog destination to '/u01/db_pump/archive';
restore archivelog from logseq=10998 until logseq=11014 thread=1 force;
}2> 3> 4>
executing command: SET ARCHIVELOG DESTINATION
Starting restore at 17-APR-22
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log restore to user-specified destination
archived log destination=/u01/db_pump/archive
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=10998
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=10999
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=11000
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=11001
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=11002
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=11003
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=11004
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=11005
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=11006
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=11007
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=11008
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=11009
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=11010
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=11011
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=11012
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=11013
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=11014
channel ORA_DISK_1: reading from backup piece /u01/db_pump/ARCHIVE_DB_UCAS_S_8716_P_1_T_1102263513
channel ORA_DISK_1: piece handle=/u01/db_pump/ARCHIVE_DB_UCAS_S_8716_P_1_T_1102263513 tag=TAG20220417T161833
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
Finished restore at 17-APR-22
RMAN>
SQL>
SQL> alter database recover managed standby database cancel;
Database altered.
SQL> alter database register logfile '/u01/db_pump/archive/log_11010_1_1019388628.arc';
alter database register logfile '/u01/db_pump/archive/log_11010_1_1019388628.arc'
*
ERROR at line 1:
ORA-16089: archive log has already been registered
SQL> alter database register or replace logfile '/u01/db_pump/archive/log_11010_1_1019388628.arc';
alter database register or replace logfile '/u01/db_pump/archive/log_11014_1_1019388628.arc';
alter database register or replace logfile '/u01/db_pump/archive/log_11005_1_1019388628.arc';
alter database register or replace logfile '/u01/db_pump/archive/log_11009_1_1019388628.arc';
alter database register or replace logfile '/u01/db_pump/archive/log_11012_1_1019388628.arc';
alter database register or replace logfile '/u01/db_pump/archive/log_11011_1_1019388628.arc';
alter database register or replace logfile '/u01/db_pump/archive/log_11007_1_1019388628.arc';
alter database register or replace logfile '/u01/db_pump/archive/log_11003_1_1019388628.arc';
alter database register or replace logfile '/u01/db_pump/archive/log_11013_1_1019388628.arc';
alter database register or replace logfile '/u01/db_pump/archive/log_11000_1_1019388628.arc';
alter database register or replace logfile '/u01/db_pump/archive/log_10999_1_1019388628.arc';
alter database register or replace logfile '/u01/db_pump/archive/log_11001_1_1019388628.arc';
alter database register or replace logfile '/u01/db_pump/archive/log_11006_1_1019388628.arc';
alter database register or replace logfile '/u01/db_pump/archive/log_11008_1_1019388628.arc';
alter database register or replace logfile '/u01/db_pump/archive/log_11002_1_1019388628.arc';
alter database register or replace logfile '/u01/db_pump/archive/log_10998_1_1019388628.arc';
alter database register or replace logfile '/u01/db_pump/archive/log_11004_1_1019388628.arc';
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> alter database recover managed standby database using current logfile disconnect from session;
Database altered.
SQL> set lines 200
set pages 200
select inst_id,process,status,client_process,THREAD#,sequence#,block#,active_agents,known_agents from gv$managed_standby where PROCESS like 'MRP%' or client_process like 'LGWR';
SQL> SQL>
INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS
---------- --------- ------------ -------- ---------- ---------- ---------- ------------- ------------
1 MRP0 APPLYING_LOG N/A 1 11005 1576 5 5
1 RFS IDLE LGWR 1 11015 1326 0 0
SQL> /
INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS
---------- --------- ------------ -------- ---------- ---------- ---------- ------------- ------------
1 MRP0 APPLYING_LOG N/A 1 11005 1576 5 5
1 RFS IDLE LGWR 1 11015 1329 0 0
SQL> /
INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS
---------- --------- ------------ -------- ---------- ---------- ---------- ------------- ------------
1 MRP0 APPLYING_LOG N/A 1 11005 1576 5 5
1 RFS IDLE LGWR 1 11015 1330 0 0
SQL> /
INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS
---------- --------- ------------ -------- ---------- ---------- ---------- ------------- ------------
1 MRP0 APPLYING_LOG N/A 1 11005 1576 5 5
1 RFS IDLE LGWR 1 11015 1331 0 0
SQL> /
INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS
---------- --------- ------------ -------- ---------- ---------- ---------- ------------- ------------
1 MRP0 APPLYING_LOG N/A 1 11005 1576 5 5
1 RFS IDLE LGWR 1 11015 1332 0 0
SQL> /
INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS
---------- --------- ------------ -------- ---------- ---------- ---------- ------------- ------------
1 MRP0 APPLYING_LOG N/A 1 11015 1354 5 5
1 RFS IDLE LGWR 1 11015 1354 0 0
SQL> /
INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS
---------- --------- ------------ -------- ---------- ---------- ---------- ------------- ------------
1 MRP0 APPLYING_LOG N/A 1 11015 1355 5 5
1 RFS IDLE LGWR 1 11015 1355 0 0
SQL> /
INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS
---------- --------- ------------ -------- ---------- ---------- ---------- ------------- ------------
1 MRP0 APPLYING_LOG N/A 1 11015 1355 5 5
1 RFS IDLE LGWR 1 11015 1355 0 0
SQL> /
INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS
---------- --------- ------------ -------- ---------- ---------- ---------- ------------- ------------
1 MRP0 APPLYING_LOG N/A 1 11015 1356 5 5
1 RFS IDLE LGWR 1 11015 1356 0 0
SQL> /
INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS
---------- --------- ------------ -------- ---------- ---------- ---------- ------------- ------------
1 MRP0 APPLYING_LOG N/A 1 11015 1357 5 5
1 RFS IDLE LGWR 1 11015 1357 0 0
SQL>
SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;
PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS
--------- ------------ ---------- ---------- ---------- ----------
ARCH CLOSING 1 11013 2048 1312
ARCH CONNECTED 0 0 0 0
ARCH CLOSING 1 11015 1 1429
ARCH CLOSING 1 11011 1 398
ARCH CLOSING 1 11012 1 434
MRP0 APPLYING_LOG 1 11016 58 1024000
RFS IDLE 0 0 0 0
RFS IDLE 1 11016 58 1
8 rows selected.
SQL>
##################################### Primary DB ###########################################
SQL> set lines 300
SQL> col destination for a40
SQL> col error for a20
SQL> select inst_id, dest_id "ID",destination,status,error,target,
2 schedule,process,mountid mid
3 from gv$archive_dest
4 where dest_id < 4
5 order by dest_id;
INST_ID ID DESTINATION STATUS ERROR TARGET SCHEDULE PROCESS MID
---------- ---------- ---------------------------------------- --------- -------------------- ------- -------- ---------- ----------
1 1 I:\FLASH_RECOVERY_AREA\UCAS\ARCHIVELOG VALID PRIMARY ACTIVE ARCH 0
1 2 ucasdr VALID STANDBY ACTIVE LGWR 0
1 3 INACTIVE PRIMARY INACTIVE ARCH 0
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> set lines 200
SQL> set pages 200
SQL> select inst_id,process,status,client_process,THREAD#,sequence#,block#,active_agents,known_agents from gv$managed_standby where PROCESS like '%LNS
%' or client_process like 'LGWR';
INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS
---------- --------- ------------ -------- ---------- ---------- ---------- ------------- ------------
1 LNS WRITING LNS 1 11016 113 0 0
SQL>
SQL>