Database Restoration

159 Views

Hi there,

Can anyone help me with my problem? Below are the details.

I have a working PROD instance. I created/installed a fresh instance in a separate machine. After I completed the installation, i restored the offline backup from my PROD instance to this new instance (called it UAT instance). After restoration, I run the CONTROL.SQL script and I got the error below:

SQL> @CONTROL.SQL

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 9009364992 bytes

Fixed Size 2035392 bytes

Variable Size 4513071424 bytes

Database Buffers 4479516672 bytes

Redo Buffers 14741504 bytes

Control file created.

ALTER DATABASE OPEN RESETLOGS

*

ERROR at line 1:

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/oracle/UAT/sapdata1/system_1/system.data1'

ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/UAT/sapdata2/temp_1/temp.data1'F

*

ERROR at line 1:

ORA-01109: database not open

SQL>

Is this normal? Why would it consider recovery when it was actually an offline backup Im using?

By the way, I restored my database using the command brrestore.

Thanks in advance.