Monday 4 October 2021

Dataguard: physical standby database restoration using full rman backup


Scenario Preview: Resolving gap between primary and physical standby database  resolved  by taking incremental backup  and perform recovery using rman incremental backup.

  • Query to check current SCN status of standby database. Run on standby DB.

SQL> SELECT CURRENT_SCN FROM V$DATABASE;


CURRENT_SCN

-----------

  339341431


SQL>  select min(fhscn) from x$kcvfh;


MIN(FHSCN)

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

339341432


SQL>  select min(f.fhscn) from x$kcvfh f, v$datafile d where f.hxfil =d.file# and d.enabled != 'READ ONLY';


MIN(F.FHSCN)

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

339341432

  • SCN  based  rman incremental backup  command below for reference.


run

{

allocate channel d0 type disk FORMAT 'backupscn_based%d_%s_%t.bak';

allocate channel d1 type disk FORMAT 'backupscn_based%d_%s_%t.bak';

allocate channel d2 type disk FORMAT 'backupscn_based%d_%s_%t.bak';

allocate channel d3 type disk FORMAT 'backupscn_based%d_%s_%t.bak';

backup as compressed backupset incremental from scn 339341432 database;

copy current controlfile to 'backupscn_basedcontrol01full_%d_%t_%U.bak';

backup current controlfile for standby format 'backupscn_basedstandbycontrol_%d_%T_%U.ctl';

RELEASE CHANNEL d0;

RELEASE CHANNEL d1;

RELEASE CHANNEL d2;

RELEASE CHANNEL d3;

}


  • Open database in nomount stage and restore control file 

[oracle@srv4 backup]$ . oraenv

ORACLE_SID = [ZABBIXDR] ?

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

[oracle@srv4 backup]$ sqlplus / as sysdba


SQL*Plus: Release 12.1.0.2.0 Production on Tue Jul 27 18:37:36 2021


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> shut immediate;

ORA-01109: database not open



Database dismounted.

ORACLE instance shut down.

SQL> startup nomount;

ORACLE instance started.


Total System Global Area 1795162112 bytes

Fixed Size                  2925456 bytes

Variable Size             620760176 bytes

Database Buffers         1157627904 bytes

Redo Buffers               13848576 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@srv4 backup]$ rman target /


Recovery Manager: Release 12.1.0.2.0 - Production on Tue Jul 27 18:40:44 2021


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


connected to target database: ZABBIX (not mounted)


RMAN> restore standby controlfile from '/u01/backup/standbycontrol_ZABBIX_1d051c76_1_1.ctl';

Starting restore at 27-JUL-21

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=23 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/ZABBIXDR/control01.ctl

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

Finished restore at 27-JUL-21

  • Open database in mount stage and restore  standby database 

RMAN> sql 'alter database mount standby database';


sql statement: alter database mount standby database

released channel: ORA_DISK_1


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


Starting implicit crosscheck backup at 27-JUL-21

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=24 device type=DISK

Crosschecked 13 objects

Finished implicit crosscheck backup at 27-JUL-21


Starting implicit crosscheck copy at 27-JUL-21

using channel ORA_DISK_1

Crosschecked 6 objects

Finished implicit crosscheck copy at 27-JUL-21


searching for all files in the recovery area

cataloging files...

cataloging done


