Skip to Main Content

Database Software

RESTORE ARCHIVELOG FROM SEQUENCE using RMAN

922134Jul 3 2012 — edited Jul 5 2012
Hi,

My primary databse is on file system having 10.2.0.5 db version.
My standby db is on ASM(11.2.0.2)
Operating system is Windows 2003.


I have taken rman backup of missing archive logs and fileset is tranferd on standby database server.

While restoring missing archivelogs using RMAN on standby database I am getting an folloeing error message.


I am using standby db controlfile instead of catalog database to use the rman.


RMAN> run {
2> ALLOCATE CHANNEL ch1 DEVICE TYPE DISK FORMAT = 'D:\dbawork\na38551\MKS01P_ARCH\';
3> RESTORE ARCHIVELOG FROM SEQUENCE 128458 UNTIL SEQUENCE 128510;
4> RELEASE CHANNEL ch1;
5> }

allocated channel: ch1
channel ch1: sid=85 devtype=DISK

Starting restore at 02-JUL-12

archive log thread 1 sequence 128501 is already on disk as file +ORAFLASH/mks01p/mks01p_seq128501_trd1_rid617106566.arc
archive log thread 1 sequence 128502 is already on disk as file +ORAFLASH/mks01p/mks01p_seq128502_trd1_rid617106566.arc
archive log thread 1 sequence 128503 is already on disk as file +ORAFLASH/mks01p/mks01p_seq128503_trd1_rid617106566.arc
restore not done; all files readonly, offline, or already restored
Finished restore at 02-JUL-12

released channel: ch1



Please help me to restore archive log files on standby database.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 2 2012
Added on Jul 3 2012
5 comments
141,793 views