hOT backup with rman

>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;
}

Select allOpen in new window

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

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

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).

Always quick and great
Thanks Angellll