niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » Oracle » Server
Cold Backups
Post new topic   Reply to topic Page 1 of 1 [3 Posts] View previous topic :: View next topic
Author Message
howard
*nix forums beginner


Joined: 02 Mar 2006
Posts: 3

PostPosted: Thu Jul 20, 2006 10:52 pm    Post subject: Cold Backups Reply with quote
Hi,

I'm running 10g R2 on RHEL 3. I need to get my hands on a good
coldbackup script or just instructions on how to do it.

I want to be able to copy the vital directories to another location.
What would those directories be?

Thanks in advance for your help,

Howard
Back to top
Jerome Vitalis
*nix forums addict


Joined: 03 Jun 2005
Posts: 58

PostPosted: Fri Jul 21, 2006 9:53 am    Post subject: Re: Cold Backups Reply with quote
howard wrote:
Quote:
Hi,

I'm running 10g R2 on RHEL 3. I need to get my hands on a good
coldbackup script or just instructions on how to do it.

I want to be able to copy the vital directories to another location.
What would those directories be?

Thanks in advance for your help,

Howard


The best way to make sure you do not forget anything it to use the RMAN
command "backup database" (eg it will backup your control file even if
you do not ask it to). It will create backup pieces, so the result will
not be exactly what you suggested (copied directories).
Back to top
frank.van.bortel@gmail.co
*nix forums Guru


Joined: 11 Sep 2005
Posts: 832

PostPosted: Fri Jul 21, 2006 10:48 am    Post subject: Re: Cold Backups Reply with quote
howard schreef:

Quote:
Hi,

I'm running 10g R2 on RHEL 3. I need to get my hands on a good
coldbackup script or just instructions on how to do it.

I want to be able to copy the vital directories to another location.
What would those directories be?


Use RMAN, and configure it properly. An example would be:
user #: rman target /
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO DISK;
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
'/oracle/backups/@/@_%F';
RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT
'/oracle/backups/@/@_%U';
RMAN> CONFIGURE MAXSETSIZE TO 2G;
shutdown
startup mount;
backup database;
alter database open;
exit;

Then, backup /oracle/backups to tape.
Back to top
Google
Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [3 Posts] View previous topic :: View next topic
The time now is Sun Nov 23, 2008 12:39 pm | All times are GMT
navigation Forum index » Databases » Oracle » Server
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Speeding up Full Online Backups Asphalt Blazer IBM DB2 1 Thu Jul 13, 2006 2:54 pm
No new posts Scheduled Backups Issue... JB MySQL 1 Sat Jul 01, 2006 9:40 am
No new posts DB2 Cold backup Santhosh IBM DB2 3 Tue Jun 20, 2006 10:31 am
No new posts Online backups and tar Wes PostgreSQL 0 Fri Jun 16, 2006 9:50 pm
No new posts Faster backups - possibly Solaris pipe buffer size Yonah Russ Solaris 29 Thu Jun 01, 2006 10:40 am

Xbox Mod Chip | Personal Finance | Personal Loans | Mortgages | Online advertising
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group

[ Time: 0.3175s ][ Queries: 16 (0.2409s) ][ GZIP on - Debug on ]