An rman backup? Using the supplied backup batch or shell script file? Or just a file copy to another folder (or drive? or filesystem? (win|linux ?))backup of data files and controlfile
Ok, that's a cold backup. If the copied files are restored, database recovery is not needed when using the backup files.db was shut...properly
Not a big deal. For hot backups, the database has to be in archivelog mode and the important part is to also get all archivelog files created after backup mode was started, not the onlike redo files. Archivelog files are created from redo. When doing a restore generally you don't want to mess with redo- could be some transaction details in the online redo that didn't get written to archivelog files yet, the instance might need those bits in a recovery scenario.missed redo.
Shutdown the database. Copy the backup files over the datafiles/controlfile(s). Startup. You're Done.to restore the db back..
Yes that situation often results in missing critical bits. And spelling/grammar mistakes too ;)in hury forgot
That isn't really a big deal at all with a cold backup, as long as the datafiles were backed up after a proper (not crash, not shutdown abort) close of all database datafiles.i dont have the redolog files
A startup nomount with a controlfile create might fix that. And redo files can be taken care of in that step as well, so having the controlfile backup isn't necessary either.database donot even mount.
Doesn't matter, the create controlfile statement specifies redo filenames- if they don't exist, the instance might gripe about it but they will get created when the database starts saving redo information.i dont have those 2 log files.... in the destination mentioned
You'll have to make the 'redo' folder, the complete <path> part has to be a valid directory. The "out of the box" setup in XE places redo files in the flash recovery area. And FRA has an arbitrary size limit, 10GB, I think. Better to point redo files to a different folder, not in the FRA location.
-- change: ... group 1 '<path>\O1_MF_1_80L7C259_.LOG' size ... , group 2 '<path>\O1_MF_2_80L7C375_.LOG' size ... -- to 'C:\oraclexe\app\oracle\oradata\XE\redo\redo01.dbf' size ... , 'C:\oraclexe\app\oracle\oradata\XE\redo\redo02.dbf' size ... -- if you want three redo files that's fine too- add <comma> group 3 ... , group 3 'C:\oraclexe\app\oracle\oradata\XE\redo\redo03.dbf' size ...
I always name the redo files with a .dbf extension, at one time there was a system administrator that got a bit too aggressive seeking log files that "needed to be cleaned up to save some space".
group 1 ( '<path1>\redo01.dbf', '<path2>\redo01.dbf' ) size ... , group 2 ( '<path1>\redo02.dbf', '<path2>\redo02.dbf' ) size ... , group 3 ( '<path1>\redo03.dbf', '<path2>\redo03.dbf' ) size ...