Home » RDBMS Server » Server Administration » unable to startup
unable to startup [message #186612] Tue, 08 August 2006 14:26 Go to next message
nandac
Messages: 41
Registered: July 2006
Location: jersey city, usa
Member

i did a db backup using 'schedule a backup' and 'custom backup' in enterprise manager.

i saw the file o1_mf_ncsnf_BACKUP_ENGDBA3_000_0_2fklxo4y_.bkp in the directory which i'd specified for the backup to be stored.

then i tried to recover the db.

but it wouldn't.

getting the following error :

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 8 15:24:16 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> SQL> Connected.
SQL> SQL> SQL> ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning and Data Mining options

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 8 15:24:28 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> SQL> Connected to an idle instance.
SQL> SQL> ORACLE instance started.

Total System Global Area 226492416 bytes
Fixed Size 2075928 bytes
Variable Size 144593640 bytes
Database Buffers 75497472 bytes
Redo Buffers 4325376 bytes
Database mounted.
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning and Data Mining options

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Aug 8 15:24:34 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

RMAN>
connected to target database: ENGDBA3 (DBID=3107938480, not open)
using target database control file instead of recovery catalog

RMAN>
echo set on


RMAN> run {
2> restore database;
3> recover database noredo;
4> }
Starting restore at 08-AUG-06
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=72 devtype=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/08/2006 15:24:38
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore


RMAN> exit;

Recovery Manager complete.
Re: unable to startup [message #186614 is a reply to message #186612] Tue, 08 August 2006 14:38 Go to previous messageGo to next message
nandac
Messages: 41
Registered: July 2006
Location: jersey city, usa
Member

i tried to startup the db - got the option to use "recover logs" - went ahead and got this error :

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 8 15:36:41 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> Connected.
SQL> SQL> ALTER DATABASE open RESETLOGS
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/apps/oracle/engdba3_files/df/system01.dbf'


Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning and Data Mining options

Re: unable to startup [message #186615 is a reply to message #186612] Tue, 08 August 2006 14:43 Go to previous messageGo to next message
nandac
Messages: 41
Registered: July 2006
Location: jersey city, usa
Member

this was only a test run.

i created an instance.

create a schema and a table on it.

then did a backup.

then created another table.

then wanted to recover from the backup and see only one table in the db.

in the recovery process for the question as to :
Do you want to restore the files to a different location?

i chose "Restore the files to the default location".

did this overwrite my existing files and that's the reason i'm not able to startup?
Re: unable to startup [message #186881 is a reply to message #186615] Thu, 10 August 2006 00:50 Go to previous messageGo to next message
ninja
Messages: 6
Registered: August 2006
Location: INDIA
Junior Member
hi nandac,
the problem is that when u backed up, u backed up only db only with one table
so when u restore it , ull be able to see only one table in db

sincerely
hardik
Re: unable to startup [message #186884 is a reply to message #186614] Thu, 10 August 2006 00:58 Go to previous message
ninja
Messages: 6
Registered: August 2006
Location: INDIA
Junior Member
hi nandac

the problem you are facing is that scn in ur redo logs and Control files are not matching with system01.dbf

solution

back up your corrupted db first and keep it at secure loc if something goes wrong with your current db

apply full backup of db if u have any backups

how ever u might loose some of the recent data

sincerely

hardik
Previous Topic: create database
Next Topic: Accessing Renamed database using OEM IN oracle 10g
Goto Forum:
  


Current Time: Sun Dec 04 16:34:59 CST 2016

Total time taken to generate the page: 0.06568 seconds