| unable to startup [message #186612] |
Tue, 08 August 2006 14:26  |
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  |
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 |
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 |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
