Home » RDBMS Server » Backup & Recovery » Hot backup of control file (Oracle 10.2)
Hot backup of control file [message #402011] Thu, 07 May 2009 05:05 Go to next message
preet_kumar
Messages: 195
Registered: March 2007
Senior Member
How can i create a hot backup of my production database without RMAN only using OS copy.
I can put the entire database in backup mode and do an OS copy but how to make a standby control file.Its mentioned that making backup of controlfile the database should be in mount state and not open.
Will the below control files be of any use when the database is open

alter database backup controlfile to '/a/control.ctl';
alter database create standby controlfile as '/a/controlsby.ctl';
Re: Hot backup of control file [message #402017 is a reply to message #402011] Thu, 07 May 2009 05:41 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

>>How can i create a hot backup of my production database without RMAN only using OS copy.

>>Will the below control files be of any use when the database is open

Yes

alter database backup controlfile to '/a/control.ctl';
alter database create standby controlfile as '/a/controlsby.ctl'; 


babu
Previous Topic: backups of read-only tablespaces ?
Next Topic: Incomplete Recovery -- until cancel
Goto Forum:
  


Current Time: Wed Dec 07 14:40:43 CST 2016

Total time taken to generate the page: 0.08505 seconds