Recover a 9i database from RMAN backup[@more@]QUESTION
=========
We suffered a disk failure last week and have to re-install a new solaris 10 on it. Unfortunately we do no
t have 9i installation disks any more. The failed database was a 9.2.0.8 databas
e. We have full database backup in RMAN and planned to install 10gR2 to the new
server. But we have no idea how to use the 9i backup to recover the database to
10gR2.
RESEARCH
==========
They are using a recovery catalog
They are backing up to tape
ANSWER
========
1. You need to download and install the 9.2.0.1 software for Solaris Sparc
2. You need to download and install the same patchset for 9.2.x from Metalink for Solaris Sparc
3. You need to install and configure your MML so that you can restore and recover using your tape backups
4. Set your ORACLE_SID environment variable
connect to the target and the recovery catalog with rman
startup nomount
set dbid=xxxxxxxxx;
restore spfile;
You should be able to get the dbid from either an rman backup log or from the recovery cata
log:
select dbid, name from rc_database where name = '';
5. After you get the spfile restored then shutdown and startup nomount with the spfile
6. connect to the target and the recovery catalog with rman
startup nomount
set dbid=xxxxxxxxx;
restore controlfile;
alter database mount;
7. after mounting the database restore and recover the database.
As you mentioned you need to work on this probably after I am gone, to get this SR reassigned to
a working analyst call: 800 223-1711
Thanks
P.
=========
We suffered a disk failure last week and have to re-install a new solaris 10 on it. Unfortunately we do no
t have 9i installation disks any more. The failed database was a 9.2.0.8 databas
e. We have full database backup in RMAN and planned to install 10gR2 to the new
server. But we have no idea how to use the 9i backup to recover the database to
10gR2.
RESEARCH
==========
They are using a recovery catalog
They are backing up to tape
ANSWER
========
1. You need to download and install the 9.2.0.1 software for Solaris Sparc
2. You need to download and install the same patchset for 9.2.x from Metalink for Solaris Sparc
3. You need to install and configure your MML so that you can restore and recover using your tape backups
4. Set your ORACLE_SID environment variable
connect to the target and the recovery catalog with rman
startup nomount
set dbid=xxxxxxxxx;
restore spfile;
You should be able to get the dbid from either an rman backup log or from the recovery cata
log:
select dbid, name from rc_database where name = '';
5. After you get the spfile restored then shutdown and startup nomount with the spfile
6. connect to the target and the recovery catalog with rman
startup nomount
set dbid=xxxxxxxxx;
restore controlfile;
alter database mount;
7. after mounting the database restore and recover the database.
As you mentioned you need to work on this probably after I am gone, to get this SR reassigned to
a working analyst call: 800 223-1711
Thanks
P.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11118/viewspace-1006068/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/11118/viewspace-1006068/