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: 204
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';

Report message to a moderator

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: 1736
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 08:08:13 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.