Hello Oracle DBAs,
Iam using rman for backup and recovery process.
Am facing problem with in time recovery..like
Iam trying to make use of RMAN's TSPINR ..but for using it I need to create an AUXILIARY Database.
As given in doc. I created a password file and init.ora but stilll I could not do TSPINR...
I did the following steps..
copied existing init.ora file to initAUX.ora and changed
>db_name,lock_name,lock_name_space,control_files,d b_file_name,log_file_name_convert attributes(as given in doc) and saved.
>created the password file.(as per instructions in doc)
then..connected to rman using command
>rman target <..> auxiliary <..>
connected to target database: OEMREP (DBID=3217103894)
connected to auxiliary database: OEMREP (DBID=3217103894)
>recover tablespace test_tbs until time 'May 10 2004 14:00:00';
RMAN-03002: failure of recover command at 05/11/2004 12:26:59
RMAN-05011: auxiliary instance must be in nomount state for TSPITR
then I shutdown auxilary and started in nomount ..
connected to target database: oemrep (not mounted)
connected to auxiliary database: oemrep (not mounted)
..and when I used to recover..
RMAN-03002: failure of recover command at 05/11/2004 12:32:02
ORA-01507: database not mounted
and when I tried to mount the database using the "alter database mount" .. says..
ERROR at line 1:
ORA-00205: error in identifying controlfile, check alert log for more info
I couldnt trace out whats happening and what to do next..
Could anybody please detail about..
Thanks in advance..