did you restore a backup?
do you have archived logs?
if NO to all then byebye or call support
Printable View
did you restore a backup?
do you have archived logs?
if NO to all then byebye or call support
Hi,
I was just doing some R&D and deleted that table. But before deleting the same I created one clone of that table in my database. But now the problem is I could not start up my database.
Here is the content of "d:\oracle\admin\buchku\udump\buchku_ora_1576.trc" ...
Dump file d:\oracle\admin\buchku\udump\buchku_ora_1576.trc
Mon Apr 21 15:35:30 2003
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Instance name: buchku
Redo thread mounted by this instance: 1
Oracle process number: 15
Windows thread id: 1576, image: ORACLE.EXE
*** SESSION ID:(11.3) 2003-04-21 15:35:30.000
ORA-00942: table or view does not exist
(assumption) As it is an unimportant database (used for R&D), you could as well do a fresh install and create another database without much sweat!Quote:
Originally posted by sumit
I was just doing some R&D and deleted that table.
Hi Pando,
I do not have backup. But I have archive log
Can I restore my database?
omg
how can you apply log if you dont have a backup, please use some common sense
Pndo u r right.
What I wanted to ask u that, is point in time recovery will work here?
Or what is the solution, if any system table will be deleted?
regards
if you have a valid backup and archived log then why it would not work....?
oracle records everything in the logs including data dictionary changes
Expect one more retardation from Pando. Pando clearly says that without any sort of backup how can u implement any type of recovery. How can u do R&D on System tables.God only has to help u.
Yes it works.Quote:
Originally posted by pando
will that work? doubt it really
Don't try this on any prod databases.Code:[email protected]D> startup
ORACLE instance started.
Total System Global Area 303111628 bytes
Fixed Size 454092 bytes
Variable Size 226492416 bytes
Database Buffers 75497472 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
[email protected]D>
[email protected]D>
[email protected]D>
[email protected]D> create table seq_backup as select * from seq$;
Table created.
[email protected]D> drop table seq$;
Table dropped.
[email protected]D> CREATE TABLE SEQ$
2 (
3 OBJ# NUMBER NOT NULL,
4 INCREMENT$ NUMBER NOT NULL,
5 MINVALUE NUMBER,
6 MAXVALUE NUMBER,
7 CYCLE# NUMBER NOT NULL,
8 ORDER$ NUMBER NOT NULL,
9 CACHE NUMBER NOT NULL,
10 HIGHWATER NUMBER NOT NULL,
11 AUDIT$ VARCHAR2(38) NOT NULL,
12 FLAGS NUMBER
13 )
14 TABLESPACE SYSTEM
15 PCTUSED 40
16 PCTFREE 10
17 INITRANS 1
18 MAXTRANS 255
19 STORAGE (
20 INITIAL 64K
21 MINEXTENTS 1
22 MAXEXTENTS 2147483645
23 PCTINCREASE 0
24 FREELISTS 1
25 FREELIST GROUPS 1
26 BUFFER_POOL DEFAULT
27 )
28 LOGGING
29 NOCACHE
30 NOPARALLEL;
Table created.
[email protected]D>
[email protected]D>
[email protected]D> CREATE UNIQUE INDEX I_SEQ1 ON SEQ$
2 (OBJ#)
3 LOGGING
4 TABLESPACE SYSTEM
5 PCTFREE 10
6 INITRANS 2
7 MAXTRANS 255
8 STORAGE (
9 INITIAL 64K
10 MINEXTENTS 1
11 MAXEXTENTS 2147483645
12 PCTINCREASE 0
13 FREELISTS 1
14 FREELIST GROUPS 1
15 BUFFER_POOL DEFAULT
16 )
17 NOPARALLEL;
Index created.
[email protected]D> insert into seq$ select * from seq_backup;
167 rows created.
[email protected]D> commit;
Commit complete.
[email protected]D> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
[email protected]D> startup
ORACLE instance started.
Total System Global Area 303111628 bytes
Fixed Size 454092 bytes
Variable Size 226492416 bytes
Database Buffers 75497472 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
[email protected]D>
Though it may not be solution for sumits question, where i earlier assumed that the database was in open state.
And won't work even if it was open as sumit would not have any backup of the seq$ table :)
You don't have a backup, so how can you do PIT recovery?Quote:
Originally posted by sumit
Pndo u r right.
What I wanted to ask u that, is point in time recovery will work here?
Or what is the solution, if any system table will be deleted?
regards