Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

standby recovery error.

sanyJan 3 2022

Dear i am getting below error while recovering stand by from primary .

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
[oracle@stby1 root]$ rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Mon Jan 3 18:41:08 2022

connected to target database: ORCL (DBID=1619830673, not open)

RMAN> recover database from service orcl noredo using compressed backupset;

Starting recover at 03-JAN-22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=41 instance=stby1 device type=DISK
skipping datafile 5; already restored to SCN 1835747
skipping datafile 7; already restored to SCN 1835747
skipping datafile 9; already restored to SCN 1888356
skipping datafile 10; already restored to SCN 1888356
skipping datafile 11; already restored to SCN 1888356
skipping datafile 12; already restored to SCN 1888356
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using compressed network backup set from service orcl
destination for restore of datafile 00001: +DATA/STBY/DATAFILE/system.260.1092134003
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using compressed network backup set from service orcl
destination for restore of datafile 00003: +DATA/STBY/DATAFILE/sysaux.261.1092134011
channel ORA_DISK_1: restore complete, elapsed time: 00:00:08
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using compressed network backup set from service orcl
destination for restore of datafile 00004: +DATA/STBY/DATAFILE/undotbs1.262.1092134013
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using compressed network backup set from service orcl
destination for restore of datafile 00006: +DATA/STBY/DATAFILE/users.264.1092134015
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using compressed network backup set from service orcl
destination for restore of datafile 00008: +DATA/STBY/DATAFILE/undotbs2.266.1092134021
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

Finished recover at 03-JAN-22

RMAN> shutdown immediate;

database dismounted
Oracle instance shut down

RMAN> startup nomount;

connected to target database (not started)
Oracle instance started

Total System Global Area 3238002688 bytes

Fixed Size 2929600 bytes
Variable Size 855641152 bytes
Database Buffers 2365587456 bytes
Redo Buffers 13844480 bytes

RMAN> restore standby controlfile from service orcl ;

Starting restore at 03-JAN-22
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 instance=stby1 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: using network backup set from service orcl
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
output file name=+DATA/STBY/CONTROLFILE/current.258.1092133995
output file name=+DATA/STBY/CONTROLFILE/current.259.1092133995
Finished restore at 03-JAN-22

RMAN> alter database mount;

Statement processed
released channel: ORA_DISK_1

RMAN> report schema;

Starting implicit crosscheck backup at 03-JAN-22
allocated channel: ORA_DISK_1
Crosschecked 7 objects
Finished implicit crosscheck backup at 03-JAN-22

Starting implicit crosscheck copy at 03-JAN-22
using channel ORA_DISK_1
Finished implicit crosscheck copy at 03-JAN-22

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: +FRA/STBY/AUTOBACKUP/2021_12_26/s_1092315395.305.1092315395
File Name: +FRA/STBY/AUTOBACKUP/2021_12_24/s_1092150346.294.1092151019
File Name: +FRA/STBY/ARCHIVELOG/2022_01_03/thread_1_seq_67.287.1093024463
File Name: +FRA/STBY/ARCHIVELOG/2022_01_03/thread_1_seq_68.282.1093024463
File Name: +FRA/STBY/ARCHIVELOG/2022_01_03/thread_1_seq_49.280.1093024895
File Name: +FRA/STBY/ARCHIVELOG/2022_01_03/thread_1_seq_51.278.1093024895
File Name: +FRA/STBY/ARCHIVELOG/2022_01_03/thread_2_seq_22.277.1093024899
File Name: +FRA/STBY/ARCHIVELOG/2022_01_03/thread_1_seq_50.274.1093024897
File Name: +FRA/STBY/ARCHIVELOG/2022_01_03/thread_2_seq_30.270.1093024897
File Name: +FRA/STBY/ARCHIVELOG/2022_01_03/thread_2_seq_38.271.1093024911
File Name: +FRA/STBY/ARCHIVELOG/2022_01_03/thread_1_seq_69.749.1093025581
File Name: +FRA/STBY/ARCHIVELOG/2022_01_03/thread_1_seq_70.746.1093025581
File Name: +FRA/STBY/ARCHIVELOG/2022_01_03/thread_1_seq_71.745.1093025581
File Name: +FRA/STBY/ARCHIVELOG/2022_01_03/thread_2_seq_43.744.1093025581
File Name: +FRA/STBY/ARCHIVELOG/2022_01_03/thread_1_seq_72.743.1093025581
File Name: +FRA/STBY/ARCHIVELOG/2022_01_03/thread_1_seq_73.742.1093025583
File Name: +FRA/STBY/ARCHIVELOG/2022_01_03/thread_1_seq_77.741.1093026689
File Name: +FRA/STBY/ARCHIVELOG/2022_01_03/thread_1_seq_78.740.1093026693
File Name: +FRA/STBY/ARCHIVELOG/2022_01_03/thread_1_seq_79.739.1093026695
File Name: +FRA/STBY/ARCHIVELOG/2022_01_03/thread_1_seq_80.738.1093026699
File Name: +FRA/STBY/ARCHIVELOG/2022_01_03/thread_1_seq_81.737.1093026701
File Name: +FRA/STBY/ARCHIVELOG/2022_01_03/thread_1_seq_82.736.1093027111

