OraFAQ Forum: Backup & Recovery » Backup controlfiles and recovery?

Home » RDBMS Server » Backup & Recovery » Backup controlfiles and recovery?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Backup controlfiles and recovery? [message #102952]

Fri, 20 December 2002 12:32

Jeff
Messages: 63
Registered: July 1999

Member

I'm trying to figure out what the best way to backup a controlfile is to ensure it will be suitable to use for recovery. I can't just make a copy of a controlfile with the OS commands while the database is up, right? If I use "backup controlfile to " will that give me a binary copy of the controlfile that IS valid for recovery?

Report message to a moderator

Re: Backup controlfiles and recovery? [message #102967 is a reply to message #102952]

Wed, 01 January 2003 06:50

Sheshadri
Messages: 12
Registered: June 2002

Junior Member

Definitely Yes..
You can use backup controlfile to '---any Path ---'
which will create you a binary copy of your control file.
Or You can use "backup controlfile to trace;"
which will create a tracefile in your udump dir. wherein you will find the syntax for creating a control file and u can change it accordingly.

try it out.
bye
shesh

Report message to a moderator

Re: Backup controlfiles and recovery? [message #102968 is a reply to message #102952]

Thu, 02 January 2003 00:07

Vishal Parkar
Messages: 1
Registered: January 2003

Junior Member

I wont suggest you taking "backup controlfile to trace"
command since it will create a "create controlfile" statement in trace files and if you run this statement for rebuilding controlfile you will have to do resetlogs. I would rather suggest taking backup through "alter database backup controlfile to <dest>" which will allow you to take backup of controlfile in binary format.

--Vishal

Report message to a moderator

Re: Backup controlfiles and recovery? [message #104240 is a reply to message #102967]

Mon, 30 August 2004 04:10

deepak mallick
Messages: 1
Registered: August 2004

Junior Member

pl imformed to me how to physical recovery with the help of
control file.
with regards,
deepak.

Report message to a moderator

Previous Topic:	Oracle database backup via SQL/SP?
Next Topic:	RMAN job failed.filesystem got filled up

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 06:30:42 CDT 2024