| recovery catalog problem [message #325890] |
Mon, 09 June 2008 07:25  |
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 #326051 is a reply to message #325896] |
Tue, 10 June 2008 01:16  |
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 |
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 |
 |
Mahesh Rajendran
Messages: 10707
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 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
