Home » RDBMS Server » Backup & Recovery » Comments in RMAN Log file (Oracle Database 11gR2 )
Comments in RMAN Log file [message #624933] Sun, 28 September 2014 23:44 Go to next message
smunir362
Messages: 310
Registered: September 2007
Senior Member
AOA,
I want to add text. like
*****This is my log file******
In rman log file.
I am using
rman log=mylog.log <<EOF
run {
}

How I do that
Re: Comments in RMAN Log file [message #624937 is a reply to message #624933] Mon, 29 September 2014 01:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

From RMAN, you can't.


Re: Comments in RMAN Log file [message #624974 is a reply to message #624933] Mon, 29 September 2014 13:30 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
But you can add comments that will appear in the log:
rman log=mylog.log <<EOF
set echo on
###
### Remove old backups:
###
allocate channel for maintenance device type disk;
crosscheck backupset;
delete noprompt expired backupset;
delete noprompt obsolete;
###
### Backup my database:
###
run
{
  allocate channel d0 device type disk;
  allocate channel d1 device type disk;
  allocate channel d2 device type disk;
  allocate channel d3 device type disk;
  backup as compressed backupset
    database
    include current controlfile
    plus archivelog delete input;
}
exit
EOF

[Updated on: Mon, 29 September 2014 13:40] by Moderator

Report message to a moderator

Re: Comments in RMAN Log file [message #625154 is a reply to message #624974] Thu, 02 October 2014 01:39 Go to previous message
smunir362
Messages: 310
Registered: September 2007
Senior Member
Thanks for reply.
But
set echo on
print all the script file plus log file. I want add comments in log file only.
I tried host command but it did not add even it display on console and write in log file "host command completed"
Previous Topic: archive backup deletion
Next Topic: RMAN-03002: failure of restore command at 10/08/2014 14:24:25
Goto Forum:
  


Current Time: Thu Mar 28 11:49:39 CDT 2024