Home » RDBMS Server » Server Administration » Log Destination
Log Destination [message #357590] Thu, 06 November 2008 00:11
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
I just want to know how to transfer archive log to another database.

What I did,
ALTER SYSTEM SET log_archive_dest_2='service=N_DB arch optional noregister reopen=5' SCOPE=BOTH;

ALTER SYSTEM SET log_archive_config='send' scope=both;


and in N_DB database,
ALTER SYSTEM SET log_archive_dest_2='location='/oradata/arh' scope-both;

ALTER SYSTEM SET log_archive_config='receive' scope=both;


And its not working...did I do a mistake or unnecessary thing? or what is the correct way to do this?

Report message to a moderator

Previous Topic: dbschema (merged)
Next Topic: Difference between V$parameter and V$parameter2
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 12:44:22 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.