List of Cataloged Files

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

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/autobackup/2021_07_25/o1_mf_s_1078857835_jhts676p_.bkp

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/autobackup/2021_07_23/o1_mf_s_1078691869_jhopt5fk_.bkp

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/autobackup/2021_07_19/o1_mf_s_1078341966_jhc13pjr_.bkp

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_17/o1_mf_1_51_jh5txgn3_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_17/o1_mf_1_52_jh5w956q_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_27/o1_mf_1_33_jhz922g1_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_27/o1_mf_1_34_jhz923jb_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_27/o1_mf_1_32_jhz87wwc_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_27/o1_mf_1_35_jhzcszvk_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_27/o1_mf_1_31_jhz87yd4_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_26/o1_mf_1_29_jhxdgqjh_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_26/o1_mf_1_28_jhx8b6c8_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_26/o1_mf_1_26_jhx752c2_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_26/o1_mf_1_27_jhx754fs_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_26/o1_mf_1_25_jhx750kr_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_26/o1_mf_1_24_jhwmbsk6_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_26/o1_mf_1_30_jhxfy2os_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_21_jhtrwp8q_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_10_jhtr7176_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_11_jhtr72bt_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_12_jhtr73o7_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_23_jhts9kwh_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_9_jhtqv96b_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_15_jhtrmltg_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_17_jhtrnorq_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_19_jhtrwhvo_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_8_jhtqv8w7_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_16_jhtrmmh5_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_18_jhtrpgbr_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_13_jhtrmj20_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_20_jhtrwmnk_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_6_jhtpbq66_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_14_jhtrmlrt_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_22_jhts9jpq_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_25/o1_mf_1_7_jhtqjvr0_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_08/o1_mf_1_49_jgg446oc_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_23/o1_mf_1_2_jhokqtln_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_23/o1_mf_1_3_jhop0w97_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_23/o1_mf_1_4_jhop0wt0_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_23/o1_mf_1_5_jhopsvv9_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_19/o1_mf_1_54_jhbqjq1l_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_19/o1_mf_1_64_jhc0njy1_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_19/o1_mf_1_58_jhbw0yf3_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_19/o1_mf_1_61_jhbzy9yf_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_19/o1_mf_1_57_jhbw02oc_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_19/o1_mf_1_63_jhbzyc4y_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_19/o1_mf_1_53_jhbqjqf9_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_19/o1_mf_1_56_jhbvzxjs_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_19/o1_mf_1_60_jhbzy6vz_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_19/o1_mf_1_55_jhbr7mg0_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_19/o1_mf_1_62_jhbzy9xr_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_19/o1_mf_1_59_jhbw495f_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR/archivelog/2021_07_19/o1_mf_1_1_jhc0tnhq_.arc


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


List of Files Unknown to the Database

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

File Name: /u01/backup/standbycontrol_ZABBIX_1d051c76_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/backup/standbycontrol_ZABBIX_1d051c76_1_1.ctl


RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 20 BACKUP TYPE TO BACKUPSET;


new RMAN configuration parameters:

CONFIGURE DEVICE TYPE DISK PARALLELISM 20 BACKUP TYPE TO BACKUPSET;

new RMAN configuration parameters are successfully stored

released channel: ORA_DISK_1


RMAN>  RECOVER DATABASE NOREDO;


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


PROCESS   STATUS        SEQUENCE#

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

ARCH      CONNECTED             0

ARCH      CONNECTED             0

ARCH      CONNECTED             0

ARCH      CONNECTED             0

  • Apply Media recovery process on standby database 

RMAN> alter database recover managed standby database disconnect from session;


Statement processed


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




Posted by at No comments:
Labels:

ORA-38880: Cannot advance compatibility from 12.1.0.2.0 to 19.0.0.0.0 due to guaranteed restore points


We recently done manual upgradation from 12c to 19c  after post upgrade  after changing compatible parameter to 19c we still  got error. This is due to restore point was not dropped before pre upgrade. so we shut reverted back compatible parameter to 12c and delete restore point  then change it back to 19c compatible parameter and startup the database server. 

Error: 

ORA-38880: Cannot advance compatibility from 12.1.0.2.0 to 19.0.0.0.0 due to guaranteed restore points


 Scenario: 


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

Total System Global Area 1862269648 bytes
Fixed Size                  9136848 bytes
Variable Size             637534208 bytes
Database Buffers         1207959552 bytes
Redo Buffers                7639040 bytes
ORA-38880: Cannot advance compatibility from 12.1.0.2.0 to 19.0.0.0.0 due to guaranteed restore points

SQL> show parameter compatible;

NAME                                 TYPE                              VALUE
------------------------------------ --------------------------------- ------------------------------
compatible                           string                            19.0.0
noncdb_compatible                    boolean                           FALSE
SQL>  select name from v$restore_point;
 select name from v$restore_point
                  *
ERROR at line 1:
ORA-01507: database not mounted

SQL> shutdown immediate;
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> startup force;
ORACLE instance started.

