Oracle Database Commands and Practical Examples: Manual NON RAC DR physical standby Database 12c

We are creating non RAC physical standby database without making changes on primary database.

We have to make changes on primary db for creating physical standby so we didn't get downtime for this, We have requested once we get we will create proper standby with automatic RFS and LNS service .

2 node Non RAC DR

Just for practice we have created this DR with with making any changes on primary db. manually or by scripts we transfer archive log apply into the same in physical standby database.

Already created non rac and RAC physical standby mentioned in the earlier blog-post.

--- 2 Node RAC with manual non RAC physical standby database---

Steps

Take RMAN Backup form primary database
Transfer file from primary to standby database server.
Startup sid in no mount state.
Restore standby controlfile.
Open standby database in mount stage
Catalog standby database
Change datafile,undo file, tempfile location and restore database from backup.
We found rman error RMAN-06026, RMAN-06023 , Due to incarnation point issue.
Start again physical standby database with pfile initsmrrac.ora
Check MRP0 using v$managed_standby
Make standby_file_management='MANUAL' for deleting redo log and creating again.
Add Redo logfile group 1, 2, 3, 4
Add Standby Redo logfile group 7, 8, 9
Set Standby File management AUTO
Transfer SCP archive log from primary to standby database.
Open Physical standby Database in read only mode
Back into standby database mode in mount stage.
Physical Standby Alert log file details.

1--- Take RMAN Backup form primary database ---

oracle@2:~> cat /u04/MasterDB/scripts/rman_RAC_FULL_.rcv
run
{
allocate channel c1 device type disk format '/u04/MasterDB/smrrac_backup_64/Backup_%d_DB_%u_%s_%p_%T';
allocate channel c2 device type disk format '/u04/MasterDB/smrrac_backup_64/Backup_%d_DB_%u_%s_%p_%T';
allocate channel c3 device type disk format '/u04/MasterDB/smrrac_backup_64/Backup_%d_DB_%u_%s_%p_%T';
allocate channel c4 device type disk format '/u04/MasterDB/smrrac_backup_64/Backup_%d_DB_%u_%s_%p_%T';
crosscheck backup;
crosscheck archivelog all;
report obsolete;
delete noprompt obsolete;
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;
#backup full database format '/u04/MasterDB/smrrac_backup_64/%d_%U.bckp' plus archivelog;
copy current controlfile to '/u04/MasterDB/smrrac_backup_64/control_%d_%T.bak';
backup current controlfile for standby format '/u04/MasterDB/smrrac_backup_64/standbycontrol_%d_%U.ctl';
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}
oracle@2:~>

--- Transfer file from primary to standby database server. ---

--- Startup sid in no mount state ---

oracle@8:/u01/rman_smrrac> . oraenv

ORACLE_SID = [smrrac] ?

The Oracle base remains unchanged with value /u01/app/oracle

oracle@8:/u01/rman_smrrac> sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 26 13:41:22 2020

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup nomount;

ORACLE instance started.

Total System Global Area 3942645760 bytes

Fixed Size 2931616 bytes

Variable Size 939525216 bytes

Database Buffers 2986344448 bytes

Redo Buffers 13844480 bytes

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

--- Restore standby controlfile ---

oracle@8:/u01/rman_smrrac> rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Wed Feb 26 13:41:40 2020

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

connected to target database: SMRRAC (not mounted)

RMAN> restore standby controlfile from '/u01/rman_smrrac/standbycontrol_SMRRAC_32upfn2e_1_1.ctl';

Starting restore at 26-FEB-2020 13:42:19

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=527 device type=DISK

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

output file name=/u01/app/oracle/oradata/smrrac/control01.ctl

output file name=/u01/app/oracle/fast_recovery_area/smrrac/control02.ctl

Finished restore at 26-FEB-2020 13:42:20

--- Open standby database in mount stage ---

RMAN> alter database mount;

Statement processed

released channel: ORA_DISK_1

--- Catalog standby database ---

RMAN> catalog start with '/u01/rman_smrrac/';

Starting implicit crosscheck backup at 26-FEB-2020 13:43:05

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=357 device type=DISK

Crosschecked 34 objects

Finished implicit crosscheck backup at 26-FEB-2020 13:43:06

Starting implicit crosscheck copy at 26-FEB-2020 13:43:06

using channel ORA_DISK_1

Crosschecked 4 objects

Finished implicit crosscheck copy at 26-FEB-2020 13:43:06

searching for all files in the recovery area

cataloging files...

cataloging done

List of Cataloged Files

=======================

File Name: /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/2020_02_26/o1_mf_2_1_h5drk9hq_.arc

