| RMAN Backup [message #54096] |
Tue, 29 October 2002 07:32  |
MNagel
Messages: 2
Registered: October 2002
|
Junior Member |
|
|
Does anyone know how to do the following? I didn't set up the backups at my previous position and I would like to implement it here. I can't seem to find the code on how to do this... Any help would be greatly appreciated!
Current setup is...
/oraarch1/log.4, log.5 log.6
/oraarch2/log.1, log.2,log.3
First Level 0 backup...
This is what happen...
files in /oraarch2/ are backuped up and deleted.
files in /oraarch1/ are backuped up and moved to /oraarch2
2nd level 0 backup...
Any files in /oraarch2/ are backed up and deleted
Any files in /oraarch1/ are backed up and moved to /oraarch2
If I do 2 level 0 backups in a row, I could
clean up both /oraarch directories. Each archive log is backed up twice before being deleted.
|
|
|
|
| Re: RMAN Backup [message #54104 is a reply to message #54096] |
Tue, 29 October 2002 17:38  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Why doing it twice since you can create as much as you want backup copies from the both datafiles and archived logs?
I am missing something??
If you want two backup copies, then do:
run {
set duplex=2;
allocate channel ch1 type 'sbt_tape';
backup database;
}
Then do the same for the archived logs.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
| Re: RMAN Backup [message #54111 is a reply to message #54096] |
Wed, 30 October 2002 06:52 |
MNagel
Messages: 2
Registered: October 2002
|
Junior Member |
|
|
I don't want two copies done at one backups. Sorry if you miss read the posting. What I want to do is 'duplex' the archive logs by...
run {
allocate channel t1 type 'sbt_tape';
backup
(database );
backup
( archivelog all delete input );
release channel t1;
}
Set in the init.ora file...
log_archive_dest="/u02/oraarch1"
log_archive_duplex_dest = "/u05/oraarch2"
* When Oracle writes an archive log, it will write one to oraarch1 and then a copy to oraarch2.
* The first backup; the logs in oraarch1 will be backed up and deleted in oraarch1. Leaving the copies in oraarch2.
* The second backup will backup and delete the logs in oraarch2.
This will give you 2 copies of the archive logs.
This works. But the first backup doesn't always take the logs in oraarch1 first. Sometimes it takes logs out of oraarch2 and leaves the copy in oraarch1.
Can anyone explain why that is? I thought it would take the logs out of oraarch1 first, because oraarch2 is the copy.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
