Chinaunix首页 | 论坛 | 博客
  • 博客访问: 404255
  • 博文数量: 65
  • 博客积分: 2711
  • 博客等级: 少校
  • 技术积分: 745
  • 用 户 组: 普通用户
  • 注册时间: 2008-04-02 10:02
文章分类

全部博文(65)

文章存档

2013年(4)

2012年(3)

2011年(24)

2010年(21)

2009年(11)

2008年(2)

分类: Oracle

2011-04-06 10:46:00


[oracle@db2 rmantest]$
[oracle@db2 rmantest]$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.5.0 - Production on Wed Mar 9 13:58:09 2011
Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
 
SQL> set linesize 1000
SQL> set pagesize 1000
SQL> select dbid from v$database;
      DBID
----------
1122370651
SQL> show parameter dbname;
SQL> show parameter db_name;
NAME                                 TYPE                              VALUE
------------------------------------ --------------------------------- ------------------------------
db_name                              string                            test1
SQL> exec dbms_backup_restore.nidbegin('test1','TEST1','2043040012','1122370651',0,0,10);
-------------注意:第二个TEST1必须大写,两个dbid前面的为修改后的,后面的为修改之前的。
 
 
PL/SQL procedure successfully completed.
SQL> select dbid from v$database;
      DBID
----------
1122370651
SQL> variable a number;
SQL> variable b number
SQL> variable c number;
SQL> exec dbms_backup_restore.nidprocessdf(0,0,:a,:b,:c);
PL/SQL procedure successfully completed.
SQL> print a;
         A
----------
         0
SQL> print b
         B
----------
         1
SQL> print c
         C
----------
         1
SQL> exec dbms_backup_restore.nidprocesscf(:a,:b);
PL/SQL procedure successfully completed.
SQL> print a
         A
----------
         1
SQL> print b
         B
----------
         1
SQL> print c
         C
----------
         1
SQL> exec dbms_backup_restore.nidend;
PL/SQL procedure successfully completed.
SQL> select dbid from v$database;
      DBID
----------
2043040012
SQL>
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
[oracle@db2 rmantest]$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.5.0 - Production on Wed Mar 9 14:33:49 2011
Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> select dbid from v$database;
      DBID
----------
2043040012
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
[oracle@db2 rmantest]$ rman target /
Recovery Manager: Release 10.2.0.5.0 - Production on Wed Mar 9 14:34:04 2011
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
connected to target database: test1 (DBID=2043040012)
RMAN> exit

Recovery Manager complete.
 
 
修改完成之后,需要重启库,重启过程中,需要更改undo_management、和_allow_resetlogs_corruption参数进行启动,否则无法启动,启动之后在把两个参数改回原来。但是要注意_allow_resetlogs_corruption这个参数为oracle的一个隐含参数,在做数据库恢复时候不要轻易使用!切记!
 
 

[oracle@db2 rmantest]$
[oracle@db2 rmantest]$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.5.0 - Production on Wed Mar 9 14:34:18 2011
Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> shutdown immediate;
ORA-03113: end-of-file on communication channel

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
[oracle@db2 rmantest]$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.5.0 - Production on Wed Mar 9 14:34:47 2011
Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size                  2096632 bytes
Variable Size             385876488 bytes
Database Buffers         1207959552 bytes
Redo Buffers               14680064 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 399661 generated at 03/09/2011 11:39:41 needed for thread 1
ORA-00289: suggestion : /home/oracle/test1/arch/1_2_745328287.dbf
ORA-00280: change 399661 for thread 1 is in sequence #2

Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log '/home/oracle/test1/arch/1_2_745328287.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

ORA-00308: cannot open archived log '/home/oracle/test1/arch/1_2_745328287.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/home/oracle/test1/test1/system01.dbf'

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 399661 generated at 03/09/2011 11:39:41 needed for thread 1
ORA-00289: suggestion : /home/oracle/test1/arch/1_2_745328287.dbf
ORA-00280: change 399661 for thread 1 is in sequence #2

Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log '/home/oracle/test1/arch/1_2_745328287.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

ORA-00308: cannot open archived log '/home/oracle/test1/arch/1_2_745328287.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/home/oracle/test1/test1/system01.dbf'

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 399661 generated at 03/09/2011 11:39:41 needed for thread 1
ORA-00289: suggestion : /home/oracle/test1/arch/1_2_745328287.dbf
ORA-00280: change 399661 for thread 1 is in sequence #2

Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log '/home/oracle/test1/arch/1_2_745328287.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

ORA-00308: cannot open archived log '/home/oracle/test1/arch/1_2_745328287.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/home/oracle/test1/test1/system01.dbf'

SQL> alter system set undo_management='manual' scope=spfile;
System altered.
SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size                  2096632 bytes
Variable Size             385876488 bytes
Database Buffers         1207959552 bytes
Redo Buffers               14680064 bytes
Database mounted.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/home/oracle/test1/test1/system01.dbf'

SQL> alter system set "_allow_resetlogs_corruption"=true scope=spfile;
System altered.
SQL> shutdown immediate;
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size                  2096632 bytes
Variable Size             385876488 bytes
Database Buffers         1207959552 bytes
Redo Buffers               14680064 bytes
Database mounted.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

SQL> conn sys as sysdba;
Enter password:
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size                  2096632 bytes
Variable Size             385876488 bytes
Database Buffers         1207959552 bytes
Redo Buffers               14680064 bytes
Database mounted.
Database opened.
SQL> show parameter _allow_resetlogs_corruption
NAME                                 TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
_allow_resetlogs_corruption          boolean
TRUE
SQL> show parameter undo_management
NAME                                 TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
undo_management                      string
MANUAL
SQL>
SQL> alter system set undo_management='auto' scope=spfile;
System altered.
SQL> alter system unset "_allow_resetlogs_corruption" scope=spfile;
alter system unset "_allow_resetlogs_corruption" scope=spfile
             *
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM

SQL> alter system unset "_allow_resetlogs_corruption"= scope=spfile;
alter system unset "_allow_resetlogs_corruption"= scope=spfile
             *
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM

SQL>
SQL> alter system set "_allow_resetlogs_corruption"='' scope=spfile;
alter system set "_allow_resetlogs_corruption"='' scope=spfile
                                               *
ERROR at line 1:
ORA-00922: missing or invalid option

SQL> alter system set "_allow_resetlogs_corruption" scope=spfile;
alter system set "_allow_resetlogs_corruption" scope=spfile
                                               *
ERROR at line 1:
ORA-00927: missing equal sign

SQL> alter system set "_allow_resetlogs_corruption"=false scope=spfile;
System altered.
SQL> show parameter _allow_resetlogs_corruption
NAME                                 TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
_allow_resetlogs_corruption          boolean
TRUE
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size                  2096632 bytes
Variable Size             385876488 bytes
Database Buffers         1207959552 bytes
Redo Buffers               14680064 bytes
Database mounted.
Database opened.
SQL> select dbid from v$database;
      DBID
----------
2043040012
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
[oracle@db2 rmantest]$
[oracle@db2 rmantest]$
[oracle@db2 rmantest]$ rman target /
Recovery Manager: Release 10.2.0.5.0 - Production on Wed Mar 9 14:57:04 2011
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
connected to target database: test1 (DBID=2043040012)
RMAN> catalog start with '/home/oracle/rmantest';
using target database control file instead of recovery catalog
searching for all files that match the pattern /home/oracle/rmantest
List of Files Unknown to the Database
=====================================
File Name: /home/oracle/rmantest/edoas2_TEST_1_20110309
Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /home/oracle/rmantest/edoas2_TEST_1_20110309
 
RMAN> list backup;

List of Backup Sets
===================
BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
1       Full    50.93M     DISK        00:00:00     2011-03-09 13:49:56
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20110309T134956
        Piece Name: /home/oracle/rmantest/edoas2_TEST_1_20110309
  List of Datafiles in backup set 1
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  6       Full 734152     2011-03-09 13:49:56
RMAN> exit

Recovery Manager complete.
阅读(3539) | 评论(0) | 转发(0) |
0

上一篇:彻底删除crs

下一篇:impdp遇到的ORA-39154

给主人留下些什么吧!~~