searching for all files that match the pattern /u01/rman_smrrac/

List of Files Unknown to the Database

=====================================

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2nupfmsr_2135_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2mupfmsr_2134_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2kupfmsr_2132_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2lupfmsr_2133_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2oupfmtk_2136_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2rupfmu4_2139_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2tupfmu7_2141_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2uupfmu9_2142_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2qupfmu4_2138_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2supfmu4_2140_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2pupfmu4_2137_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2vupfn2a_2143_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_30upfn2a_2144_1_20200226

File Name: /u01/rman_smrrac/control_SMRRAC_20200226.bak

File Name: /u01/rman_smrrac/standbycontrol_SMRRAC_32upfn2e_1_1.ctl

Do you really want to catalog the above files (enter YES or NO)? yes

cataloging files...

cataloging done

List of Cataloged Files

=======================

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2nupfmsr_2135_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2mupfmsr_2134_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2kupfmsr_2132_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2lupfmsr_2133_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2oupfmtk_2136_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2rupfmu4_2139_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2tupfmu7_2141_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2uupfmu9_2142_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2qupfmu4_2138_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2supfmu4_2140_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2pupfmu4_2137_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2vupfn2a_2143_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_30upfn2a_2144_1_20200226

File Name: /u01/rman_smrrac/control_SMRRAC_20200226.bak

File Name: /u01/rman_smrrac/standbycontrol_SMRRAC_32upfn2e_1_1.ctl

--- Change datafile,undo file, tempfile location and restore database from backup ---

RMAN> run

{

set newname for datafile 1 to "/u01/app/oracle/oradata/smrrac/system01.dbf";

2> 3> 4>

set newname for datafile 2 to "/u02/oradata/smrrac/idata01.dbf";

set newname for datafile 3 to "/u01/app/oracle/oradata/smrrac/sysaux01.dbf";

5> 6> 7> 8> 9> 10> set newname for datafile 4 to "/u01/app/oracle/oradata/smrrac/undotbs01.dbf";

set newname for datafile 5 to "/u01/app/oracle/oradata/smrrac/undotbs02.dbf";

set newname for datafile 6 to "/u02/oradata/smrrac/users01.dbf";

set newname for datafile 7 to "/u02/oradata/smrrac/ilog01.dbf";

set newname for datafile 8 to "/u02/oradata/smrrac/indx01.dbf";

set newname for tempfile 1 to "/u01/app/oracle/oradata/smrrac/temp01.dbf";

RESTORE DATABASE;

SWITCH DATAFILE ALL;

SWITCH TEMPFILE ALL;

}11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28>

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 26-FEB-2020 13:43:44

using channel ORA_DISK_1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 02/26/2020 13:43:44

RMAN-06026: some targets not found - aborting restore

RMAN-06023: no backup or copy of datafile 6 found to restore

RMAN-06023: no backup or copy of datafile 4 found to restore

RMAN-06023: no backup or copy of datafile 3 found to restore

RMAN-06023: no backup or copy of datafile 1 found to restore

RMAN>

--- We found rman error RMAN-06026, RMAN-06023 , Due to incarnation point issue ---

So we disable db_recovery_file_dest and db_recovery_file_dest_size and start stndby with pfile initsmrrac.ora

oracle@8:/u01/app/oracle/product/12.1.0/dbhome_1/dbs> cat initsmrrac.ora
smrrac.__data_transfer_cache_size=0
smrrac.__db_cache_size=2952790016
smrrac.__java_pool_size=16777216
smrrac.__large_pool_size=33554432
smrrac.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
smrrac.__pga_aggregate_target=1325400064
smrrac.__sga_target=3942645760
smrrac.__shared_io_pool_size=201326592
smrrac.__shared_pool_size=721420288
smrrac.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/smrrac/adump'
*.audit_trail='db'
*.compatible='12.1.0.2.0'
*.control_files='/u01/app/oracle/oradata/smrrac/control01.ctl','/u01/app/oracle/fast_recovery_area/smrrac/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='smrrac'
#*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
#*.db_recovery_file_dest_size=4560m
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=smrracXDB)'
*.local_listener='LISTENER_SMRRAC'
*.log_archive_format='%t_%s_%r.arc'
*.STANDBY_FILE_MANAGEMENT='AUTO'
LOG_ARCHIVE_DEST_1='LOCATION=/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog'
*.open_cursors=300
*.pga_aggregate_target=1250m
*.processes=450
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=3750m
*.undo_tablespace='UNDOTBS1'
oracle@8:/u01/app/oracle/product/12.1.0/dbhome_1/dbs>

