Incomplete recovery - using 3'rd party Snapshot tool
We are on 11.2.0.2 on AIX,Linux and we use 3'rd party snapshot technology to backup our database - We are planning to use the snapshot to create clone of our database .I don't require any transactions that have commited after alter database begin backup
1) Note down the SCN before alter database begin backup
2) Put the database in begin backup - Use snapshot tool to copy the data.
3)Alter database end backup - Note down the SCN.
4) Now find the archives that got generated from step1 and step3 - Select name from gv$archived_log where first_change# between scn_in_step1 and scn_in-step3.
0