Database Backup and Recovery (MOSC)

MOSC Banner

Incomplete recovery - using 3'rd party Snapshot tool

edited Nov 29, 2012 6:52AM in Database Backup and Recovery (MOSC) 3 commentsAnswered
 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center