oracle@8:/u01/app/oracle/product/12.1.0/dbhome_1/dbs> vi initrac.ora

--- Start again physical standby database with pfile initsmrrac.ora ---

oracle@8:/u01/app/oracle/product/12.1.0/dbhome_1/dbs> sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 26 14:50:25 2020

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup nomount pfile='/u01/app/oracle/product/12.1.0/dbhome_1/dbs/initsmrrac.ora';

ORACLE instance started.

Total System Global Area 3942645760 bytes

Fixed Size 2931616 bytes

Variable Size 939525216 bytes

Database Buffers 2986344448 bytes

Redo Buffers 13844480 bytes

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

oracle@8:/u01/app/oracle/product/12.1.0/dbhome_1/dbs> rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Wed Feb 26 14:51:11 2020

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

connected to target database: SMRRAC (not mounted)

---- Restore Standby database Controlfile Again (optional) ----

RMAN> restore standby controlfile from '/u01/rman_smrrac/standbycontrol_SMRRAC_32upfn2e_1_1.ctl';

Starting restore at 26-FEB-2020 14:51:34

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=527 device type=DISK

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

output file name=/u01/app/oracle/oradata/smrrac/control01.ctl

output file name=/u01/app/oracle/fast_recovery_area/smrrac/control02.ctl

Finished restore at 26-FEB-2020 14:51:36

--- Mount database physical standby ---

RMAN> alter database mount standby;

RMAN> ALTER DATABASE MOUNT STANDBY DATABASE;

Statement processed

released channel: ORA_DISK_1

--- Catalog Start with ---

RMAN> catalog start with '/u01/rman_smrrac/';

searching for all files that match the pattern /u01/rman_smrrac/

List of Files Unknown to the Database

=====================================

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2nupfmsr_2135_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2mupfmsr_2134_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2kupfmsr_2132_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2lupfmsr_2133_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2oupfmtk_2136_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2rupfmu4_2139_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2tupfmu7_2141_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2uupfmu9_2142_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2qupfmu4_2138_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2supfmu4_2140_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2pupfmu4_2137_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2vupfn2a_2143_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_30upfn2a_2144_1_20200226

File Name: /u01/rman_smrrac/control_SMRRAC_20200226.bak

File Name: /u01/rman_smrrac/standbycontrol_SMRRAC_32upfn2e_1_1.ctl

Do you really want to catalog the above files (enter YES or NO)? yes

cataloging files...

cataloging done

List of Cataloged Files

=======================

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2nupfmsr_2135_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2mupfmsr_2134_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2kupfmsr_2132_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2lupfmsr_2133_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2oupfmtk_2136_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2rupfmu4_2139_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2tupfmu7_2141_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2uupfmu9_2142_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2qupfmu4_2138_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2supfmu4_2140_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2pupfmu4_2137_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_2vupfn2a_2143_1_20200226

File Name: /u01/rman_smrrac/Backup_SMRRAC_DB_30upfn2a_2144_1_20200226

File Name: /u01/rman_smrrac/control_SMRRAC_20200226.bak

File Name: /u01/rman_smrrac/standbycontrol_SMRRAC_32upfn2e_1_1.ctl

--- Restore standby database ---

RMAN> run

{

set newname for datafile 1 to "/u01/app/oracle/oradata/smrrac/system01.dbf";

set newname for datafile 2 to "/u02/oradata/smrrac/idata01.dbf";

set newname for datafile 3 to "/u01/app/oracle/oradata/smrrac/sysaux01.dbf";

set newname for datafile 4 to "/u01/app/oracle/oradata/smrrac/undotbs01.dbf";

2> 3> set newname for datafile 5 to "/u01/app/oracle/oradata/smrrac/undotbs02.dbf";

set newname for datafile 6 to "/u02/oradata/smrrac/users01.dbf";

set newname for datafile 7 to "/u02/oradata/smrrac/ilog01.dbf";

set newname for datafile 8 to "/u02/oradata/smrrac/indx01.dbf";

4> 5> 6> 7> 8> 9> 10> 11> set newname for tempfile 1 to "/u01/app/oracle/oradata/smrrac/temp01.dbf";

RESTORE DATABASE;

12> 13> SWITCH DATAFILE ALL;

SWITCH TEMPFILE ALL;

}14> 15>

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 26-FEB-2020 14:54:45

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=357 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/smrrac/undotbs01.dbf

channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/smrrac/undotbs02.dbf

channel ORA_DISK_1: reading from backup piece /u04/MasterDB/smrrac_backup_64/Backup_SMRRAC_DB_2rupfmu4_2139_1_20200226

