Rman Archive (sh)


export ORACLE_SID=TEST2
sqlplus /nolog <<EOF
connect / as sysdba
alter system switch logfile;
EXIT
EOF
rman <<EOF
connect target rman/rman_oracledba@test2 
connect catalog rman/rman_oracledba@test1
run { allocate channel d1 type disk 
format '/data/BACKUP/rman_ARC_%s_%p_%t.bus';
# backup archivelog until time 'sysdate-1/24' delete input;
backup archivelog from time 'sysdate-1/24'; 
}
EOF
sqlplus /nolog <<EOF
connect / as sysdba
alter system switch logfile;
EXIT
EOF

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: