Home » RDBMS Server » Backup & Recovery » Break of database restoring process
Break of database restoring process [message #209079] Wed, 13 December 2006 04:16 Go to next message
dzeljko
Messages: 19
Registered: April 2005
Junior Member
Hi,

The restore database process was broken and after that I can repeat restore and recovery of database successfully. I get the following message:

restore not done; all files readonly, offline, or already restored

Oracle database is 9.2.0.5.
Backup is done using rman. Day before I try restoring I created full database backup and backup all archivelog files with controlfile autobackup option.

I try to execute the following workflow for restoring process:

startup nomount;
set DBID
restore controlfile from autobackup;
alter database open;
restore database;

Does anybody have idea how to restore my database?
Re: Break of database restoring process [message #209082 is a reply to message #209079] Wed, 13 December 2006 04:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
please post the exact the message / output from the session.
Re: Break of database restoring process [message #209084 is a reply to message #209082] Wed, 13 December 2006 04:38 Go to previous messageGo to next message
dzeljko
Messages: 19
Registered: April 2005
Junior Member
[oracle@mushroom wmh4]$ rman

Recovery Manager: Release 9.2.0.5.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN> connect target

connected to target database (not started)

RMAN> startup nomount;

Oracle instance started

Total System Global Area 1008801076 bytes

Fixed Size 451892 bytes
Variable Size 352321536 bytes
Database Buffers 655360000 bytes
Redo Buffers 667648 bytes

RMAN> set DBID=2222965763

executing command: SET DBID

RMAN> restore controlfile form autobackup;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: "archivelog, cha nnel, check, controlfile, clone, database, datafile, device, from, force, high, (, parms, ;, spfile, standby, tablespace, to, until, validate"
RMAN-01008: the bad identifier was: form
RMAN-01007: at line 1 column 21 file: standard input

RMAN> restore controlfile from autobackup;

Starting restore at 13.12.06

using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=13 devtype=DISK
channel ORA_DISK_1: looking for autobackup on day: 20061213
channel ORA_DISK_1: looking for autobackup on day: 20061212
channel ORA_DISK_1: looking for autobackup on day: 20061211
channel ORA_DISK_1: autobackup found: c-2222965763-20061211-00
channel ORA_DISK_1: controlfile restore from autobackup complete
replicating controlfile
input filename=/u1/oradata/wmh4/control01.ctl
output filename=/u2/oradata/wmh4/control02.ctl
output filename=/opt/oracle/oradata/wmh4/control03.ctl
Finished restore at 13.12.06

RMAN>

RMAN> alter database mount;

database mounted

RMAN> restore database;

Starting restore at 13.12.06

using channel ORA_DISK_1
skipping datafile 1; already restored to file /u2/oradata/wmh4/system01.dbf
skipping datafile 2; already restored to file /u1/oradata/wmh4/undotbs01.dbf
skipping datafile 3; already restored to file /u1/oradata/wmh4/drsys01.dbf
skipping datafile 4; already restored to file /u2/oradata/wmh4/tools01.dbf
skipping datafile 5; already restored to file /u2/oradata/wmh4/xdb01.dbf
skipping datafile 6; already restored to file /u2/oradata/wmh4/ir_intra_yc_DATA0 1.dbf
skipping datafile 7; already restored to file /u2/oradata/wmh4/ir_intra_yc_LOB01 .dbf
skipping datafile 8; already restored to file /u1/oradata/wmh4/ir_intra_yc_INDEX 01.dbf
skipping datafile 9; already restored to file /u1/oradata/wmh4/YCWS_DATA.dbf
skipping datafile 10; already restored to file /u1/oradata/wmh4/YCWS_LOB1.dbf
skipping datafile 11; already restored to file /u2/oradata/wmh4/YCWS_INDEX1.dbf
skipping datafile 12; already restored to file /u1/oradata/wmh4/ir_inter_yc_DATA 01.dbf
skipping datafile 13; already restored to file /u1/oradata/wmh4/ir_inter_yc_LOB0 1.dbf
skipping datafile 14; already restored to file /u2/oradata/wmh4/ir_inter_yc_INDE X01.dbf
skipping datafile 15; already restored to file /u1/oradata/wmh4/VT_INTER_YC_DATA 01.dbf
skipping datafile 16; already restored to file /u1/oradata/wmh4/VT_INTER_YC_LOB0 1.dbf
skipping datafile 17; already restored to file /u2/oradata/wmh4/VT_INTER_YC_INDE X01.dbf
skipping datafile 40; already restored to file /u1/oradata/wmh4/VIWS_DATA01.dbf
skipping datafile 41; already restored to file /u1/oradata/wmh4/VIWS_LOB01.dbf
skipping datafile 42; already restored to file /u2/oradata/wmh4/VIWS_INDEX01.dbf
skipping datafile 49; already restored to file /u1/oradata/wmh4/vcms_DATA01.dbf
skipping datafile 50; already restored to file /u1/oradata/wmh4/vcms_LOB01.dbf
skipping datafile 51; already restored to file /u2/oradata/wmh4/vcms_INDEX01.dbf
skipping datafile 52; already restored to file /u2/oradata/wmh4/FONDS.dbf
skipping datafile 53; already restored to file /u2/oradata/wmh4/HV_HEL_YC_DATA.d bf
skipping datafile 54; already restored to file /u2/oradata/wmh4/TS_WM_LOB01.dbf
skipping datafile 55; already restored to file /u1/oradata/wmh4/HV_HEL_YC_INDEX1 .dbf
skipping datafile 56; already restored to file /u1/oradata/wmh4/hv_car_yc_DATA01 .dbf
skipping datafile 57; already restored to file /u2/oradata/wmh4/HV_HEL_YC_LOB1.d bf
skipping datafile 58; already restored to file /u1/oradata/wmh4/hv_car_yc_LOB01. dbf
skipping datafile 59; already restored to file /u2/oradata/wmh4/hv_car_yc_INDEX0 1.dbf
restore not done; all files readonly, offline, or already restored
Finished restore at 13.12.06

RMAN>
Re: Break of database restoring process [message #209112 is a reply to message #209084] Wed, 13 December 2006 06:27 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>all files readonly, offline, or already restored
Seems rman is finding nothing to restore for the said reasons.
Did you check the database.
Are you not seeing something that you are supposed to see?

Re: Break of database restoring process [message #209116 is a reply to message #209112] Wed, 13 December 2006 06:51 Go to previous messageGo to next message
dzeljko
Messages: 19
Registered: April 2005
Junior Member
I try the following issues when I started sqlplus (database not open):

SQL> select username from dba_users;
select username from dba_users
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> alter database open noresetlogs;
alter database open noresetlogs
*
ERROR at line 1:
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u2/oradata/wmh4/system01.dbf'

So my conclusion was that is necessary to restore and recover database again but you have already seen in previous post what is happened when I try to restore database.

I think that somewhere is written that the restore process is started and didn't finish yet and that blocks the new restore process.

Have you any idea where can be such kind of information.

Maybe to drop all dbf files and try again to restore all database?

Thanks for help me.
Re: Break of database restoring process [message #209122 is a reply to message #209116] Wed, 13 December 2006 07:07 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Maybe to drop all dbf files and try again to restore all database?
if you can afford, yes.
Did you also try a TSPITR? or recover until cancel?
You can see that, restore is fine or not needed at all.
It is the recovery part that is missing here.

Re: Break of database restoring process [message #209125 is a reply to message #209122] Wed, 13 December 2006 07:14 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Not sure how you did the backup.
Try in this sequence ( should'nt make any difference at all).
Only difference is, I am issuing the recovery explicitly within RMAN.
run {
restore controlfile;
restore database;
sql "alter database mount";
recover database;
sql "alter database open resetlogs";
}

[Updated on: Wed, 13 December 2006 07:15]

Report message to a moderator

Previous Topic: Importing data from Oracle 9i to Oracle 7.3.4......
Next Topic: Newbie recover question
Goto Forum:
  


Current Time: Tue Dec 06 02:42:04 CST 2016

Total time taken to generate the page: 0.09934 seconds