channel ORA_DISK_1: errors found reading piece handle=/u04/MasterDB/smrrac_backup_64/Backup_SMRRAC_DB_2rupfmu4_2139_1_20200226

channel ORA_DISK_1: failover to piece handle=/u01/rman_smrrac/Backup_SMRRAC_DB_2rupfmu4_2139_1_20200226 tag=TAG20200226T050611

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:15

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/smrrac/system01.dbf

channel ORA_DISK_1: restoring datafile 00008 to /u02/oradata/smrrac/indx01.dbf

channel ORA_DISK_1: reading from backup piece /u04/MasterDB/smrrac_backup_64/Backup_SMRRAC_DB_2qupfmu4_2138_1_20200226

channel ORA_DISK_1: errors found reading piece handle=/u04/MasterDB/smrrac_backup_64/Backup_SMRRAC_DB_2qupfmu4_2138_1_20200226

channel ORA_DISK_1: failover to piece handle=/u01/rman_smrrac/Backup_SMRRAC_DB_2qupfmu4_2138_1_20200226 tag=TAG20200226T050611

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:35

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/smrrac/sysaux01.dbf

channel ORA_DISK_1: restoring datafile 00007 to /u02/oradata/smrrac/ilog01.dbf

channel ORA_DISK_1: reading from backup piece /u04/MasterDB/smrrac_backup_64/Backup_SMRRAC_DB_2supfmu4_2140_1_20200226

channel ORA_DISK_1: errors found reading piece handle=/u04/MasterDB/smrrac_backup_64/Backup_SMRRAC_DB_2supfmu4_2140_1_20200226

channel ORA_DISK_1: failover to piece handle=/u01/rman_smrrac/Backup_SMRRAC_DB_2supfmu4_2140_1_20200226 tag=TAG20200226T050611

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:55

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00002 to /u02/oradata/smrrac/idata01.dbf

channel ORA_DISK_1: restoring datafile 00006 to /u02/oradata/smrrac/users01.dbf

channel ORA_DISK_1: reading from backup piece /u04/MasterDB/smrrac_backup_64/Backup_SMRRAC_DB_2pupfmu4_2137_1_20200226

channel ORA_DISK_1: errors found reading piece handle=/u04/MasterDB/smrrac_backup_64/Backup_SMRRAC_DB_2pupfmu4_2137_1_20200226

channel ORA_DISK_1: failover to piece handle=/u01/rman_smrrac/Backup_SMRRAC_DB_2pupfmu4_2137_1_20200226 tag=TAG20200226T050611

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:03:05

Finished restore at 26-FEB-2020 14:59:35

datafile 1 switched to datafile copy

input datafile copy RECID=150 STAMP=1033397976 file name=/u01/app/oracle/oradata/smrrac/system01.dbf

datafile 2 switched to datafile copy

input datafile copy RECID=151 STAMP=1033397976 file name=/u02/oradata/smrrac/idata01.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=152 STAMP=1033397976 file name=/u01/app/oracle/oradata/smrrac/sysaux01.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=153 STAMP=1033397976 file name=/u01/app/oracle/oradata/smrrac/undotbs01.dbf

datafile 5 switched to datafile copy

input datafile copy RECID=154 STAMP=1033397976 file name=/u01/app/oracle/oradata/smrrac/undotbs02.dbf

datafile 6 switched to datafile copy

input datafile copy RECID=155 STAMP=1033397976 file name=/u02/oradata/smrrac/users01.dbf

datafile 7 switched to datafile copy

input datafile copy RECID=156 STAMP=1033397976 file name=/u02/oradata/smrrac/ilog01.dbf

datafile 8 switched to datafile copy

input datafile copy RECID=157 STAMP=1033397976 file name=/u02/oradata/smrrac/indx01.dbf

renamed tempfile 1 to /u01/app/oracle/oradata/smrrac/temp01.dbf in control file

----- Check MRP0 using v$managed_standby -----

RMAN> select process,status,sequence# from v$managed_standby;

PROCESS STATUS SEQUENCE#

--------- ------------ ----------

ARCH CONNECTED 0

ARCH CONNECTED 0

ARCH CONNECTED 0

ARCH CONNECTED 0

RMAN>

alter database recover managed standby database disconnect from session;

RMAN>

RMAN> select process,status,sequence# from v$managed_standby;

Statement processed

PROCESS STATUS SEQUENCE#

--------- ------------ ----------

ARCH CONNECTED 0

ARCH CONNECTED 0

ARCH CONNECTED 0

ARCH CONNECTED 0

MRP0 WAIT_FOR_GAP 1066

RMAN>

