Search results for query: *

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?

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.

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...

This is a simulation situation. I have two databases production and standby. My standby database is not set up for managed recovery. I added a new datafile to my users tablespace in the production database. I took a backup of the tablespace. I made a new entry of the datafile in the standby...

I backed up my database using the controlfile instead of the recovery catalog.I created two tables, call them A and B.I executed some INSERT and UPDATE commands on these two tables. Then i executed a DELETE command in table B. I tried to restore/recover the database to a point in time before the...

I have moved all my data files to a new location with success except the Temp01.dbf and Undotbs01.dbf. I get the following error when i try to move them. SQL> alter database rename file 'c:\u01\oracle\oradata\cicada\undotbs01.dbf' to 'c:\u01\oradata\cicada\undotbs01.dbf'; alter database rename...

I performed restore and recover operation on my simulation database using rman. My last step RMAN> OPEN RESETLOGS DATABASE; but i forgot to take a fresh backup immediately. Infact am doing it the next day. Am getting this error. How do i resolve it? piece...

Am trying to recover my database to a point in time.I have used different time format combinations and still got an error. This is an oracle9i ver:9.2 on window operating system. What is the right time format? RMAN> recover database until time 'feb 18 20:31:38 2006'; Starting recover at...

I deleted my alert log file by mistake. I thought it's automatically created if it's not there. Can anybody tell me what to do. The path specified below is where dumped before i deleted it. It appears the same way in the pfile LOG_ARCHIVE_DEST = C:\U01\APP\ORACLE\ADMIN\SID\DBUMP