select to_char(current_scn) from v$database; SQL> select to_char(current_scn) from v$database; TO_CHAR(CURRENT_SCN) ---------------------------------------- 13778257403 SQL> SQL> alter database open; alter database open * ERROR at line 1: ORA-10458: standby database requires recovery ORA-01196: file 1 is inconsistent due to a failed media recovery session ORA-01110: data file 1: 'K:\UCASII\ORADATA_2\O1_MF_SYSTEM_GMYLZ22B_.DBF' SQL> SQL> set lines 300 SQL> set pages 300 SQL> SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------------------- K:\UCASII\ORADATA_2\O1_MF_SYSTEM_GMYLZ22B_.DBF'; K:\UCASII\ORADATA_2\O1_MF_SYSAUX_GMYLZ1FG_.DBF'; K:\UCASII\ORADATA_2\O1_MF_UNDOTBS1_GMYLYYSY_.DBF'; K:\UCASII\ORADATA_2\O1_MF_USERS_GMYLZ57R_.DBF'; K:\UCASII\ORADATA_2\O1_MF_UCAS_GMYLYYSO_.DBF'; K:\UCASII\ORADATA_2\O1_MF_UCAS_GMYLYYSD_.DBF'; K:\UCASII\ORADATA_2\O1_MF_UCAS_DAT_GMYLZ3DM_.DBF'; K:\UCASII\ORADATA_2\O1_MF_UCAS_DAT_GMYLZ2OT_.DBF'; K:\UCASII\ORADATA_2\O1_MF_UCAS_IND_GMYLZ1GN_.DBF'; K:\UCASII\ORADATA_2\O1_MF_UCAS_IND_GMYLYYY1_.DBF'; N:\UCASII\ORADATA_2\O1_MF_GGS_DATA_GMYLZ4MQ_.DBF'; N:\UCASII\ORADATA_2\O1_MF_TELEX_GMYLZ3G1_.DBF'; N:\UCASII\ORADATA_2\O1_MF_UCAS_NEW_GMYLZ559_.DBF'; N:\UCASII\ORADATA_2\O1_MF_UCAS_NEW_GMYLYYX0_.DBF'; N:\UCASII\ORADATA_2\O1_MF_UCAS_DAT_GMYLZ3CF_.DBF'; N:\UCASII\ORADATA_2\O1_MF_UCAS_GMYLYYTG_.DBF'; N:\UCASII\ORADATA_2\O1_MF_UCAS_GMYLYYT3_.DBF'; N:\UCASII\ORADATA_2\O1_MF_UCAS_GMYLZ0SQ_.DBF'; N:\UCASII\ORADATA_2\O1_MF_UCAS_GMYLZ4KP_.DBF'; 19 rows selected. SQL> SQL> select name from v$tempfile; NAME -------------------------------------------------------------------------------------------- K:\UCASII\ORADATA_2\O1_MF_TEMP_GN0FWZC2_.TMP'; K:\UCASII\ORADATA_2\O1_MF_TEMP_1_GN0FZQ36_.TMP'; SQL> SQL> select member from v$logfile; MEMBER -------------------------------------------------------------------------------------------- M:\FLASH_RECOVERY_AREA\UCASIIDR\ONLINELOG\O1_MF_5_H0STJTFS_.LOG M:\FLASH_RECOVERY_AREA\UCASIIDR\ONLINELOG\O1_MF_4_H0STJQRJ_.LOG M:\FLASH_RECOVERY_AREA\UCASIIDR\ONLINELOG\O1_MF_3_H0STJO5G_.LOG M:\FLASH_RECOVERY_AREA\UCASIIDR\ONLINELOG\O1_MF_2_H0STJLMZ_.LOG M:\FLASH_RECOVERY_AREA\UCASIIDR\ONLINELOG\O1_MF_1_H0STJKQR_.LOG M:\FLASH_RECOVERY_AREA\UCASIIDR\ONLINELOG\O1_MF_11_H0ST452J_.LOG M:\FLASH_RECOVERY_AREA\UCASIIDR\ONLINELOG\O1_MF_6_H0ST4530_.LOG M:\FLASH_RECOVERY_AREA\UCASIIDR\ONLINELOG\O1_MF_7_H0ST454G_.LOG M:\FLASH_RECOVERY_AREA\UCASIIDR\ONLINELOG\O1_MF_8_H0ST4CP6_.LOG M:\FLASH_RECOVERY_AREA\UCASIIDR\ONLINELOG\O1_MF_9_H0ST4CSN_.LOG M:\FLASH_RECOVERY_AREA\UCASIIDR\ONLINELOG\O1_MF_10_H0ST4K0Q_.LOG 11 rows selected. SQL> SQL> select name from v$controlfile; NAME --------------------------------------- F:\UCASII\ORADATA_1\CONTROL01.CTL G:\UCASII\ORADATA_1\CONTROL02.CTL SQL> SQL> SQL> show parameter convert NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_file_name_convert string /u02/app/oracle/oradata/ucasii /UCASDR/datafile/, K:\UCASII\O RADATA_2\, /u02/app/oracle/ora data/ucasii/UCASII/datafile/, K:\UCASII\ORADATA_2\ log_file_name_convert string /u03/app/oracle/redo/UCASDR/on linelog/, F:\UCASII\ORADATA_1\ , /u03/app/oracle/redo/UCASII/ onlinelog/, G:\UCASII\ORADATA_ 1\ SQL> alter system set db_file_name_convert='','','','' scope=spfile SQL> show parameter recovery NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string M:\FLASH_RECOVERY_AREA RMAN> run { allocate channel ch1 device type disk; allocate channel ch2 device type disk; backup as compressed backupset incremental from scn 13759890709 database format '/u01/DB_PUMP/ForStandby_%U' tag 'FORSTANDBY'; release channel ch1; release channel ch1; } allocated channel: ch1 channel ch1: SID=1149 device type=DISK allocated channel: ch1 channel ch2: SID=1150 device type=DISK Starting backup at 14-APR-21 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=205 device type=DISK channel ORA_DISK_1: starting compressed full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00003 name=/u02/app/oracle/oradata/ucasii/UCASDR/datafile/o1_mf_undotbs1_gmylyysy_.dbf input datafile file number=00006 name=/u02/app/oracle/oradata/ucasii/UCASDR/datafile/o1_mf_ucas_gmylyysd_.dbf input datafile file number=00005 name=/u02/app/oracle/oradata/ucasii/UCASDR/datafile/o1_mf_ucas_gmylyyso_.dbf input datafile file number=00016 name=/u02/app/oracle/oradata/ucasii/UCASDR/datafile/o1_mf_ucas_gmylyytg_.dbf input datafile file number=00017 name=/u02/app/oracle/oradata/ucasii/UCASDR/datafile/o1_mf_ucas_gmylyyt3_.dbf input datafile file number=00018 name=/u02/app/oracle/oradata/ucasii/UCASDR/datafile/o1_mf_ucas_gmylz0sq_.dbf input datafile file number=00019 name=/u02/app/oracle/oradata/ucasii/UCASDR/datafile/o1_mf_ucas_gmylz4kp_.dbf input datafile file number=00007 name=/u02/app/oracle/oradata/ucasii/UCASDR/datafile/o1_mf_ucas_dat_gmylz3dm_.dbf input datafile file number=00008 name=/u02/app/oracle/oradata/ucasii/UCASDR/datafile/o1_mf_ucas_dat_gmylz2ot_.dbf input datafile file number=00015 name=/u02/app/oracle/oradata/ucasii/UCASDR/datafile/o1_mf_ucas_dat_gmylz3cf_.dbf input datafile file number=00009 name=/u02/app/oracle/oradata/ucasii/UCASDR/datafile/o1_mf_ucas_ind_gmylz1gn_.dbf input datafile file number=00010 name=/u02/app/oracle/oradata/ucasii/UCASDR/datafile/o1_mf_ucas_ind_gmylyyy1_.dbf input datafile file number=00001 name=/u02/app/oracle/oradata/ucasii/UCASDR/datafile/o1_mf_system_gmylz22b_.dbf input datafile file number=00014 name=/u02/app/oracle/oradata/ucasii/UCASDR/datafile/o1_mf_ucas_new_gmylyyx0_.dbf input datafile file number=00013 name=/u02/app/oracle/oradata/ucasii/UCASDR/datafile/o1_mf_ucas_new_gmylz559_.dbf input datafile file number=00004 name=/u02/app/oracle/oradata/ucasii/UCASDR/datafile/o1_mf_users_gmylz57r_.dbf input datafile file number=00002 name=/u02/app/oracle/oradata/ucasii/UCASDR/datafile/o1_mf_sysaux_gmylz1fg_.dbf input datafile file number=00011 name=/u02/app/oracle/oradata/ucasii/UCASDR/datafile/o1_mf_ggs_data_gmylz4mq_.dbf input datafile file number=00012 name=/u02/app/oracle/oradata/ucasii/UCASDR/datafile/o1_mf_telex_gmylz3g1_.dbf channel ORA_DISK_1: starting piece 1 at 14-APR-21 channel ORA_DISK_1: finished piece 1 at 14-APR-21 piece handle=/u01/DB_PUMP/ForStandby_efvs9b6g_1_1 tag=FORSTANDBY comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:09:25 channel ORA_DISK_1: starting compressed full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set channel ORA_DISK_1: starting piece 1 at 14-APR-21 channel ORA_DISK_1: finished piece 1 at 14-APR-21 piece handle=/u01/DB_PUMP/ForStandby_egvs9bo5_1_1 tag=FORSTANDBY comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 Finished backup at 14-APR-21 released channel: ch1 released channel: ch2 RMAN> D:\UCAS_Backup> D:\UCAS_Backup>pscp.exe oracle@192.168.91.151:/u01/DB_PUMP/ForStandby* . oracle@192.168.91.151's password: ForStandby_efvs9b6g_1_1 | 5275136 kB | 16640.8 kB/s | ETA: 00:00:00 | 100% ForStandby_egvs9bo5_1_1 | 1360 kB | 1360.0 kB/s | ETA: 00:00:00 | 100% D:\UCAS_Backup> D:\UCAS_Backup> C:\Users\jkhan>rman target sys/ucas123 Recovery Manager: Release 11.2.0.4.0 - Production on Wed Apr 14 14:00:42 2021 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: UCASII (DBID=1353719689, not open) RMAN> catalog start with 'D:\UCAS_Backup\ForStandby*'; using target database control file instead of recovery catalog searching for all files that match the pattern D:\UCAS_Backup\ForStandby* List of Files Unknown to the Database ===================================== File Name: D:\UCAS_BACKUP\FORSTANDBY_EFVS9B6G_1_1 File Name: D:\UCAS_BACKUP\FORSTANDBY_EGVS9BO5_1_1 Do you really want to catalog the above files (enter YES or NO)? YES cataloging files... cataloging done List of Cataloged Files ======================= File Name: D:\UCAS_BACKUP\FORSTANDBY_EFVS9B6G_1_1 File Name: D:\UCAS_BACKUP\FORSTANDBY_EGVS9BO5_1_1 RMAN> RMAN> RMAN> run { 2> allocate channel ch1 device type disk; 3> allocate channel ch2 device type disk; 4> recover database noredo; 5> release channel ch1; 6> release channel ch1; 7> } allocated channel: ch1 channel ch1: SID=1441 device type=DISK allocated channel: ch2 channel ch2: SID=1489 device type=DISK Starting recover at 14-APR-21 channel ch1: starting incremental datafile backup set restore channel ch1: specifying datafile(s) to restore from backup set destination for restore of datafile 00001: K:\UCASII\ORADATA_2\O1_MF_SYSTEM_GMYLZ22B_.DBF destination for restore of datafile 00002: K:\UCASII\ORADATA_2\O1_MF_SYSAUX_GMYLZ1FG_.DBF destination for restore of datafile 00003: K:\UCASII\ORADATA_2\O1_MF_UNDOTBS1_GMYLYYSY_.DBF destination for restore of datafile 00004: K:\UCASII\ORADATA_2\O1_MF_USERS_GMYLZ57R_.DBF destination for restore of datafile 00005: K:\UCASII\ORADATA_2\O1_MF_UCAS_GMYLYYSO_.DBF destination for restore of datafile 00006: K:\UCASII\ORADATA_2\O1_MF_UCAS_GMYLYYSD_.DBF destination for restore of datafile 00007: K:\UCASII\ORADATA_2\O1_MF_UCAS_DAT_GMYLZ3DM_.DBF destination for restore of datafile 00008: K:\UCASII\ORADATA_2\O1_MF_UCAS_DAT_GMYLZ2OT_.DBF destination for restore of datafile 00009: K:\UCASII\ORADATA_2\O1_MF_UCAS_IND_GMYLZ1GN_.DBF destination for restore of datafile 00010: K:\UCASII\ORADATA_2\O1_MF_UCAS_IND_GMYLYYY1_.DBF destination for restore of datafile 00011: N:\UCASII\ORADATA_2\O1_MF_GGS_DATA_GMYLZ4MQ_.DBF destination for restore of datafile 00012: N:\UCASII\ORADATA_2\O1_MF_TELEX_GMYLZ3G1_.DBF destination for restore of datafile 00013: N:\UCASII\ORADATA_2\O1_MF_UCAS_NEW_GMYLZ559_.DBF destination for restore of datafile 00014: N:\UCASII\ORADATA_2\O1_MF_UCAS_NEW_GMYLYYX0_.DBF destination for restore of datafile 00015: N:\UCASII\ORADATA_2\O1_MF_UCAS_DAT_GMYLZ3CF_.DBF destination for restore of datafile 00016: N:\UCASII\ORADATA_2\O1_MF_UCAS_GMYLYYTG_.DBF destination for restore of datafile 00017: N:\UCASII\ORADATA_2\O1_MF_UCAS_GMYLYYT3_.DBF destination for restore of datafile 00018: N:\UCASII\ORADATA_2\O1_MF_UCAS_GMYLZ0SQ_.DBF destination for restore of datafile 00019: N:\UCASII\ORADATA_2\O1_MF_UCAS_GMYLZ4KP_.DBF channel ch1: reading from backup piece D:\UCAS_BACKUP\FORSTANDBY_EFVS9B6G_1_1 channel ch1: piece handle=D:\UCAS_BACKUP\FORSTANDBY_EFVS9B6G_1_1 tag=FORSTANDBY channel ch1: restored backup piece 1 channel ch1: restore complete, elapsed time: 00:26:08 Finished recover at 14-APR-21 released channel: ch1 RMAN> RMAN> run { allocate channel ch1 device type disk; backup current controlfile for standby format '/u01/DB_PUMP/ForStandbyCTRL.bck'; release channel ch1; }2> 3> 4> 5> using target database control file instead of recovery catalog allocated channel: ch1 channel ch1: SID=1149 device type=DISK Starting backup at 14-APR-21 channel ch1: starting full datafile backup set channel ch1: specifying datafile(s) in backup set including standby control file in backup set channel ch1: starting piece 1 at 14-APR-21 channel ch1: finished piece 1 at 14-APR-21 piece handle=/u01/DB_PUMP/ForStandbyCTRL.bck tag=TAG20210414T140420 comment=NONE channel ch1: backup set complete, elapsed time: 00:00:01 Finished backup at 14-APR-21 Starting Control File and SPFILE Autobackup at 14-APR-21 piece handle=/u01/app/oracle/product/11.2.0.4/dbhome_2/dbs/c-1353719689-20210414-00 comment=NONE Finished Control File and SPFILE Autobackup at 14-APR-21 released channel: ch1 RMAN> D:\UCAS_Backup> D:\UCAS_Backup>pscp.exe oracle@192.168.91.151:/u01/DB_PUMP/ForStandbyCTRL.bck . oracle@192.168.91.151's password: ForStandbyCTRL.bck | 12992 kB | 12992.0 kB/s | ETA: 00:00:00 | 100% D:\UCAS_Backup> SQL> SQL> shut immediate ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> SQL> SQL> startup nomount; ORACLE instance started. Total System Global Area 6413680640 bytes Fixed Size 2293232 bytes Variable Size 1660944912 bytes Database Buffers 4731174912 bytes Redo Buffers 19267584 bytes SQL> SQL> C:\Users\jkhan>rman target sys Recovery Manager: Release 11.2.0.4.0 - Production on Wed Apr 14 14:38:17 2021 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. target database Password: connected to target database: UCASII (not mounted) RMAN> RMAN> restore standby controlfile from 'D:\UCAS_Backup\ForStandbyCTRL.bck'; Starting restore at 14-APR-21 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=1057 device type=DISK channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 output file name=F:\UCASII\ORADATA_1\CONTROL01.CTL output file name=G:\UCASII\ORADATA_1\CONTROL02.CTL Finished restore at 14-APR-21 RMAN> SQL> shut immediate ORA-01507: database not mounted ORACLE instance shut down. SQL> SQL> startup mount ORACLE instance started. Total System Global Area 6413680640 bytes Fixed Size 2293232 bytes Variable Size 1660944912 bytes Database Buffers 4731174912 bytes Redo Buffers 19267584 bytes Database mounted. RMAN> catalog start with 'K:\UCASII\ORADATA_2\'; Starting implicit crosscheck backup at 14-APR-21 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=1441 device type=DISK Crosschecked 1 objects Finished implicit crosscheck backup at 14-APR-21 Starting implicit crosscheck copy at 14-APR-21 using channel ORA_DISK_1 Finished implicit crosscheck copy at 14-APR-21 searching for all files in the recovery area cataloging files... cataloging done List of Cataloged Files ======================= File Name: M:\FLASH_RECOVERY_AREA\UCASIIDR\AUTOBACKUP\2019_12_22\O1_MF_S_1027712788_GZZ7P595_.BKP File Name: M:\FLASH_RECOVERY_AREA\UCASIIDR\AUTOBACKUP\2020_01_01\O1_MF_S_1028574719_H0SK6HPT_.BKP searching for all files that match the pattern K:\UCASII\ORADATA_2\ no files found to be unknown to the database RMAN> catalog start with 'N:\UCASII\ORADATA_2\'; searching for all files that match the pattern N:\UCASII\ORADATA_2\ List of Files Unknown to the Database ===================================== File Name: N:\UCASII\ORADATA_2\O1_MF_GGS_DATA_GMYLZ4MQ_.DBF File Name: N:\UCASII\ORADATA_2\O1_MF_TELEX_GMYLZ3G1_.DBF File Name: N:\UCASII\ORADATA_2\O1_MF_UCAS_DAT_GMYLZ3CF_.DBF File Name: N:\UCASII\ORADATA_2\O1_MF_UCAS_GMYLYYT3_.DBF File Name: N:\UCASII\ORADATA_2\O1_MF_UCAS_GMYLYYTG_.DBF File Name: N:\UCASII\ORADATA_2\O1_MF_UCAS_GMYLZ0SQ_.DBF File Name: N:\UCASII\ORADATA_2\O1_MF_UCAS_GMYLZ4KP_.DBF File Name: N:\UCASII\ORADATA_2\O1_MF_UCAS_NEW_GMYLYYX0_.DBF File Name: N:\UCASII\ORADATA_2\O1_MF_UCAS_NEW_GMYLZ559_.DBF Do you really want to catalog the above files (enter YES or NO)? Yes cataloging files... cataloging done List of Cataloged Files ======================= File Name: N:\UCASII\ORADATA_2\O1_MF_GGS_DATA_GMYLZ4MQ_.DBF File Name: N:\UCASII\ORADATA_2\O1_MF_TELEX_GMYLZ3G1_.DBF File Name: N:\UCASII\ORADATA_2\O1_MF_UCAS_DAT_GMYLZ3CF_.DBF File Name: N:\UCASII\ORADATA_2\O1_MF_UCAS_GMYLYYT3_.DBF File Name: N:\UCASII\ORADATA_2\O1_MF_UCAS_GMYLYYTG_.DBF File Name: N:\UCASII\ORADATA_2\O1_MF_UCAS_GMYLZ0SQ_.DBF File Name: N:\UCASII\ORADATA_2\O1_MF_UCAS_GMYLZ4KP_.DBF File Name: N:\UCASII\ORADATA_2\O1_MF_UCAS_NEW_GMYLYYX0_.DBF File Name: N:\UCASII\ORADATA_2\O1_MF_UCAS_NEW_GMYLZ559_.DBF RMAN> switch database to copy; datafile 1 switched to datafile copy "K:\UCASII\ORADATA_2\O1_MF_SYSTEM_GMYLZ22B_.DBF" datafile 2 switched to datafile copy "K:\UCASII\ORADATA_2\O1_MF_SYSAUX_GMYLZ1FG_.DBF" datafile 3 switched to datafile copy "K:\UCASII\ORADATA_2\O1_MF_UNDOTBS1_GMYLYYSY_.DBF" datafile 4 switched to datafile copy "K:\UCASII\ORADATA_2\O1_MF_USERS_GMYLZ57R_.DBF" datafile 5 switched to datafile copy "K:\UCASII\ORADATA_2\O1_MF_UCAS_GMYLYYSO_.DBF" datafile 6 switched to datafile copy "K:\UCASII\ORADATA_2\O1_MF_UCAS_GMYLYYSD_.DBF" datafile 7 switched to datafile copy "K:\UCASII\ORADATA_2\O1_MF_UCAS_DAT_GMYLZ3DM_.DBF" datafile 8 switched to datafile copy "K:\UCASII\ORADATA_2\O1_MF_UCAS_DAT_GMYLZ2OT_.DBF" datafile 9 switched to datafile copy "K:\UCASII\ORADATA_2\O1_MF_UCAS_IND_GMYLZ1GN_.DBF" datafile 10 switched to datafile copy "K:\UCASII\ORADATA_2\O1_MF_UCAS_IND_GMYLYYY1_.DBF" datafile 11 switched to datafile copy "N:\UCASII\ORADATA_2\O1_MF_GGS_DATA_GMYLZ4MQ_.DBF" datafile 12 switched to datafile copy "N:\UCASII\ORADATA_2\O1_MF_TELEX_GMYLZ3G1_.DBF" datafile 13 switched to datafile copy "N:\UCASII\ORADATA_2\O1_MF_UCAS_NEW_GMYLZ559_.DBF" datafile 14 switched to datafile copy "N:\UCASII\ORADATA_2\O1_MF_UCAS_NEW_GMYLYYX0_.DBF" datafile 15 switched to datafile copy "N:\UCASII\ORADATA_2\O1_MF_UCAS_DAT_GMYLZ3CF_.DBF" datafile 16 switched to datafile copy "N:\UCASII\ORADATA_2\O1_MF_UCAS_GMYLYYTG_.DBF" datafile 17 switched to datafile copy "N:\UCASII\ORADATA_2\O1_MF_UCAS_GMYLYYT3_.DBF" datafile 18 switched to datafile copy "N:\UCASII\ORADATA_2\O1_MF_UCAS_GMYLZ0SQ_.DBF" datafile 19 switched to datafile copy "N:\UCASII\ORADATA_2\O1_MF_UCAS_GMYLZ4KP_.DBF" RMAN> exit Recovery Manager complete. remove the logfiles otherwise will get below error. SQL> set lines 300 col destination for a40 col error for a20 select inst_id, dest_id "ID",destination,status,error,target, schedule,process,mountid mid from gv$archive_dest where dest_id < 4 order by dest_id; SQL> SQL> SQL> 2 3 4 5 INST_ID ID DESTINATION STATUS ERROR TARGET SCHEDULE PROCESS MID ---------- ---------- ---------------------------------------- --------- -------------------- ------- -------- ---------- ---------- 1 1 USE_DB_RECOVERY_FILE_DEST VALID PRIMARY ACTIVE ARCH 0 1 2 ucasiidr ERROR ORA-00340: IO error STANDBY ACTIVE LGWR 0 processing online log of thread 1 3 INACTIVE PRIMARY INACTIVE ARCH 0 SQL> / SQL> select distinct group#, type from v$logfile order by group#; GROUP# TYPE ---------- ------- 1 ONLINE 2 ONLINE 3 ONLINE 4 ONLINE 5 ONLINE 6 STANDBY 7 STANDBY 8 STANDBY 9 STANDBY 10 STANDBY 11 STANDBY 11 rows selected. SQL> SQL> alter database clear logfile group 1; Database altered. SQL> alter database clear logfile group 2; Database altered. SQL> alter database clear logfile group 3; Database altered. SQL> alter database clear logfile group 4; Database altered. SQL> alter database clear logfile group 5; Database altered. SQL> alter database clear logfile group 6; Database altered. SQL> alter database clear logfile group 7; Database altered. SQL> alter database clear logfile group 8; Database altered. SQL> alter database clear logfile group 9; Database altered. SQL> alter database clear logfile group 10; Database altered. SQL> alter database clear logfile group 11; Database altered. SQL> SQL> alter database flashback off; Database altered. SQL> alter database flashback on; Database altered. SQL> alter database recover managed standby database using current logfile disconnect from session; Database altered. 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 'MRP%' or client_process like 'LGWR INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS ---------- --------- ------------ -------- ---------- ---------- ---------- ------------- ------------ 1 RFS IDLE LGWR 1 15287 2428 0 0 1 MRP0 APPLYING_LOG N/A 1 15286 0 33 33 SQL> / INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS ---------- --------- ------------ -------- ---------- ---------- ---------- ------------- ------------ 1 RFS IDLE LGWR 1 15287 2429 0 0 1 MRP0 APPLYING_LOG N/A 1 15286 1 33 33 SQL> / INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS ---------- --------- ------------ -------- ---------- ---------- ---------- ------------- ------------ 1 RFS IDLE LGWR 1 15287 2430 0 0 1 MRP0 WAIT_FOR_LOG N/A 1 15287 0 33 33 SQL> / INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS ---------- --------- ------------ -------- ---------- ---------- ---------- ------------- ------------ 1 RFS IDLE LGWR 1 15287 2439 0 0 1 MRP0 WAIT_FOR_LOG N/A 1 15287 0 33 33 SQL> / INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS ---------- --------- ------------ -------- ---------- ---------- ---------- ------------- ------------ 1 RFS IDLE LGWR 1 15287 2482 0 0 1 MRP0 WAIT_FOR_LOG N/A 1 15287 0 33 33 SQL> / INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS ---------- --------- ------------ -------- ---------- ---------- ---------- ------------- ------------ 1 RFS IDLE LGWR 1 15287 2499 0 0 1 MRP0 WAIT_FOR_LOG N/A 1 15287 0 33 33 SQL> / INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS ---------- --------- ------------ -------- ---------- ---------- ---------- ------------- ------------ 1 RFS IDLE LGWR 1 15287 2760 0 0 1 MRP0 WAIT_FOR_LOG N/A 1 15287 0 33 33 SQL> / INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS ---------- --------- ------------ -------- ---------- ---------- ---------- ------------- ------------ 1 RFS IDLE LGWR 1 15288 4 0 0 1 MRP0 APPLYING_LOG N/A 1 15288 3 33 33 SQL> / INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS ---------- --------- ------------ -------- ---------- ---------- ---------- ------------- ------------ 1 RFS IDLE LGWR 1 15288 7 0 0 1 MRP0 APPLYING_LOG N/A 1 15288 6 33 33 SQL>