SQL> sho parameter standby

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

standby_archive_dest string ?/dbs/arch

standby_file_management string AUTO

--- Make standby_file_management='MANUAL' ---

SQL> alter system set standby_file_management='MANUAL';

System altered.

SQL> sho parameter standby

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

standby_archive_dest string ?/dbs/arch

standby_file_management string MANUAL

--- drop redo logfile group 1 ---

SQL> alter database drop logfile group 1;

Database altered.

--- drop redo logfile group 2 ---

SQL> alter database drop logfile group 2;

Database altered.

--- check status using query ---

SQL> col REDOLOG_FILE_NAME for a50

SQL> set lines 200

SQL> SELECT a.GROUP#, a.THREAD#, a.SEQUENCE#,
a.ARCHIVED, a.STATUS, b.MEMBER AS REDOLOG_FILE_NAME,
(a.BYTES/1024/1024) AS SIZE_MB FROM v$log a
JOIN v$logfile b ON a.Group#=b.Group#
ORDER BY a.GROUP#; 2 3 4 5

GROUP# THREAD# SEQUENCE# ARC STATUS REDOLOG_FILE_NAME SIZE_MB
---------- ---------- ---------- --- ---------------- -------------------------------------------------- ----------
3 2 0 YES CLEARING +DATA 500
3 2 0 YES CLEARING +FRA1 500
4 2 0 YES CLEARING +DATA 500
4 2 0 YES CLEARING +FRA1 500
5 1 0 YES CLEARING +FRA1 500
5 1 0 YES CLEARING +DATA 500
6 2 0 YES CLEARING +DATA 50
6 2 0 YES CLEARING +FRA1 50

8 rows selected.

--- drop redo logfile group 3 ---

SQL> alter database drop logfile group 3;

Database altered.

--- drop redo logfile group 4 ---

SQL> alter database drop logfile group 4;

Database altered.

--- drop redo logfile group 5 ---

SQL> alter database drop logfile group 5;

Database altered.

--- drop redo logfile group 6 ---

SQL> alter database drop logfile group 6;

Database altered.

SQL> SELECT a.GROUP#, a.THREAD#, a.SEQUENCE#,
a.ARCHIVED, a.STATUS, b.MEMBER AS REDOLOG_FILE_NAME,
(a.BYTES/1024/1024) AS SIZE_MB FROM v$log a
JOIN v$logfile b ON a.Group#=b.Group#
ORDER BY a.GROUP#; 2 3 4 5

no rows selected

--- Add Redo logfile group 1, 2, 3, 4 ---

SQL> ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 1 ('/u01/app/oracle/oradata/smrrac/redo01.log') SIZE 200m, GROUP 2 ('/u01/app/oracle/oradata/smrrac/redo02.log') SIZE 200m;

Database altered.

SQL> ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 3 ('/u01/app/oracle/oradata/smrrac/redo03.log') SIZE 200m, GROUP 4 ('/u01/app/oracle/oradata/smrrac/redo04.log') SIZE 200m;

Database altered.
SQL> SELECT a.GROUP#, a.THREAD#, a.SEQUENCE#,
a.ARCHIVED, a.STATUS, b.MEMBER AS REDOLOG_FILE_NAME,
(a.BYTES/1024/1024) AS SIZE_MB FROM v$log a
JOIN v$logfile b ON a.Group#=b.Group#
ORDER BY a.GROUP#; 2 3 4 5

GROUP# THREAD# SEQUENCE# ARC STATUS REDOLOG_FILE_NAME SIZE_MB
---------- ---------- ---------- --- ---------------- -------------------------------------------------- ----------
1 1 0 YES UNUSED /u01/app/oracle/oradata/smrrac/redo01.log 200
2 1 0 YES UNUSED /u01/app/oracle/oradata/smrrac/redo02.log 200
3 1 0 YES UNUSED /u01/app/oracle/oradata/smrrac/redo03.log 200
4 1 0 YES UNUSED /u01/app/oracle/oradata/smrrac/redo04.log 200

SQL> col MEMBER for a50

SQL> /

GROUP# STATUS TYPE MEMBER IS_ CON_ID
---------- ------- ------- -------------------------------------------------- --- ----------
1 ONLINE /u01/app/oracle/oradata/smrrac/redo01.log NO 0
2 ONLINE /u01/app/oracle/oradata/smrrac/redo02.log NO 0
3 ONLINE /u01/app/oracle/oradata/smrrac/redo03.log NO 0
4 ONLINE /u01/app/oracle/oradata/smrrac/redo04.log NO 0

--- Add Standby Redo logfile group 7, 8, 9 ---

