| I cant open my Database [message #245644] |
Mon, 18 June 2007 05:00  |
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
|
Senior Member |
 
|
|
-------------------
SQL> select * from tab;
select * from tab
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
------------------
------------------------
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
-------------------------------
---------------------
SQL> alter database open resetlogs;
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: '/oradata/oradata/THERAP/system01.dbf'
-----------------------
RMAN> restore datafile 1 until time 'SYSDATE-5';
Starting restore at 18-JUN-07
using channel ORA_DISK_1
channel ORA_DISK_1: restoring datafile 00001
input datafile copy recid=42 stamp=624995190 filename=/oradata/THERAP/datafile/o1_mf_system_36tfdtbg_.dbf
destination for restore of datafile 00001: /oradata/oradata/THERAP/system01.dbf
channel ORA_DISK_1: copied datafile copy of datafile 00001
output filename=/oradata/oradata/THERAP/system01.dbf recid=50 stamp=625593738
Finished restore at 18-JUN-07
------------------
RMAN> recover datafile 1 until time 'SYSDATE-5';
Starting recover at 18-JUN-07
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /oradata/oradata/THERAP/system01.dbf
channel ORA_DISK_1: reading from backup piece /oradata/THERAP/backupset/2007_06_12/o1_mf_nnnd1_TAG20070612T020015_36vbgjrt_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/oradata/THERAP/backupset/2007_06_12/o1_mf_nnnd1_TAG20070612T020015_36vbgjrt_.bkp tag=TAG20070612T020015
channel ORA_DISK_1: restore complete, elapsed time: 00:00:08
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/18/2007 16:04:25
RMAN-06067: RECOVER DATABASE required with a backup or created control file
--------------
I have done <code>
rman>
startup force nomount
restore control file from autobackup
</code>
But it also does not work. What I should do to open the database?
[Updated on: Mon, 18 June 2007 05:06] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: I cant open my Database [message #246026 is a reply to message #245825] |
Tue, 19 June 2007 10:47  |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
| Quote: | RMAN> restore controlfile to '/oradata/oradata/THERAP/control01.ctl' from autobackup;
Starting restore at 19-JUN-07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
recovery area destination: /oradata
database name (or database unique name) used for search: THERAP
channel ORA_DISK_1: autobackup found in the recovery area
channel ORA_DISK_1: autobackup found: /oradata/THERAP/autobackup/2007_06_13/o1_mf_s_625152567_36z76rck_.bkp
channel ORA_DISK_1: control file restore from autobackup complete
Finished restore at 19-JUN-07
|
As your controlfile restored successfulluy now you can mount your database and then restart recovery.
| Quote: | Now for full database recovery what I would do?
|
RMAN>run
{
restore database;
recover database;
sql 'alter databse open';
}; |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
