Re: Backup file names with rman run by Grid Control (11g)
- From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- To: "peter.schauss@xxxxxxx" <peter.schauss@xxxxxxx>
- Date: Fri, 5 Jul 2013 14:24:07 -0300
use rman stored configuration,
configure channel 1 device type disk format 'RMAN FORMAT STRING'; (note
that if you use multiple channels then you need to run this for each of
them)
but this will only accept an RMAN format string, no date from the OS. (you
can easily add db name and datetime using RMAN masks instead of having to
use OS tools. check them out here:
http://ss64.com/ora/rman_format_string.html
hth
Alan.-
On Fri, Jul 5, 2013 at 12:52 PM, Schauss, Peter (ESS) <peter.schauss@xxxxxxx
> wrote:
> Environment: Oracle 11.2.0.3 - Windows
>
> On UNIX systems, I have been able to control what the backup file names
> look like by using a combination of shell and rman variables when I
> allocate a channel. For example:
>
> BASE_NAME= 'date+$1_%y%m%d%H%M%S' (where $1 is the database name)
> ...
> Rman target ...
> {
> allocate channel ch1 type disk format '$BACKUP_DIR2/${BASE_NAME}_1_%U.rbk';
> ...
>
>
> This gives me file name in the format <database name>_<date time>_<channel
> #>_<unique id>.rbk.
>
> When I set up my backups with grid control, it uses the value that I enter
> in the disk backup location field (Backup Settings->device) to determine
> where to put the backup files, but the names are cryptic. Is there a way
> to specify the format?
>
> Thanks,
> Peter Schauss
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
