- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle 9i and archivelog
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2006 06:45 PM
тАО02-01-2006 06:45 PM
Re: Oracle 9i and archivelog
below an example on how you do it in your rman script. If you need further assistance, do let us know.
run {
allocate channel fs1 type disk format='/backup/rman/al/al1_t%t_s%s_p%p';
set limit channel fs1 kbytes=100000;
backup filesperset 10 archivelog all delete input;
release channel fs1;
}
Note that i am backup up the archived log to disk in the above example.
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2006 07:12 PM
тАО02-01-2006 07:12 PM
Re: Oracle 9i and archivelog
Wow, you guys are going way too fast for me!
Let's rewind back a few steps here. I wanna do HOT backups, but what you tell me here, is that I need to do COLD backups on a regular basis and then use rman to backup my archive logs to restore the changes since the last cold backup?
Is this the best practice for doing hot backups of Oracle, or are there better ways?
Regards,
- Viger -
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2006 08:03 PM
тАО02-01-2006 08:03 PM
Re: Oracle 9i and archivelog
In our setup we take two copies of archive logs onto tape. Once backup are through archive files are deleted from disks.
As previous posts suggest one also need to test the backup data and the process of restore & recovery.
sks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2006 08:10 PM
тАО02-01-2006 08:10 PM
Re: Oracle 9i and archivelog
RMAN is indeed the best practice for Hot backups.
But you should consider the following before making a decision about Hot or Cold backup:
- Necessary DBA skills (Recovering from hot backups is much more complex than with cold ones);
- Restore time (depends of the number of archive log files that needs to be applied);
- Maximum data you can loose (hours of users work);
- Downtime you can have;
- Database volatility (changing speed);
- Disk space available for archive logs and budget available to buy more if they are needed.
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2006 09:15 PM
тАО02-01-2006 09:15 PM
Re: Oracle 9i and archivelog
Cold backups are much easier to get your head around. Effectively it is just
shut the database down,
copy the files.
Hot backups are much more complex, we spent some time and effort in getting them to restore.
Eric, Your advice is as always marvellous however I have to mention that your statement,
"Not since the last backup but since the last COLD backup", seems to me to be misleading.
We don't do cold backups here any more, yet we were able to restore. I'm talking with our dba now about this.
My feeling is that the archive logs just before, during and after the hot backup are useful, the earlier archive logs can be discarded (although backing them up beforehand is always a good idea). We keep a few days worth of archive logs just in case one hot backup doesn't work, this then gives us the option to go back to the previous one. I'm assuming that you do daily hot backups.
What we did for a while was a cold backup at the weekend and hot backups during the week. When we did this we kept the archive logs back to the cold backup.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2006 09:43 PM
тАО02-01-2006 09:43 PM
Re: Oracle 9i and archivelog
A 24x7 environment is fine running with hot backups and is a necessary as most companies cannot afford any downtime. I have various clients who I have integrated RMAN with third-party Media Managers so there is no point in using cold backups if this is the option you desire and meets your buisness needs.
Have you set RMAN up with repository database? The RMAN repository database contains the schema that owns the tables, indexes, and PL/SQL packages that comprise the RMAN repository, or catalog.
Regards,
Simon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2006 09:53 PM
тАО02-01-2006 09:53 PM
Re: Oracle 9i and archivelog
Forget about COLD backup. Just do your RMAN hot backup. if possible, backup to disk first (then backup to tape). Both Backup and Recovery will be much faster!
How big is your database?
Above all YOU must test your recovery.
also read:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96572/toc.htm
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2006 10:29 PM
тАО02-01-2006 10:29 PM
Re: Oracle 9i and archivelog
Interresting reading. To me it seems possible to make a valid backup of the whole database by issuing:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE ALL INPUT
This will both backup my database AND clean out all archive logs.
The doc says:
1. Runs the ALTER SYSTEM ARCHIVE LOG CURRENT command.
2. Runs BACKUP ARCHIVELOG ALL.
3. Backs up files specified in BACKUP command.
4. Runs the ALTER SYSTEM ARCHIVE LOG CURRENT command.
5. Backs up any remaining archived logs generated during the backup.
Not quite sure I can add "DELETE ALL INPUT" to the command though, but "BACKUP ARCHIVELOG ALL DELETE ALL INPUT" is valid, so I was hoping they could be combined...
Regards,
- Viger -
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2006 10:57 PM
тАО02-01-2006 10:57 PM
Re: Oracle 9i and archivelog
of course you can proceed this way.
In fact, in the same script you can include multiple commands.
#Backup the whole database
backup
tag Whole_database_hot
database;
#Switch out of the current logfile
sql 'alter system archive log current';
#Backup the archived logs
backup
archivelog all delete input
format '/backup/rman/full/fs1/al_%u.%p';
hope this helps too!
good luck and don't forget Recovery tests are most important!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-02-2006 01:48 AM
тАО02-02-2006 01:48 AM
Re: Oracle 9i and archivelog
Darren