0
votes
1answer
249 views

Oracle 10g cannot start after cloning server with dd

I used dd to clone a x4100 server with Linux Red Hat. The hardware is identical for old and new servers. Then I changed IP address and host name. The newly restored server is up and running but Oracle ...
0
votes
2answers
149 views

Is it possible to restore an Oracle DB on a different Operating System?

Is it possible to restore a backup of an Oracle 10.2.0.2.0 database which runs on UNIX to an Oracle 10g Express Edition (10.2.0.1.0) instance on Windows?
0
votes
1answer
305 views

Oracle Restore and recover Database on the same host?

I have DB1 database on Server1 . I have taken backup. After that I have created table TEST. Inserted some values in the TEST table. Truncated table. And want to return my TEST table to its ...
1
vote
1answer
1k views

After applying archive log in oracle, what time is it now?

I have restored the database and applied the archive log. How can I tell the latest transaction timestamp I have recovered to? This is oracle 10g R2 standard (no flashback enable)
1
vote
2answers
1k views

How to fix corrupt indexes blocks in SYSAUX tablespace

we had power failure that left corruption in data files. It was recovered from RMAN backup including logs and all is OK, the DB is working.. except that I noticed this: RMAN> BACKUP VALIDATE CHECK ...