Backup by just copying all files?
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.