This content has been marked as final. Show 9 replies
dbc001 wrote:You will be prompted if Oracle can not locate the needed files
I have taken a database backup as hot backup.i woud like to clone the database to another server by using hot bkp , for that i have restored hot bkp,created init.ora,controlfiles required dir.
backup taken at 11:30 to 12:00PM
10 archfile are genrated by that time.
is it 10 arch files is enough for recovery or any additional files required?
how to know from which arch logfiles are needs for recovey.
can anyone help me out.
Best option is to used RMAN utility for performeing cloning or taking backups . RMAN has enormous features . Use that utility.
As far as your question is concerned , yes you need only ten archive logs for recovery , perform the following :
sql> ALTER DATABASER RECOVER AUTOMATIC USING BACKUP CONTROLFILE UNTIL CANCEL;
It applies all the required logs present in the control file.
The archive log information will be present in the control file and it also keep the information of absolute paths of datafiles & online redolog files as well. Please read the documentation of controlfiles from oracle.
thanks for ur quick reply...
i want to clone database by using fresh controfile....
am following below steps
1)restore of hot backup from prod
2)nessasary dir are created and init.ora file created as per the cloning
i have taken create controlfile from prod by using sql>alter database backup controlfile to trace as "..."
4)i would like to open the database like below ....
sql>recover database using BACKUP CONTROLFILE until cancel;
is it any controlfile backup prod is it required ?or from trace copy we can open database?
5)alter database open resetlogs;
plase correct me if am wrong...
I think below link will answer you :
Point No. 12
recover database using backup controlfile until cancel
When prompted to 'Specify log' enter 'auto'. Oracle will then apply all the available logs, and then error with ORA-00308. This is normal, it simply means that all available logs have been applied. Open the database with reset logs:
alter database open resetlogs;
But, I will suggest you to clone the database by RMAN which is more simpler and popular way though.
your steps are correct and one thing you have to remember that when you are recovering with following line give the option as "auto" as stated by Girish :
SQL> ALTER DATABASE RECOVER AUTOMATIC USING BACKUP CONTROLFILE UNTIL CANCEL;
Note : Use RMAN which is very simplest method of cloning. It reduces your job . Try it once then you will realise it. you can get many sites for RMAN cloning.