Re: RMAN SCRIPT
Date: Fri, 14 Mar 2008 06:40:34 -0700 (PDT)
Message-ID: <fb1f2255-a1a6-4acd-9564-54bd6536c209@59g2000hsb.googlegroups.com>
On 14 mar, 06:38, "gpand..._at_gmail.com" <gpand..._at_gmail.com> wrote:
> I am currently taking backup in RMAN thru following script.
> and catalog
>
> run {
> allocate channel d1 type disk ;
> backup full
> filesperset 5
> tag full_backup
> format '/data/backup/full_r280%t.dfil'
> database plus archivelog;
>
> backup
> format '/data/backup/full_r280%t.cfil'
> current controlfile;
>
> backup
> format '/data/backup/full_r280%t.afil'
> (archivelog all delete input);
>
> release channel d1;
> }
>
> will it restore compltely if my target database damaged completly
> or if i want to clone this database in other host.
> please advice
Hello gpand,
Truly, I saw various things:
1. Your'r allocating a channel on disk for your BK, so It's going to
ramain there until you need (It could be many time), and you must
allocate a channel only if U donot have define it.
2. In the first command ( database plus archivelog;) Your're backing
up yours Archive log so U dont nee to back them again (|backup
format '/data/backup/full_r280%t.afil' (archivelog all delete input);) U can do this in one command( backup database plus archivelog delete input;) 3.Your backing up your current control file, this is necesary only if u don't have configured the (controlfile autobackup).
I hope this will help. The best you can do ever is 'test', test your script.
Bye, JUDL. Received on Fri Mar 14 2008 - 08:40:34 CDT