Home » RDBMS Server » Backup & Recovery » flashback database (Oracle 10g, Rel 2, Linux AS4)
flashback database [message #293319] Fri, 11 January 2008 12:17 Go to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello All,

I've dropped a user u1 and I'm trying to flashing back using Oracle's feature Flashback Database. I'm getting the prompt as Flashback complete but after that I'm getting error like this:

SYS> flashback database to timestamp to_timestamp('2008-01-11:23:20:38','yyyy-mm-dd:hh24:mi:ss');

Flashback complete.

SYS> alter database open read only;

Then when next I connect as the user u1 and doing transactions , I'm getting this error:


SYS >conn u1/u1
Connected.
U1 >insert into dept select * from dept;
insert into dept select * from dept
*
ERROR at line 1:
ORA-01552: cannot use system rollback segment for non-system tablespace 'TS'

please help me out.

Regards,
Raj
Re: flashback database [message #293321 is a reply to message #293319] Fri, 11 January 2008 12:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

SYS> alter database open read only;

Then when next I connect as the user u1 and doing transactions

Don't you think "read only" and "transaction" are incompatible?

Regards
Michel
Re: flashback database [message #293323 is a reply to message #293321] Fri, 11 January 2008 12:29 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Yes Michel,

After that I just logged into the database , because when I gave
alter database open, it was saying an instance was already being opened whereas it was just in read only mode .

How to come out of this.
Re: flashback database [message #293324 is a reply to message #293323] Fri, 11 January 2008 12:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know I don't see your session.

First, are you in RAC? Or do you have set a RAC parameter (like CLUSTER_DATABASE or INSTANCE_NUMBER...)?

Then copy and paste your session.

Regards
Michel
Re: flashback database [message #293325 is a reply to message #293323] Fri, 11 January 2008 12:46 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry, answered too fast.
After a "flashback database" you can either open in read only mode or open in read write mode but with a reset log.

Regards
Michel
Previous Topic: Apply primary RMAN archive logs to standby database
Next Topic: Rman TSPITR error
Goto Forum:
  


Current Time: Sat Dec 10 16:24:29 CST 2016

Total time taken to generate the page: 0.07270 seconds