Operating System - HP-UX
1748019 Members
4639 Online
108757 Solutions
New Discussion юеВ

Re: backup script failed to stop db instance

 
William Lai
New Member

Re: backup script failed to stop db instance

Hi,

Just curious, why do you need to shutdown the database to perform backup?

Regards,
William
Volker Borowski
Honored Contributor

Re: backup script failed to stop db instance

Hello,
just a word on configuration:
- your 3 copies of your controlfile are at the very same location
/u01/oracle/oradata/prod/control01.ctl
/u01/oracle/oradata/prod/control02.ctl
/u01/oracle/oradata/prod/control03.ctl
you should locate them on diffrent physical disks

- your oracle onlineredolog software mirror is at the very same location:
mem#0: /u01/oracle/oradata/prod/redo_1_02_01.log
mem#1: /u01/oracle/oradata/prod/redo_1_02_02.log
you should locate them on diffrent physical disks

Volker
Fauziah Mahdan
Super Advisor

Re: backup script failed to stop db instance

Volker,
any reason for that?


Thanks
Fauziah
Yogeeraj_1
Honored Contributor

Re: backup script failed to stop db instance

hi Fauziah,

All the control files should not be kept in the same location. It is for obvious reasons that they are always multiplexed - corruption of the files or disk crash.

If a control file has been lost or damaged
to a point that Oracle cannot recognize it anymore, when trying to start up the
database will result in an ORA-00205 ("error in identifying control file '%s'")
and an operating system level Oracle error such as ORA-27037 (unable to obtain file status).

In case of a disk crash and loss of all the controlfile, it would be harder to restore.

See metalink note 1014504.6 - Recovering From A Lost Control File.

Below part of the Backup and Recovery basics:
- Running in Archivelog mode
- multiplexing the controlfile
- Taking regular backups
- Periodically doing a complete restore to test your procedures.

hope this helps!

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)