SQL> alter database add standby logfile group 7 '/u01/app/oracle/oradata/smrrac/srl01.log' size 200m;

Database altered.

SQL> alter database add standby logfile group 8 '/u01/app/oracle/oradata/smrrac/srl02.log' size 200m;

Database altered.

SQL> alter database add standby logfile group 9 '/u01/app/oracle/oradata/smrrac/srl03.log' size 200m;

Database altered.\

--- Set Standby File management AUTO ---

SQL> alter system set standby_file_management='AUTO';

System altered.

RMAN> select process,status,sequence# from v$managed_standby;

PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_GAP 1066

RMAN> exit

---- Check status standby_file_management ---

Recovery Manager complete.
oracle@8:~> sqlplus sys/system123@smrrac as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Feb 27 08:51:51 2020

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> sho parameter standby

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_archive_dest string ?/dbs/arch
standby_file_management string AUTO

SQL> select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------
RMAN> select PROCESS,CLIENT_PROCESS,THREAD#,SEQUENCE#,BLOCK# from v$managed_standby where process = 'MRP0' or client_process='LGWR';

PROCESS CLIENT_P THREAD# SEQUENCE# BLOCK#
--------- -------- ---------- ---------- ----------
MRP0 N/A 1 1066 0

RMAN> alter database recover managed standby database cancel;

Statement processed

oracle@sgdcpl08:/u01/app/oracle/product/12.1.0/dbhome_1/dbs> cat initsmrrac.ora
smrrac.__data_transfer_cache_size=0
smrrac.__db_cache_size=2952790016
smrrac.__java_pool_size=16777216
smrrac.__large_pool_size=33554432
smrrac.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
smrrac.__pga_aggregate_target=1325400064
smrrac.__sga_target=3942645760
smrrac.__shared_io_pool_size=201326592
smrrac.__shared_pool_size=721420288
smrrac.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/smrrac/adump'
*.audit_trail='db'
*.compatible='12.1.0.2.0'
*.control_files='/u01/app/oracle/oradata/smrrac/control01.ctl','/u01/app/oracle/fast_recovery_area/smrrac/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='smrrac'
#*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
#*.db_recovery_file_dest_size=4560m
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=smrracXDB)'
*.local_listener='LISTENER_SMRRAC'
*.log_archive_format='%t_%s_%r.arc'
*.STANDBY_FILE_MANAGEMENT='AUTO'
LOG_ARCHIVE_DEST_1='LOCATION=/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog'
*.open_cursors=300
*.pga_aggregate_target=1250m
*.processes=450
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=3750m
*.undo_tablespace='UNDOTBS1'

oracle@sgdcpl08:/u01/app/oracle/product/12.1.0/dbhome_1/dbs>

--- Transfer SCP archive log from primary to standby database ---

oracle@2:/u04/MasterDB/smrrac_archivelog> scp arch_1_1072_1020157972.arc arch_1_1073_1020157972.arc arch_2_760_1020157972.arc arch_1_1074_1020157972.arc arch_1_1075_1020157972.arc arch_1_1076_1020157972.arc arch_1_1077_1020157972.arc oracle@1.1.1.1:/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog
Password:
arch_1_1072_1020157972.arc 100% 233MB 116.6MB/s 00:02
arch_1_1073_1020157972.arc 100% 235MB 117.6MB/s 00:02
arch_2_760_1020157972.arc 100% 73MB 72.9MB/s 00:01
arch_1_1074_1020157972.arc 100% 259MB 129.6MB/s 00:02
arch_1_1075_1020157972.arc 100% 63MB 62.8MB/s 00:01
arch_1_1076_1020157972.arc 100% 41KB 40.5KB/s 00:00
arch_1_1077_1020157972.arc

--- perform recovery on physical Standby database ---

SQL> RECOVER AUTOMATIC STANDBY DATABASE ;
ORA-00279: change 85460887 generated at 02/26/2020 05:08:23 needed for thread 2
ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_2_758_1020157972.arc
ORA-00280: change 85460887 for thread 2 is in sequence #758
ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_2_758_1020157972.arc' no longer needed for this recovery
ORA-00308: cannot open archived log '/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_2_758_1020157972.arc'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00279: change 85460887 generated at 02/26/2020 05:05:21 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1066_1020157972.arc
ORA-00280: change 85460887 for thread 1 is in sequence #1066

ORA-00279: change 85460891 generated at 02/26/2020 05:08:25 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1067_1020157972.arc
ORA-00280: change 85460891 for thread 1 is in sequence #1067
ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1066_1020157972.arc' no longer needed for this recovery

