##################################### 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>