Restore whith RMAN

[cjgrozo]

Hi all;

After of perform a restore with RMAN, i cant open database. The following error is:

SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 247463936 bytes
Fixed Size 1977816 bytes
Variable Size 192942632 bytes
Database Buffers 50331648 bytes
Redo Buffers 2211840 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

I try open with: alter database open resetlogs, but i cant and now show the following error:

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 12/05/2007 14:27:36
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u01/prod/system01.dbf'

Somebody know how recover the database with legato networker ???

[hrishy]

Hi

Post your backup script.

regards
Hrishy

[cjgrozo]

run {
allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type 'SBT_TAPE';
send 'NSR_ENV=(NSR_SERVER=bhspdbs00,NSR_CLIENT=bhspdbs00)';
restore database;
alter database open;
release channel t1;
release channel t2;
}

[hrishy]

Hi

If there is an RMAN backup log that would tell you what redologs were archived and backed up as a part of this backup.

You need to restore the archivelogs also so rman applies those to the datafile and makes your datafiles consistent

rman target / nocatalog
allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type 'SBT_TAPE';
send 'NSR_ENV=(NSR_SERVER=bhspdbs00,NSR_CLIENT=bhspdbs00)';
run {
restore archivelog from time = 'date-of-start-of-backup';
}
exit

and then do

sqlplus "/ as sysdba"
recover database using backup controlfile until time 'some-point-in-time';
exit

regards
Hrishy

[cjgrozo]

thanks, its ok.