RMAN Error

All posts relating to Oracle database administration.

Moderator: Tim...

RMAN Error

Postby me_lucky » Thu Jan 10, 2013 12:05 pm

Hi tim,

While performing RAM dupilcation on standby database am getting below error.
Pl help me in resolving the issue.

My standby database is in started mode. Am able to connect to promary and standby database from both servers.
Pl let me know waht information further i can provide you to help me resolving the issue.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of allocate command at 01/10/2013 16:40:45
RMAN-06403: could not obtain a fully authorized session
RMAN-04006: error from auxiliary database: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
me_lucky
Senior Member
 
Posts: 170
Joined: Tue Jun 02, 2009 11:40 am

Re: RMAN Error

Postby Tim... » Thu Jan 10, 2013 2:06 pm

Hi.

Sorry, what is it you are trying to do? Create a duplicate of your standby, or create a duplicate of your primary for use as a standby?

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17955
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: RMAN Error

Postby me_lucky » Fri Jan 11, 2013 5:25 am

Hi Tim,

sorry to provide you imcomplete information.

am trying to create a duplicate of your primary for use as a standby.

Pl let me know i if can provide you any other information.

Thanks & Regards,
Lucky
me_lucky
Senior Member
 
Posts: 170
Joined: Tue Jun 02, 2009 11:40 am

Re: RMAN Error

Postby Tim... » Fri Jan 11, 2013 9:29 am

Hi.

You should be doing something like this.

http://www.oracle-base.com/articles/11g ... -11gr2.php

Regarding the standby setup, you should be following the DUPLICATE method, not the manual method.

http://www.oracle-base.com/articles/11g ... _setup_dup

At no point (until the duplicate is complete) is the standby started, so I don't know what you mean by "My standby database is in started mode.".

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17955
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: RMAN Error

Postby me_lucky » Fri Jan 11, 2013 9:52 am

Dear tim,

am really very sorry to bother you again and again.

I have followed the below steps to configure the dataguard. Pl let me know where i was wrong.

# On Primary
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE ARCHIVELOG;
SQL> ALTER DATABASE OPEN;
SQL> ALTER DATABASE FORCE LOGGING;
SQL> alter system set LOG_ARCHIVE_DEST_1 = 'LOCATION=+FLASH' scope=both sid='*';
SQL> alter system set db_recovery_file_dest='+FLASH' scope=both;
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=1G SCOPE=BOTH

SQL> ALTER SYSTEM SET db_flashback_retention_target = 7200 SCOPE=BOTH;


SQL> ALTER DATABASE ADD STANDBY LOGFILE size 100M;

SQL> ALTER DATABASE ADD STANDBY LOGFILE size 100M;

SQL> ALTER DATABASE ADD STANDBY LOGFILE size 100M;

SQL> ALTER DATABASE ADD STANDBY LOGFILE size 100M;

SQL> ALTER SYSTEM SET log_archive_config='DG_CONFIG=(pd_test,sd_test)' scope=both;

SQL> ALTER SYSTEM SET log_archive_dest_2= 'SERVICE=sd_test SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=sd_test' scope=both;

SQL> ALTER SYSTEM SET log_archive_dest_state_2=enable scope=both;

SQL> ALTER SYSTEM SET standby_file_management=auto scope=both;

SQL> ALTER SYSTEM SET dg_broker_start=TRUE scope=both;


# On Standby Server
Create a standby init.ora file containing following line:

db_name=test
db_unique_name=sd_test
sga_target=572043264



#Start standby database in NOMOUNT mode:
$ . oraenv
ORACLE_SID = [oracle] ? sd_test
ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/11.2/db

[oracle@tst2 dbs]$ sqlplus "/as sysdba"

SQL> startup nomount pfile='/u01/app/oracle/11.2/db/dbs/inittest.ora';

SQL> ALTER SYSTEM SET local_listener='(DESCRIPTION=(ADDRESS_LIST
=(ADDRESS=(PROTOCOL=TCP)(HOST=1.2.3.4)(PORT=1521))))';

SQL> select status from v$instance;

STATUS
------------
STARTED

#On Primary :
RMAN> backup device type disk format '/u02/test/dump/%U' database plus archivelog;
RMAN> backup device type disk format '/u02/test/dump/%U' current controlfile for standby;

Copied above backup files to one location
#On Standby:

connect target sys/oracle123@pd_test
connect auxiliary sys/oracle123@sd_test
run {
allocate channel primary1 type disk;
allocate channel primary2 type disk;
allocate auxiliary channel standby1 type disk;
duplicate target database for standby from active database spfile
parameter_value_convert 'pd_test', 'sd_test'
set db_unique_name='sd_test'
set db_create_file_dest='+DATA'
set db_recovery_file_dest='+FLASH'
set db_recovery_file_dest_size='1G'
set control_files='+DATA'
set fal_client='sd_test'
set fal_server='sd_test'
set sga_target='572043264'
set standby_file_management='auto'
set CLUSTER_DATABASE='FALSE'
set log_archive_config='dg_config=(pd_test, sd_test)'
set log_archive_dest_2='service=pd_test async valid_for=(online_logfile, primary_role) db_unique_name=pd_test'
set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=1.2.3.4)(PORT=1521))))'
;
}
me_lucky
Senior Member
 
Posts: 170
Joined: Tue Jun 02, 2009 11:40 am

Re: RMAN Error

Postby Tim... » Fri Jan 11, 2013 10:01 am

Hi.

Rather than post your procedure and make me compare it to my article, why don't you compare your procedure to my suggested procedure in the article and highlight what differences you've made compared to the steps I suggest? :)

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17955
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 1 guest