有人试过用 Oracle Standby Read Only database 的 Backup 来Restore？# Database - 数据库
W*P
1 楼
本人主要做胚胎干细胞的分化和表观遗传学调控，无奈申绿卡审稿数还不够，恳请版上
兄弟姐妹推荐相关的审稿机会。
我的邮箱是：
c***[email protected]
万分感谢！！！
兄弟姐妹推荐相关的审稿机会。
我的邮箱是：
c***[email protected]
万分感谢！！！
l*d
2 楼
Obama Plans Change in Immigration Waiver
WASHINGTON — The Obama administration plans a rule change to help reduce
the time illegal immigrant spouses and children are separated from citizen
relatives while they try to win legal status in the United States, a senior
administration official said.
Currently, illegal immigrants must leave the country before they can ask the
government to waive a three- to 10-year ban on legally coming back to the U
.S. The length of the ban depends on how long they have lived in the U.S.
without permission.
Editor's Notes:
The One Thing You Should Do for Your Prostate Every Morning
Wall Street Insider Exposes Death of Main Street America
The official said Thursday the new rule would let children and spouses of
citizens ask the government to decide on the waiver request before the
illegal immigrant heads to his or her home country to apply for a visa. The
illegal immigrants still must go home to finish the visa process to come
back to the U.S., but getting the waiver ahead of time could reduce the time
an illegal immigrant is out of the country.
The official spoke on the condition of anonymity because the proposed policy
change had not been made public.
The waiver shift is the latest move by President Barack Obama to make
changes to immigration policy without congressional action. Congressional
Republicans repeatedly have criticized the administration for policy changes
they describe as providing "backdoor amnesty" to illegal immigrants.
Immigrants who do not have criminal records and who have only violated
immigration laws can win a waiver if they can prove that their absence would
cause an "extreme hardship" for their citizen spouse or parent. The
government received about 23,000 hardship applications in 2011 and more than
70 percent were approved, the official said.
Applications for the waiver can take as long as six months to be acted upon,
the official said. The new rule is expected to reduce that processing time
to just days or weeks, the official added.
"This would streamline the process (and) reduce the time of separation
between family members," the official said.
The proposal will be published in the Federal Register on Friday. The
official said the administration hopes to change the rule later this year.
Immigration has become a difficult issue for Obama ahead of the November
election. As a presidential candidate, he pledged to change what many
consider to be a broken immigration system.
To that end, Homeland Security Secretary Janet Napolitano announced plans
last year to review some 300,000 pending deportation cases in an effort to
target criminal illegal immigrants, repeat immigration law violators and
those who pose a national security or public safety threat. Napolitano said
the DHS would delay indefinitely the cases of many illegal immigrants who
have no criminal record and those who have been arrested for only minor
traffic violations or other misdemeanors.
A pilot program to review about 12,000 cases pending in immigration court in
Baltimore and Denver was launched in November and ends next week. The
review is expected to expand to other jurisdictions later this year.
Immigration and Customs Enforcement Director John Morton also issued a memo
in June outlining how immigration authorities could use discretion in
deciding which illegal immigrants to arrest and put into deportation
proceedings. Morton wrote in the memo that discretion could be used in a
variety of cases, including for people with no criminal record and young
people brought to the country illegally as children.
Congressional Republicans have decried the policy changes, arguing that the
Obama administration is circumventing Congress to essentially provide
amnesty to countless illegal immigrants.
Rep. Lamar Smith, who chairs the House Judiciary Committee, has been among
the most vocal critics and has accused Obama repeatedly of not enforcing
immigration law.
Several attempts at an immigration law overhaul have failed in recent years,
including the so-called DREAM Act, which would have allowed for some young
illegal immigrants brought to the U.S. as children to earn legal status if
they went to college or joined the military.
WASHINGTON — The Obama administration plans a rule change to help reduce
the time illegal immigrant spouses and children are separated from citizen
relatives while they try to win legal status in the United States, a senior
administration official said.
Currently, illegal immigrants must leave the country before they can ask the
government to waive a three- to 10-year ban on legally coming back to the U
.S. The length of the ban depends on how long they have lived in the U.S.
without permission.
Editor's Notes:
The One Thing You Should Do for Your Prostate Every Morning
Wall Street Insider Exposes Death of Main Street America
The official said Thursday the new rule would let children and spouses of
citizens ask the government to decide on the waiver request before the
illegal immigrant heads to his or her home country to apply for a visa. The
illegal immigrants still must go home to finish the visa process to come
back to the U.S., but getting the waiver ahead of time could reduce the time
an illegal immigrant is out of the country.
The official spoke on the condition of anonymity because the proposed policy
change had not been made public.
The waiver shift is the latest move by President Barack Obama to make
changes to immigration policy without congressional action. Congressional
Republicans repeatedly have criticized the administration for policy changes
they describe as providing "backdoor amnesty" to illegal immigrants.
Immigrants who do not have criminal records and who have only violated
immigration laws can win a waiver if they can prove that their absence would
cause an "extreme hardship" for their citizen spouse or parent. The
government received about 23,000 hardship applications in 2011 and more than
70 percent were approved, the official said.
Applications for the waiver can take as long as six months to be acted upon,
the official said. The new rule is expected to reduce that processing time
to just days or weeks, the official added.
"This would streamline the process (and) reduce the time of separation
between family members," the official said.
The proposal will be published in the Federal Register on Friday. The
official said the administration hopes to change the rule later this year.
Immigration has become a difficult issue for Obama ahead of the November
election. As a presidential candidate, he pledged to change what many
consider to be a broken immigration system.
To that end, Homeland Security Secretary Janet Napolitano announced plans
last year to review some 300,000 pending deportation cases in an effort to
target criminal illegal immigrants, repeat immigration law violators and
those who pose a national security or public safety threat. Napolitano said
the DHS would delay indefinitely the cases of many illegal immigrants who
have no criminal record and those who have been arrested for only minor
traffic violations or other misdemeanors.
A pilot program to review about 12,000 cases pending in immigration court in
Baltimore and Denver was launched in November and ends next week. The
review is expected to expand to other jurisdictions later this year.
Immigration and Customs Enforcement Director John Morton also issued a memo
in June outlining how immigration authorities could use discretion in
deciding which illegal immigrants to arrest and put into deportation
proceedings. Morton wrote in the memo that discretion could be used in a
variety of cases, including for people with no criminal record and young
people brought to the country illegally as children.
Congressional Republicans have decried the policy changes, arguing that the
Obama administration is circumventing Congress to essentially provide
amnesty to countless illegal immigrants.
Rep. Lamar Smith, who chairs the House Judiciary Committee, has been among
the most vocal critics and has accused Obama repeatedly of not enforcing
immigration law.
Several attempts at an immigration law overhaul have failed in recent years,
including the so-called DREAM Act, which would have allowed for some young
illegal immigrants brought to the U.S. as children to earn legal status if
they went to college or joined the military.
T4
3 楼
有没有人试过这个：
Computer A:
1）Open Oracle Standby database to read only;
2) then run rman back it up;
3) Move all the backup pieces to computer B
4) restore the controlfile and the database in computer B;
5）open the restored database as a standalone database;
Computer A:
1）Open Oracle Standby database to read only;
2) then run rman back it up;
3) Move all the backup pieces to computer B
4) restore the controlfile and the database in computer B;
5）open the restored database as a standalone database;
T4
4 楼
I tried that and it didn't work.
Any 大师 know why?
Any 大师 know why?
c*d
5 楼
出了什么错？
T4
6 楼
RMAN> run {
2> set until time "to_date('12-24-2011 12:05:00','mm-dd-yyyy hh24:mi:ss')";
3> restore database;
4> recover database;
5> }
Error:
creating datafile fno=1 name=/data/oradata/myhost/datafile/system01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/28/2011 23:39:20
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/data/oradata/myhost/datafile/system01.dbf'
2> set until time "to_date('12-24-2011 12:05:00','mm-dd-yyyy hh24:mi:ss')";
3> restore database;
4> recover database;
5> }
Error:
creating datafile fno=1 name=/data/oradata/myhost/datafile/system01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/28/2011 23:39:20
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/data/oradata/myhost/datafile/system01.dbf'
c*d
7 楼
有这个路径吗？/data/oradata/myhost/datafile/
T4
8 楼
restore 就是要在这路径产生这个文件。可是failed.
所以我怀疑用standby read only database 的备份是不能用在异地db restore的，我好像没见过这样的文件叙述。
【在 c*****d 的大作中提到】
: 有这个路径吗？/data/oradata/myhost/datafile/
所以我怀疑用standby read only database 的备份是不能用在异地db restore的，我好像没见过这样的文件叙述。
【在 c*****d 的大作中提到】
: 有这个路径吗？/data/oradata/myhost/datafile/
c*d
9 楼
你怎么恢复control file的?
我感觉应该用trace file来创建，而不是用controlfile的backup
因为controlfile确实会记录这是standby的controlfile
我好像没见过这样的文件叙述。
【在 T4 的大作中提到】
: restore 就是要在这路径产生这个文件。可是failed.
: 所以我怀疑用standby read only database 的备份是不能用在异地db restore的，我好像没见过这样的文件叙述。
我感觉应该用trace file来创建，而不是用controlfile的backup
因为controlfile确实会记录这是standby的controlfile
我好像没见过这样的文件叙述。
【在 T4 的大作中提到】
: restore 就是要在这路径产生这个文件。可是failed.
: 所以我怀疑用standby read only database 的备份是不能用在异地db restore的，我好像没见过这样的文件叙述。
T4
10 楼
controlfile was produced on the standby using rman controlfile backup;
then move it to the location and restore it via rman.
I also tried using trace file. Didn't work either.
【在 c*****d 的大作中提到】
: 你怎么恢复control file的?
: 我感觉应该用trace file来创建，而不是用controlfile的backup
: 因为controlfile确实会记录这是standby的controlfile
:
: 我好像没见过这样的文件叙述。
then move it to the location and restore it via rman.
I also tried using trace file. Didn't work either.
【在 c*****d 的大作中提到】
: 你怎么恢复control file的?
: 我感觉应该用trace file来创建，而不是用controlfile的backup
: 因为controlfile确实会记录这是standby的controlfile
:
: 我好像没见过这样的文件叙述。
T4
11 楼
有没有人试过这个：
Computer A:
1）Open Oracle Standby database to read only;
2) then run rman back it up;
3) Move all the backup pieces to computer B
4) restore the controlfile and the database in computer B;
5）open the restored database as a standalone database;
Computer A:
1）Open Oracle Standby database to read only;
2) then run rman back it up;
3) Move all the backup pieces to computer B
4) restore the controlfile and the database in computer B;
5）open the restored database as a standalone database;
T4
12 楼
I tried that and it didn't work.
Any 大师 know why?
Any 大师 know why?
c*d
13 楼
出了什么错？
T4
14 楼
RMAN> run {
2> set until time "to_date('12-24-2011 12:05:00','mm-dd-yyyy hh24:mi:ss')";
3> restore database;
4> recover database;
5> }
Error:
creating datafile fno=1 name=/data/oradata/myhost/datafile/system01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/28/2011 23:39:20
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/data/oradata/myhost/datafile/system01.dbf'
2> set until time "to_date('12-24-2011 12:05:00','mm-dd-yyyy hh24:mi:ss')";
3> restore database;
4> recover database;
5> }
Error:
creating datafile fno=1 name=/data/oradata/myhost/datafile/system01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/28/2011 23:39:20
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/data/oradata/myhost/datafile/system01.dbf'
c*d
15 楼
有这个路径吗？/data/oradata/myhost/datafile/
T4
16 楼
restore 就是要在这路径产生这个文件。可是failed.
所以我怀疑用standby read only database 的备份是不能用在异地db restore的，我好像没见过这样的文件叙述。
【在 c*****d 的大作中提到】
: 有这个路径吗？/data/oradata/myhost/datafile/
所以我怀疑用standby read only database 的备份是不能用在异地db restore的，我好像没见过这样的文件叙述。
【在 c*****d 的大作中提到】
: 有这个路径吗？/data/oradata/myhost/datafile/
c*d
17 楼
你怎么恢复control file的?
我感觉应该用trace file来创建，而不是用controlfile的backup
因为controlfile确实会记录这是standby的controlfile
我好像没见过这样的文件叙述。
【在 T4 的大作中提到】
: restore 就是要在这路径产生这个文件。可是failed.
: 所以我怀疑用standby read only database 的备份是不能用在异地db restore的，我好像没见过这样的文件叙述。
我感觉应该用trace file来创建，而不是用controlfile的backup
因为controlfile确实会记录这是standby的controlfile
我好像没见过这样的文件叙述。
【在 T4 的大作中提到】
: restore 就是要在这路径产生这个文件。可是failed.
: 所以我怀疑用standby read only database 的备份是不能用在异地db restore的，我好像没见过这样的文件叙述。
T4
18 楼
controlfile was produced on the standby using rman controlfile backup;
then move it to the location and restore it via rman.
I also tried using trace file. Didn't work either.
【在 c*****d 的大作中提到】
: 你怎么恢复control file的?
: 我感觉应该用trace file来创建，而不是用controlfile的backup
: 因为controlfile确实会记录这是standby的controlfile
:
: 我好像没见过这样的文件叙述。
then move it to the location and restore it via rman.
I also tried using trace file. Didn't work either.
【在 c*****d 的大作中提到】
: 你怎么恢复control file的?
: 我感觉应该用trace file来创建，而不是用controlfile的backup
: 因为controlfile确实会记录这是standby的controlfile
:
: 我好像没见过这样的文件叙述。
b*r
19 楼
You can convert standby to snapshot database and using rman duplicate to
clone it.
http://uhesse.com/2010/12/21/clone-database-from-snapshot-stand
clone it.
http://uhesse.com/2010/12/21/clone-database-from-snapshot-stand
e*2
20 楼
你必须connect to primary db's catalog来backup和restore.
standby的controlfile木有用.
在这个case里面,standby的controlfile trace backup更是木有用.
如果是logic standby你只能用controlfile的image copy, backup to trace一样木有
用.
【在 c*****d 的大作中提到】
: 你怎么恢复control file的?
: 我感觉应该用trace file来创建，而不是用controlfile的backup
: 因为controlfile确实会记录这是standby的controlfile
:
: 我好像没见过这样的文件叙述。
standby的controlfile木有用.
在这个case里面,standby的controlfile trace backup更是木有用.
如果是logic standby你只能用controlfile的image copy, backup to trace一样木有
用.
【在 c*****d 的大作中提到】
: 你怎么恢复control file的?
: 我感觉应该用trace file来创建，而不是用controlfile的backup
: 因为controlfile确实会记录这是standby的controlfile
:
: 我好像没见过这样的文件叙述。
相关阅读
Reverse an unreversable batch in Oracle?Access application form 转成html请问有没有免费的SQL Server...请教一个query关于多维结构性数据的分类技术问题Database Interview Questionsmysql doesn't support subquery still?请求帮助，关于存储计算access help!servlet调用sql 访问oracle的问题database exceptionAccess中如何update 100个fields让他们都乘以25%?mssql的查询器无法正确显示日期.弱问：如何用access打开并修改远程服务器上的数据库？Access 用户权限设置的疑问借人气问：连MySQL的问题?How to add a blank column in a Query?问一个excel的弱问题5151mysql和oracle