OraFAQ Forum: Backup & Recovery » Is there anyway that I can append dbid at the end of a controlfile trace

Home » RDBMS Server » Backup & Recovery » Is there anyway that I can append dbid at the end of a controlfile trace (12.1.0.2 SE2 Oracle Linux 7.3)

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

Is there anyway that I can append dbid at the end of a controlfile trace [message #667911]

Wed, 24 January 2018 02:02

juniordbanewbie
Messages: 250
Registered: April 2014

Senior Member

Dear all,

Is there anyway that I can append dbid at the end of a controlfile trace


ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS '&2' || '_' || dbid;

if the original trace file is create_abc_controlfile
it should be become create_abc_controlfile_dbid

many thanks in advance!

Report message to a moderator

Re: Is there anyway that I can append dbid at the end of a controlfile trace [message #667912 is a reply to message #667911]

Wed, 24 January 2018 03:16

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I assume you execute this in a SQL*Plus session, in this case you can do it in the following way (ignore the "def 2=", it is there just to show the result):

SQL> def 2="create_abc_controlfile"
SQL> col dbid new_value dbid
SQL> select trim(dbid) dbid from v$database;
DBID
----------------------------------------
288523517

1 row selected.

SQL> prompt backing up the control file into file '&2._&dbid'
backing up the control file into file 'create_abc_controlfile_288523517'

If you don't want to see the result of the query in your spool file (if any) then just put it between "set termout off"/"set termout on".

Report message to a moderator

Re: Is there anyway that I can append dbid at the end of a controlfile trace [message #667914 is a reply to message #667911]

Wed, 24 January 2018 03:17

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And don't forget to feedback.

Report message to a moderator

Re: Is there anyway that I can append dbid at the end of a controlfile trace [message #667939 is a reply to message #667911]

Thu, 25 January 2018 03:00

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Report message to a moderator

Re: Is there anyway that I can append dbid at the end of a controlfile trace [message #667949 is a reply to message #667939]

Thu, 25 January 2018 18:08

juniordbanewbie
Messages: 250
Registered: April 2014

Senior Member

Dear Michel,

this is correct.

I'm now able to append to dbid to the backup controlfile trace.

thanks

Report message to a moderator

Previous Topic:	RMAN duplicate nopen from 11g to 12c fails
Next Topic:	Cannot drop undotbs2 when restoring 10.2.0.4 rac db to 11.2.0.4 single instance db

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 21:06:51 CST 2025