分类： Oracle
2011-07-16 18:20:59
自动备份controlfile
[oracle@station23 ~]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Sun Jul 10 17:15:17 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORCL (DBID=1267524952)
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_orcl.f'; # default
RMAN> configure controlfile autobackup on;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_orcl.f'; # default
口令文件丢失
orapwd file=orapwsid password=pass entries=5
[oracle@station23 ~]$ cd /u01/app/oracle/product/10.2.0/db_1/dbs/
[oracle@station23 dbs]$ ls
hc_orcl.dat init.ora lkORCL snapcf_orcl.f
initdw.ora initorcl.ora orapworcl spfileorcl.ora
[oracle@station23 dbs]$ cp orapworcl orapworcl.bak
[oracle@station23 dbs]$ rm orapworcl
[oracle@station23 dbs]$ ls
hc_orcl.dat init.ora lkORCL snapcf_orcl.f
initdw.ora initorcl.ora orapworcl.bak spfileorcl.ora
[oracle@station23 dbs]$ orapwd file=orapworcl password=oracle entries=5
spfile丢失
l startup nomount;
l set dbid 1267524952
l restore spfile from autobackup;
l shutdown immediate;
l set dbid 1267524952;
l startup
[oracle@station23 dbs]$ pwd
/u01/app/oracle/product/10.2.0/db_1/dbs
[oracle@station23 dbs]$ ls
hc_orcl.dat init.ora lkORCL orapworcl.bak spfileorcl.ora
initdw.ora initorcl.ora orapworcl snapcf_orcl.f
[oracle@station23 dbs]$ mv spfileorcl.ora spfileorcl.ora.orig
[oracle@station23 dbs]$ ls
hc_orcl.dat init.ora lkORCL orapworcl.bak spfileorcl.ora.orig
initdw.ora initorcl.ora orapworcl snapcf_orcl.f
[oracle@station23 dbs]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jul 11 22:46:12 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORCL (DBID=1267524952)
RMAN> shutdown immediate;
using target database control file instead of recovery catalog
database closed
database dismounted
Oracle instance shut down
RMAN> startup nomount;
connected to target database (not started)
Oracle instance started
Total System Global Area 683671552 bytes
Fixed Size 1221276 bytes
Variable Size 192941412 bytes
Database Buffers 486539264 bytes
Redo Buffers 2969600 bytes
RMAN> set dbid 1267524952
executing command: SET DBID
RMAN> restore spfile from autobackup;
Starting restore at 11-JUL-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
recovery area destination: /u01/app/oracle/flash_recovery_area
database name (or database unique name) used for search: ORCL
channel ORA_DISK_1: autobackup found in the recovery area
channel ORA_DISK_1: autobackup found: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2011_07_10/o1_mf_s_756150698_71lxkf57_.bkp
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 11-JUL-11
RMAN> quit
Recovery Manager complete.
[oracle@station23 dbs]$ ls
hc_orcl.dat init.ora lkORCL orapworcl.bak spfileorcl.ora
initdw.ora initorcl.ora orapworcl snapcf_orcl.f spfileorcl.ora.orig
[oracle@station23 dbs]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jul 11 22:57:00 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: orcl (not mounted)
RMAN> shutdown immediate;
using target database control file instead of recovery catalog
Oracle instance shut down
RMAN> startup;
connected to target database (not started)
Oracle instance started
database mounted
database opened
Total System Global Area 683671552 bytes
Fixed Size 1221276 bytes
Variable Size 201330020 bytes
Database Buffers 478150656 bytes
Redo Buffers 2969600 bytes
RMAN>
controlfile丢失
l startup nomount;
l restore controlfile from autobackup;
l alter database mount;
l recover database;
l alter database open resetlogs;
[oracle@station23 ~]$ cd /u01/app/oracle/oradata/orcl/
[oracle@station23 orcl]$ ll
total 1056964
-rw-r----- 1 oracle oinstall 7061504 Jul 11 23:08 control01.ctl
-rw-r----- 1 oracle oinstall 7061504 Jul 11 23:08 control02.ctl
-rw-r----- 1 oracle oinstall 7061504 Jul 11 23:08 control03.ctl
-rw-r----- 1 oracle oinstall 104865792 Jul 11 22:57 example01.dbf
-rw-r----- 1 oracle oinstall 52429312 Jul 11 23:08 redo01.log
-rw-r----- 1 oracle oinstall 52429312 Jul 11 22:57 redo02.log
-rw-r----- 1 oracle oinstall 52429312 Jul 11 22:57 redo03.log
-rw-r----- 1 oracle oinstall 262152192 Jul 11 23:08 sysaux01.dbf
-rw-r----- 1 oracle oinstall 503324672 Jul 11 23:07 system01.dbf
-rw-r----- 1 oracle oinstall 20979712 Jul 11 22:06 temp01.dbf
-rw-r----- 1 oracle oinstall 26222592 Jul 11 23:08 undotbs01.dbf
-rw-r----- 1 oracle oinstall 5251072 Jul 11 22:57 users01.dbf
[oracle@station23 orcl]$ rm *.ctl
[oracle@station23 orcl]$ ls
example01.dbf redo02.log sysaux01.dbf temp01.dbf users01.dbf
redo01.log redo03.log system01.dbf undotbs01.dbf
[oracle@station23 orcl]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jul 11 23:09:54 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-06003: ORACLE error from target database:
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/orcl/control01.ctl'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
[oracle@station23 orcl]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 11 23:10:26 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> shutdown immediate;
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/orcl/control01.ctl'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
SQL> shutdown abort;
ORACLE instance shut down.
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@station23 orcl]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jul 11 23:12:20 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database (not started)
RMAN> startup nomount;
Oracle instance started
Total System Global Area 683671552 bytes
Fixed Size 1221276 bytes
Variable Size 205524324 bytes
Database Buffers 473956352 bytes
Redo Buffers 2969600 bytes
RMAN> restore controlfile from autobackup;
Starting restore at 11-JUL-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
recovery area destination: /u01/app/oracle/flash_recovery_area
database name (or database unique name) used for search: ORCL
channel ORA_DISK_1: autobackup found in the recovery area
channel ORA_DISK_1: autobackup found: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2011_07_10/o1_mf_s_756150698_71lxkf57_.bkp
channel ORA_DISK_1: control file restore from autobackup complete
output filename=/u01/app/oracle/oradata/orcl/control01.ctl
output filename=/u01/app/oracle/oradata/orcl/control02.ctl
output filename=/u01/app/oracle/oradata/orcl/control03.ctl
Finished restore at 11-JUL-11
RMAN> quit
Recovery Manager complete.
[oracle@station23 orcl]$ ls
control01.ctl control03.ctl redo01.log redo03.log system01.dbf undotbs01.dbf
control02.ctl example01.dbf redo02.log sysaux01.dbf temp01.dbf users01.dbf
[oracle@station23 orcl]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jul 11 23:13:44 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: orcl (not mounted)
RMAN> alter database mount;
using target database control file instead of recovery catalog
database mounted
RMAN> recover database;
Starting recover at 11-JUL-11
Starting implicit crosscheck backup at 11-JUL-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=160 devtype=DISK
Crosschecked 3 objects
Finished implicit crosscheck backup at 11-JUL-11
Starting implicit crosscheck copy at 11-JUL-11
using channel ORA_DISK_1
Crosschecked 1 objects
Finished implicit crosscheck copy at 11-JUL-11
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2011_07_10/o1_mf_s_756150698_71lxkf57_.bkp
using channel ORA_DISK_1
starting media recovery
archive log thread 1 sequence 8 is already on disk as file /u01/app/oracle/oradata/orcl/redo01.log
archive log filename=/u01/app/oracle/oradata/orcl/redo01.log thread=1 sequence=8
media recovery complete, elapsed time: 00:00:10
Finished recover at 11-JUL-11
RMAN> alter database open resetlogs;
database opened
RMAN> quit
Recovery Manager complete.
[oracle@station23 orcl]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 11 23:20:31 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> select * from dual;
D
-
X
SQL>
redolog file丢失
l shutdown immediate;
l startup mount;
l recover database until cancel;
l alter database open resetlogs;
[oracle@station23 orcl]$ ls
control01.ctl control03.ctl redo01.log redo03.log system01.dbf undotbs01.dbf
control02.ctl example01.dbf redo02.log sysaux01.dbf temp01.dbf users01.dbf
[oracle@station23 orcl]$ rm *.log
[oracle@station23 orcl]$ ls
control01.ctl control03.ctl sysaux01.dbf temp01.dbf users01.dbf
control02.ctl example01.dbf system01.dbf undotbs01.dbf
[oracle@station23 orcl]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 11 23:31:09 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 683671552 bytes
Fixed Size 1221276 bytes
Variable Size 209718628 bytes
Database Buffers 469762048 bytes
Redo Buffers 2969600 bytes
Database mounted.
SQL> recover database until cancel;
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.
SQL> select * from dual;
D
-
X
SQL>
datafile丢失
l sql “alter database datafile 3 offline”;
l restore datafile 3
l recover datafile 3
l sql “alter database datafile 3 online”;
[oracle@station23 u01]$ cd /u01/app/oracle/oradata/orcl/
[oracle@station23 orcl]$ ls
control01.ctl example01.dbf redo03.log temp01.dbf
control02.ctl redo01.log sysaux01.dbf undotbs01.dbf
control03.ctl redo02.log system01.dbf users01.dbf
[oracle@station23 orcl]$ mv example01.dbf example01.dbf.orig
[oracle@station23 orcl]$ ls
control01.ctl example01.dbf.orig redo03.log temp01.dbf
control02.ctl redo01.log sysaux01.dbf undotbs01.dbf
control03.ctl redo02.log system01.dbf users01.dbf
[oracle@station23 orcl]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jul 13 00:58:03 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORCL (DBID=1267524952)
RMAN> sql "alter database datafile 5 offline";
using target database control file instead of recovery catalog
sql statement: alter database datafile 5 offline
RMAN> report schema;
Report of database schema
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 480 SYSTEM *** /u01/app/oracle/oradata/orcl/system01.dbf
2 25 UNDOTBS1 *** /u01/app/oracle/oradata/orcl/undotbs01.dbf
3 230 SYSAUX *** /u01/app/oracle/oradata/orcl/sysaux01.dbf
4 5 USERS *** /u01/app/oracle/oradata/orcl/users01.dbf
5 0 EXAMPLE *** /u01/app/oracle/oradata/orcl/example01.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20 TEMP 32767 /u01/app/oracle/oradata/orcl/temp01.dbf
RMAN> restore datafile 5;
Starting restore at 13-JUL-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=144 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00005 to /u01/app/oracle/oradata/orcl/example01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ORCL/backupset/2011_07_13/o1_mf_nnndf_TAG20110713T005521_71rz3sd8_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2011_07_13/o1_mf_nnndf_TAG20110713T005521_71rz3sd8_.bkp tag=TAG20110713T005521
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
Finished restore at 13-JUL-11
RMAN> recover datafile 5;
Starting recover at 13-JUL-11
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:00
Finished recover at 13-JUL-11
RMAN> sql "alter database datafile 5 online";
sql statement: alter database datafile 5 online
RMAN>
表空间恢复
l sql “alter tablespace users offline”;
l restore tablespace users;
l recover tablespace users;
l sql “alter tablespace users online”;
SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
TEMP
USERS
EXAMPLE
6 rows selected.
SQL>
[oracle@station23 orcl]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jul 14 23:29:42 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORCL (DBID=1267524952)
RMAN> sql "alter tablespace example offline";
using target database control file instead of recovery catalog
sql statement: alter tablespace example offline
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 07/14/2011 23:30:55
RMAN-11003: failure during parse/execution of SQL statement: alter tablespace example offline
ORA-01116: error in opening database file 5
ORA-01110: data file 5: '/u01/app/oracle/oradata/orcl/example01.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
RMAN> sql "alter tablespace example offline immediate";
sql statement: alter tablespace example offline immediate
RMAN> restore tablespace example;
Starting restore at 14-JUL-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=146 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00005 to /u01/app/oracle/oradata/orcl/example01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ORCL/backupset/2011_07_13/o1_mf_nnndf_TAG20110713T005521_71rz3sd8_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2011_07_13/o1_mf_nnndf_TAG20110713T005521_71rz3sd8_.bkp tag=TAG20110713T005521
channel ORA_DISK_1: restore complete, elapsed time: 00:00:57
Finished restore at 14-JUL-11
RMAN> recover tablespace example;
Starting recover at 14-JUL-11
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:08
Finished recover at 14-JUL-11
RMAN> sql "alter tablespace example online";
sql statement: alter tablespace example online
RMAN> quit
非catalog方式完全恢复
l 数据库出现问题
l startup nomount;
l restore controlfile from autobackup;
l alter database mount;
l restore database;
l recover database;
l alter database open resetlogs;
[oracle@station23 ~]$ cd /u01/app/oracle/oradata/orcl/
[oracle@station23 orcl]$ ls
control01.ctl example01.dbf redo03.log temp01.dbf
control02.ctl redo01.log sysaux01.dbf undotbs01.dbf
control03.ctl redo02.log system01.dbf users01.dbf
[oracle@station23 orcl]$ rm *
[oracle@station23 orcl]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Sat Jul 16 11:56:59 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-06003: ORACLE error from target database:
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/orcl/control01.ctl'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
[oracle@station23 orcl]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jul 16 11:57:15 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> shutdown abort;
ORA-01031: insufficient privileges
SQL> conn /as sysdba
Connected.
SQL> shutdown abort;
ORACLE instance shut down.
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@station23 orcl]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Sat Jul 16 11:58:10 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database (not started)
RMAN> startup nomount;
Oracle instance started
Total System Global Area 683671552 bytes
Fixed Size 1221276 bytes
Variable Size 197135716 bytes
Database Buffers 482344960 bytes
Redo Buffers 2969600 bytes
RMAN> restore controlfile from autobackup;
Starting restore at 16-JUL-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
recovery area destination: /u01/app/oracle/flash_recovery_area
database name (or database unique name) used for search: ORCL
channel ORA_DISK_1: autobackup found in the recovery area
channel ORA_DISK_1: autobackup found: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2011_07_16/o1_mf_s_756647088_72229k32_.bkp
channel ORA_DISK_1: control file restore from autobackup complete
output filename=/u01/app/oracle/oradata/orcl/control01.ctl
output filename=/u01/app/oracle/oradata/orcl/control02.ctl
output filename=/u01/app/oracle/oradata/orcl/control03.ctl
Finished restore at 16-JUL-11
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
RMAN> restore database;
Starting restore at 16-JUL-11
Starting implicit crosscheck backup at 16-JUL-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
Crosschecked 7 objects
Finished implicit crosscheck backup at 16-JUL-11
Starting implicit crosscheck copy at 16-JUL-11
using channel ORA_DISK_1
Finished implicit crosscheck copy at 16-JUL-11
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2011_07_16/o1_mf_s_756647088_72229k32_.bkp
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/app/oracle/oradata/orcl/system01.dbf
restoring datafile 00002 to /u01/app/oracle/oradata/orcl/undotbs01.dbf
restoring datafile 00003 to /u01/app/oracle/oradata/orcl/sysaux01.dbf
restoring datafile 00004 to /u01/app/oracle/oradata/orcl/users01.dbf
restoring datafile 00005 to /u01/app/oracle/oradata/orcl/example01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ORCL/backupset/2011_07_15/o1_mf_nnndf_TAG20110715T002701_71y66p25_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2011_07_15/o1_mf_nnndf_TAG20110715T002701_71y66p25_.bkp tag=TAG20110715T002701
channel ORA_DISK_1: restore complete, elapsed time: 00:05:22
Finished restore at 16-JUL-11
RMAN> recover database;
Starting recover at 16-JUL-11
using channel ORA_DISK_1
starting media recovery
archive log thread 1 sequence 3 is already on disk as file /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2011_07_16/o1_mf_1_3_72225txy_.arc
archive log thread 1 sequence 4 is already on disk as file /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2011_07_16/o1_mf_1_4_722296my_.arc
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2011_07_16/o1_mf_1_3_72225txy_.arc thread=1 sequence=3
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2011_07_16/o1_mf_1_4_722296my_.arc thread=1 sequence=4
unable to find archive log
archive log thread=1 sequence=5
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/16/2011 12:06:47
RMAN-06054: media recovery requesting unknown log: thread 1 seq 5 lowscn 505294
RMAN>
[oracle@station23 orcl]$ vim /u01/app/oracle/product/10.2.0/db_1/dbs/
hc_orcl.dat init.ora lkORCL snapcf_orcl.f
initdw.ora initorcl.ora orapworcl spfileorcl.ora
[oracle@station23 orcl]$ vim /u01/app/oracle/product/10.2.0/db_1/dbs/initorcl.ora
末尾加上一行
*._allow_resetlogs_corruption='TRUE'
[oracle@station23 orcl]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jul 16 12:17:13 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup pfile=/u01/app/oracle/product/10.2.0/db_1/dbs/initorcl.ora mount
ORACLE instance started.
Total System Global Area 683671552 bytes
Fixed Size 1221276 bytes
Variable Size 197135716 bytes
Database Buffers 482344960 bytes
Redo Buffers 2969600 bytes
Database mounted.
SQL> alter database open resetlogs;
Database altered.
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@station23 orcl]$ ls
control01.ctl example01.dbf redo03.log temp01.dbf
control02.ctl redo01.log sysaux01.dbf undotbs01.dbf
control03.ctl redo02.log system01.dbf users01.dbf
[oracle@station23 orcl]$
这样做会有数据的丢失。
基于SCN的恢复
l startup mount;
l restore database UNTIL SCN
l recover database UNTIL SCN
l alter database open resetlogs;
RMAN> shutdown immediate;
database closed
database dismounted
Oracle instance shut down
RMAN> startup mount;
connected to target database (not started)
Oracle instance started
database mounted
Total System Global Area 683671552 bytes
Fixed Size 1221276 bytes
Variable Size 197135716 bytes
Database Buffers 482344960 bytes
Redo Buffers 2969600 bytes
RMAN> restore database until scn 505306;
Starting restore at 16-JUL-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=157 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/app/oracle/oradata/orcl/system01.dbf
restoring datafile 00002 to /u01/app/oracle/oradata/orcl/undotbs01.dbf
restoring datafile 00003 to /u01/app/oracle/oradata/orcl/sysaux01.dbf
restoring datafile 00004 to /u01/app/oracle/oradata/orcl/users01.dbf
restoring datafile 00005 to /u01/app/oracle/oradata/orcl/example01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ORCL/backupset/2011_07_15/o1_mf_nnndf_TAG20110715T002701_71y66p25_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2011_07_15/o1_mf_nnndf_TAG20110715T002701_71y66p25_.bkp tag=TAG20110715T002701
channel ORA_DISK_1: restore complete, elapsed time: 00:03:39
Finished restore at 16-JUL-11
RMAN> recover database until scn 505306;
Starting recover at 16-JUL-11
using channel ORA_DISK_1
starting media recovery
archive log thread 1 sequence 3 is already on disk as file /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2011_07_16/o1_mf_1_3_72225txy_.arc
archive log thread 1 sequence 4 is already on disk as file /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2011_07_16/o1_mf_1_4_722296my_.arc
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2011_07_16/o1_mf_1_3_72225txy_.arc thread=1 sequence=3
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2011_07_16/o1_mf_1_4_722296my_.arc thread=1 sequence=4
media recovery complete, elapsed time: 00:00:16
Finished recover at 16-JUL-11
RMAN> alter database open resetlogs;
database opened
RMAN>
catalog mode
l 创建catalog所用表空间
SQL>create tablespace rman_ts datafile ‘’ size 20M;
l 创建RMAN用户并授权
SQL>create user rman identified by rman default tablespace rman_ts t quota unlimited on rman_ts;
SQL>grant recovery_catalog_owner to rman;
l 创建恢复目录
rman catalog rman/rman
RMAN>create catalog tablespace rman_ts;
RMAN>register database;
[oracle@station23 orcl]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jul 16 17:30:39 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> create tablespace rman_ts datafile '/u01/app/oracle/rmants.dbf' size 20M;
Tablespace created.
SQL> create user rman identified by rman default tablespace rman_ts quota unlimited on rman_ts;
User created.
SQL> grant recovery_catalog_owner to rman;
Grant succeeded.
SQL> select * from dba_sys_privs where grantee='RECOVERY_CATALOG_OWNER';
GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
RECOVERY_CATALOG_OWNER CREATE SYNONYM NO
RECOVERY_CATALOG_OWNER CREATE CLUSTER NO
RECOVERY_CATALOG_OWNER ALTER SESSION NO
RECOVERY_CATALOG_OWNER CREATE DATABASE LINK NO
RECOVERY_CATALOG_OWNER CREATE PROCEDURE NO
RECOVERY_CATALOG_OWNER CREATE SEQUENCE NO
RECOVERY_CATALOG_OWNER CREATE TABLE NO
RECOVERY_CATALOG_OWNER CREATE SESSION NO
RECOVERY_CATALOG_OWNER CREATE TYPE NO
RECOVERY_CATALOG_OWNER CREATE VIEW NO
RECOVERY_CATALOG_OWNER CREATE TRIGGER NO
11 rows selected.
grant RECOVERY_CATALOG_OWNER所具有的权限
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@station23 orcl]$ rman catalog rman/rman
Recovery Manager: Release 10.2.0.1.0 - Production on Sat Jul 16 17:45:13 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to recovery catalog database
RMAN> create catalog tablespace rman_ts;
recovery catalog created
RMAN> register database;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of register command at 07/16/2011 17:47:34
RMAN-06171: not connected to target database
RMAN> connect target /
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
RMAN> quit
[oracle@station23 orcl]$ mkdir /u01/app/rmanbak/
[oracle@station23 orcl]$ rman target / catalog rman/rman
Recovery Manager: Release 10.2.0.1.0 - Production on Sat Jul 16 17:59:46 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORCL (DBID=1267524952)
connected to recovery catalog database
RMAN> backup format '/u01/app/rmanbak/full_%T_%t.bak' database;
Starting backup at 16-JUL-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=144 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile fno=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf
input datafile fno=00002 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
input datafile fno=00006 name=/u01/app/oracle/rmants.dbf
input datafile fno=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: starting piece 1 at 16-JUL-11
channel ORA_DISK_1: finished piece 1 at 16-JUL-11
piece handle=/u01/app/rmanbak/full_20110716_756669643.bak tag=TAG20110716T180042 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:09:51
Finished backup at 16-JUL-11
Starting Control File and SPFILE Autobackup at 16-JUL-11
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/autobackup/2011_07_16/o1_mf_s_756670240_722rx1t2_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 16-JUL-11
starting full resync of recovery catalog
full resync complete
RMAN>
