Question I can't find an answer to...
Date: Mon, 9 Apr 2018 18:37:54 -0500
Message-ID: <CAP79kiSJp9s-5rJ2HrtZAXOKWeSsyc5BkMswN5gObHVEGswnqQ_at_mail.gmail.com>
DB: 12.1.0.2
Situation: Standby database recovery using incremental backup from Prod
I've done this before on another db, but not regularly. Following note:
Steps to perform for Rolling Forward a Physical Standby Database using RMAN Incremental Backup. (Doc ID 836986.1)
It says:
On the standby database, find the SCN which will be used for the incremental backup at the primary database:
You need to use the 'lowest SCN' from the queries below:
SQL> SELECT CURRENT_SCN FROM V$DATABASE; CURRENT_SCN
3164433
SQL> select min(checkpoint_change#) from v$datafile_header where file# not in (select file# from v$datafile where enabled = 'READ ONLY'); MIN(F.FHSCN)
3162298
Problem is, on my physical standby I have several datafiles with 0 as the checkpoint_change#. (SYSAUX is one of them and we haven't added any datafiles to SYSAUX - datafile #2 which is the 2nd datafile ever created)
Does this mean I should use 0 as my starting SCN for the backup? I sure as hell hope not. I'm hopeful I can ignore a 0 there but I'm confused and I can't find an answer anywhere online.
(I've run into this before but can't remember if it mattered or if I did indeed need to take a level 0 backup at the primary)
Regards,
Chris
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 10 2018 - 01:37:54 CEST