-
rman hotbackup without archive logs
Oracle 9.2.0.4 on Solaris
Let's say my db has been up one month.
Can I delete all my archive logs, do a hotbackup (rman: backup database),and from that backup (and the ongoing archive logs) I can recover fine at any time right?
(obviously not the best practice, just wondering about the scenario)
You don't need to backup or keep PAST archive logs when you do an RMAN online hotbackup to recover?
My tests say this works.
The Documentation is ambiguous at best regarding the need of archive logs or if it is necessary to backup archivelogs. It just says it is helpful if you want to use logminer on them or that type of thing.
- Cookies
-
You are correct!
I normally keep my achived logs for the last 1-2 days just in case, and the rest you can delete.
--------------------------------------
It's not what the world does to you that matters. It's how you respond...
-
thanks.
I just found my new friend: 'delete obsolete'
- Cookies
-
that's what i really need to know.. will a full RMAN online backup sufficient enough to recover the database to the point when the backup was taking place.
I need a master backup for a training database that is to be restored after every training session. the backup will be done by issuing BACKUP DATABASE. all the archivelogs before and after the backup will be deleted. will the backup still function without any backup on both ends?
-
Invalid Post specified. If you followed a valid link, please notify the administrator
-
if you want to delete archivelog file,you will do it with rman.
RMAN>delete obsolete;
do not delete archivelog file using OS commands,like rm.
good luck for you
hehe
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
|