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)
Is there anyway that I can append dbid at the end of a controlfile trace [message #667911] Wed, 24 January 2018 02:02 Go to previous message
juniordbanewbie
Messages: 239
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!
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Restore 10.2.0.4 RAC Backup to 11.2.0.4 dbhome
Next Topic: Cannot drop undotbs2 when restoring 10.2.0.4 rac db to 11.2.0.4 single instance db
Goto Forum:
  


Current Time: Sat Jan 18 20:59:18 CST 2020