• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 503
  • Last Modified:

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
  • 3
  • 3
1 Solution
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;
format '/app/oracle/db_backup/%d_t%t_s%s_p%p'
( database );
release channel t1;

Open in new window

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.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
your pfile/init.ora needs this one to know where to write the archivelogs:

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:

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
if you have a spfile, you don't open it actually.
you use:

if it's a init.ora (pfile), then you just open it with a text editor (vi for example).
taazAuthor Commented:
Always quick and great
Thanks Angellll
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.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now