ORA-00279: change 85577144 generated at 02/26/2020 09:32:55 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1068_1020157972.arc
ORA-00280: change 85577144 for thread 1 is in sequence #1068
ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1067_1020157972.arc' no longer needed for this recovery

ORA-00308: cannot open archived log '/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1068_1020157972.arc'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

SQL>
SQL> RECOVER AUTOMATIC STANDBY DATABASE ;

ORA-00279: change 85985278 generated at 02/26/2020 18:00:15 needed for thread 2
ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_2_760_1020157972.arc
ORA-00280: change 85985278 for thread 2 is in sequence #760
ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_2_760_1020157972.arc' no longer needed for this recovery
ORA-00308: cannot open archived log '/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_2_760_1020157972.arc'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log '/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_2_760_1020157972.arc'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

--- open Physical standby Database in read only mode ---

SQL> @/home/oracle/d

NAME INSTANCE_NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE CURRENT_SCN FAILOVER_SCN
--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------
SMRRAC smrrac smrrac MOUNTED PHYSICAL STANDBY NO 0

SQL> alter database open read only;

Database altered.

SQL> @/home/oracle/d

NAME INSTANCE_NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE CURRENT_SCN FAILOVER_SCN
--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------
SMRRAC smrrac smrrac READ ONLY PHYSICAL STANDBY NO 0
SQL> @/home/oracle/d

NAME INSTANCE_NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE CURRENT_SCN FAILOVER_SCN
--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------
SMRRAC smrrac smrrac READ ONLY PHYSICAL STANDBY NO 0

--- Back in standby database in mount stage ---

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 3942645760 bytes
Fixed Size 2931616 bytes
Variable Size 939525216 bytes
Database Buffers 2986344448 bytes
Redo Buffers 13844480 bytes
Database mounted.

SQL> @/home/oracle/d

NAME INSTANCE_NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE CURRENT_SCN FAILOVER_SCN
--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------
SMRRAC smrrac smrrac MOUNTED PHYSICAL STANDBY NO 0

SQL> select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------

--- Physical Standby Alert log file details ---

Thu Feb 27 12:35:04 2020

ALTER DATABASE RECOVER AUTOMATIC STANDBY DATABASE
Thu Feb 27 12:35:04 2020
Media Recovery Start
Started logmerger process
Thu Feb 27 12:35:04 2020
Managed Standby Recovery not using Real Time Apply
Thu Feb 27 12:35:04 2020
Parallel Media Recovery started with 4 slaves
Thu Feb 27 12:35:04 2020
Media Recovery Log /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_2_760_1020157972.arc
Thu Feb 27 12:35:04 2020
Media Recovery Log /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1071_1020157972.arc
Thu Feb 27 12:35:04 2020
Errors with log /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1071_1020157972.arc
Thu Feb 27 12:35:04 2020
Errors in file /u01/app/oracle/diag/rdbms/smrrac/smrrac/trace/smrrac_pr00_5908.trc:
ORA-00308: cannot open archived log '/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1071_1020157972.arc'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-279 signalled during: ALTER DATABASE RECOVER AUTOMATIC STANDBY DATABASE ...
ALTER DATABASE RECOVER CONTINUE DEFAULT
Thu Feb 27 12:35:56 2020
Media Recovery Log /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1071_1020157972.arc
ORA-279 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
ALTER DATABASE RECOVER CONTINUE DEFAULT
Thu Feb 27 12:36:02 2020
Media Recovery Log /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1072_1020157972.arc
ORA-279 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
ALTER DATABASE RECOVER CONTINUE DEFAULT
Thu Feb 27 12:36:15 2020
Media Recovery Log /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1073_1020157972.arc
ORA-279 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
ALTER DATABASE RECOVER CONTINUE DEFAULT
Thu Feb 27 12:36:26 2020
Media Recovery Log /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1074_1020157972.arc
ORA-279 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
ALTER DATABASE RECOVER CONTINUE DEFAULT
Thu Feb 27 12:36:26 2020
Media Recovery Log /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_2_761_1020157972.arc
ORA-279 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
ALTER DATABASE RECOVER CONTINUE DEFAULT
Thu Feb 27 12:36:40 2020
Media Recovery Log /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1075_1020157972.arc
ORA-279 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
ALTER DATABASE RECOVER CONTINUE DEFAULT
Thu Feb 27 12:36:44 2020
Media Recovery Log /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1076_1020157972.arc
ORA-279 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
ALTER DATABASE RECOVER CONTINUE DEFAULT
Thu Feb 27 12:36:44 2020
Media Recovery Log /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_2_762_1020157972.arc
ORA-279 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
ALTER DATABASE RECOVER CONTINUE DEFAULT
Thu Feb 27 12:36:44 2020
Media Recovery Log /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1077_1020157972.arc
ORA-279 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
ALTER DATABASE RECOVER CONTINUE DEFAULT
Thu Feb 27 12:36:44 2020
Media Recovery Log /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_2_763_1020157972.arc
ORA-279 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
ALTER DATABASE RECOVER CONTINUE DEFAULT
Thu Feb 27 12:36:44 2020
Media Recovery Log /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1078_1020157972.arc
Thu Feb 27 12:36:44 2020
Errors with log /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1078_1020157972.arc
Thu Feb 27 12:36:44 2020
Errors in file /u01/app/oracle/diag/rdbms/smrrac/smrrac/trace/smrrac_pr00_5908.trc:
ORA-00308: cannot open archived log '/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1078_1020157972.arc'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-308 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
ALTER DATABASE RECOVER CANCEL
Thu Feb 27 12:36:44 2020
Media Recovery Canceled
Completed: ALTER DATABASE RECOVER CANCEL

