Home » RDBMS Server » Backup & Recovery » recovery catalog problem
recovery catalog problem [message #325890] Mon, 09 June 2008 07:25 Go to next message
khosravi
Messages: 68
Registered: April 2006
Member
Hello to all

we use oracle 10.2.0.1.0 as recovery catalog in windows os and target database
is oracle 10.2.0.2.0 in linux , target database is registered in catalog
when i connect to RMAN (by this parameters: rman target sys/xxx@G900
catalog rman_user/xxx@backup ) and perform backup , backup performed but
backup information stores in target controlfile database instead of recovery catalog

do you think this problem is because of difference between databases version?
otherwise do you know what is problem?

thanks

Message was edited by:
khosravi
Re: recovery catalog problem [message #325896 is a reply to message #325890] Mon, 09 June 2008 07:48 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>do you think this problem is because of difference between databases version?
Probably not.
>>otherwise do you know what is problem?
Give us some proof. Post what you did instead on explaining what you did.
Post your RMAN config.
How did you create the catalog?
Re: recovery catalog problem [message #326051 is a reply to message #325896] Tue, 10 June 2008 01:16 Go to previous messageGo to next message
khosravi
Messages: 68
Registered: April 2006
Member
I created an user in backup server by this statement

CREATE USER rman_user IDENTIFIED BY xxx
TEMPORARY TABLESPACE ts_bac_temp
DEFAULT TABLESPACE ts_back
QUOTA UNLIMITED ON ts_back;

(datafiles of the both tablespace are autoextend)

and then grant to rman_user , RECOVERY_CATALOG_OWNER privilage

then i performed these statements in RMAN

% rman

RMAN> CONNECT CATALOG rman_user/xxx@bk_server

RMAN> CREATE CATALOG;

RMAN> exit;

% rman TARGET sys/xxx@g900 CATALOG rman_user/xxx@db_server

RMAN> REGISTER DATABASE; (database registered successfully)

RMAN> RUN{
allocate channel c1 type disk format '/RmanNSC/db_%u_%d_%s.bk';
backup incremental level 0 database channel c1;
}


Re: recovery catalog problem [message #326059 is a reply to message #326051] Tue, 10 June 2008 01:44 Go to previous messageGo to next message
khosravi
Messages: 68
Registered: April 2006
Member
I dropped rman_user and recreated it and catalog then
i registered all instances some of them become fine but still some
has problem we have 7 instance but process of creating catalog and
registering is same for them
Re: recovery catalog problem [message #326175 is a reply to message #326059] Tue, 10 June 2008 07:29 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quoting myself
>>Give us some proof. Post what you did instead on explaining what you did.
Please post the exact session. Not the snippets. Unless we can see
the exact messages,
we can only do a rude guess.
In your post, Where does it say that the control file is used instead of catalog?

>>RMAN> CONNECT CATALOG rman_user/xxx@bk_server
As per your own posting,
You created the catalog in bk_server
>>% rman TARGET sys/xxx@g900 CATALOG rman_user/xxx@db_server

and connecting to db_server.


Unless you post the whole session (your commands and the output) I cannot proceed.

[Updated on: Tue, 10 June 2008 07:30]

Report message to a moderator

Re: recovery catalog problem [message #326289 is a reply to message #326175] Wed, 11 June 2008 00:02 Go to previous message
khosravi
Messages: 68
Registered: April 2006
Member
We have a bat file with name (job_G900NS1.bat) that execute every night it contains this:

********************************************************************************************************************************
rman target sys/WWSD@srv_g900ns1 catalog rman_user/DEFF@bkserver cmdfile='f:\g900ns1\Param_Full_ARC.cvs' log='F:\G900NS1\log\g900ns1Backup.log'

********************************************************************************************************************************




"Param_Full_ARC.cvs" file contains this:

********************************************************************************************************************************
run {
Configure controlfile autobackup on;
Set controlfile autobackup format for device type disk to '/RmanNSC/g900ns1/bs/cf/%F.cf';
Allocate channel c1 type disk format '/RmanNSC/g900ns1/bs/db_%u_%d_%s.bk' ;
Allocate channel c2 type disk format '/RmanNSC/g900ns1/lg/log_t%t_s%s_p%p.bk';
Backup incremental level 0 database channel c1 tag Full_L0_End_Daily_backup;
Backup archivelog all channel c2 delete all input;
Delete force noprompt obsolete ;
}

********************************************************************************************************************************



a sample of "g900ns1Backup.log" is:

********************************************************************************************************************************

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jun 11 08:59:19 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: G900NS1 (DBID=817528985)
connected to recovery catalog database

RMAN> run {
2> Configure controlfile autobackup on;
3> Set controlfile autobackup format for device type disk to '/RmanNSC/g900ns1/bs/cf/%F.cf';
4> Allocate channel c1 type disk format '/RmanNSC/g900ns1/bs/db_%u_%d_%s.bk' ;
5> Allocate channel c2 type disk format '/RmanNSC/g900ns1/lg/log_t%t_s%s_p%p.bk';
6> Backup incremental level 0 database channel c1 tag Full_L0_End_Daily_backup;
7> Backup archivelog all channel c2 delete all input;
8> Delete force noprompt obsolete ;
9> }
10>
11>
12>
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

executing command: SET CONTROLFILE AUTOBACKUP FORMAT

allocated channel: c1
channel c1: sid=117 devtype=DISK

RMAN-06908: WARNING: operation will not run in parallel on the allocated channels
RMAN-06909: WARNING: parallelism require Enterprise Edition
allocated channel: c2
channel c2: sid=155 devtype=DISK

Starting backup at 11-JUN-08
channel c1: starting incremental level 0 datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00005 name=/ORAnsc/oradata/G900NS1/tbl_varG900NS1.dbf
input datafile fno=00002 name=/ORAnsc/oradata/G900NS1/rbsegG900NS1.dbf
input datafile fno=00008 name=/ORAnsc/oradata/G900NS1/idx_fixG900NS1_2.dbf
input datafile fno=00004 name=/ORAnsc/oradata/G900NS1/tbl_fixG900NS1.dbf
input datafile fno=00007 name=/ORAnsc/oradata/G900NS1/idx_varG900NS1.dbf
input datafile fno=00001 name=/ORAnsc/oradata/G900NS1/sysG900NS1.dbf
input datafile fno=00003 name=/ORAnsc/oradata/G900NS1/sysauxG900NS1.dbf
input datafile fno=00006 name=/ORAnsc/oradata/G900NS1/idx_fixG900NS1.dbf
channel c1: starting piece 1 at 11-JUN-08
channel c1: finished piece 1 at 11-JUN-08
piece handle=/RmanNSC/g900ns1/bs/db_29jil7io_G900NS1_73.bk tag=FULL_L0_END_DAILY_BACKUP comment=NONE
channel c1: backup set complete, elapsed time: 00:01:25
Finished backup at 11-JUN-08

Starting backup at 11-JUN-08
current log archived
specification does not match any archive log in the recovery catalog
backup cancelled because all files were skipped
Finished backup at 11-JUN-08

Starting Control File and SPFILE Autobackup at 11-JUN-08
piece handle=/RmanNSC/g900ns1/bs/cf/c-817528985-20080611-00.cf comment=NONE
Finished Control File and SPFILE Autobackup at 11-JUN-08

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
no obsolete backups found
released channel: c1
released channel: c2

Recovery Manager complete.

********************************************************************************************************************************

After backup complete i connect to rman by this command:

rman target sys/WWSD@srv_g900ns1 catalog rman_user/DEFF@bkserver

and performing "LIST BACKUP" results nothing
but if i connect to rman by this parameters :rman target sys/WWSD@srv_g900ns1

LIST BACKUP command results this:


********************************************************************************************************************************

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jun 11 09:24:53 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: G900NS1 (DBID=817528985)

RMAN>
using target database control file instead of recovery catalog

List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
73 Incr 0 1.45G DISK 00:01:23 11-JUN-08
BP Key: 73 Status: AVAILABLE Compressed: NO Tag: FULL_L0_END_DAILY_BACKUP
Piece Name: /RmanNSC/g900ns1/bs/db_29jil7io_G900NS1_73.bk
List of Datafiles in backup set 73
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 0 Incr 25289319 11-JUN-08 /ORAnsc/oradata/G900NS1/sysG900NS1.dbf
2 0 Incr 25289319 11-JUN-08 /ORAnsc/oradata/G900NS1/rbsegG900NS1.dbf
3 0 Incr 25289319 11-JUN-08 /ORAnsc/oradata/G900NS1/sysauxG900NS1.dbf
4 0 Incr 25289319 11-JUN-08 /ORAnsc/oradata/G900NS1/tbl_fixG900NS1.dbf
5 0 Incr 25289319 11-JUN-08 /ORAnsc/oradata/G900NS1/tbl_varG900NS1.dbf
6 0 Incr 25289319 11-JUN-08 /ORAnsc/oradata/G900NS1/idx_fixG900NS1.dbf
7 0 Incr 25289319 11-JUN-08 /ORAnsc/oradata/G900NS1/idx_varG900NS1.dbf
8 0 Incr 25289319 11-JUN-08 /ORAnsc/oradata/G900NS1/idx_fixG900NS1_2.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
74 Full 6.27M DISK 00:00:01 11-JUN-08
BP Key: 74 Status: AVAILABLE Compressed: NO Tag: TAG20080611T090241
Piece Name: /RmanNSC/g900ns1/bs/cf/c-817528985-20080611-00.cf
Control File Included: Ckp SCN: 25289376 Ckp time: 11-JUN-08
SPFILE Included: Modification time: 09-JUN-08


********************************************************************************************************************************

it show that backups information only stor in controlfile and don't save in recovery catalog and it is my problem

[Updated on: Wed, 11 June 2008 00:16]

Report message to a moderator

Previous Topic: RMAN complete restore -- noarchive log fails..
Next Topic: Is my backup strategy safe?
Goto Forum:
  


Current Time: Sat Dec 03 12:22:09 CST 2016

Total time taken to generate the page: 0.08366 seconds