[oracle@ray ~]$ crontab -l
1 23 * * * /backup/fullrmanbak.sh >/dev/null 2>&1
[oracle@ray backup]$ cat fullrmanbak.sh
#!/bin/sh
source
H
O
M
E
/
.
b
a
s
h
p
r
o
f
i
l
e
e
x
p
o
r
t
N
L
S
D
A
T
E
F
O
R
M
A
T
=
′
Y
Y
Y
Y
M
M
D
D
H
H
24
:
M
I
:
S
S
′
L
O
G
P
A
T
H
=
/
h
o
m
e
/
o
r
a
c
l
e
/
b
a
c
k
u
p
l
o
g
R
M
A
N
F
I
L
E
=
/
h
o
m
e
/
o
r
a
c
l
e
/
r
m
a
n
b
a
k
L
O
G
F
I
L
E
=
HOME/.bash_profile export NLS_DATE_FORMAT='YYYYMMDD HH24:MI:SS' LOG_PATH=/home/oracle/backuplog RMAN_FILE=/home/oracle/rmanbak LOG_FILE=
HOME/.bashprofileexportNLSDATEFORMAT=′YYYYMMDDHH24:MI:SS′LOGPATH=/home/oracle/backuplogRMANFILE=/home/oracle/rmanbakLOGFILE=LOG_PATH/backfull-date +%Y%m%d-%H%M.log
$ORACLE_HOME/bin/rman log KaTeX parse error: Expected '}', got 'EOF' at end of input: … TYPE DISK TO 'RMAN_FILE/%F’;
CONFIGURE DEVICE TYPE DISK clear;
CONFIGURE CHANNEL DEVICE TYPE DISK clear;
CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
show all;
crosscheck archivelog all;
delete noprompt expired archivelog all;
backup as compressed backupset full database filesperset = 5
format “
R
M
A
N
F
I
L
E
/
f
u
l
l
p
l
u
s
a
r
c
h
i
v
e
l
o
g
f
o
r
m
a
t
"
RMAN_FILE/full_%d_%T_%s" plus archivelog format "
RMANFILE/fullplusarchivelogformat"RMAN_FILE/arch_%d_%t_%s”;
delete noprompt archivelog until time ‘sysdate-2’;
backup current controlfile format 'KaTeX parse error: Expected 'EOF', got '}' at position 107: …ompt obsolete; }̲ exit EOF date …LOG_FILE
#use find ,delete some backfile 1 days ago
find $RMAN_FILE/full* -mmin +1000 -exec rm -f {} ;
find $RMAN_FILE/arch* -mmin +1000 -exec rm -f {} ;
3702
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
