-
Hot Backup
Hi all,
I am doing a script to do hot backups (archive mode) every week for my database.
I am not sure about doing things in the right steps. The steps to do things are:
1. Switch logfiles
2. Backup Datafiles
3. Backup control files
4. archive current log
5 switch logfile
Do I need to backup redo logs and where?
Am I missing something
Regrds Hamhey
-
Why don't u use RMAN to accomplish all the tasks or u can use RMAN to execute your script.Which redo logs?.If they are archived redo logs then u need to back them from their destination directory to tape and also on the hard disk at one location for purpose of fast recovery.
-
Re: Hot Backup
Originally posted by hamhey
Hi all,
I am doing a script to do hot backups (archive mode) every week for my database.
I am not sure about doing things in the right steps. The steps to do things are:
1. Switch logfiles
2. Backup Datafiles
3. Backup control files
4. archive current log
5 switch logfile
Do I need to backup redo logs and where?
Am I missing something
Regrds Hamhey
If you are on version 8 or higher use RMAN.
You can find some scripts (OS as well as RMAN) on this site.
HTH
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
what can I say. You're right.
I've done almost the hole script and and just wondering right procedure doing hot backup by script.
Thanks anyway
-
Originally posted by hamhey
what can I say. You're right.
I've done almost the hole script and and just wondering right procedure doing hot backup by script.
Thanks anyway
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
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
|