jueves, 19 de noviembre de 2020

Manejo de servicio en RAC

 11gR2

	Command: srvctl add service -d db_unique_name -s service_name
	-g server_pool [-c {UNIFORM|SINGLETON}] [-k network_number]
	[-l [PRIMARY|PHYSICAL_STANDBY|LOGICAL_STANDBY|SNAPSHOT_STANDBY]
	[-y {AUTOMATIC|MANUAL}] [-q {TRUE|FALSE}] [-j {SHORT|LONG}]
	[-B {NONE|SERVICE_TIME|THROUGHPUT}] [-e {NONE|SESSION|SELECT}]
	[-m {NONE|BASIC}] [-P {BASIC|NONE|PRECONNECT}] [-x {TRUE|FALSE}]
	[-z failover_retries] [-w failover_delay]

To add service with service goals
Example: srvctl add service -d rac -s rac1 -q TRUE -m BASIC -e SELECT -z 180 -w 5 -j LONG

To add service wih preconnect taf

	Command: srvctl add service -d db_unique_name -s service_name -u {-r preferred_list | -a available_list}
	Example: srvctl add serv -d rac -s report -r rac01,rac02 -a rac03 -P PRECONNECT

To start service

	Command: srvctl start service -d db_unique_name [-s "service_name_list" [-n node_name | -i instance_name]] [-o start_options]
	Example: srvctl start serv -d rac -s rac
	Example: srvctl start service -d rac -s rac -i rac2

To stop service

	srvctl stop service -d db_unique_name [-s "service_name_list"] [-n node_name | -i instance_name] [-f]
	srvctl stop service -d rac -s rac
	srvctl stop serv -d rac -s rac -i rac2

To view service

	srvctl status service -d db_unique_name [-s "service_name_list"] [-f] [-v]
	srvctl status service -d rac -s rac -v

To modify the service

	Command: srvctl modify service -d db_unique_name -s service_name
	[-c {UNIFORM|SINGLETON}] [-P {BASIC|PRECONNECT|NONE}]
	[-l {[PRIMARY]|[PHYSICAL_STANDBY]|[LOGICAL_STANDBY]|[SNAPSHOT_STANDBY]} [-q {TRUE|FALSE}] [-x {TRUE|FALSE}] [-j {SHORT|LONG}] [-B {NONE|SERVICE_TIME|THROUGHPUT}] [-e {NONE|SESSION|SELECT}] [-m {NONE|BASIC}] [-z failover_retries] [-w failover_delay] [-y {AUTOMATIC|MANUAL}]

	Command: srvctl modify service -d db_unique_name -s service_name -i old_instance_name -t new_instance_name [-f]
	Command: srvctl modify service -d db_unique_name -s service_name -i avail_inst_name -r [-f]
	Command: srvctl modify service -d db_unique_name -s service_name -n -i preferred_list [-a available_list] [-f]

	Example: srvctl modify service -d rac -s rac -i rac1 -t rac2
	Example: srvctl modify serv -d rac -s rac -i rac1 -r
	Example: srvctl modify service -d rac -s rac -n -i rac1 -a rac2

RMAN - Cuando no se encuentra un archive log --- RMAN-06726: could not locate archived log

  Lo importante en todo esto, es estar dentro del catalogo correspondiente, sino el crosscheck NO FNCIONA !!   oracle backup of logfiles is ...