Home » RDBMS Server » Backup & Recovery » backup controlfile to trace (10g)
backup controlfile to trace [message #345479] Wed, 03 September 2008 15:00 Go to next message
Sizzlineyes
Messages: 3
Registered: June 2008
Junior Member
when we write backup controlfile to trace and creates controlfile through trace file save it as a text file
after doing all these steps how to call this script from rman
what is default location for this as in book its written to be called as @filename but no path is specified
do we have to write path with the comand or we have to to that directory and call it from there

what will b the right procedure to create controlfile like this
Re: backup controlfile to trace [message #345480 is a reply to message #345479] Wed, 03 September 2008 15:03 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

the default directory, at least for *nix, installations is "udump".
Re: backup controlfile to trace [message #345481 is a reply to message #345479] Wed, 03 September 2008 15:06 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Or you can create it where ever you want. Preferably, a text copy along with your backups.
alter database backup controlfile to trace as '/myFilesystem/myTraceFile';
backup controlfile to trace [message #345486 is a reply to message #345481] Wed, 03 September 2008 15:49 Go to previous messageGo to next message
Sizzlineyes
Messages: 3
Registered: June 2008
Junior Member
well i work on windows xp using oracle 10.1.0
and after creating the controlfile from the trace file i saved it to desktop and when it come to be called from rman it just didn't find the file ,,,,so i was asking where this file to b saved and how to call it ,,,,,,the extension of file is .txt,,,does it has to be .sql or something else,,,how rman scripts are created via create script command of rman from rman promt

Re: backup controlfile to trace [message #345487 is a reply to message #345479] Wed, 03 September 2008 15:58 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above


What problem are you really, really trying to solve?

Why do you think you should call this file from RMAN?

It has been my experience that the contents of this file has 2 sections;
-- Set #1. NORESETLOGS case
-- Set #2. RESETLOGS case

So I have always edited this file before (ab)using it.
backup controlfile to trace [message #345492 is a reply to message #345487] Wed, 03 September 2008 17:02 Go to previous message
Sizzlineyes
Messages: 3
Registered: June 2008
Junior Member
never mind the problem is solved
thanks anyways Smile

Previous Topic: RMAN - Networker integration
Next Topic: Recover Database - All Files Deleted while DB was running
Goto Forum:
  


Current Time: Thu Dec 08 04:21:28 CST 2016

Total time taken to generate the page: 0.26756 seconds