Database Backup and Recovery (MOSC)

MOSC Banner

Backup by just copying all files?

edited Sep 25, 2018 5:01AM in Database Backup and Recovery (MOSC) 5 commentsAnswered

Dear all,

I have a single instance 11.2.0.4 database. Let's say the name is mybase.

I want to process some data in my database (update, delete, insert,..... but no changing of database settings, configurations, users, parameters,...)

Before this, I would shutdown immediate the DB, and just make a simple copy of:

- all files in the ....\oradata\mybase folder (all datafiles, all relog logs, the control file),

- and the second control file which is in the folder ...\fast_recovery_area\mybase,

....to an other place on the disk.

And in case that I realize later that I need to restore the database to the state before the data changing, just to replace all the the files.

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