-
complete RMAN backup script
Hi Dearest Friends,
What is the simplest RMAN command that will backup everything
that is needed in complete recovery including init.ora,controlfiles,datafiles, redologs,etc,etc ...and output will be located on one folder for ease of transfer to offsite and then clean up all unnecessary old files.
I tried to backup my test tb and move the backup to other server and
restore there and everytime I do it i lack somethin or its incomplete and I have to copy something again manually and some files dafaulted to other
backup dir
Thanks a lot for your kindness
Is this correct?
rman
run
{
allocate channel d1 type disk;
backup
format '/u03/RMAN/%d_al_t%t_s%s_p%p'
database;
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
crosscheck backup;
delete obsolete;
delete expired backup;
crosscheck archivelog all;
delete expired archivelog all;
}
Last edited by yxez; 09-15-2007 at 01:09 AM.
Behind The Success And Failure Of A Man Is A Woman
-
Muchas gracias Pando mi querido,usted es muy amable
(Im practising my spanish now coz i'll be employed in Mexico as DBA soon
say good luck to me )
Do you have somthing like this for windows too?
Puedo yo usar este para la versión 9i. Puede u darme también la versión de no estante
Gracias mucho otra vez
Last edited by yxez; 09-15-2007 at 02:56 AM.
Behind The Success And Failure Of A Man Is A Woman
-
I dont do Windows hehe, if you want to use it for Windows use Cygwin or something similar
For 9i you just have to get rid of compression part and it should work....
-
thanks dear ....do you undertand my spanish message? are they grammatically correct
Behind The Success And Failure Of A Man Is A Woman
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
|