hOT backup with rman

I need to do hotback up with rman can i get easy to follow steps. the db is in noarchive log mode

oracle 9i  on hp Unix
taazAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
your pfile/init.ora needs this one to know where to write the archivelogs:
log_archive_dest_1='location=/u02/oradata/cuddle/archive'

your "alter database archivelog" is to enable the archivelog mode indeed; it will not start the logging itself, though.

to start (stop) the logging process would be:
alter system archive log start;
alter system archive log stop;

your pfile/init.ora will need this setting, unless you want to actually start the logging manually each time you start the db:
log_archive_start=TRUE

0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>the db is in noarchive log mode
then, you cannot do a hotbackup. full stop.
you have to get the database into archivelog mode first.


once you have that, here is a sample backup script:
rman target sys/*** nocatalog
run {
allocate channel t1 type disk;
backup
format '/app/oracle/db_backup/%d_t%t_s%s_p%p'
( database );
release channel t1;
}

Open in new window

0
 
taazAuthor Commented:
How to put the database in archive log mode
i know  alter database archivelog;
do i need to change any thing in the pfile or init.ora to make it permanent? and if so how do I ahve to go about that.

Thanks
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
taazAuthor Commented:
You almost complete the answer. if possibel please tell me how to get to open the pfile.
I guess  $ORACLE_HOME/dbs   and do vi and add the entry
log_archive_start=TRUE is this write or you have better solution to this.

Thanks
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
if you have a spfile, you don't open it actually.
you use:
ALTER SYSTEM log_archive_start=TRUE SCOPE SPFILE;

if it's a init.ora (pfile), then you just open it with a text editor (vi for example).
0
 
taazAuthor Commented:
Always quick and great
Thanks Angellll
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.