Automate Cold backup refresh

[castlerock]

Hi ,
I have a cold backup copy and want to automate the refresh process to development database using shell script

1. FTP to development database
2. Using backup control file...recreating a new controlfile
3. recover database

In step 3 recover database?? how to automate this step. I have 6 redo log files with 3 groups.

During recovery it will ask for different log files?

How to give the requested log file during recovery in an shell script?

Pls advice.

Thanks,

[marist89]

2. Using backup control file...recreating a new controlfile

why? Don't you have a copy of your control files?

3. recover database

what's there to recover? you already shutdown your database and it is consistent.

In step 3 recover database?? how to automate this step. I have 6 redo log files with 3 groups.

easy, don't recover.

During recovery it will ask for different log files?

why, you already have a consistent backup.

How to give the requested log file during recovery in an shell script?

you can always recover with backup controlfile until cancel and then cancel immediately.

[castlerock]

Sorry the steps are for the HOT BACKUP wrongly typed as cold backup.

Many Thanks,

[davey23uk]

stil dont see the need to re-create control file

fto backup, ftp all archive logs, restore and recover, open resetlogs

done

[marist89]

I can see it now:

but i'm in noarchivelog mode

[castlerock]

while refresh with the hot backup copy of prod.... the new database name is different (ef.oradev)

Step1. FTP the datafiles,redolog files and copy of control files,copy of controlfile trace and arch log files.

step2. I am trying to creat a new db with the hotbackup copy
and my new database (oradev) is no archive log mode


Do I have to re-create the controlfiles??

can you pls advice me on the next step

Thanks,

[marist89]

the new database name is different (ef.oradev)

That's a different story. Yes, you have to recreate the controlfiles.

[castlerock]

After re-creating the control file...

SQL>


SQL> @/u01/app/oracle/admin/oradev/udump/oranew.sql
ORACLE instance started.

Total System Global Area 1149638088 bytes
Fixed Size 734664 bytes
Variable Size 738197504 bytes
Database Buffers 409600000 bytes
Redo Buffers 1105920 bytes

Control file created.

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u10/oradata/oradev/system01.dbf'


SQL> recover database using backup controlfile;
ORA-00279: change 1653019426 generated at 05/10/2006 00:30:12 needed for thread
1
ORA-00289: suggestion : /u01/app/oracle/product/9.2.0/dbs/arch1_13050.dbf
ORA-00280: change 1653019426 for thread 1 is in sequence #13050

after this i am giving the archive files and redologfiles...

Is there a way to automate using shell script ...the steps for archive logs...(ie)based on the requested number and then redolog file


Thanks,