-
RMAN shell script - db in archive log mode
Hi,
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:
/backup/dbffiles
/backup/controlfiles
/backup/spfiles
/backup/archivelog
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
-
rman
{
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 ?
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|