RE: RMAM duplicate database

From: Lawie, Duncan <duncan.lawie_at_credit-suisse.com>
Date: Fri, 22 Dec 2006 04:22:15 -0500
Message-ID: <07150B51CE30744CBBB58E696139708D0A8F3762@elon11p32002.csfp.co.uk>

I don't believe I can safely subtract one from the SCN and expect it to be in an existing log - and I get the same error as with the higher number

Oracle Error:

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 3 was not restored from a sufficiently old backup
ORA-01110: data file 3: '/data/oracle/TESTDBE30/u01/sysaux01.dbf'

Now that error doesn't make sense, as the file 3 has a higher SCN than 1 or 2 ...

SQL> select FILE#, CHECKPOINT_CHANGE# from v$datafile_header order by 1;

FILE# CHECKPOINT_CHANGE#

---------- ------------------
         1           45670185
         2           45670185
         3           45670188

...

Note that recovery works if I use the checkpoint_change# for file 3. But this database was pretty static when it was backed up.

From: Rajeev Prabhakar [mailto:rprabha01_at_gmail.com] Sent: 21 December 2006 18:25
To: duncan.lawie_at_credit-suisse.com
Cc: oracle-l_at_freelists.org
Subject: Re: RMAM duplicate database - until when?

On your source db, get the scn info :

select max(next_change#)-1 from v$archived_log;

-Rajeev

On 12/21/06, Lawie, Duncan <duncan.lawie_at_credit-suisse.com <mailto:duncan.lawie_at_credit-suisse.com> > wrote:

List,

I'm suffering at the hands of the rman cloning code.

I'm doing a
"backup database incremental level zero plus archivelog"

I've shown an output from the "list backup" at the bottom of the email.

What I want to do is

run {
set until scn XXX
duplicate target database to TESTDBE30;
}

Where XXX is the last SCN in the backup.

How do I find this?

rc_backup_archivelog_details will tell me the next_change# of the archivelog - but that isn't the last SCN in the current file is it?

BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ---------------

4280    Incr 0  108.34M    DISK        00:00:51     20 Dec 11:37:23
       BP Key: 4286   Status: AVAILABLE  Compressed: YES  Tag: TAG20061220T113632 
       Piece Name: /app/oracle/TESTRAC80/admin/rman/whole_db_online_backup_TESTRAC80_70_26i5duq0_1_1_20061220
List of Datafiles in backup set 4280
File LV Type Ckp SCN    Ckp Time        Name

---- -- ---- ---------- --------------- ---- 1 0 Incr 45670185 20 Dec 11:36:33 /data/oracle/TESTRAC80/u01/system01.dbf

.
.
.

8 0 Incr 45670188 20 Dec 11:36:34 /data/oracle/TESTRAC80/u01/soeindex.dbf

BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ---------------

4306    27.50K     DISK        00:00:02     20 Dec 11:37:53
       BP Key: 4313   Status: AVAILABLE  Compressed: YES  Tag: TAG20061220T113742
       Piece Name: /app/oracle/TESTRAC80/admin/rman/whole_db_online_backup_TESTRAC80_72_28i5dusf_1_1_20061220 

List of Archived Logs in backup set 4306
Thrd Seq     Low SCN    Low Time        Next SCN   Next Time

---- ------- ---------- --------------- ---------- --------- 1 3004 45670151 20 Dec 11:36:03 45670267 20 Dec 11:37:29

BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ---------------

4307    2.00K      DISK        00:00:02     20 Dec 11:37:53
       BP Key: 4314   Status: AVAILABLE  Compressed: YES  Tag: TAG20061220T113742 
       Piece Name: /app/oracle/TESTRAC80/admin/rman/whole_db_online_backup_TESTRAC80_73_29i5dusf_1_1_20061220

List of Archived Logs in backup set 4307
Thrd Seq     Low SCN    Low Time        Next SCN   Next Time

---- ------- ---------- --------------- ---------- --------- 2 2952 45670149 20 Dec 11:34:03 45670270 20 Dec 11:35:31

BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ---------------

4323    Full    15.98M     DISK        00:00:02     20 Dec 11:38:00
       BP Key: 4325   Status: AVAILABLE  Compressed: NO  Tag: TAG20061220T113758
       Piece Name: /app/oracle/TESTRAC80/admin/rman/whole_db_online_backup_TESTRAC80_c-2618574194-20061220-02 
Control File Included: Ckp SCN: 45670323     Ckp time: 20 Dec 11:37:58

SPFILE Included: Modification time: 14 Dec 19:11:16

Duncan Lawie
DBE - Oracle
020 788 3 9229
"Problems cannot be solved at the same level of awareness that created them." -- Albert Einstein

Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html <http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html>

--
http://www.freelists.org/webpage/oracle-l  <http://www.freelists.org/webpage/oracle-l> 






==============================================================================
Please access the attached hyperlink for an important electronic communications disclaimer: 

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================


--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 22 2006 - 03:22:15 CST

RE: RMAM duplicate database - until when?