Total System Global Area 1862269648 bytes
Fixed Size                  9136848 bytes
Variable Size             637534208 bytes
Database Buffers         1207959552 bytes
Redo Buffers                7639040 bytes
ORA-38880: Cannot advance compatibility from 12.1.0.2.0 to 19.0.0.0.0 due to guaranteed restore points

  • Change  compatible parameter to 12.1.0.2.0 then check restore point and delete it.

    • SQL> alter system set compatible="12.1.0.2.0" scope=spfile;

    System altered.

    SQL> startup force;
    ORACLE instance started.

    Total System Global Area 1862269648 bytes
    Fixed Size                  9136848 bytes
    Variable Size             637534208 bytes
    Database Buffers         1207959552 bytes
    Redo Buffers                7639040 bytes
    Database mounted.
    Database opened.

    SQL> select GUARANTEE_FLASHBACK_DATABASE,NAME from v$restore_point;

    GUA NAME
    --- --------------------------------------------------------------------------------------------------------------------------------
    YES BEFORE_UPGRADE_19C

    1 row selected.

    SQL> select flashback_On from v$database;

    FLASHBACK_ON
    ------------------
    RESTORE POINT ONLY

    1 row selected.

    SQL> alter database flashback off;

    Database altered.

    SQL> select flashback_On from v$database;

    FLASHBACK_ON
    ------------------
    RESTORE POINT ONLY

    1 row selected.

    SQL> drop restore point BEFORE_UPGRADE_19C;

    Restore point dropped.

    SQL> select flashback_On from v$database;

    FLASHBACK_ON
    ------------------
    NO

    1 row selected.

    SQL> show parameter compatible

    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    compatible                           string      12.1.0.2.0
    noncdb_compatible                    boolean     FALSE

    SQL>  alter system set compatible='19.0.0' scope=spfile;

    System altered.

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

    Total System Global Area 1862269648 bytes
    Fixed Size                  9136848 bytes
    Variable Size             637534208 bytes
    Database Buffers         1207959552 bytes
    Redo Buffers                7639040 bytes
    Database mounted.

    Database opened.
    SQL> SQL> sho parameter compatible

    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    compatible                           string      19.0.0
    noncdb_compatible                    boolean     FALSE
    SQL>

    Posted by at 1 comment:
    Labels:

    Dataguard - Restore standby database Using Full rman backup

    Dataguard - Restore standby database Using Full  rman backup 


    • Create full rman backup on primary database.
    • SCP  backup file to standby database 
    • start standby database  in nomount stage
    • Restore standby control file from rman 
    • start db in mount stage
    • Catalog rman backup on standby database
    • Restore datbabase
    • Apply mrp process


    • Create full rman backup on primary database.


    RMAN> run

    {

    allocate channel c1 device type disk format '/u01/rmanbkp/Backup_%d_DB_%u_%s_%p_%T';

    2> 3> 4> 5> 6>

    allocate channel c2 device type disk format '/u01/rmanbkp/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 '/u01/rmanbkp/%d_%U.bckp' plus archivelog;

    copy current controlfile to '/u01/rmanbkp/control_%d_%T.bak';

    backup current controlfile for standby format '/u01/rmanbkp/standbycontrol_%d_%U.ctl';


    release channel c1;


    release channel c2;


    }7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31>



    [oracle@srv6 rmanbkp]$ ll


    total 697904


    -rw-r----- 1 oracle oinstall  11801088 Sep 15 17:04 Backup_ORCL12C_DB_0f0951pg_15_1_20210915

    -rw-r----- 1 oracle oinstall   6962176 Sep 15 17:04 Backup_ORCL12C_DB_0g0951pg_16_1_20210915

    -rw-r----- 1 oracle oinstall    836608 Sep 15 17:04 Backup_ORCL12C_DB_0h0951pn_17_1_20210915

    -rw-r----- 1 oracle oinstall 215261184 Sep 15 17:07 Backup_ORCL12C_DB_0i0951po_18_1_20210915

    -rw-r----- 1 oracle oinstall 115064832 Sep 15 17:06 Backup_ORCL12C_DB_0j0951po_19_1_20210915

    -rw-r----- 1 oracle oinstall 110133248 Sep 15 17:08 Backup_ORCL12C_DB_0k0951t2_20_1_20210915

    -rw-r----- 1 oracle oinstall 110051328 Sep 15 17:08 Backup_ORCL12C_DB_0l0951uf_21_1_20210915

    -rw-r----- 1 oracle oinstall  54157312 Sep 15 17:08 Backup_ORCL12C_DB_0m0951vt_22_1_20210915

    -rw-r----- 1 oracle oinstall  54157312 Sep 15 17:09 Backup_ORCL12C_DB_0n09521a_23_1_20210915

    -rw-r----- 1 oracle oinstall    155136 Sep 15 17:09 Backup_ORCL12C_DB_0o095223_24_1_20210915

    -rw-r----- 1 oracle oinstall  18006016 Sep 15 17:09 control_ORCL12C_20210915.bak

    -rw-r----- 1 oracle oinstall  18055168 Sep 15 17:09 standbycontrol_ORCL12C_0q095226_1_1.ctl


    • Transfer rman backup to standby location 

    [oracle@srv6 rmanbkp]$ scp * oracle@srv7:/u01/rmanbkp/

    oracle@srv7's password:

    Backup_ORCL12C_DB_0f0951pg_15_1_20210915                                                                                             100%   11MB  42.9MB/s   00:00

    Backup_ORCL12C_DB_0g0951pg_16_1_20210915                                                                                            100% 6799KB  28.7MB/s   00:00

    Backup_ORCL12C_DB_0h0951pn_17_1_20210915                                                                                             100%  817KB  26.0MB/s   00:00

    Backup_ORCL12C_DB_0i0951po_18_1_20210915                                                                                             100%  205MB  52.3MB/s   00:03

    Backup_ORCL12C_DB_0j0951po_19_1_20210915                                                                                             100%  110MB  48.7MB/s   00:02

    Backup_ORCL12C_DB_0k0951t2_20_1_20210915                                                                                             100%  105MB  55.2MB/s   00:01

    Backup_ORCL12C_DB_0l0951uf_21_1_20210915                                                                                             100%  105MB  56.2MB/s   00:01

    Backup_ORCL12C_DB_0m0951vt_22_1_20210915                                                                                             100%   52MB  62.9MB/s   00:00

    Backup_ORCL12C_DB_0n09521a_23_1_20210915                                                                                             100%   52MB  53.6MB/s   00:00

    Backup_ORCL12C_DB_0o095223_24_1_20210915                                                                                             100%  152KB  20.6MB/s   00:00

    control_ORCL12C_20210915.bak                                                                                                         100%   17MB  60.2MB/s   00:00

    standbycontrol_ORCL12C_0q095226_1_1.ctl                                                                                              100%   17MB  53.3MB/s   00:00

    [oracle@srv6 rmanbkp]$


    • Shut down and start standby database  in nomount stage

    [oracle@srv7 rmanbkp]$ sqlplus / as sysdba


    SQL*Plus: Release 12.1.0.2.0 Production on Wed Sep 15 17:28:17 2021


    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> shut immediate;


    ORA-01109: database not open

    Database dismounted.

    ORACLE instance shut down.

    SQL> startup nomount;

    ORACLE instance started.

    Total System Global Area 1862270976 bytes

    Fixed Size                  2925648 bytes

    Variable Size             687868848 bytes

    Database Buffers         1157627904 bytes

    Redo Buffers               13848576 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 control file using rman backup 


    [oracle@srv7 rmanbkp]$ rman target /


    Recovery Manager: Release 12.1.0.2.0 - Production on Wed Sep 15 17:30:06 2021


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


    connected to target database: ORCL12C (not mounted)


    RMAN>  restore standby controlfile from '/u01/rmanbkp/standbycontrol_ORCL12C_0q095226_1_1.ctl'


    2> ;


    Starting restore at 2021-09-15:17:30:11


    using target database control file instead of recovery catalog


    allocated channel: ORA_DISK_1


    channel ORA_DISK_1: SID=23 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/orcl12cdr/control01.ctl


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


    Finished restore at 2021-09-15:17:30:13


    Open standby database in mount stage


    RMAN> alter database mount standby database;


    Statement processed


    released channel: ORA_DISK_1

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


    Starting implicit crosscheck backup at 2021-09-15:17:30:44


    allocated channel: ORA_DISK_1


    channel ORA_DISK_1: SID=33 device type=DISK


    Crosschecked 18 objects


    Finished implicit crosscheck backup at 2021-09-15:17:30:45


    Starting implicit crosscheck copy at 2021-09-15:17:30:45


    using channel ORA_DISK_1


    Crosschecked 2 objects


    Finished implicit crosscheck copy at 2021-09-15:17:30:45


    searching for all files in the recovery area


    cataloging files...


    cataloging done


    List of Cataloged Files


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


    File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_08_31/o1_mf_1_20_jlw664wb_.arc


    File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_08_31/o1_mf_1_22_jlw6652v_.arc


    File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_08_31/o1_mf_1_14_jlvrvoj6_.arc


    File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_08_31/o1_mf_1_21_jlw6651s_.arc


    File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_08_31/o1_mf_1_25_jlw6cjvw_.arc


    File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_08_31/o1_mf_1_24_jlw6chrb_.arc


    File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_08_31/o1_mf_1_23_jlw6650r_.arc


    File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_09_15/o1_mf_1_26_jn39jqxc_.arc


    File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_09_15/o1_mf_1_34_jn3pkflm_.arc


    File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_09_15/o1_mf_1_27_jn39jpz2_.arc


    File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_09_15/o1_mf_1_31_jn3b7hkv_.arc


    File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_09_15/o1_mf_1_28_jn39zbn9_.arc


    File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_09_15/o1_mf_1_37_jn3pvclg_.arc


    File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_09_15/o1_mf_1_30_jn3b7ggn_.arc


    File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_09_15/o1_mf_1_32_jn3myjq8_.arc


    File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_09_15/o1_mf_1_36_jn3plqmh_.arc


    File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_09_15/o1_mf_1_33_jn3nmy9l_.arc


    File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_09_15/o1_mf_1_35_jn3plq71_.arc


    File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_09_15/o1_mf_1_29_jn39zcpj_.arc


    File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_08_27/o1_mf_1_12_jlkjmqwy_.arc


    File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_08_27/o1_mf_1_13_jlkjnw8r_.arc


    File Name: /u01/app/oracle/fast_recovery_area/ORCL12CDR/archivelog/2021_08_27/o1_mf_1_11_jlkjm2o3_.arc


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


    List of Files Unknown to the Database


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


    File Name: /u01/rmanbkp/standbycontrol_ORCL12C_0q095226_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/rmanbkp/standbycontrol_ORCL12C_0q095226_1_1.ctl


    • When full backup restoration on standby database 

    RMAN> restore database;


    Starting restore at 2021-09-15:17:30:54


    using channel ORA_DISK_1


    skipping datafile 5; already restored to file /u01/app/oracle/oradata/orcl12cdr/pdbseed/system01.dbf


    skipping datafile 7; already restored to file /u01/app/oracle/oradata/orcl12cdr/pdbseed/sysaux01.dbf


    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/orcl12cdr/sysaux01.dbf


    channel ORA_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/orcl12cdr/users01.dbf


    channel ORA_DISK_1: reading from backup piece /u01/rmanbkp/Backup_ORCL12C_DB_0j0951po_19_1_20210915


    channel ORA_DISK_1: piece handle=/u01/rmanbkp/Backup_ORCL12C_DB_0j0951po_19_1_20210915 tag=TAG20210915T170456


    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 00001 to /u01/app/oracle/oradata/orcl12cdr/system01.dbf


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


    channel ORA_DISK_1: reading from backup piece /u01/rmanbkp/Backup_ORCL12C_DB_0i0951po_18_1_20210915


    channel ORA_DISK_1: piece handle=/u01/rmanbkp/Backup_ORCL12C_DB_0i0951po_18_1_20210915 tag=TAG20210915T170456


    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 00009 to /u01/app/oracle/oradata/orcl12cdr/pdb12c/sysaux01.dbf


    channel ORA_DISK_1: reading from backup piece /u01/rmanbkp/Backup_ORCL12C_DB_0k0951t2_20_1_20210915


    channel ORA_DISK_1: piece handle=/u01/rmanbkp/Backup_ORCL12C_DB_0k0951t2_20_1_20210915 tag=TAG20210915T170456


    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 00008 to /u01/app/oracle/oradata/orcl12cdr/pdb12c/system01.dbf


    channel ORA_DISK_1: restoring datafile 00010 to /u01/app/oracle/oradata/orcl12cdr/pdb12c/pdb12c_users01.dbf


    channel ORA_DISK_1: reading from backup piece /u01/rmanbkp/Backup_ORCL12C_DB_0m0951vt_22_1_20210915


    channel ORA_DISK_1: piece handle=/u01/rmanbkp/Backup_ORCL12C_DB_0m0951vt_22_1_20210915 tag=TAG20210915T170456


    channel ORA_DISK_1: restored backup piece 1


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


    Finished restore at 2021-09-15:17:33:15


    • Apply media recovery process to using command below

    RMAN> alter database recover managed standby database disconnect from session;


    Statement processed


    RMAN> exit


    Recovery Manager complete.


    [oracle@srv7 rmanbkp]$ sqlplus / as sysdba


    SQL*Plus: Release 12.1.0.2.0 Production on Wed Sep 15 17:53:34 2021


    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> select name,open_mode,database_role from v$database;


    NAME      OPEN_MODE            DATABASE_ROLE


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


    ORCL12C   MOUNTED              PHYSICAL STANDBY


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


    PROCESS   STATUS        SEQUENCE#


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


    ARCH      CONNECTED             0


    ARCH      CONNECTED             0


    ARCH      CONNECTED             0


    ARCH      CONNECTED             0


    RFS       IDLE                 38


    RFS       IDLE                  0


    MRP0      APPLYING_LOG         38


    7 rows selected.


    SQL>



    Posted by at No comments:
    Labels: ,
    Subscribe to: Posts (Atom)