# NLS_LANG=american
# NLS_DATE_FORMAT='yyyy/mm/dd HH24:MI:SS'
run {
# set until scn 13147;
# allocate channel c1 type disk;
# restore controlfile to 'd:\orc1\ctl1orc1.ora';
# release channel c1;
# allocate channel c2 type disk;
# replicate
# controlfile from 'd:\orc1\ctl1orc1.ora';
# release channel c2; sql 'alter session set NLS_LANGUAGE = AMERICAN'; # sql 'alter database mount'; allocate channel c3 type disk;
# set archivelog destination to 'e:\backup';
# restore archivelog from logseq 533 until logseq 569;
# restore archivelog all;
# release channel c3;
# allocate channel c4 type disk;
restore database;
# release channel c4; recover database;
# allocate channel c5 type disk;
# recover database noredo;
release channel c3;#
# The open resetlogs is commented out deliberately. Only complete this
# last step if you are certain there are no more archived logs to apply.
# sql 'alter database open resetlogs';
sql 'alter database open';
}
好多不懂,能帮我依次解释来来吗?感激不尽!
# NLS_DATE_FORMAT='yyyy/mm/dd HH24:MI:SS'
run {
# set until scn 13147;
# allocate channel c1 type disk;
# restore controlfile to 'd:\orc1\ctl1orc1.ora';
# release channel c1;
# allocate channel c2 type disk;
# replicate
# controlfile from 'd:\orc1\ctl1orc1.ora';
# release channel c2; sql 'alter session set NLS_LANGUAGE = AMERICAN'; # sql 'alter database mount'; allocate channel c3 type disk;
# set archivelog destination to 'e:\backup';
# restore archivelog from logseq 533 until logseq 569;
# restore archivelog all;
# release channel c3;
# allocate channel c4 type disk;
restore database;
# release channel c4; recover database;
# allocate channel c5 type disk;
# recover database noredo;
release channel c3;#
# The open resetlogs is commented out deliberately. Only complete this
# last step if you are certain there are no more archived logs to apply.
# sql 'alter database open resetlogs';
sql 'alter database open';
}
好多不懂,能帮我依次解释来来吗?感激不尽!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货