BRRESTORE - ALTER DATABASE OPEN RESTLOGS

[mukundk_sap]

Hi all

We are doing Backup restore of Our PRD to Test. The test system is stand alone with same sid same sys no.

Backup on Disk ( Offline + redo logs)

we restore the backup. brrestore -c force -b (filename) -m full

create control file with sql script. ( alter database backup controlfile to trace )

control file created succesfully

with startup mount we try to alter database open restlog , it gives error

error at line 1

ORA-02288: Invalid OPEN mode

FYI : ECC 6 with Oracle 10g and Windows2003-64bit

[Former Member]

Hi Mukund,

You know the command, but you committed a silly typo there.

To convince you, check this:

http://ora-02288.ora-code.com/

regards.

[Former Member]

Hi Mukund,

alter database open restlog

is it a typeing mistake resetlog

or noresetlog

Regards

Ashok Dalai

[mukundk_sap]

Dear Ashok Dalai

i know the cmd ...

ALTER DATABASE OPEN RESTLOGS;

Mukund

[Former Member]

i know the cmd ... 
ALTER DATABASE OPEN RESTLOGS;

And yet a letter is missing:

RESETLOGS

[Former Member]

hi mukund,

all right,

you can alter database open noresetlogs or only open.

and you can test db!

ferhan

[Former Member]

Try SQL> alter database open resetlogs;