| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-00230 during RMAN backup
The most common reason I've seen for this is having two rman processes running simultaneously against the same database - you didn't happen to have a scheduled backup running at the same time did you?
The 10g compressed backupsets work fine and we are seeing files about 1/8th of their previous size. Unfortunately despite the I/O reduction the elapsed times have hardly reduced as our cpu's don't seem to be able the compression too well.
Cheers,
Ian
|---------+----------------------------->
| | jack_at_vanzanen.com |
| | Sent by: |
| | oracle-l-bounce_at_fr|
| | eelists.org |
| | |
| | |
| | 26/09/2007 12:15 |
| | Please respond to |
| | jack |
| | |
|---------+-----------------------------> >--------------------------------------------------------------------------------------------------------------| | | | To: oracle-l_at_freelists.org | | cc: | | Subject: ORA-00230 during RMAN backup | >--------------------------------------------------------------------------------------------------------------|
Hi All,
I'm doing an RMAN backup that includes automatic backup of controlfile. The script has been working fine sofar but today I got this ORA message.
I looked up the message and basically it means that another process has a lock on the controlfile while RMAN tries to back it up.
Now I did check what other processes are suppose to be running at that time and there is just no other processes around the time that I got this message. There is not even a lot of activity on the database causing excessive log switching or anything.
Backup script:
Run
{
Delete noprompt backup;
Backup database format 'OraBackups/application/DB_%d_%U';
Backup archivelog all format 'OraBackups/application/AL_d%_%U' delete all
input;
}
We do not back up to tape directly.
Configured:
Controlfile autobackup on
Controlfile autobackup format ??
Default device type disk
Device type disk parallelism 10 backup type to backupset
Snapshot controlfile name to '???'
These scripts are leftover from previous DBA and will be changed after I have convinced the powers that be that we are better off with backup database plus archivelogs. Hopefully next week. The deletes are needed as there is a shortage of backup space on disk so we can not hold 2 days worth of backups on disk.
We are going to be testing compressed backups (10G) any bad experience with it?
Brgds
Jack
This email was received from the INTERNET and scanned by the Government Secure Intranet Anti-Virus service supplied by Cable&Wireless in partnership with MessageLabs. (CCTM Certificate Number 2006/04/0007.) In case of problems, please call your organisation's IT Helpdesk. Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes.
For the latest data on the economy and society consult National Statistics at http://www.statistics.gov.uk
Please Note: Incoming and outgoing email messages are routinely monitored for compliance with our policy on the use of electronic communications
Legal Disclaimer : Any views expressed by the sender of this message are not necessarily those of the Office for National Statistics
The original of this email was scanned for viruses by the Government Secure Intranet Anti-Virus service supplied by Cable&Wireless in partnership with MessageLabs. (CCTM Certificate Number 2006/04/0007.) On leaving the GSi this email was certified virus free. Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 26 2007 - 08:20:31 CDT
 |
 |