OraFAQ Forum: Backup & Recovery » RMAN Cloning issues

Home » RDBMS Server » Backup & Recovery » RMAN Cloning issues (Oracle 10.2.0.1.0 ,0EL4.8)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN Cloning issues [message #527621]

Wed, 19 October 2011 06:19

sekharsomu
Messages: 72
Registered: December 2008

Member

The error i am getting is

RMAN> duplicate target database to esstest
2> ;

Starting Duplicate Db at 19-OCT-11
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/19/2011 16:09:51
RMAN-06403: could not obtain a fully authorized session
RMAN-04006: error from auxiliary database: ORA-01034: ORACLE not available

what i have done to resolve?

Quote:

Recreated my listner and tnsnames
have checked the tnsping
add a parameter remote_login_passwordfile=exclusive to auxilary's pfile

Spent nearly 5 hrs on books and net tried adding inbound parameter to listner either that didnt help

none of them helped

This all what a done:
i have tried to clone between 2 system(Same Configuration)

This are the steps i have done:
@aux:
1.create a oracle home @auxilary<esstest>
2.create similar database structure in esstest
3.create a same backup location structure in esstest
4.moved a pfile from source<essprod> @ ora_home/dbs and made
necessary changes and add parameters db_file_name_convert,
log_file_name_convert
5.add parameter remote_login_passwordfile=exclusive and create
password file in dbs directory
6.create a new environmental file with new sid esstest
7. created a new listner and started it

@Source

1.ran the env file for essprod
2.startup successful
3.configured tnsnames.ora
4.tried to tnsping result:Successful

@AUX:
1.Started database in nomount
@source:
1.rman target=/ auxilary =sys/oracle@AUXDB
2.Succesful

ISSUE:
When try the following command in rman
RMAN>duplicate target database to esstest

errors are as follows:

RMAN> duplicate target database to esstest
2> ;

Starting Duplicate Db at 19-OCT-11
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/19/2011 16:09:51
RMAN-06403: could not obtain a fully authorized session
RMAN-04006: error from auxiliary database: ORA-01034: ORACLE not available

various configs at Aux:

pfile <initesstest.ora>

essprod.__db_cache_size=239075328
essprod.__java_pool_size=4194304
essprod.__large_pool_size=4194304
essprod.__shared_pool_size=62914560
essprod.__streams_pool_size=0
*.background_dump_dest='/prod/esstest/admin/bdump'
*.compatible='10.2.0'
*.control_files='/prod/esstest/oradata/contro01.dbf'
*.core_dump_dest='/prod/esstest/admin/cdump'
*.db_block_size=2048
*.db_name='esstest'
*.log_archive_dest='/backup/archive'
*.sga_target=300M
*.undo_management='auto'
*.undo_tablespace='undotbs'
*.user_dump_dest='/prod/esstest/admin/udump'
db_file_name_convert='/prod/essqa/ordata','/prod/esstest/oradata'
log_file_name_convert='/prod/essqa/ordata','/prod/esstest/oradata'
remote_login_passwordfile=exclusive

Lisneter@Aux:

# listener.ora Network Configuration File: /a01/oracle/product/10.2.0//network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = esstest)
      (ORACLE_HOME = /a01/oracle/product/10.2.0/)
          )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = som2.fzl.com)(PORT = 1521))
    )
  )

cross verified all mypath everthing exist

@Source

tnsnames.ora

AUXDB =
  (DESCRIPTION =
    (ADDRESS = (HOST = som2.fzl.com)(PORT = 1521)(PROTOCOL = tcp))
    (CONNECT_DATA =
      (SID = esstest)
    )
  )

How do i resolve this error

[Updated on: Wed, 19 October 2011 06:26]