Skip to Main Content

Database Software

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!

rman keeps different scn

GTS (DBA)Sep 25 2015 — edited Sep 27 2015

Good Morning ,

How rman backup having different SCN ?

Rman backup is consistent backup  unlike hot backup.

In my case , some datafiles having different SCN's ,

Suppose no archive logs (deleted manually)

If i perform recovery , how rman can sync  different scn's ?

Please see HIGN SCN  column

RMAN> backup validate database;

Starting backup at 26-SEP-15

using channel ORA_DISK_1

channel ORA_DISK_1: starting compressed full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set


..

...


List of Datafiles

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

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

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

1    OK     0              13623        218952          60292123

  File Name: /u02/app/oracle/oradata/orcl/system01.dbf

  Block Type Blocks Failing Blocks Processed

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

  Data       0              175372

  Index      0              14086

  Other      0              15799

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

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

2    OK     0              21593        126728          60292106

  File Name: /u02/app/oracle/oradata/orcl/sysaux01.dbf

  Block Type Blocks Failing Blocks Processed

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

  Data       0              41535

  Index      0              28122

  Other      0              35470

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

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

3    OK     0              19991        963656          60178764

  File Name: /u01/app/oracle/oradata/orcl/sda01.dbf

  Block Type Blocks Failing Blocks Processed

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

  Data       0              939356

  Index      0              0

  Other      0              4309


File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

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

7    OK     0              6267         6400            37958094

  File Name: /u02/app/oracle/oradata/orcl/tbs1_01.dbf

  Block Type Blocks Failing Blocks Processed

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

  Data       0              0

  Index      0              3

  Other      0              130

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

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

8    OK     0              6273         6400            37957419

  File Name: /u02/app/oracle/oradata/orcl/tbs2_01.dbf

  Block Type Blocks Failing Blocks Processed

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

  Data       0              0

  Index      0              0

  Other      0              127

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

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

9    OK     0              5            6400            60292118

  File Name: /u02/app/oracle/oradata/orcl/tbs3_01.dbf

  Block Type Blocks Failing Blocks Processed

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

  Data       0              5798

  Index      0              51

  Other      0              546

..

...

Thanks in advance.

This post has been answered by Shivananda Rao on Sep 27 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 25 2015
Added on Sep 25 2015
11 comments
1,428 views