ltedb2$[/oracle]nohup ./restore.sh 1>restore.log 2>&1 &
[1]     13172738
ltedb2$[/oracle]
ltedb2$[/oracle]jobs
[1] +  Running                 nohup ./restore.sh 1>restore.log 2>&1 &
ltedb2$[/oracle]
ltedb2$[/oracle]cat restore.sh
#!/bin/sh
ORACLE_HOME=$ORACLE_HOME
export ORACLE_HOME
ORACLE_SID=$ORACLE_SID
export ORACLE_SID
rman target / nocatalog << EOF
run
{
ALLOCATE CHANNEL CH00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL CH01 TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=essdb2,NB_ORA_SERV=sfmbak';
set until time "to_date( '2013-12-06 00:00', 'YYYY-MM-DD HH24:MI' )";
recover DATABASE;
RELEASE CHANNEL CH00;
RELEASE CHANNEL CH01;
}
EOF

[ltedb2:root:/oracle]cat recover.sh

#!/bin/sh
ORACLE_HOME=$ORACLE_HOME
export ORACLE_HOME
ORACLE_SID=$ORACLE_SID
export ORACLE_SID
rman target / nocatalog << EOF
run
{
ALLOCATE CHANNEL CH00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL CH01 TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=essdb2,NB_ORA_SERV=sfmbak';
set until time "to_date( '2013-12-06 00:00', 'YYYY-MM-DD HH24:MI' )";
RECOVER DATABASE;
RELEASE CHANNEL CH00;
RELEASE CHANNEL CH01;
}
EOF

catalog archivelog '/arch/1_14778_813844108.dbf';
catalog archivelog '/arch/1_14779_813844108.dbf';
catalog archivelog '/arch/1_14780_813844108.dbf';
catalog archivelog '/arch/1_14781_813844108.dbf';
catalog archivelog '/arch/1_14782_813844108.dbf';
catalog archivelog '/arch/1_14783_813844108.dbf';
catalog archivelog '/arch/1_14784_813844108.dbf';
catalog archivelog '/arch/1_14785_813844108.dbf';
catalog archivelog '/arch/1_14786_813844108.dbf';
catalog archivelog '/arch/1_14787_813844108.dbf';
catalog archivelog '/arch/1_14788_813844108.dbf';
catalog archivelog '/arch/1_14789_813844108.dbf';

[ltedb2:root:/oracle]cat restore.sh
#!/bin/sh
ORACLE_HOME=$ORACLE_HOME
export ORACLE_HOME
ORACLE_SID=$ORACLE_SID
export ORACLE_SID
rman target / nocatalog << EOF
run
{
ALLOCATE CHANNEL CH00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL CH01 TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=essdb2,NB_ORA_SERV=sfmbak';
set until time "to_date( '2013-12-06 00:00', 'YYYY-MM-DD HH24:MI' )";
RESTORE DATABASE;
RELEASE CHANNEL CH00;
RELEASE CHANNEL CH01;
}
EOF

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery

SQL>  alter database open;

Database altered.

SQL>
SQL>