| SPFILE restore from autobackup no catalog (2 Merged) [message #562494] |
Wed, 01 August 2012 12:25  |
|
|
Hi,
I need to restore entire database(sp+control+datafile) to new host.I have started the instance with nomount( and it has created a dummy parameter file).Now, I need to fire the command to restore spfile.
RUN
{
ALLOCATE CHANNEL c1 DEVICE TYPE sbt PARMS='...';
RESTORE SPFILE TO PFILE '?/oradata/test/inittrgta.ora' FROM AUTOBACKUP;
SHUTDOWN ABORT;
}
My questions:-
1.How will RMAN find the location of backupset(Since there is controlfile for neither target or catalog database)?
2.How does RMAN reache the backupset in case of a)tape b)disk?
|
|
|
|
| SPFILE restore from autobackup no catalog [message #562495 is a reply to message #562494] |
Wed, 01 August 2012 12:26  |
|
|
Hi,
I need to restore entire database(sp+control+datafile) to new host.I have started the instance with nomount( and it has created a dummy parameter file).Now, I need to fire the command to restore spfile.
RUN
{
ALLOCATE CHANNEL c1 DEVICE TYPE sbt PARMS='...';
RESTORE SPFILE TO PFILE '?/oradata/test/inittrgta.ora' FROM AUTOBACKUP;
SHUTDOWN ABORT;
}
My questions:-
1.How will RMAN find the location of backupset(Since there is controlfile for neither target or catalog database)?
2.How does RMAN reache the backupset in case of a)tape b)disk?
|
|
|
|
|
|
| Re: SPFILE restore from autobackup no catalog (2 Merged) [message #562508 is a reply to message #562497] |
Wed, 01 August 2012 14:57 |
|
|
Hi Mikel,
Thanks for your reply,
1.okay..i am giving location in params=ora_client=hostname env=path of library file...So,Rman accesses the library file and scan the tape for the autobackups..am i correct?
2.But,in case of disk we dont give parms,so how can RMAN find the backupset to restorespfile from autobackup?
3.We can configure autobackup format while restoring.a)Should this path be same as format of autobackup while taking the ackup?
b)Do I need to keep the backupset in the path specified in the autobackup format?
Regards,
Saikat
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
