-
Restore whith RMAN
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 ???
-
Hi
Post your backup script.
regards
Hrishy
-
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;
}
-
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
Code:
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
Code:
sqlplus "/ as sysdba"
recover database using backup controlfile until time 'some-point-in-time';
exit
regards
Hrishy
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|