|
我以前做过一个试验,rman自动备份控制文件,没有使用catalog,自动备份控制文件位置可以按需更改一下,恢复的时候我没有使用autobackup 而是手动指定了一下路径,看看对你有帮助没有。
我想请教一下,rman自动备份控制文件时也备份参数文件spfile,这个文件保存在哪里了,恢复的时候怎么指定。(如果参数文件损坏,手动生成pfile,再启动实例,之后再生成spfile)
。
现在开始恢复:
[oracle@ns ~]$ rman target /
Recovery Manager: Release 9.2.0.4.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database (not started)
RMAN> startup nomount;
Oracle instance started
Total System Global Area 236000356 bytes
Fixed Size 451684 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
RMAN> set DBID=2347671489
executing command: SET DBID
RMAN> restore controlfile from '/opt/ora9/product/9.2.0.4/dbs/c-2347671489-20061006-00';
Starting restore at 08-OCT-06
using channel ORA_DISK_1
channel ORA_DISK_1: restoring controlfile
channel ORA_DISK_1: restore complete
replicating controlfile
input filename=/opt/ora9/oradata/oradb/control01.ctl
output filename=/opt/ora9/oradata/oradb/control02.ctl
output filename=/opt/ora9/oradata/oradb/control03.ctl
Finished restore at 08-OCT-06
RMAN> startup mount;
database is already started
database mounted
RMAN> list backup
2> ;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 761M DISK 00:02:59 06-OCT-06
BP Key: 1 Status: AVAILABLE Tag: DBALL
Piece Name: /tmp/dball01hv6ll4_1_1_20061006
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 196538 06-OCT-06 /opt/ora9/oradata/oradb/system01.dbf
2 Full 196538 06-OCT-06 /opt/ora9/oradata/oradb/undotbs01.dbf
3 Full 196538 06-OCT-06 /opt/ora9/oradata/oradb/cwmlite01.dbf
4 Full 196538 06-OCT-06 /opt/ora9/oradata/oradb/drsys01.dbf
5 Full 196538 06-OCT-06 /opt/ora9/oradata/oradb/example01.dbf
6 Full 196538 06-OCT-06 /opt/ora9/oradata/oradb/indx01.dbf
7 Full 196538 06-OCT-06 /opt/ora9/oradata/oradb/odm01.dbf
8 Full 196538 06-OCT-06 /opt/ora9/oradata/oradb/tools01.dbf
9 Full 196538 06-OCT-06 /opt/ora9/oradata/oradb/users01.dbf
10 Full 196538 06-OCT-06 /opt/ora9/oradata/oradb/xdb01.dbf
RMAN> restore database;
Starting restore at 08-OCT-06
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 /opt/ora9/oradata/oradb/system01.dbf
restoring datafile 00002 to /opt/ora9/oradata/oradb/undotbs01.dbf
restoring datafile 00003 to /opt/ora9/oradata/oradb/cwmlite01.dbf
restoring datafile 00004 to /opt/ora9/oradata/oradb/drsys01.dbf
restoring datafile 00005 to /opt/ora9/oradata/oradb/example01.dbf
restoring datafile 00006 to /opt/ora9/oradata/oradb/indx01.dbf
restoring datafile 00007 to /opt/ora9/oradata/oradb/odm01.dbf
restoring datafile 00008 to /opt/ora9/oradata/oradb/tools01.dbf
restoring datafile 00009 to /opt/ora9/oradata/oradb/users01.dbf
restoring datafile 00010 to /opt/ora9/oradata/oradb/xdb01.dbf
channel ORA_DISK_1: restored backup piece 1
piece handle=/tmp/dball01hv6ll4_1_1_20061006 tag=DBALL params=NULL
channel ORA_DISK_1: restore complete
Finished restore at 08-OCT-06
RMAN> recover database;
Starting recover at 08-OCT-06
using channel ORA_DISK_1
starting media recovery
archive log thread 1 sequence 10 is already on disk as file /opt/ora9/oradata/oradb/redo01.log
archive log filename=/opt/ora9/oradata/oradb/redo01.log thread=1 sequence=10
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 10/08/2006 16:23:49
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/opt/ora9/oradata/oradb/redo01.log'
ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [kcrfr_resize2], [2151608832], [2151677952], [33542144], [], [], [], []
RMAN> alter database open resetlogs;
database opened
RMAN> exit |
|