Monday, September 21, 2009

How to Display Time/Date During RMAN Operations

To display time / date during RMAN operations, follow the procedure:

TIMESTAMP FOR NT
------------------
To get time / date displayed during an RMAN operation the OS command (time and
date) should be
used with the option /T ( to stop the OS requiring user interaction)

To display a timestamp in the RMAN log, run something similar to the following -

RMAN >run{
allocate channel a1 type disk
.
.
.
HOST 'time /T';
HOST 'date /T';
release channel a1;
}

Output looks like -

04:09 PM
host command complete

24/07/2002
host command complete

--------------------------------------------------------------------------------
-

If you want the Time or Date to be recorded in a file you can use the following
-

RMAN> run{
host 'echo Backup stored in logfile (logrman.txt) taken on ->d:
\oracle\ora81\rmanbkp\rmandate.log';
host 'time /T>>d:\oracle\ora81\rmanbkp\rmandate.log';
host 'date /T>>d:\oracle\ora81\rmanbkp\rmandate.log';
}

This will produce a file that has -

Backup stored in logfile (logrman.txt) taken on -
16:57
05-Sep-2002


TIMESTAMP FOR UNIX
--------------------
To get time / date displayed during an RMAN operation the OS command (date)
should be used.

To display a timestamp in the RMAN log, run something similar to the following -

RMAN >run{
allocate channel a1 type disk
.
.
.
HOST 'date';
release channel a1;
}
Output looks like -

RMAN-03022: compiling command: host
Wed Jul 24 16:31:06 BST 2002
RMAN-06134: host command complete

--------------------------------------------------------------------------------
-

If you want the Time or Date to be recorded in a file you can use the following
-

RMAN> run{
host 'echo Backup stored in logfile (logrman.txt) taken on ->/tmp/rmandate.
log';
host 'date>>/tmp/rmandate.log';
}

This will produce a file that has -

Backup stored in logfile (logrman.txt) taken on -
Thu Sep 5 16:49:51 BST 2002

1 comment:

Unknown said...

once upon a time I have heard about a good way of how to create script of all user defined tabled in sql server. hope it helps