Database Backup and Recovery (MOSC)

MOSC Banner

File level partial offline backup

edited Apr 26, 2016 10:32AM in Database Backup and Recovery (MOSC) 6 commentsAnswered ✓

Scope: Oracle 12c database; x86-64; Oracle Linux

Database organization: NOARCHIVELOG mode; several table-spaces holding data

Data: table-space A holds important data, table-spaces B holds temporary and junk data

Proposed backup strategy:

a) take database offline (stop DB server)

b) copy data files of both table-spaces A and B to safe location

c) start database

d) repeat process daily only for table-space A files

e) in case of data-loss restore current files of table-space A and initial files of table-space B

Question:

Will this work, or Oracle need that all files would be copied at the same time?

How to avoid creating daily copy's of table-space B?

Tagged:

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