RMAN shell script - db in archive log mode
DB: oracle 10g .
OS: RHAL /LINUX
I need to take full backup copy every day in midnight. all dbf file, sp file, control files, archive logs into a locaiton /backup directory in understandable format what each file belongs to and its kind. ( I need to do backup as copy database plus archive log all) including spfile and control file. can one provide me suitable script please. thanks
I have something like directory structure:
there should be only one latest set of backup copy including all the files all the time.
thanks in advance.
well what have you come up with so far
backup AS COPY format ‘/backup/dbffiles/%U’ database;
backup AS COPY format ‘/backup/archivelogs/arch_%U’ archivelog all delete input;;
backup AS COPY format ‘/backup/controlfile/ctl_%U’ current controlfile;
backup AS COPY format ‘/backup/spfile/spfile_%U’ current spfile;
is the way to do or any changes u suggest ?
Click Here to Expand Forum to Full Width