| how can i recover database in this case? [message #137872] |
Sun, 18 September 2005 03:56  |
Teddyboy
Messages: 8
Registered: September 2005
|
Junior Member |
|
|
hello,
i use rman backup database in Oracle 10.1.0.2 nocatalog, on every Monday make a full backup and transfer the backupset to another server, and every night backup archived log. Now the disk is corrupt , and we must recover the database from the backupset. but we only have Oracle database server 10.1.0.3 now, and when we begin to restore spfile and controlfile , but got the error:
<?php
[oracle@test dbs]$ rman target /
Recovery Manager: Release 10.1.0.3.0 - Production
Copyright (c) 1995, 2004, Oracle.��All rights reserved.
connected to target database: DEFAULT (not mounted)
RMAN> restore spfile from '/data/oradata/backup/TESTDB_c-2323471823-20050915-00';
Starting restore at 2005-09-15 14:28:44
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=51 devtype=DISK
channel ORA_DISK_1: autobackup found: /data/oradata/backup/TESTDB_c-2323471823-20050915-00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/15/2005 14:28:48
ORA-19690: backup piece release 10.1.0.2.0 incompatible with Oracle release 10.0.0.0.0
?>
please tell me what can i do or where can i get Oracle server 10.1.0.2 for linux? i searched from
http://www.oracle.com/technology/software/products/database/oracle10g/index.html
but nothing for download.
regards
Teddy
[Updated on: Sun, 18 September 2005 03:57] Report message to a moderator |
|
|
|
|
|
|
|
| Re: how can i recover database in this case? [message #138170 is a reply to message #137910] |
Tue, 20 September 2005 09:45  |
Teddyboy
Messages: 8
Registered: September 2005
|
Junior Member |
|
|
hello,
i had recover database from the backupset, include restore the controlfile. but when i reconfigure rman and meet the following errors:
<?php
RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
RMAN-00571: ======================================================
RMAN-00569: ============ ERROR MESSAGE STACK FOLLOWS =============
RMAN-00571: ======================================================
RMAN-03002: failure of configure command at 09/19/2005 15:30:31
RMAN-05021: this configuration cannot be changed for a BACKUP or STANDBY control file
RMAN> resync catalog;
RMAN-00571: ======================================================
RMAN-00569: ============= ERROR MESSAGE STACK FOLLOWS ============
RMAN-00571: ======================================================
RMAN-03002: failure of resync command at 09/19/2005 15:37:16
RMAN-06002: command not allowed when not connected to a recovery catalog
?>
because i used the controlfile from the backupset.
what should i do now? recreate the controlfile?
Best regards
Teddy
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