SQL> RECOVER AUTOMATIC STANDBY DATABASE ;
ORA-00279: change 85985278 generated at 02/26/2020 16:50:38 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1071_1020157972.arc
ORA-00280: change 85985278 for thread 1 is in sequence #1071
ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1071_1020157972.arc' no longer needed for this recovery
ORA-00308: cannot open archived log '/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1071_1020157972.arc'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

auto
ORA-00279: change 86048248 generated at 02/26/2020 19:10:36 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1072_1020157972.arc
ORA-00280: change 86048248 for thread 1 is in sequence #1072
ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1071_1020157972.arc' no longer needed for this recovery

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00279: change 86150690 generated at 02/26/2020 20:42:39 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1073_1020157972.arc
ORA-00280: change 86150690 for thread 1 is in sequence #1073
ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1072_1020157972.arc' no longer needed for this recovery

ORA-00279: change 86233478 generated at 02/26/2020 22:01:30 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1074_1020157972.arc
ORA-00280: change 86233478 for thread 1 is in sequence #1074
ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1073_1020157972.arc' no longer needed for this recovery

ORA-00279: change 86233481 generated at 02/26/2020 22:01:32 needed for thread 2
ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_2_761_1020157972.arc
ORA-00280: change 86233481 for thread 2 is in sequence #761
ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_2_760_1020157972.arc' no longer needed for this recovery

ORA-00279: change 86326645 generated at 02/27/2020 01:09:15 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1075_1020157972.arc
ORA-00280: change 86326645 for thread 1 is in sequence #1075
ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1074_1020157972.arc' no longer needed for this recovery

ORA-00279: change 86364645 generated at 02/27/2020 05:05:12 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1076_1020157972.arc
ORA-00280: change 86364645 for thread 1 is in sequence #1076
ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1075_1020157972.arc' no longer needed for this recovery

ORA-00279: change 86364649 generated at 02/27/2020 05:05:13 needed for thread 2
ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_2_762_1020157972.arc
ORA-00280: change 86364649 for thread 2 is in sequence #762
ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_2_761_1020157972.arc' no longer needed for this recovery

ORA-00279: change 86364658 generated at 02/27/2020 05:05:14 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1077_1020157972.arc
ORA-00280: change 86364658 for thread 1 is in sequence #1077
ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1076_1020157972.arc' no longer needed for this recovery

ORA-00279: change 86364661 generated at 02/27/2020 05:05:16 needed for thread 2
ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_2_763_1020157972.arc
ORA-00280: change 86364661 for thread 2 is in sequence #763
ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_2_762_1020157972.arc' no longer needed for this recovery

ORA-00279: change 86365002 generated at 02/27/2020 05:08:12 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1078_1020157972.arc
ORA-00280: change 86365002 for thread 1 is in sequence #1078
ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1077_1020157972.arc' no longer needed for this recovery

ORA-00308: cannot open archived log '/u01/app/oracle/fast_recovery_area/SMRRAC/archivelog/arch_1_1078_1020157972.arc'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

SQL> SQL> @/home/oracle/d

NAME INSTANCE_NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE CURRENT_SCN FAILOVER_SCN
--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------
SMRRAC smrrac smrrac MOUNTED PHYSICAL STANDBY NO 0

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/fast_recovery_area/SMRRAC/archivelog
Oldest online log sequence 0
Next log sequence to archive 0
Current log sequence 0
SQL>

Oracle Database Commands and Practical Examples

HOME

Friday 28 February 2020

Manual NON RAC DR physical standby Database 12c

No comments:

Post a Comment