Recent content by dbstudent

One more question. How do i take an export of my primary database?

yeh y'all, My production database automatically archives to the standby. I tried to shutdown the standby, it hang on me. So i did the shutdown abort and there after startup and shutdown immediate.Then brought it backup ALTER DATABASE MOUNT STANDBY DATABASE; followed by ALTER DATABASE RECOVER...

My database will not shutdown using the SHUTDOWN IMMEDIATE option It hang with the following error message for about 20 minutes. OPIRIP: Uncaught error 447. Error stack: ORA-00447: fatal error in background process ORA-00604: error occurred at recursive SQL level 2 ORA-01089: immediate...

Our production database was slowing down and hanging during normal operation so we decided to reboot it. It hanged up and when i checked the alert log file i got the following error mesaage. Active call for process 20507 user 'dbopr' program 'oracle@londata1 (TNS V1-V3)' Active call for process...

Hello, Can someone please explain to me what the checkpoint process does. I am not clear whether it writes directly to the datafile headers directly or does it pass on the scn number to the DBWn? dbstudent

I have a full database backup taken using RMAN. Since that backup a table was created and dropped before another backup had been done. All online redo logs, archived logs are avaliable. The time and sequence# before table was dropped is know. How do i recover this table?

Okay, so how do i stop a listener to a database that am accessing remotely? This is how i connect to it OS prompt>set oracle_sid=abc OS prompt>sqlplus /nolog SQL>connect /as sysdba SQL>startup

I have shutdown the database and stopped the listener, Checked the status it was down. I went back and started the database, mounted and opened it and queried it. I thought that was not suppose to happen? If i have other databases on the same server are they affected by the listener being stopped?

Am going to shutdown my database using th SHUTDOWN IMMEDIATE command. How do i shutdown the listener. Thanks

I created a standby database and when i tried to take an RMAN backup of the database i got a message saying that the control file not current, controlfile autobackup skipped. Can some one please explain this to me. I get this whether the database is auto managed or done manaully.

Sorry i wasn't so clear. I received an error indicating that i had an block corruption in my database. Since i was backing up the database using RMAN utility i was going to recover the block using Rman RECOVER FILE command as in RECOVER FILE 11, BLOCK 2954; but then i thought i had read...

Hey Gurus does anybody know if block recovery can be done in Oracle Standard Edition? Thanks in advance.

Am getting the following error in the alert log file from one of my database. ORA-1691: unable to extend lobsegment C01D3.SYS_LOB0000051915C00020$$ by 128 in tablespace CMPRDATA1 The tablespace still has about 30% of unused space. What so i need to do. Thanks for your help.

After what kind of backup do you use RESET DATABASE command? Thanks-

I have been able to restore and recover a database to a point in time using: RESTORE DATABASE UNTIL TIME "TO_DATE('16/03/2006 18:00:00','DD/MM/YYYY HH24:MI:SS')"; RECOVER DATABASE UNTIL TIME "TO_DATE('16/03/2006 18:00:00','DD/MM/YYYY HH24:MI:SS')"; I don't seem to be able to use the RECOVER...