Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Basic backup and recovery

504407Dec 14 2010 — edited Dec 16 2010
We have Oracle 11g running on Windows Server 2008. We recently had a catastrophic failure and after countless Oracle errors we finally just reinstalled Oracle and recreated the database.

Can anyone perhaps give me some basic in a nutshell information about backing up and restoring an Oracle database? It can be a cold backup, to a network or local directory. Yes I Googled this and went through FAQ, but there is so much of it and lot of it just gives syntax errors because it is for a different Oracle version etc. I finally put this together:

Start a command window and enter: RMAN
Enter this:

connect target;
shutdown immediate;
startup mount;
backup database;
sql 'alter database open';
exit;

(I have set or made no RMAN configuration settings, all default.)
(If the backup area is too small and you get errors, look into: ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 10G SCOPE=BOTH SID='*';)

Will this also back up the control files and log files and what have you?

When I installed Oracle, there was an option for automatic backup and recovery, related to "Backup Job" but I have been unable to find any information about this and whether it is running or not or how you would recover such a backup?

How do you get the database back again from a backup such as shown above?

I just need very basic basic explicit cold "this will backup your database and restore it" type information. Cold backup or lasing partial information is fine.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 13 2011
Added on Dec 14 2010
7 comments
273 views