rman Restore tablespace (sh)


export ORACLE_SID=TEST2
# sqlplus /nolog <<EOF
# connect rman/rman_oracledba as sysdba
# shutdown abort
# startup 
# exit
# EOF
rman <<EOF
connect target rman/rman_oracledba@test2 
connect catalog rman/rman_oracledba@test1
run { allocate channel d1 type disk;
sql 'Alter tablespace data offline';
restore tablespace data;
recover tablespace data;
sql 'Alter tablespace data online';
}
EOF
Advertisements

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: