RE: RMAM duplicate database - until when?
- From: "Lawie, Duncan" <duncan.lawie@xxxxxxxxxxxxxxxxx>
- To: "'Rajeev Prabhakar'" <rprabha01@xxxxxxxxx>
- Date: Fri, 22 Dec 2006 04:22:15 -0500
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@xxxxxxxxx]
Sent: 21 December 2006 18:25
To: duncan.lawie@xxxxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxx
<mailto:duncan.lawie@xxxxxxxxxxxxxxxxx> > 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>
==============================================================================
--
//www.freelists.org/webpage/oracle-l
<//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
==============================================================================
Other related posts:
