| RMAN backup using .rcv [message #189039] |
Tue, 22 August 2006 23:43  |
rmalhi
Messages: 42
Registered: May 2006
Location: Australia
|
Member |
|
|
Hi Guru's,
just want to be 100 sure.
at the moment i am using RMAN stored script.
i want to use my own .rcv script to backup the database on different mount points and catalog on different database.
I have done all. I have created the script .rcv and .sh is calling .rcv file.
But have bit confussion that
Do i need to change Configuration Parameters in RMAN.
like show all; and change the configure parameters.
I am using the following script.run
{
delete force noprompt obsolete recovery window of 1 days;
configure controlfile autobackup off;
configure device type disk parallelism 3;
allocate channel d1 type disk;
allocate channel d2 type disk;
allocate channel d3 type disk;
backup
format '/rman_bkp/backups/spfile/sp%d_t%t_s%s_p%p'
(spfile);
backup
format '/rman_bkp/backups/ctrl/cf%d_t%t_s%s_p%p'
(current controlfile);
backup
full
skip offline
skip readonly
skip inaccessible
format '/rman_bkp/backups/data/df%d_t%t_s%s_p%p.dbk'
(database);
sql 'alter system archive log current';
backup
format '/rman_bkp/backups/arch/al%d_t%t_s%s_p%p'
(archivelog all
delete input);
release channel d1;
release channel d2;
release channel d3;
delete force noprompt obsolete recovery window of 1 days;
}
Do i need to change the configure parameters or RMAN will pick up from scripts.
thanks in advance
Regards
Rupi
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
