Topic: Backup & Recovery >> rman archive backup to tape and disk
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: rman archive backup to tape and disk |
| sridhar |
Posted: Aug 19, 2006 02:32:30 PM |
Total Post: 2
Joined: Aug, 2006
|
hi ,
I am using oracle 9.2.0.6 RAC database on solaris 5.9.
I am trying to backup all the inactive archive logs from archive destination (say "/arc/") to tape(OMNIBACK) and
then to disk(say "/arch_disk").
Then delete all the archivelogs from ("/arc/*.arc") archive dest. that are just backedup.
Currently I am using the follwing script to achive this..,
rman << EOF
connect target rman/rman@mydb;
connect catalog rman/rman@mydb;
run {
allocate channel dev_1 type 'SBT_TAPE'
parms'ENV=OB2BARTYPE=Oracle8,OB2APPNAME=MYTEST,OB2BARLIST=ERSDEV_MYTEST_RMAN2)';
sql "alter system switch logfile";
backup archivelog all ;
release channel dev_1;
allocate channel dev_1 type disk
format '/u08/oradata/mdb/rmantest/%t_%s.arc';
backup archivelog all delete all input;
release channel dev_1;
}
I am not sure is it correct way of doing it.
I doubt that if there are any new archives created during the tape backup going on and it will be backed up to disk.
**can i have a script(or may be few changes in existing one) that can take the same copy of backup set both on tape and disk***
Thanks in advance.
sridhar |
|
|
 goudelly |
| Posted: Sep 04, 2006 11:17:33 AM |  |
|
Total Post: 3
Joined: Sep, 2006
|
Hi,
It is correct. any dount still i will send the oracle RMA complete e-book.
Thanks,
Mohan Reddy G.
|
|
|
|
|
| sridhar |
| Posted: Sep 07, 2006 06:20:51 AM | |
|
Total Post: 2
Joined: Aug, 2006
|
hi ,
Actually my requirement is like this...,
The conventional RMAN way is:
a)Archive logs are written to /archlog directory
b)Backup ALL archive logs to tape
c)Delete ALL archive logs in / archlog directory
Current requirement is:
a)Archive logs are written to /archlog directory
b)Backup ALL archive logs except the last one which is currently active.
Eg.If there are 5 files in the current directory (the 5th file should
not be backup-ed to tape)
c)Those 4 files which are backed-up to tape, should be moved to another
directory called /archlog/bckp
d)At the end of the RMAN backup archiving log job, 4 archiving logs will be
in tape, the same 4 archiving logs will be in /archlog/bckp directory &
1 archive log will still be in /archlog directory.
I hope now I am clear in explaining my problem.
Please help me in this regard.
Thanks & Regards,
Sridhar
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 333 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
