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
Subscribe to:
Post Comments (Atom)
1 comment:
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
Post a Comment