RMAN-06139: WARNING: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name STBY

List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 0 SYSTEM *** +DATA/ORCL/DATAFILE/system.258.1092049859
3 0 SYSAUX *** +DATA/ORCL/DATAFILE/sysaux.257.1092049833
4 0 UNDOTBS1 *** +DATA/ORCL/DATAFILE/undotbs1.260.1092049895
5 0 PDB$SEED:SYSTEM *** +DATA/ORCL/FD9AC20F64D244D7E043B6A9E80A2F2F/DATAFILE/system.269.1092049945
6 0 USERS *** +DATA/ORCL/DATAFILE/users.259.1092049893
7 0 PDB$SEED:SYSAUX *** +DATA/ORCL/FD9AC20F64D244D7E043B6A9E80A2F2F/DATAFILE/sysaux.268.1092049945
8 0 UNDOTBS2 *** +DATA/ORCL/DATAFILE/undotbs2.271.1092050133
9 0 PDBORCL:SYSTEM *** +DATA/ORCL/FD9BD2B44413096FE043B6A9E80ABC28/DATAFILE/system.279.1092050257
10 0 PDBORCL:SYSAUX *** +DATA/ORCL/FD9BD2B44413096FE043B6A9E80ABC28/DATAFILE/sysaux.278.1092050257
11 0 PDBORCL:USERS *** +DATA/ORCL/FD9BD2B44413096FE043B6A9E80ABC28/DATAFILE/users.280.1092050257
12 0 PDBORCL:EXAMPLE *** +DATA/ORCL/FD9BD2B44413096FE043B6A9E80ABC28/DATAFILE/example.277.1092050257

List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 60 TEMP 32767 +DATA/ORCL/TEMPFILE/temp.267.1092049943
2 20 PDB$SEED:TEMP 32767 +DATA/ORCL/FD9AC20F64D244D7E043B6A9E80A2F2F/DATAFILE/pdbseed_temp012021-12-23_11-12-42-am.dbf
3 20 PDBORCL:TEMP 32767 +DATA/ORCL/FD9BD2B44413096FE043B6A9E80ABC28/DATAFILE/pdborcl_temp012021-12-23_11-18-05-am.dbf

RMAN> report schema
2> ;

RMAN-06139: WARNING: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name STBY

RMAN> Catalog start with '+DATA/STBY/DATAFILE/' ;

searching for all files that match the pattern +DATA/STBY/DATAFILE/

List of Files Unknown to the Database
=====================================
File Name: +DATA/STBY/DATAFILE/system.260.1092134003
File Name: +DATA/STBY/DATAFILE/sysaux.261.1092134011
File Name: +DATA/STBY/DATAFILE/undotbs1.262.1092134013
File Name: +DATA/STBY/DATAFILE/users.264.1092134015
File Name: +DATA/STBY/DATAFILE/undotbs2.266.1092134021

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

List of Cataloged Files
=======================
File Name: +DATA/STBY/DATAFILE/system.260.1092134003
File Name: +DATA/STBY/DATAFILE/sysaux.261.1092134011
File Name: +DATA/STBY/DATAFILE/undotbs1.262.1092134013
File Name: +DATA/STBY/DATAFILE/users.264.1092134015
File Name: +DATA/STBY/DATAFILE/undotbs2.266.1092134021

RMAN> SWITCH DATABASE TO COPY;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of switch to copy command at 01/03/2022 21:37:42
RMAN-06571: datafile 1 does not have recoverable copy

Added on Jan 3 2022

#general-database-discussions

1 comment

360 views