Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 2 2012
Added on Jul 3 2012
#asm, #performance-availability, #recovery-manager-rman
5 comments
157,493 views